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.
| What it counts | The count of high-value OpenCart customers (top spenders) whose email engagement over the window is below the engagement threshold (no opens or clicks). |
| How “high value” is defined | Top spenders by order total, read from oc_order aggregated per oc_customer. The threshold is the top spend tier; the detail view lists each customer and their spend. |
| How “unengaged” is defined | No opens or clicks recorded by the connected email platform over the engagement window. Engagement data comes from the email connector, not from OpenCart. |
| Currency | Spend is read from oc_order in the order’s stored currency; multi-currency stores mix currencies without FX. The headline count is currency-agnostic. |
| Channels / sources | OpenCart customers and orders joined with a separately connected email platform. OpenCart has no native email engagement, so the email connector supplies the engagement half. |
| Why this matters | High-value customers are the most expensive to lose and the most profitable to retain. A top spender who stops engaging with email is an early churn signal you can act on while they are still a customer. |
| Time window | 90D (engagement assessed over a rolling 90 days) |
| Alert trigger | >20 top spenders unengaged |
| Roles | owner, marketing |
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).| Customer tier | Customers | Engaged on email (90d) | Unengaged | Avg spend (12m) |
|---|---|---|---|---|
| Top spenders (top 5%) | 140 | 112 | 28 | EUR 1,180 |
| Mid spenders | 1,260 | 690 | 570 | EUR 240 |
| Casual / one-time | 4,800 | 1,100 | 3,700 | EUR 64 |
| High-value unengaged (this card) | 28 |
- 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
| Card | Why pair it with High-Value Customers Unengaged on Email |
|---|---|
| Repeat Customer Rate | The retention headline. This card is the high-value slice of the churn risk it measures. |
| Total Customers | The base. This card is the most valuable, most at-risk corner of it. |
| New Customers (30d) | Acquisition only pays off if you retain the best buyers. The two sit at opposite ends of the lifecycle. |
| Newsletter Opt-In Rate | Reachability upstream. You cannot re-engage a top spender who never opted in. |
| Orders to Email Attribution | The revenue email actually drives. If this card is high, attribution from your best customers is leaking. |
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.
| Reason | Direction of divergence |
|---|---|
| Spend window vs lifetime. “High value” can be defined over the lifetime or a window; if your manual cut uses a different window, the cohort differs. | Either direction |
| Engagement window. This card uses a 90-day engagement window; an email-platform report using 30 or 60 days will classify more or fewer customers as unengaged. | Either direction |
| Identity matching. Customers are matched between OpenCart and the email platform by email address. A customer who uses different addresses, or whose email is not synced, may be miscounted. | Either direction |
| Multi-currency spend. Top-spender ranking mixes currencies without FX; a converted ranking may reorder the tail of the cohort. | Marginal at the tier boundary |
| Sync lag. Recent opens, clicks, or orders appear on the next sync. | Self-resolves at next sync |
| Card | Expected relationship | What causes legitimate divergence |
|---|---|---|
klaviyo.unengaged_profiles | The email platform’s own unengaged segment should overlap heavily with this cohort, once filtered to high spenders. | The email platform does not know OpenCart spend, so its unengaged segment is not spend-filtered. This card adds the spend filter OpenCart provides. |
dotdigital.engagement_score | Low-engagement-score contacts who are also top OpenCart spenders are this card’s population. | Score thresholds and windows differ between the email platform and this card. |
| Orders to Email Attribution | As this card rises, attributed revenue from top customers tends to fall. | Attribution depends on click-through, not opens; the relationship is directional, not exact. |