Goodwill Requests Standard Export Template
This export template is based on the goodwill_requests fact.
Lets you export the details of the goodwill requests generated while allocating goodwill points or coupons to the customers.
Measures
Measure Name | Description |
---|---|
Request Status | Gives the status of the goodwill request. |
Request Type | Gives the type of the goodwill request. |
Is One Step Change | Indicates if one step issual of goodwill points is active or not. In one step issual, goodwill points are issued instantly without requiring additional approval steps. |
Request Auto Update Time | Time when the goodwill request table available at the source was last updated. It is in the Unix timestamp format. |
Goodwill Type | Type or category of the goodwill request (coupons or points). |
Goodwill Request Status | Status of the goodwill request associated with the points. Indicates if the status is approved or not. |
Reason | Reason for the goodwill request. |
Comments | Any remarks related to the goodwill points, added by the user. |
Request Assoc Id | Associated ID for the goodwill request. |
Approved Value | Value of the points that has been approved. |
Approval Comments | Comments added by the approver for the goodwill point allocation request. |
Allocated Points | Total number of goodwill points issued to the customer. |
GoodWill Points log notes | Additional information about goodwill points. |
Points Event Id | Refers to the points fact table event id. |
GoodWill Points Log Status | Status indicator for the goodwill points log. |
Gr Auto Update Time | Time when the goodwill request table available at the source was last updated. It is in the Unix timestamp format. |
Gpl Auto Update Time | Time when the goodwill points logs table available at the source was last updated. It is in the Unix timestamp format. |
Event Id | Unique identifier for the Goodwill points table. |
Goodwill Points Logs Id | Unique identifier for each entry in the goodwill points log. |
Dimensions
Dimension Name | Description |
---|---|
Latest Updated Date | Latest date when the data is updated. |
Latest Updated Time | Latest time when the data is updated. |
User | User details such as user id, source, slab name, external id, fraud status, mobile, email, etc. |
User Segments | Segment details of the customers such as valued customer, lapsed customer. |
User Attributes | User attributes such as total visits, recent view. |
Store Hierarchy (zone till) | Identifier for the store, till id. |
Concept Hierarchy | Identifier for the concept. |
Ou Hierarchy | Identifier for the organization unit. |
Request Created Date | Date when the goodwill request was created. |
Request Updated Date | Date when the goodwill request was updated. |
Event Program | Gives the loyalty program name against which the goodwill points have been allocated. |
Points Category Id | Gives the category name against which the goodwill points have been allocated. Possible values are - Regular points, Trackers, Promised points, Alternate currencies, and External trigger based points. |
Updated about 1 month ago