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-channel 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.
| What it counts | Per campaign, over 90 days: emails sent, open rate, click rate, and store revenue attributed to the campaign via the ecom integration. Sortable by revenue (which earned the most) and readable for the engagement-to-revenue gap (which engaged but did not convert). |
| Why cross-channel | Engagement (opens, clicks) is a Mailchimp number; revenue is a store number. A campaign that looks great in Mailchimp’s report can have driven almost no actual orders, and only the join reveals it. |
| The key pattern: high engagement, low revenue | A campaign with a strong open and click rate but negligible revenue is the diagnostic prize. The clicks went somewhere that did not convert: a broken CTA, a wrong or expired link, an out-of-stock product, a wrong audience, or a checkout surprise. Each is a fixable leak. |
| The inverse pattern: modest engagement, strong revenue | Worth noting too, a campaign with ordinary opens but high revenue found the right buyers. These are templates to replicate, not problems to fix. |
| Currency | Revenue per campaign, in the store’s currency, attributed by the ecom integration. The store-wide total surfaces in total-revenue and the email share in email-share-of-total-store-revenue. |
| Time window | 90D (90-day rolling). A quarter captures enough campaigns to surface patterns and to let slower-converting sends fully attribute. |
| Alert trigger | Any campaign with a strong open rate (over ~30 percent) driving negligible store revenue (under ~£100), the high-engagement-low-revenue leak. |
| Sentiment key | mc_xc_ecom_purchase_attribution |
| Roles | owner, marketing, finance |
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).| Campaign | Sent | Open rate | Click rate | Ecom revenue | Read |
|---|---|---|---|---|---|
| Spring Collection Launch | 44,000 | 31% | 4.1% | £18,400 | strong all round |
| Mother’s Day Edit | 42,500 | 34% | 4.6% | £21,200 | top performer |
| ”Our Story” brand email | 40,800 | 38% | 5.2% | £85 | high engagement, near-zero revenue |
| Restock: Bestseller Candles | 12,300 | 29% | 3.8% | £9,900 | modest reach, strong revenue |
| Weekly Newsletter (avg) | 41,000 | 26% | 2.4% | £3,100 | steady baseline |
- 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-channel 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.
| Time horizon | Action |
|---|---|
| First 4 hours | Identify the high-engagement, low-revenue campaign and confirm whether it was meant to sell. |
| First day | For a selling campaign, check the CTA destination and audience match; for a store-side leak, route to the commerce team. |
| First week | Replicate the high-revenue-per-send winners; rework or retire the engagement-without-revenue campaigns that were meant to sell. |
| First month | Track the engagement-to-revenue gap across campaigns as a standing quality check on the campaign calendar. |
Sibling cards merchants should reference together
| Card | Why merchants reach for it |
|---|---|
top-campaigns-by-revenue | The pure revenue ranking. This card adds the engagement dimension to catch the high-engagement, low-revenue leaks. |
email-attributed-revenue | The total revenue Mailchimp drove; this card decomposes it per campaign. |
email-share-of-total-store-revenue | How much of total store revenue email drives; the campaign table is the per-send detail behind it. |
email-click-rate | The click engagement the revenue should follow; a click-rich, revenue-poor campaign is the leak. |
conversion-rate | The programme-wide conversion benchmark to judge a campaign’s revenue-per-click against. |
cart-abandonment-email-open-ecom-recovery | The automation-level cross-channel funnel; this card is the campaign-level equivalent. |
revenue-per-send | The per-send efficiency metric; the restock-style winners stand out here. |
segments-overview | Wrong-audience leaks are a segmentation problem; use to audit which segment a low-converting campaign targeted. |
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.
| Reason | Direction | What to do |
|---|---|---|
| Attribution window. Revenue is credited to a campaign within a configured window after the click; orders outside it are not attributed. | Vortex IQ may read lower for slow-converting categories | Confirm the account’s attribution window; longer windows credit more revenue per campaign. |
| Last-touch vs multi-touch. Mailchimp’s ecom attribution is typically last-touch within window; a customer touched by several campaigns may credit only one. | Either direction | Understand that high-consideration purchases may under-credit early-funnel campaigns. |
| Ecom integration coverage. If the store integration is partially connected or recently reconnected, some orders may not be attributed. | Vortex IQ may read lower | Confirm the ecom integration is fully connected and back-filled. |
| MPP opens. The open rate column is MPP-inflated; the engagement-to-revenue gap can look larger than it is because the open rate is padded. | Open rate inflated | Weight the click rate over the open rate when judging the engagement side of the gap. |
| Refresh lag. The table recalculates each sync; Mailchimp and store dashboards update on their own cadences. | Vortex IQ moves slowly | Wait for the next sync; check last_synced_at. |
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.