What is my email campaign Open Rate? How is my email marketing campaign performing over time?
One of the first email campaign metrics is the number of emails sent during an email campaign. Then the relevant email campaign open rate and how it changes over time.
*Open Rate: The percentage of email recipients who open a given email.
Blendo will sync all of our Mailchimp data into your data warehouse properly re-modeled for it and ready to be used for our analytics purposes. Check this post about the resources Mailchimp exposes and should be replicated on our database, in case you want to dig in more.
reportstable contains information about the performance of our campaign. It has the following structure.
create or replace email_reports_all as ( SELECT id as campaign_id, campaign_title, send_time, emails_sent, clicks\_click\_rate, clicks\_clicks\_total, clicks\_unique\_clicks, clicks\_unique\_subscriber\_clicks, opens\_open\_rate, opens\_opens\_total, opens\_unique\_opens, bounces\_hard\_bounces, bounces\_soft\_bounces, unsubscribed FROM mailchimp_reports );
SELECT campaign_title, emails_sent, opens_unique_opens, opens_open_rate, send_time FROM email_reports_all ORDER BY send_time ASC LIMIT 10 ;