Column
Description
message_countSum 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_idThis is the communication id at its lowest level. Each nsadmin_id corresponds to a specific communication to a user  
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