High-Value Square Customers Unengaged on Email, broken down by row.
At a glance
A cross-channel revenue-at-risk audit. It cross-references your highest-spending customers in the Square Customers Directory against engagement in your email platform (Klaviyo, Dotdigital, Mailchimp, or similar) and lists the top spenders who are either not in the email audience at all or have gone cold (no opens or clicks in the window). These are proven buyers you are failing to retain through your cheapest channel.
| What it counts | Top-spending Square customers (ranked by total spend in the Customers Directory) whose matching email contact is missing, unsubscribed, or shows no email engagement in the window. One row per flagged customer. |
| Channel / source treatment | Cross-channel by definition. It joins the Square Customers Directory (spend, email_address) to your email platform’s engagement data (subscribed status, last open / click). Meaningless without an email connector configured. |
| How customers are matched | On email_address. A Square profile with no email cannot be matched, which is itself a capture gap surfaced by sibling cards. |
| Currency / unit | Count of flagged customers (whole number). Each row also shows the customer’s Square spend so you can size the exposure. |
| Time window | 90D (engagement assessed over the trailing 90 days; spend ranked over the customer’s history). |
| Alert trigger | Fires when more than 20 top spenders are unengaged on email. The list is ranked by Square spend, highest exposure first. |
| Roles | owner, marketing |
| Why it is revenue at risk | A proven high-spend customer with no email reach has a far higher lapse risk and a far lower reactivation cost than acquiring a new one. Every name here is retention revenue you are not defending. |
| The two failure modes | (1) Never captured / never synced, the Square profile has an email but it is not in the email platform. (2) Cold, the contact exists but has not opened or clicked, often a deliverability, frequency, or relevance problem. |
Calculation
Calculated automatically by cross-referencing your Square Online data against your connected email platform. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A US specialty wine shop on Square. One store plus a Square Online storefront for club shipments and gifting, with Klaviyo as the email platform. The audit is reviewed on the morning of 14 Mar 26. Each row is a flagged high-value customer.| Square customer | Square spend (lifetime) | In email platform? | Last email open | Flag reason |
|---|---|---|---|---|
| customer A (collector, monthly club) | $8,420 | No | n/a | Has email in Square, never synced to Klaviyo |
| customer B (corporate gifting) | $6,150 | Yes, subscribed | 142 days ago | Cold, no open in 90 days |
| customer C (in-store regular) | $4,900 | No email on profile | n/a | No email_address captured at POS |
| customer D (web subscriber) | $3,780 | Yes, unsubscribed | 210 days ago | Opted out, now unreachable |
| customer E (case buyer) | $3,310 | Yes, subscribed | 88 days ago | Cold, borderline outside window |
| … 19 more flagged | mixed | mixed | mixed | mixed |
| Flagged top spenders (this card) | 24 |
- The flag has distinct root causes that need different fixes. customer A has an email in Square that never reached Klaviyo, a sync or consent-mapping gap. customer C has no email on the profile at all, a POS capture gap, fix it at the register and via Customer Capture Source (POS vs Online). customer D opted out, which is a permission reality, not a sync bug. Reading the flag reason column tells you which playbook to run.
- Exposure is sized by Square spend, not by count. 24 customers sounds small, but the top five alone represent over $26,000 of proven lifetime spend. Work the list top down by spend, the highest-value lapses are the most urgent and the most reactivatable.
- This crosses the 20-customer alert threshold. With 24 flagged, the Vortex IQ Nerve Centre alert fires. Pair with Email Opted-In Customers to see the directory-wide opt-in gap and Square Orders to Email Attribution to see the revenue your email programme is and is not influencing.
Sibling cards merchants should reference together
| Card | Why pair it with High-Value Square Customers Unengaged on Email |
|---|---|
| Email Opted-In Customers (Directory) | The directory-wide permission picture. This card is the high-value, unreachable tail of that opt-in gap. |
| Total Customers (Directory) | The full audience these flagged spenders sit inside. Frames how concentrated your value-at-risk is. |
| Customer Capture Source (POS vs Online) | Explains the “no email on profile” rows. POS capture gaps are the root cause of unmatchable high spenders. |
| Square Orders to Email Attribution | The revenue side of the same cross-channel story, how much Square revenue your email programme actually influences. |
| Repeat Purchase Rate | High spenders going cold on email are the ones most at risk of not repeating. This card quantifies the retention exposure. |
klaviyo | The email-platform side of the join. Use it to confirm subscribed status, suppression, and last-engagement detail per contact. |
Reconciling against Square
Where to look in the Square Dashboard: Square Dashboard, Customers, Directory. Sort by spend to find your top customers, and open each flagged profile to confirm itsemail_address and creation_source. Square’s customer Insights and groups can isolate high spenders, but Square alone cannot tell you whether a customer is engaged in your email platform, that is the cross-channel half of this card.
Other Square Dashboard views that look like the same issue but aren’t:
- Customers, Directory sorted by spend: confirms who your top spenders are and whether they have an email on file. This is the Square half of the join.
- Customer groups (for example “spent over $500”): a useful way to define high value, but it has no email-engagement dimension.
- Marketing audience size: shows who is eligible for a Square campaign, not who is cold in an external email platform.
- Customer Insights: behavioural summaries, not per-contact email-engagement status.
| Reason | Direction of divergence |
|---|---|
Email match on email_address. A high spender with a typo’d or secondary email may fail to match the email platform even though they are engaged under a different address. | Vortex IQ may over-flag until emails are deduplicated |
| Engagement window. A customer who opened on day 91 is cold by the 90-day window but engaged by a longer lens. Borderline cases sit near the boundary. | Boundary customers move in and out by a few |
| Suppression and consent. An unsubscribed or suppressed contact is correctly flagged as unreachable even though they exist in the email platform. | Vortex IQ correctly flags opted-out high spenders |
| Sync lag. A recent engagement or a new sync from the email platform may take a cycle to reach our index. | Self-resolves within minutes |
| Card | Expected relationship | What causes legitimate divergence |
|---|---|---|
klaviyo | Each flagged customer should be absent, unsubscribed, or show no recent engagement in the email platform | Email matching is on email_address. Mismatched, secondary, or typo’d emails can make a contact look absent when they are engaged under another address. Deduplicate emails to tighten the match. |
| Square Orders to Email Attribution | High unengaged spend should correlate with high unattributed Square revenue | If many top spenders are unreachable by email, a large share of Square revenue will show as not influenced by email. The two cards move together. |
Known limitations / merchant FAQs
What makes a customer “high value” here? Total spend recorded against their profile in the Square Customers Directory. The card ranks customers by spend and assesses the top of that list. Square aggregates spend across in-store and online for the same profile, so a customer who buys mostly in-store still qualifies if their lifetime spend is high. What does “unengaged on email” mean exactly? One of three things: the customer is not in your email platform at all, they are present but unsubscribed or suppressed, or they are subscribed but have not opened or clicked an email in the 90-day window. The flag reason on each row tells you which, because each needs a different fix. Why is a customer with an email in Square flagged as not in the email platform? Because the email never synced or never gained consent in the email platform. This is the most common and most fixable case, a Square profile has the address but it was never passed to Klaviyo, Dotdigital, or Mailchimp, or the consent mapping was missed. Check your Square-to-email-platform sync rules. A flagged customer has no email on their Square profile. What do I do? That is a capture gap, not an engagement gap. The customer spends with you but you have no way to email them at all. Fix it at the point of capture, prompt for email at the register and at checkout, and review Customer Capture Source (POS vs Online) to see how widespread the POS capture gap is. Should I email customers who unsubscribed? No. An unsubscribed contact is flagged here so you understand the exposure, not so you can mail them anyway. Respect the opt-out. For these customers the lever is in-store or a different channel, not email. The card surfaces them so the lapse is visible and not silently written off. Why does the same customer drop on and off the list? Engagement is assessed over a rolling 90-day window. A customer who opens an email moves out of “cold”, and one whose last open ages past 90 days moves back in. Matching is onemail_address, so a typo’d or secondary address can also flip a customer’s status. Deduplicate emails to stabilise the match.
Can I change the threshold or the window?
Yes. The default alert fires above 20 flagged top spenders over a 90-day engagement window. Both the count threshold and the engagement window can be tuned per merchant in your Vortex IQ workspace settings if your programme cadence is different.