Email campaign performance
“compare our email campaigns by open rate, click rate and unsubscribe rate, and revenue”
Compare our Mailchimp campaign report by open rate, click rate and unsubscribe rate, and revenue.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
- FileMailchimp campaign reportCSV export · 10 rows
- StepShow campaign performanceStep 1
- ResultCampaign Performance Comparison10 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 10 rows came out.
- Download Mailchimp campaign report sample (10 rows)Mailchimp: Campaigns > All campaigns > Export as CSV
What you get back
The result of that run, the rows to look at first.
| Campaign Name | Open Rate | Click Rate | Unsubscribe Rate | Revenue |
|---|---|---|---|---|
| Fall Preview | 38% | 5% | 0.3% | 18,450 |
| October Launch | 37.5% | 6.9% | 0.4% | 25,680 |
| Welcome Series | 43.3% | 7.2% | 0.2% | 14,220 |
| VIP Offer | 43% | 7.1% | 0.5% | 38,740 |
| Product Tips | 34.2% | 2.8% | 0.1% | 9,620 |
| Midweek Deal | 30.2% | 5.4% | 0.3% | 17,310 |
| Customer Stories | 42.5% | 6.3% | 0.3% | 30,110 |
| Holiday Teaser | 36.5% | 3% | 0.2% | 11,840 |
| Black Friday Preview | 32.3% | 7.8% | 0.5% | 44,120 |
| Reactivation Blast | 24% | 2.4% | 0.2% | 3,120 |
How do you compare email campaigns by open rate, click rate, unsubscribe rate, and revenue?
Export your Mailchimp campaign report, then upload it to Mammoth. The workflow shows campaign performance and compares the campaigns by open rate, click rate, unsubscribe rate, and revenue. Rows that do not match the required columns stay out of the result until you change the rules.
How it works
How to use the Campaign Performance Comparison workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Campaign Performance Comparison: questions
What export should you use?
What happens to rows that do not match?
How do you change the rules?
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Decide which pages to keep, update or prune, and find the search terms that spend without converting.
- Customer acquisition cost by channelCalculate customer acquisition cost by channel each month from HubSpot exports, with CAC rounded to whole dollars and a simple status.See the workflow Built by the agent
- ROAS by campaignCalculate ROAS by campaign from Google Ads and Shopify exports, matched by week and utm campaign.See the workflow Built by the agent
- Content auditEvery page's clicks now and before, and a keep, update or prune callSee the workflow Template
- Google Ads wasted spendFind search terms with spend and no conversions in the last 30 days, ranked by spend, from a Google Ads export.See the workflow Built by the agent
- Keyword rankings changeCompare this month's average position with last month from Search Console and see which keywords moved up or down in a keyword ranking report.See the workflow Built by the agent
- Negative keyword finderEvery search term that spent money and never converted, with its share of spendSee the workflow Template