Per-campaign ecom revenue attribution. Surfaces high-engagement campaigns that don’t convert (broken CTA or wrong audience).
At a glance
A per-campaign table that joins each Mailchimp campaign’s engagement (sends, opens, clicks) with the store revenue it actually drove over a 90-day window. This is a cross-platform card: the engagement comes from Mailchimp, the revenue comes from your store via the ecom integration, and the value is in reading the two together. The most important pattern this card surfaces is the high-engagement, low-revenue campaign, a send that earned a great open and click rate but almost no store revenue. That gap is a diagnosis, not just a data point: it means either the click destination was broken (a dead CTA, a wrong link, an out-of-stock product), or the audience was wrong (engaged people who were never going to buy this), or the offer did not survive contact with the checkout (a price or shipping surprise). A campaign that engages but does not convert is wasted reach and a fixable leak. The card lets the marketing team rank by revenue while also catching the campaigns whose engagement promised revenue that never arrived.
Calculation
Calculated automatically from your joined store and 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 home-fragrance brand on Shopify running Mailchimp Standard. Snapshot of the campaign table for the 90-day window ending Friday 12 Jun 26 (illustrative figures, top campaigns shown).
What this table is telling us:
- The “Our Story” brand email is the alert. It had the highest engagement of any campaign in the quarter, 38 percent open, 5.2 percent click, and drove essentially no revenue (£85). That is the classic high-engagement, low-revenue leak, and at over 30 percent open with under £100 revenue, it trips the card’s alert condition. Something is wrong with where those clicks went.
- Diagnosing the “Our Story” gap. The email clearly resonated, lots of people opened and clicked, so the subject line and content were excellent. The failure is downstream of the click. Candidates: (a) the email was a brand-story piece with no product or offer, so the clicks went to a content page that was never going to convert (in which case the “leak” is by design and this is fine, brand emails are not always meant to sell); (b) the CTA linked to a broken, expired, or out-of-stock page; (c) the click destination was a generic homepage rather than a shoppable landing page. Action: check the CTA destination. If it was an intentional brand email with no sell, note that and move on; if it was meant to drive revenue, the broken or weak CTA is the fixable leak.
- The Restock email is a replication target. Modest reach (12,300 sent, the smallest send) but £9,900 revenue, an excellent revenue-per-send. It found exactly the right buyers (people waiting for a bestseller to come back in stock). Action: this is a template to repeat, restock and back-in-stock triggers to engaged-but-waiting segments are high-converting; do more of this.
- Mother’s Day and Spring Launch are healthy top performers. Strong engagement and strong revenue, no gap. These are working as intended and need no diagnosis.
- The newsletter is a steady baseline. Ordinary engagement, steady revenue. Not a problem, but also not a growth lever, it is the programme’s reliable floor.
-
The cross-platform insight in one line. Mailchimp’s own report would have crowned “Our Story” the best campaign of the quarter (highest open and click rates). Only by joining store revenue does the truth appear: it was the worst revenue performer despite the best engagement. This is exactly why the card exists. Cross-reference
top-campaigns-by-revenuefor the pure revenue ranking.
- Confirm intent. Was the campaign meant to sell? A pure brand or content email with no offer is allowed to engage without converting; do not treat it as a leak.
- Check the CTA destination. For a campaign meant to sell, the most common cause is a broken, expired, out-of-stock, or generic click destination.
- Check the audience. Engaged-but-wrong-audience converts poorly; confirm the segment matched the offer.
- Check the checkout for clickers. A strong click rate that fails to convert can be a store-side checkout or pricing problem.
- Replicate the winners. Use the inverse pattern, modest engagement with strong revenue, to find templates worth repeating.
Sibling cards merchants should reference together
Reconciling against Mailchimp
Where to look in Mailchimp’s own dashboard, and in your store:- Mailchimp → Reports → All campaigns for per-campaign sends, open rate, click rate, and the revenue Mailchimp’s ecom integration attributes.
- Mailchimp → Account → Integrations to confirm the store ecom integration is connected, this is what populates the revenue column.
- Your store’s order and analytics dashboard for the actual order and revenue figures the attribution is matched against.
Quick rule for support tickets: when a merchant says “Mailchimp says this was my best campaign but your card shows it made no money”, explain that Mailchimp’s “best” is usually best by engagement (open and click rate), while this card ranks and diagnoses by revenue. A campaign can top the engagement chart and bottom the revenue chart, which is precisely the leak worth finding. The next step is checking where those clicks went: a broken or weak CTA, a wrong audience, or a brand email that was never meant to sell.
Known limitations / merchant FAQs
A campaign had amazing open and click rates but made almost no money. Did the tracking break? Usually not, more often the clicks went somewhere that does not convert. The email succeeded (strong opens and clicks mean the subject line and content worked), but the click destination failed: a broken or expired CTA link, an out-of-stock product, a generic homepage instead of a shoppable page, or a wrong audience that engaged but was never going to buy. Sometimes it is intentional, a brand or content email with no offer is supposed to engage without selling. Check the CTA destination and the campaign’s purpose before assuming a tracking fault. My brand-story emails always show high engagement and low revenue. Is that a problem? Not if they were not meant to sell. Brand-story, content, and relationship emails earn engagement (people enjoy them) without driving direct revenue, and that is a legitimate role in the calendar, they build the relationship that makes later selling emails work. The card flags the pattern so you can confirm intent; for a deliberate brand email, note it and move on. The pattern is only a leak when a campaign that was meant to sell engages but does not convert. Why 90 days and not 30? A quarter captures enough campaigns to surface patterns (a single month may have too few sends to compare meaningfully) and gives slower-converting purchases time to attribute. High-consideration or higher-priced categories convert over days or weeks after a campaign, so a 30-day window would under-credit them. The 90-day window balances pattern-richness with full attribution. Should I judge a campaign by revenue or by engagement? By both, which is the whole point of this card. Revenue alone misses campaigns that engaged but leaked (fixable). Engagement alone misses campaigns that converted quietly (replicable). The two together tell you which campaigns to fix (high engagement, low revenue), which to replicate (modest engagement, strong revenue), and which are simply healthy (both strong). Reading them in isolation hides exactly the insights that matter. The revenue column is lower than my store’s total email revenue. Why? Several reasons: the attribution window may exclude slow-converting orders; last-touch attribution credits only one campaign when a customer was touched by several; or the ecom integration may not have back-filled all orders if it was recently connected. The per-campaign figures are attributed, conservative numbers; for the store-wide email revenue total, seeemail-attributed-revenue, and confirm the ecom integration is fully connected.
Can Vortex IQ fix the broken CTA or rework the campaign?
No. Vortex IQ is read-only by design. It joins the engagement and revenue data, surfaces the high-engagement-low-revenue leaks, and points at the likely cause; fixing the CTA, reworking the audience, or repairing the checkout happens in Mailchimp and your store by the merchant’s teams. The Vortex Mind Customer Recovery Opportunity report can raise a merchant-side Action naming the leaking campaign, but the changes stay with the merchant.