Contacted Standard Export Template
The Contacted template is based on the Contact Info fact table.
This template consists of details of customers that were contacted for a specific campaign., except for timeline campaigns.
Measures
Measure | Description |
---|---|
auto_update_time_comm_details | Date and time (in Unix timestamp) when bill level extended fields are updated |
auto_update_time_contact | Date and time (in Unix timestamp) when the contact table is updated |
message_body | Template of a campaign message |
msg_id | This is the template id generated for each message template of a campaign. For example, if there are 5 types of messages sent in a campaign, it will have 5 msg_ids |
nsadmin_id | This is the communication id at its lowest level. Each nsadmin_id corresponds to a specific communication sent to a customer |
open_count | Total count of open for an email message |
total_link_click_count | Total count of click for an email message |
unsubscribed | If marked as yes if customer unsubscribed otherwise it will be written NOT-YET |
year | This is a partition column mainly on year(event_date), this columns helps in faster execution of codes when you need a particular year |
Dimensions
campaign_delivery_status, campaign_group, campaign, campaign_message, communication_channel, contact_date, contact_time, email_open_date, email_open_time, event_date, event_time, event_user, event_zone_till, latest_updated_date, latest_updated_time, unsubscription_status, communication_type
Updated 6 days ago