Queen City — Retention Intelligence Report

Wins

Engaged Customer AOV

$70.65

+25.0% vs store avg

Blast Campaign Revenue

$60,632

Total revenue from blast campaigns

Customers Kept Loyal

$60,055

from 420 customers kept loyal during May 2026

Revenue

Store Revenue

$343,574

+4.9% MoM -20% YoY

Purchases

6,080

+4.4% MoM -18% YoY

Customers

2,644

+0.49% MoM -14% YoY

Campaign-Engaged $63,654 (19%) Organic $279,921 (81%)

AOV Comparison

STOREWIDE

$56.51

ENGAGED CUSTOMERS

$70.65

+25.0% 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

335

+1.7% MoM

Revenue

$18,492

$51.22 AOV

Opted-In (Reachable)

165

49% capture rate

Unreachable

170

51% — no contact info

Opted-In (Email)

152

of 335 new customers

Critical Opt-In Rate (Email)

45%

First-time buyers with email

Opted-In (Text)

58

of 335 new customers

Critical Opt-In Rate (Text)

17%

First-time buyers with SMS

Loyalty Ladder Movement

Customers who advanced a purchase tier this month through campaign engagement

1 → 2

purchases

11

customers

$785

2 → 3

purchases

15

customers

$1,094

3 → 4

purchases

5

customers

$564

4 → 5

purchases

9

customers

$535

Kept Loyal

6+ purchases

420

customers

$60,055

Total

460

customers

$63,033

Churn Intelligence & Revenue Recovery

Total Lost Customers

18,308

60+ days lapsed

6,810 opted in

New Lost This Month

717

Newly crossed 60-day mark

392 opted in

Recovered This Month

71

1.0% recovery rate

of 6,810 opted-in lost

Recovery Revenue

$13,404

Campaign + repurchases

At-Risk Pipeline (45–60 Day Window)

At-Risk Customers

514

292 opted in

Saved by Campaign

28

Save Rate

8.8%

Lost Customer Pipeline

60–179 Days Lost

2,725

1,459 opted in

180–359 Days Lost

3,187

1,301 opted in

360+ Days Lost

12,396

4,050 opted in

Abandoned Cart Recovery (Lifetime)

Carts Abandoned

646

Recovered

46

Revenue

$4,027

Win-Back Revenue Recovery

CAMPAIGN REV

$4,430

REPURCHASES

$8,975

TOTAL RECOVERED

$13,404

Recovery by Lapse Timeframe

Timeframe	Customers	Revenue	AOV	% Rev
60-179 days	50	$2,716	$54.32	61%
180-359 days	17	$1,090	$64.13	25%
360+ days	7	$623	$89.07	14%
Total	74	$4,430	$59.86	100%

All Time Revenue Recovered

$37,842

Revenue Recovery — Past Months

(last 6 months only)

Month	Revenue Recovered	Campaign Revenue	Past Cohort Repurchases	Repurchase Share
May 2026	$13,404	$4,430	$8,975	67%
April 2026	$11,857	$4,917	$6,941	59%
March 2026	$8,029	$4,962	$3,066	38%
February 2026	$4,551	$3,671	$880	19%
Total	$37,842	$17,980	$19,862	52%

Revenue Recovery — All Time by Timeframe

Bucket	Customers	%	Revenue Recovered	AOV	Avg Days Lost	Repurchase Value	%
60-90 days	83	30%	$5,405	$65.12	73	$8,317	40%
91-120 days	46	16%	$2,621	$56.98	105	$1,701	8.1%
121-180 days	60	21%	$3,124	$52.07	146	$7,967	38%
181-365 days	65	23%	$3,940	$60.62	257	$1,917	9.2%
365+ days	26	9.3%	$1,814	$69.78	522	$1,035	4.9%
TOTAL	280	100%	$16,905	$60.38	178	$20,937	100%

List Health & Subscriber Intelligence

Total Customers (All-Time)

21,419

Known customers with purchases

Total Reachable

8,864

41% reachable

Ghosts

12,555

No email or SMS on file

Email List

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

New Opt-Ins This Month276

Opt-Outs This Month85

Net List Growth+191

SMS List

Total SMS Opt-Ins (real customers)6,234 29%

New Opt-Ins This Month144

Opt-Outs This Month53

Net SMS Growth+91

Channel Mix

Email Only

2,630

30%

SMS Only

3,451

39%

Email + SMS

2,783

31%

Spin Wheel Acquisition

Lifetime Stats

Unique Visitors

59,584

Conversions

2,388

Conversion Rate

4.0%

May 2026 Stats

Signups

119

Customers

51

Non-Customers

68

First Purchase Conversions

All Time

New Customers

350

Revenue

$20,032

Avg Order

$57.23

Conv. Rate

14%

May 2026

New Customers

19

Revenue

$876

Avg Order

$46.10

Conv. Rate

16%

Campaigns

Campaign Performance — May 2026

Strategy	Sends	Revenue	MoM	Conversions	AOV	Email Open	SMS Open	Conv Rate	Unsub Rate
Active	23,187	$55,993	-7.4%	788	$71.06	33%	3.4%	3.4%	0.14%
Winback	29,608	$3,487	+67%	53	$65.80	38%	2.6%	0.18%	0.10%
Weekly Lost	22,299	$1,152	-64%	22	$52.38	36%	1.8%	0.10%	0.10%
Total	75,094	$60,632		863	$70.26	36%	3.1%

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
Welcome	1	3,306	$8,322	115	$72.36	20%	17%	3.5%	Jan 2025
Abandoned Cart	1	646	$4,027	46	$87.54	42%	17%	7.1%	Jan 2025
Birthday	1	5,455	$11,889	205	$58.00	31%	9.2%	3.8%	Jan 2025
Points Reminder	1	76,206	$88,610	1,051	$84.31	40%	3.1%	1.4%	Feb 2024
Total	4	85,613	$112,848	1,417	$79.64	36%	4.9%

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