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