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.