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 user |
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 | The 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 point been redeemed on the transaction |
Total Link Click Count | Total count of click that has been done by the user on the link which has been added in the message |
Dimensions
Dimension Name | Description |
---|---|
Bill Outlier | Outlier status of the bills on bill level |
campaign_delivery_status | Unique id generated by the system which tells the campaigns delivery status More details here :Delivery_status |
campaign_group | Unique id generated by the system which specifies the group of the campaign More details here:Campaign_group |
campaign | Unique id generated by the system for the campaigns More details here:Campaigns |
campaign_message | Unique id generated by the system for the campaign_message |
campaign_schedule_date | Measures the date when the campaign has been schedule |
campaign_schedule_time | Measures the time when the campaign has been schedule |
communication_channel | Type of communication channel on which the message has been communicated to the user More details here : communication_channel |
communication_type | Type of communication which has been received by the user More details here: communication_type |
Date | Measures the date when the event has occurred |
Time | Measures the timestamp when the event has occurred , it captures upto minutes and seconds is not captured |
User | Unique user identifier , this is an integer set internally by capillary. |
Store Hierarchy | Captures till_id of a store where the event has occurred. |
latest_updated_date | The latest updated date when the data has been updated. |
Line Item Outlier | Outlier status of the bills at line item level. More details here: outlier_status |
loyalty_type | Loyalty type of the customer.Could be loyalty ,non_loyalty or not_registered Linked table:loyalty_type |
Repeat | Repeat status of the customer. Linked table: repeat_status |
Source | Source of the bill Linked table : source_type |
Unsubscription status | Unique id generated by the system for the unsubscription status |
Updated 23 days ago