Column | Description |
message_count | Sum of credits used for the individual communication |
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 to a user |
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 |