Column | Description |
Bill Amount | The amount of the bill which has been made by the target customer |
Bill Discount | Denotes the discount availed by the target customer in the response bill |
Bill ID | Stands for the identifier of the transaction made by target customer |
Bill Number | Stands for external bill number captured in our system generated by brand |
Bill Amount | Amount of a specific bill |
Item Code | Unique identifier of product |
Line Item Amount | Denotes amount at product level |
Line Item Discount | Discount availed on the line-item |
Line Item ID | Unique internal reference id associated to a lineitem |
Quantity | Quantity of line-item purchased |
Redeemed Points | Number of points redeemed for the transaction |
Total Link Click Count | Number of clicks on a link sent through a campaign |
Msg ID | It is a template id that is generated when a message is sent. If there are 5 types of messages sent in a campaign, it will have 5 different message ids |
latest_updated_date | Date when a specific data are recently updated. |
latest_updated_time | Time when a specific data are recently updated. |
Bill Outlier | Outlier status of a bill |
campaign_delivery_status | Delivery status of a campaign. Veneno Statuses: DELAYED_DELIVERY, CLICKED,OPENED, SENT, DELIVERED, NOT_DELIVERED, FAILED, SENT_TO_NSADMIN, SENT_TO_CALL_TASK, BLOCKED, DND_BLOCKED, NDNC_BLOCKED, CREDIT_LIMIT_EXCEEDED, RELEVANCE_TIMEOUT , PARTIAL_RESPONSE,RATE_LIMIT_EXCEEDED, IN_GTW ,HARD_BOUNCED, SOFT_BOUNCED,TIMEOUT, RETRY_TIMEOUT , HANDLER_NOT_FOUND, OPENED_INTOUCH, CLICKED_INTOUCH, MARKED_SPAM, GTW_NOT_FOUND, ,ORG_DISABLED,MARKED_UNSUBSCRIBED, SUBSCRIPTION_SERVICE_ERROR, GTW_PROCESSED, MOBILE_WHITELISTED_BLOCKED |
campaign_group | Name of the campaign group |
campaign | Name of the campaign |
campaign_message | |
campaign_schedule_date | Date when a campaign is scheduled |
campaign_schedule_time | Time when a campaign is schedules |
communication_channel | Communication channel of campaign messages |
communication_type | Type of communication. Values: Test, Control, Trans, Trans_EMF |
email_open_date | Date when customer opened the email message |
email_open_time | Time when customer opened the email message |
Date | Date of transaction of a customer during campaign period |
Time | Time of transaction of a customer during campaign period |
User | Responder details |
User Segments | If any user segments created |
Store Hierarchy | Transacted store details |
Concept Hierarchy | Transacted concept details |
Product | Purchased item details |
Product Attributes | Attributes of the item that are available |
Line Item Outlier | Outlier status of Lineitem |
Loyalty | Loyalty type of the customer - loyalty, non-loyalty |
Repeat | Customer repeat status - customer visit > 1 |
Source | Customer registered source. Values: Instore, e-comm, newsletter, campaigns, NCA, wechat, martjack, webengage, facebook, tmall, others |
unsubscription status | Unsubscription status of the user fpr a specific campaign |