This week, I'm going to introduce you to analysing your email data using SQL and a Redshift datastore. Using data sent to a Redshift database from Vero, we'll put together a chart that will help you start to conceptualize how you could build out a detailed and accurate Email Dashboard for your organization. This will also further the skills you need to analyze your email marketing data using ...
Latest
Migrating to Vero from Mandrill
If you're a Mandrill customer, last week you will have read that Mailchimp is unifying Mandrill with its Mailchimp product suite. We have immense respect for the Mandrill platform, particularly as it is used by many of Vero's customers. With the upcoming changes, we understand that some of Mandrill's transactional customers will have questions around what Mailchimp's new changes mean for them and ...
Graphing net churn using Redshift and SQL
In 2015 two important trends emerged that everyone working to create great products and customer experiences will be interested in: It is easier than ever before to synchronise data from your SaaS tools into a data warehouse (often Amazon's Redshift). There are more and more great tools (Periscope, RJ Metrics, Looker) that allow you to query and chart the data in your warehouse in a ...
Why Most Newsletters Fail
2015 was the year of the newsletter. Tools like Curated, Goodbits and TinyLetter made it easier than ever to start a newsletter. Many people took advantage of these great tools and began building lists and curating content. The problem? These tools don't suddenly make people care about what you have to say. Marketers, the chief offenders of bad emails, took it too far this year. Most ...
The MeUndies Lifecycle: Send Great Emails Before and After the Sale
Photo: MeUndies Most email marketing happens before the sale, but that's just the beginning of the customer lifecycle. The most successful businesses send their best emails after the signup, purchase or conversion. Creating lifecycle emails require that marketers look at the whole customer, not just the sale. I was reminded of this after making a recent purchase from MeUndies. The post-purchase ...