Dashboard Explore Dictionary (SMS Rollup)

Dimensions

Name Description
sms_reference Unique reference used to identify an SMS
customer_id Unique reference used to identify a customer
send Boolean value showing whether an SMS is sent or not
campaign_id Unique reference used to identify a campaign
campaignemailid Unique reference used to identify an SMS variant
campaign_name Name of Email/SMS Campaign
ref_count_sent Number of SMS that have been sent
ref_count_delivered Number of SMS that have been delivered
ref_count_clicks Number of SMS that have been clicked
first_delivered Date at which the SMS was first delivered
first_clicked Date at which the SMS was first clicked
first_sent Date at which the SMS was first sent
last_delivered Date at which the SMS was last delivered
last_clicked Date at which the SMS was last clicked
last_sent Date at which the SMS was last sent
time_to_delivery Hours from when the SMS was first sent and first delivered

Measures

Name Description
count_sent Number of SMS that have been sent
count_sent_distinct_customer Number of customers that have had SMS sent
30_day_count_sent_distinct_customer Number of customers that have had SMS sent in the last 30 days
30_day_sent_count Number of SMS that have been sent in the last 30 days
previous_30_day_sent_count Number of SMS that have been sent in the previous 30 days
previous_30_day_count_sent_distinct_customer Number of customers that have had SMS sent in the previous 30 days
sends_per_customer Number of SMS sent per customer
30_day_sends_per_customer Number of SMS sent per customer in the last 30 days
previous_30_day_sends_per_customer Number of SMS sent per customer in the previous 30 days
count_clicks Number of SMS that have been clicked
count_clicks_distinct_customer Number of customers that have had SMS clicked
count_clicks_distinct_campaigns Number of campaigns that have had SMS clicked
30_day_count_clicks_distinct_customer Number of customers that have had SMS clicked in the last 30 days
30_day_clicks_count Number of SMS that have been clicked in the last 30 days
previous_30_day_clicks_count Number of SMS that have been clicked in the previous 30 days
previous_30_day_count_clicks_distinct_customer Number of customers that have had SMS clicked in the previous 30 days
30_day_click_per_customer Number of SMS clicked per customer in the last 30 days
previous_30_day_click_per_customer Number of SMS clicked per customer in the previous 30 days
click_rate Ratio of sms clicked based on the number of sms opened
30_day_click_rate Ratio of sms clicked based on the number of sms opened in the last 30 days
previous_30_day_click_rate Ratio of sms clicked based on the number of sms opened in the previous 30 days
delivered_count Number of SMS that have been delivered
count_delivered_distinct_customer Number of customers that have had SMS delivered
count_delivered_distinct_campaigns Number of campaigns that have had SMS delivered
30_day_delivered_count_distinct_customer Number of customers that have had SMS delivered in the last 30 days
30_day_delivered_count Number of SMS that have been delivered in the last 30 days
previous_30_day_delivered_count Number of SMS that have been delivered in the previous 30 days
previous_30_day_delivered_count_distinct_customer Number of customers that have had SMS delivered in the previous 30 days
30_day_delivered_per_customer Number of SMS delivered per customer in the last 30 days
previous_30_day_delivered_per_customer Number of SMS delivered per customer in the previous 30 days

Still need help? Contact Us Contact Us