Queen City — Retention Intelligence Report

Wins

Engaged Customer AOV

$69.20

+21.8% vs store avg

Blast Campaign Revenue

$74,440

Total revenue from blast campaigns

Customers Kept Loyal

$72,948

from 510 customers kept loyal during March 2026

Revenue

Store Revenue

$329,830

+10% MoM -23% YoY

Purchases

5,807

+13% MoM -20% YoY

Customers

2,529

+7.8% MoM -16% YoY

Campaign-Engaged $79,163 (24%) Organic $250,667 (76%)

AOV Comparison

STOREWIDE

$56.80

ENGAGED CUSTOMERS

$69.20

+21.8% vs store avg

Monthly Revenue Trend

Store Revenue Engaged Revenue

* Trend line: campaign-attributed (conversion) revenue — tracked consistently across all months. The Campaign-Engaged figure above uses AIQ engagement attribution and can differ slightly.

New Customer Intelligence

New Customers

308

+24% MoM

Revenue

$18,082

$57.40 AOV

Opted-In (Reachable)

163

53% capture rate

Unreachable

145

47% — no contact info

Opted-In (Email)

145

of 308 new customers

Critical Opt-In Rate (Email)

47%

First-time buyers with email

Opted-In (Text)

63

of 308 new customers

Critical Opt-In Rate (Text)

20%

First-time buyers with SMS

Loyalty Ladder Movement

Customers who advanced a purchase tier this month through campaign engagement

1 → 2

purchases

20

customers

$1,489

2 → 3

purchases

11

customers

$1,221

3 → 4

purchases

13

customers

$1,247

4 → 5

purchases

14

customers

$1,004

Kept Loyal

6+ purchases

510

customers

$72,948

Total

568

customers

$77,910

Churn Intelligence & Revenue Recovery

Total Lost Customers

17,883

60+ days lapsed

6,703 opted in

New Lost This Month

926

Newly crossed 60-day mark

558 opted in

Recovered This Month

77

1.1% recovery rate

of 6,703 opted-in lost

Recovery Revenue

$8,029

Campaign + repurchases

At-Risk Pipeline (45–60 Day Window)

At-Risk Customers

460

278 opted in

Saved by Campaign

32

Save Rate

10%

Lost Customer Pipeline

60–179 Days Lost

2,984

1,529 opted in

180–359 Days Lost

3,306

1,390 opted in

360+ Days Lost

11,593

3,784 opted in

Abandoned Cart Recovery (Lifetime)

Carts Abandoned

630

Recovered

39

Revenue

$2,655

Win-Back Revenue Recovery

CAMPAIGN REV

$4,962

REPURCHASES

$3,066

TOTAL RECOVERED

$8,029

Recovery by Lapse Timeframe

Timeframe	Customers	Revenue	AOV	% Rev
60-179 days	57	$3,657	$64.15	74%
180-359 days	15	$851	$56.74	17%
360+ days	6	$454	$75.72	9.2%
Total	78	$4,962	$63.62	100%

All Time Revenue Recovered

$12,580

Revenue Recovery — Past Months

(last 6 months only)

Month	Revenue Recovered	Campaign Revenue	Past Cohort Repurchases	Repurchase Share
March 2026	$8,029	$4,962	$3,066	38%
February 2026	$4,551	$3,671	$880	19%
Total	$12,580	$8,633	$3,947	31%

Revenue Recovery — All Time by Timeframe

Bucket	Customers	%	Revenue Recovered	AOV	Avg Days Lost	Repurchase Value	%
60-90 days	43	31%	$2,884	$67.06	76	$1,712	43%
91-120 days	24	18%	$1,684	$70.15	104	$376	9.4%
121-180 days	25	18%	$1,320	$52.81	144	$1,550	39%
181-365 days	32	23%	$1,718	$53.69	243	$205	5.1%
365+ days	13	9.5%	$956	$73.56	528	$175	4.4%
TOTAL	137	100%	$8,562	$62.50	175	$4,018	100%

List Health & Subscriber Intelligence

Total Customers (All-Time)

20,750

Known customers with purchases

Total Reachable

8,629

42% reachable

Ghosts

12,121

No email or SMS on file

Influence Rate

—

Current-snapshot metric — n/a for past months

Email List

Total Email Opt-Ins (real customers)5,242 25%

New Opt-Ins This Month229

Opt-Outs This Month81

Net List Growth+148

SMS List

Total SMS Opt-Ins (real customers)6,134 30%

New Opt-Ins This Month88

Opt-Outs This Month87

Net SMS Growth+1

Channel Mix

Email Only

2,495

29%

SMS Only

3,387

39%

Email + SMS

2,747

32%

Spin Wheel Acquisition

Lifetime Stats

Unique Visitors

56,691

Conversions

2,293

Conversion Rate

4.0%

March 2026 Stats

Signups

57

Customers

13

Non-Customers

44

First Purchase Conversions

All Time

New Customers

320

Revenue

$18,555

Avg Order

$57.98

Conv. Rate

14%

March 2026

New Customers

10

Revenue

$555

Avg Order

$55.54

Conv. Rate

18%

Campaigns

Campaign Performance — March 2026

Strategy	Sends	Revenue	MoM	Conversions	AOV	Email Open	SMS Open	Conv Rate	Unsub Rate
Active	22,320	$68,886	+27%	980	$70.29	34%	7.1%	4.4%	0.22%
Winback	28,875	$2,693	+185%	44	$61.20	37%	—	0.15%	0.13%
Weekly Lost	21,265	$2,861	-66%	49	$58.39	37%	5.0%	0.23%	0.08%
Total	72,460	$74,440		1,073	$69.38	37%	6.8%

Funnels — Automated & Recurring Campaigns (Lifetime Totals)

Lifetime performance of automated flows that sent in the reporting month — revenue and conversions are cumulative since each flow launched (not month-only), so this total is not additive with the monthly Campaigns total. These campaigns run continuously and target specific customer lifecycle stages.

Funnel	Campaigns	Sends	Revenue	Conversions	AOV	Email Open *	SMS Open *	Conv Rate	Active Since
Abandoned Cart	2	597	$2,655	39	$68.07	39%	28%	6.5%	Mar 2026
Total	2	597	$2,655	39	$68.07	39%	28%

* Open rates derived from contact engagement data (rolling 90-day window).