Dashboard Explore Dictionary (Email Rollup)

Dimensions

Name Description
campaign_id Unique reference used to identify a specific campaign
campaignemailid Unique reference used to identify a specific variation within an email campaign
campaign_name Name of Email Campaign
ref_count_not_sent Number of emails that have not been sent
ref_count_sent Number of emails that have been sent
ref_count_bounces Number of emails that have been bounced
ref_count_clicks Number of emails that have been clicked
ref_count_complaints Number of emails that have been marked as a complaint
ref_count_opens Number of emails that have been opened
ref_count_unsubscribes Number of emails that have been unsubscribed
first_bounced Date at which the email was first bounced
first_clicked Date at which the email was first clicked
first_complained Date at which the email was first complained
first_not_sent Date at which the email was first not sent
first_opened Date at which the email was first opened
first_sent Date at which the email was first sent
first_unsubscribed Date at which the email was first unsubscribed
last_bounced Date at which the email was last bounced
last_clicked Date at which the email was last clicked
last_complained Date at which the email was last complained
last_not_sent Date at which the email was last not sent
last_opened Date at which the email was last opened
last_sent Date at which the email was last sent
last_unsubscribed Date at which the email was last unsubscribed
time_to_open Hours from when the email was first sent and first opened

Measures

Name Description
count_sent Number of emails that have been sent
count_not_sent Number of emails that have not been sent
count_sent_distinct_customer Number of customers that have had emails sent
count_not_sent_distinct_customer Number of customers that have not had emails sent
30_day_count_sent_distinct_customer Number of customers that have had emails sent in the last 30 days
30_day_not_sent_distinct_customer Number of customers that have not had emails sent in the last 30 days
30_day_sent_count Number of emails that have been sent in the last 30 days
30_day_not_sent_count Number of emails that have not been sent in the last 30 days
previous_30_day_sent_count Number of emails that have been sent in the previous 30 days
previous_30_day_not_sent_count Number of emails that have not been sent in the previous 30 days
previous_30_day_count_sent_distinct_customer Number of customers that have had emails sent in the previous 30 days
previous_30_day_count_not_sent_distinct_customer Number of customers that have not had emails sent in the previous 30 days
sends_per_customer Number of emails sent per customer
30_day_sends_per_customer Number of emails sent per customer in the last 30 days
previous_30_day_sends_per_customer Number of emails sent per customer in the previous 30 days
count_opens Number of emails that have been opened
count_open_distinct_customer Number of customers that have opened emails
count_open_distinct_campaigns Number of campaigns that have had emails opened
30_day_open_count_distinct_customer Number of customers that have opened emails in the last 30 days
30_day_open_count Number of emails that have been opened in the last 30 days
previous_30_day_open_count Number of emails that have been opened in the previous 30 days
previous_30_day_open_count_distinct_customer Number of customers that have opened emails in the previous 30 days
30_day_open_per_customer Number of opens per customer in the last 30 days
previous_30_day_count_open_per_customer Number of opens per customer in the previous 30 days
open_rate Ratio of emails opened based on the number of emails sent
30_day_open_rate Ratio of emails opened based on the number of emails sent in the last 30 days
previous_30_day_open_rate Ratio of emails opened based on the number of emails sent in the previous 30 days
count_clicks Number of emails that have been clicked
count_clicks_distinct_customer Number of customers that have clicked emails
count_clicks_distinct_campaigns Number of campaigns that have had emails clicked
30_day_count_clicks_distinct_customer Number of customers that have clicked emails in the last 30 days
30_day_clicks_count Number of emails that have been clicked in the last 30 days
previous_30_day_clicks_count Number of emails that have been clicked in the previous 30 days
previous_30_day_count_clicks_distinct_customer Number of customers that have clicked emails in the previous 30 days
30_day_click_per_customer Number of clicks per customer in the last 30 days
previous_30_day_click_per_customer Number of clicks per customer in the previous 30 days
click_rate Ratio of emails clicked based on the number of emails opened
30_day_click_rate Ratio of emails clicked based on the number of emails opened in the last 30 days
previous_30_day_click_rate Ratio of emails clicked based on the number of emails opened in the previous 30 days
bounce_count Number of emails that have been bounced
count_bounce_distinct_customer Number of customers that have bounced emails
count_bounce_distinct_campaigns Number of campaigns that have had emails bounced
30_day_bounce_count_distinct_customer Number of customers that have bounced emails in the last 30 days
30_day_bounce_count Number of emails that have been bounced in the last 30 days
previous_30_day_bounce_count Number of emails that have been bounced in the previous 30 days
previous_30_day_bounce_count_distinct_customer Number of customers that have bounced emails in the previous 30 days
30_day_bounce_per_customer Number of bounces per customer in the last 30 days
previous_30_day_bounce_per_customer Number of bounces per customer in the previous 30 days
count_complaints Number of emails that have been marked as a complaint
count_complaints_distinct_customer Number of customers that have marked emails as complaints
count_complaints_distinct_campaigns Number of campaigns that have had emails marked as complaints
30_day_complaint_count_distinct_customer Number of customers that have been marked emails as complaintsin the last 30 days
30_day_complaint_count Number of emails that have been marked as complaints in the last 30 days
previous_30_day_complaint_count Number of emails that have been marked as complaints in the previous 30 days
previous_30_day_complaint_count_distinct_customer Number of customers that have marked emails as complaints in the previous 30 days
30_day_complaint_per_customer Number of complaints per customer in the last 30 days
previous_30_day_complaint_per_customer Number of complaints per customer in the previous 30 days
unsubscribe_count Number of emails that have been unsubscribed
count_unsubscribe_distinct_customer Number of customers that have unsubscribed from emails
count_unsubscribe_distinct_campaigns Number of campaigns that have unsubscribed from emails
30_day_unsubscribe_count_distinct_customer Number of customers that have unsubscribed from emails in the last 30 days
30_day_unsubscribe_count Number of emails that have been unsubscribed in the last 30 days
previous_30_day_unsubscribe_count Number of emails that have been unsubscribed in the previous 30 days
previous_30_day_unsubscribe_count_distinct_customer Number of customers that have unsubscribed from emails in the previous 30 days

Still need help? Contact Us Contact Us