Queen City — Retention Intelligence Report

Wins

Engaged Customer AOV

$68.91

+22.5% vs store avg

Blast Campaign Revenue

$65,751

Total revenue from blast campaigns

Customers Kept Loyal

$65,303

from 477 customers kept loyal during April 2026

Revenue

Store Revenue

$327,460

-0.72% MoM -21% YoY

Purchases

5,821

+0.24% MoM -17% YoY

Customers

2,631

+4.0% MoM -9.0% YoY

Campaign-Engaged $69,732 (21%) Organic $257,727 (79%)

AOV Comparison

STOREWIDE

$56.25

ENGAGED CUSTOMERS

$68.91

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

344

+13% MoM

Revenue

$18,744

$52.80 AOV

Opted-In (Reachable)

147

43% capture rate

Unreachable

197

57% — no contact info

Opted-In (Email)

137

of 344 new customers

Critical Opt-In Rate (Email)

40%

First-time buyers with email

Opted-In (Text)

51

of 344 new customers

Critical Opt-In Rate (Text)

15%

First-time buyers with SMS

Loyalty Ladder Movement

Customers who advanced a purchase tier this month through campaign engagement

1 → 2

purchases

12

customers

$653

2 → 3

purchases

14

customers

$1,064

3 → 4

purchases

7

customers

$516

4 → 5

purchases

10

customers

$1,258

Kept Loyal

6+ purchases

477

customers

$65,303

Total

520

customers

$68,794

Churn Intelligence & Revenue Recovery

Total Lost Customers

18,108

60+ days lapsed

6,770 opted in

New Lost This Month

736

Newly crossed 60-day mark

443 opted in

Recovered This Month

79

1.2% recovery rate

of 6,770 opted-in lost

Recovery Revenue

$11,857

Campaign + repurchases

At-Risk Pipeline (45–60 Day Window)

At-Risk Customers

421

249 opted in

Saved by Campaign

21

Save Rate

7.8%

Lost Customer Pipeline

60–179 Days Lost

2,879

1,531 opted in

180–359 Days Lost

3,266

1,363 opted in

360+ Days Lost

11,963

3,876 opted in

Abandoned Cart Recovery (Lifetime)

Carts Abandoned

630

Recovered

39

Revenue

$2,655

Win-Back Revenue Recovery

CAMPAIGN REV

$4,917

REPURCHASES

$6,941

TOTAL RECOVERED

$11,857

Recovery by Lapse Timeframe

Timeframe	Customers	Revenue	AOV	% Rev
60-179 days	67	$3,550	$52.99	72%
180-359 days	16	$1,132	$70.75	23%
360+ days	6	$234	$39.05	4.8%
Total	89	$4,917	$55.24	100%

All Time Revenue Recovered

$24,437

Revenue Recovery — Past Months

(last 6 months only)

Month	Revenue Recovered	Campaign Revenue	Past Cohort Repurchases	Repurchase Share
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	$24,437	$13,550	$10,887	45%

Revenue Recovery — All Time by Timeframe

Bucket	Customers	%	Revenue Recovered	AOV	Avg Days Lost	Repurchase Value	%
60-90 days	69	32%	$4,429	$64.19	74	$4,349	39%
91-120 days	39	18%	$2,373	$60.84	105	$817	7.3%
121-180 days	44	20%	$2,393	$54.39	145	$4,287	38%
181-365 days	48	22%	$2,850	$59.38	250	$862	7.7%
365+ days	19	8.7%	$1,191	$62.67	527	$887	7.9%
TOTAL	219	100%	$13,236	$60.44	172	$11,202	100%

List Health & Subscriber Intelligence

Total Customers (All-Time)

21,093

Known customers with purchases

Total Reachable

8,730

41% reachable

Ghosts

12,363

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,315 25%

New Opt-Ins This Month194

Opt-Outs This Month103

Net List Growth+91

SMS List

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

New Opt-Ins This Month70

Opt-Outs This Month54

Net SMS Growth+16

Channel Mix

Email Only

2,563

29%

SMS Only

3,415

39%

Email + SMS

2,752

32%

Spin Wheel Acquisition

Lifetime Stats

Unique Visitors

56,692

Conversions

2,293

Conversion Rate

4.0%

April 2026 Stats

Signups

—

Customers

—

Non-Customers

—

First Purchase Conversions

All Time

New Customers

331

Revenue

$19,156

Avg Order

$57.87

Conv. Rate

14%

April 2026

New Customers

11

Revenue

$601

Avg Order

$54.66

Conv. Rate

0.00%

Campaigns

Campaign Performance — April 2026

Strategy	Sends	Revenue	MoM	Conversions	AOV	Email Open	SMS Open	Conv Rate	Unsub Rate
Active	25,567	$60,496	-12%	858	$70.51	34%	4.6%	3.4%	0.09%
Winback	23,396	$2,091	-22%	40	$52.28	40%	—	0.17%	0.16%
Weekly Lost	23,377	$3,164	+11%	55	$57.53	39%	2.5%	0.24%	0.11%
Total	72,340	$65,751		953	$68.99	38%	4.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
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).