Finding out the Lifetime Value of Each Email Segment
Segmenting your subscribers is a great start, but are you certain how much $$ each one brings in?
After all, one might have people making single cheap purchases, whilst another contains repeat big spenders.
Cross checking MailChimp with Stripe
The key part is to match the emails between MailChimp and Stripe. We won’t pretend that’s easy, partly as that’s where we come in…
Yes, we have an app.
Gasket is a tool to automate data tasks like this. It lets you perform a ‘join’ to connect the data from two apps.
It will match the email addresses between the two, importing those that match into your Google Sheet. That way you get a table of MailChimp subscribers, complete their spending history.
You could even sort them by where the biggest spenders reside.
Diving into the data
Want to know the average time to purchase?
With the data sets combined, you can compare the opt-in time to the time of purchase. Finally you can tell the manager that yes, the 2 months of weekly emails really were worth sending.
One-click-update the status of your subscriber spending
Maybe it’s too soon to tell, so you decide to check again later?
Well with Gasket you just click the re-sync button. It will remember what filters you gave it so you can see the latest data.
That way you can get an instant update to see the spending of your MailChimp subscribers.
How to get started
Gasket is free to join today at gasket.io.
From there, the stages will be:
- Connect the apps you want to use
- Make a gasket to join and filter the data
- Add the gasket into your google sheet
- Build any graphs or reports around it
- Hit the sync button to your heart’s content
So what are you waiting for? Join Gasket today to discover the value of email list
