Contacted

The Contacted template is based on the fact Contact Info

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