Responsed Standard Export Template
This template is based on the fact - Response Info.
- It consists of data related to the transactions at a line-item level of customers that responded to a particular campaign.
- You can export transactions and line-item level details of customers that responded to a specific campaign.
Measures
Measure Name | Description |
---|---|
Bill Amount | Measures the net amount of the transaction made by the customer. |
Bill Discount | Measures the total discount applied on the bill. |
Bill Id | A unique id generated for the bill internally by the capillary system. It helps in differentiating one customer's bill from another. |
Bill Number | A unique number for a transaction that is either auto-generated at the POS machine or provided manually. |
Msg Id | Unique id generated by the system for the campaign_message. |
Item Code | Unique code of the line-item. |
Line Item Amount | Total amount after discount including tax. |
Line Item Discount | Discount given for the particular line-item. |
Line Item Id | Unique id generated by the system for the line-item. |
Quantity | Total count of quantity in the transaction. |
Redeemed Points | Total points redeemed on the transaction. |
Total Link Click Count | Total number of times the links within an message have been clicked by the customer. |
Dimensions
Dimension Name | Description |
---|---|
Bill Outlier | Outlier status of the bill. |
Campaign_delivery_status | Unique id generated by the system which indicates the campaigns delivery status. |
Campaign_group | Unique id generated by the system that specifies the group of the campaign. |
Campaign | Unique id generated by the system for the campaign. |
Campaign_message | Unique id generated by the system for the campaign_message. |
Campaign_schedule_date | Date when the campaign has been scheduled. |
Campaign_schedule_time | Time when the campaign has been schedule |
Communication_channel | Type of communication channel through which the campaign related communication is sent to the customer. |
Communication_type | Type of communication used in the campaign, differentiating between Test Group and Control Group. |
Date | Transaction date when customers contacted during the campaign made a purchase. |
Time | Transaction time when customers contacted during the campaign made a purchase. |
User | Unique identifier assigned to the user by Capillary. |
Store Hierarchy (zone till) | Captures till_id of the store where the transaction occurred. |
Concept Hierarchy | Identifier for the concept. |
Ou Hierarchy | Identifier for the organization unit. |
Latest_updated_date | Latest date when the data is updated. |
Line Item Outlier | Outlier status of the bills at line item level. |
Loyalty_type | Identifier of the Loyalty type of the customer. Possible values are - loyalty, non loyalty, not registered (who have not provided their contact details). |
Repeat | Shows if the customer has made previous purchases or if it's their first transaction. |
Source | Identifier for the source of the bill. Possible values are instore, e-comm, newsletter, campaigns, NCA, Wechat, Facebook, etc. |
Unsubscription status | Unique id generated by the system for the unsubscription status. Indicates if the customer has unsubscribed or not. |
Updated 3 months ago