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

MeasureDescription
auto_update_time_comm_detailsDate and time (in Unix timestamp) when bill level extended fields are updated
auto_update_time_contactDate and time (in Unix timestamp) when the contact table is updated
message_bodyTemplate of a campaign message
msg_idThis 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_idThis is the communication id at its lowest level. Each nsadmin_id corresponds to a specific communication sent to a customer
open_countTotal count of open for an email message
total_link_click_countTotal count of click for an email message
unsubscribedIf marked as yes if customer unsubscribed otherwise it will be written NOT-YET
yearThis 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