Goodwill Requests Standard Export Template

This export template is based on the goodwill requests fact table. Lets you export the details of the goodwill requests generated while allocating goodwill points or coupons to the customers.

Measures

Measure NameDescription
Request StatusGives the status of the goodwill request.
Request TypeGives the type of the goodwill request.
Is One Step ChangeIndicates 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 TimeTime when the goodwill request table available at the source was last updated. It is in the Unix timestamp format.
Goodwill TypeType or category of the goodwill request (coupons or points).
Goodwill Request StatusStatus of the goodwill request associated with the points. Indicates if the status is approved or not.
ReasonReason for the goodwill request.
CommentsAny remarks related to the goodwill points, added by the user.
Request Assoc IdAssociated ID for the goodwill request.
Approved ValueValue of the points that has been approved.
Approval CommentsComments added by the approver for the goodwill point allocation request.
Allocated PointsTotal number of goodwill points issued to the customer.
GoodWill Points log notesAdditional information about goodwill points.
Points Event IdRefers to the points fact table event id.
GoodWill Points Log StatusStatus indicator for the goodwill points log.
Gr Auto Update TimeTime when the goodwill request table available at the source was last updated. It is in the Unix timestamp format.
Gpl Auto Update TimeTime when the goodwill points logs table available at the source was last updated. It is in the Unix timestamp format.
Event IdUnique identifier for the Goodwill points table. It is the primary key for this table.
Goodwill Points Logs IdUnique identifier for each entry in the goodwill points log.

Dimensions

Latest Updated Date; Latest Updated Time; User; User Segments; User Attributes; Store Hierarchy; Concept Hierarchy; Ou Hierarchy; Request Created Date; Request Updated Date; Event Program; Points Category Id