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 NameDescription
Bill AmountMeasures the net amount of the transaction made by the user
Bill DiscountMeasures the total discount applied on the bill
Bill IdA unique id generated for the bill internally by the capillary system. It helps in differentiating one customer's bill from another
Bill NumberA unique number for a transaction that is either auto-generated at the POS machine or provided manually
Msg IdUnique id generated by the system for the campaign_message
Item CodeThe unique code of the line-item
Line Item AmountTotal amount after discount including tax.
Line Item DiscountDiscount given for the particular line-item
Line Item IdUnique id generated by the system for the line-item
QuantityTotal count of quantity in the transaction
Redeemed PointsTotal point been redeemed on the transaction
Total Link Click CountTotal count of click that has been done by the user on the link which has been added in the message

Dimensions

Dimension NameDescription
Bill OutlierOutlier status of the bills on bill level
campaign_delivery_statusUnique id generated by the system which tells the campaigns delivery status

More details here :Delivery_status
campaign_groupUnique id generated by the system which specifies the group of the campaign

More details here:Campaign_group
campaignUnique id generated by the system for the campaigns

More details here:Campaigns
campaign_messageUnique id generated by the system for the campaign_message
campaign_schedule_dateMeasures the date when the campaign has been schedule
campaign_schedule_timeMeasures the time when the campaign has been schedule
communication_channelType of communication channel on which the message has been communicated to the user

More details here : communication_channel
communication_typeType of communication which has been received by the user

More details here: communication_type
DateMeasures the date when the event has occurred
TimeMeasures the timestamp when the event has occurred , it captures upto minutes and seconds is not captured
UserUnique user identifier , this is an integer set internally by capillary.
Store HierarchyCaptures till_id of a store where the event has occurred.
latest_updated_dateThe latest updated date when the data has been updated.
Line Item OutlierOutlier status of the bills at line item level.

More details here: outlier_status
loyalty_typeLoyalty type of the customer.Could be loyalty ,non_loyalty or not_registered

Linked table:loyalty_type
RepeatRepeat status of the customer.

Linked table: repeat_status
SourceSource of the bill

Linked table : source_type
Unsubscription statusUnique id generated by the system for the unsubscription status