Top 10 sent campaigns ranked by ecommerce.total_revenue. Answer to merchant question #1 (which campaign drove most revenue).
At a glance
The top 10 sent campaigns in the period, ranked by Mailchimp-attributed revenue. Direct answer to the most-asked merchant question: “which email made me the most money this quarter?” Pullsreports.ecommerce.total_revenuefromGET /3.0/reports?type=regular,absplitand ranks descending. Excludes Customer Journey emails (those rank in Top Automation Revenue).
Calculation
Calculated automatically from your Mailchimp data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A small DTC kitchenware brand on Shopify, Mailchimp Standard, single audience of 31,000. 90D window 02 Feb 26 to 02 May 26.
Five observations:
- Mother’s Day at £14,200 is 23% of all campaign revenue from a single send. This is the canonical Mailchimp pattern: tentpole moments compound. One well-timed campaign can match three months of weekly newsletters. Plan the calendar around tentpoles (Mother’s Day, Father’s Day, Black Friday, Christmas), not around fill-in-the-cadence sends.
- Segmented sends punch above their weight on revenue-per-recipient. The knife-sharpening masterclass at #5 reached 18,400 (segmented to engaged subscribers) and generated £4,800, or £0.26 per recipient. The general March newsletter at #10 reached 29,800 (whole list) and generated £1,400, £0.05 per recipient. Segmented sends are 5x more efficient. This is the main lever for closing the gap with Klaviyo’s segment-first model.
- Click rate predicts revenue rank better than open rate. The top-revenue campaigns sit at 3-5% click vs the bottom at 1.6-2.4%. Open rates are tightly clustered (48-58%) because of MPP inflation, click rate has more separation. Use click rate as the primary leading indicator, not open rate.
- The referral campaign at #6 underperforms because of the offer mechanic. “Refer a friend, get £10 off” requires friction (sharing a link), which suppresses immediate-purchase intent. The £3,200 attributed revenue is from existing customers redeeming, not from new acquisition. Pure-promotion sends out-revenue mechanic-required campaigns 2-3x.
- Top-10 alone covers 67% of all campaign revenue. The remaining 35+ campaigns sent during the window contributed the other 33%. The Pareto skew is strong, focus optimisation effort on the top 10 (better subject lines, better timing, better segmentation), not on the long tail. Cutting low-revenue campaigns by 50% would barely affect total but would protect deliverability and reduce list fatigue.
Sibling cards merchants should reference together
Reconciling against the vendor’s own dashboard
Where to look in Mailchimp’s own dashboard: Mailchimp → Reports supports sorting by “E-Commerce Revenue” (column header click). The top-N here should match this card. Mailchimp → Reports → Comparative Reports lets you build a custom view filtered by date range. The All Reports list with date filter set to the same 90D window is the closest direct match. Other Mailchimp views that look like the same number but aren’t:- Audience → All Contacts → Activity feed: per-contact recent activity, not campaign rankings.
- Account Overview → Recent campaign performance: last 5 sends, not top-10 by revenue.
- Campaigns → list filtered by status: shows recent sends, not ranked by revenue.
Cross-connector reconciliation:
Top campaigns is a Mailchimp-internal ranking. Closest cross-references: