Your highest-spending OpenCart customers who have stopped engaging with email. The cohort most expensive to lose, and the one your email reports rarely single out.
At a glance
A cross-connector view that joins your top OpenCart customers by lifetime or windowed spend with a connected email platform’s engagement signal (opens and clicks). It surfaces the customers who matter most to revenue but who have gone quiet on email. These are the highest-value churn risk in the store: losing one top spender costs far more than losing several casual buyers, and email is usually the cheapest channel to win them back. Because OpenCart has no native email engagement data, this card only populates when an email connector (for example Klaviyo or Dotdigital) is linked.
Calculation
Calculated automatically from your OpenCart data joined with the connected channel. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A French skincare brand on OpenCart 4.x with Dotdigital connected as its email platform. Snapshot taken 12 Apr 26, engagement assessed over the prior 90 days (13 Jan 26 to 12 Apr 26).
What’s interesting here:
- 28 top spenders are quietly disengaging, and that trips the alert. With a
>20 top spenders unengagedthreshold, the card is firing. These 28 customers average EUR 1,180 a year each, so the cohort represents roughly EUR 33,000 of annual revenue at risk. Losing them silently costs far more than the 3,700 unengaged casual buyers combined. - The casual tier is a distraction here. 3,700 casual customers are unengaged too, but they spend EUR 64 a year. The whole point of this card is to filter the noise and surface only the high-value cohort, so marketing spends its win-back effort where the money is.
- OpenCart cannot see this on its own. OpenCart knows who the top spenders are (from
oc_order), but it has no idea who opened an email. The engagement half comes entirely from the connected Dotdigital account. Without the email connector, this card stays empty, which is itself a signal that you are flying blind on retention. - The 28 are still customers today. This is a leading indicator, not a churn report. They have not left; they have gone quiet. That window, still a customer but no longer engaging, is the cheapest time to act.
- Engagement, not recency of purchase, is the trigger. A top spender might have bought last month but ignored every email since. This card catches that, where a pure recency-of-purchase view would not, because the email channel going dark predicts the next purchase not happening.
- Pull the 28 into a dedicated win-back flow in the email platform within the week. Personalise on their actual purchase history from OpenCart.
- Try a different channel for the hardest cases. If email is dark, an SMS or a direct outreach for the very top spenders may reconnect them; email-only is not the only lever.
- Check deliverability before assuming disinterest. Some “unengaged” customers are not ignoring you, your mail is landing in spam. Verify the email platform’s deliverability metrics before writing them off.
- Feed the cohort back to acquisition. If your best customers churn at this rate, the acquisition cards (New Customers (30d)) need to keep pace just to stand still.
Sibling cards merchants should reference together
Reconciling against OpenCart
Where to look in OpenCart admin: OpenCart can give you the spend half but not the engagement half. Reports → Customers → Customer Orders ranks customers by number of orders and total, which is how you identify top spenders. Customers → Customers shows the account and newsletter consent. The underlying data isoc_customer joined to aggregated oc_order totals. There is no email open or click data anywhere in OpenCart, that lives only in the connected email platform.
Other OpenCart views that look relevant but cannot answer this:
- Customers → Customers newsletter flag: tells you who consented, not who is engaging.
- Reports → Customers → Customers Online: shows site activity, not email engagement.
- Marketing → Mail: OpenCart’s own basic mailer has no per-customer open/click tracking.
Cross-connector reconciliation (OpenCart customers and orders joined with a connected email platform):