Queen City — Retention Intelligence Report

Wins

Engaged Customer AOV

$61.90

+14.4% vs store avg

Blast Campaign Revenue

$28,275

Total revenue from blast campaigns

Customers Kept Loyal

$25,011

from 279 customers kept loyal during July 2026

Revenue

Store Revenue

$235,386

-27% MoM-43% YoY

Purchases

4,349

-27% MoM-40% YoY

Customers

2,263

-12% MoM -23% YoY

Campaign-Engaged $27,544 (12%) Organic $207,842 (88%)

AOV Comparison

STOREWIDE

$54.12

ENGAGED CUSTOMERS

$61.90

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

270

-34% MoM

Revenue

$14,030

$47.40 AOV

Opted-In (Reachable)

171

58% capture rate

Unreachable

125

42% — no contact info

Opted-In (Email)

163

of 296 new customers

Critical Opt-In Rate (Email) -5.0% MoM

55%

First-time buyers with email

Opted-In (Text)

58

of 296 new customers

Critical Opt-In Rate (Text) -28% MoM

20%

First-time buyers with SMS

Loyalty Ladder Movement

Customers who advanced a purchase tier this month through campaign engagement

1 → 2

purchases

9

customers

$826

2 → 3

purchases

10

customers

$605

3 → 4

purchases

4

customers

$277

4 → 5

purchases

10

customers

$714

Kept Loyal

6+ purchases

279

customers

$25,011

Total

312

customers

$27,433

Churn Intelligence & Revenue Recovery

Total Lost Customers

18,979

60+ days lapsed

7,498 opted in

New Lost This Month

919

Newly crossed 60-day mark

566 opted in

Recovered This Month

61

0.81% recovery rate

of 7,498 opted-in lost

Recovery Revenue

$10,698

Campaign + repurchases

Lost Customer Buckets

Active (60d)

3,671

60–89 Days

851

90–179 Days

1,819

180–359 Days

3,162

360+ Days

13,147

Total Lost

18,979

At-Risk Pipeline (45–60 Day Window)

At-Risk Customers

564

370 opted in

Saved by Campaign

16

Save Rate

4.1%

Lost Customer Pipeline

60–179 Days Lost

2,670

1,636 opted in

180–359 Days Lost

3,162

1,431 opted in

360+ Days Lost

13,147

4,431 opted in

Abandoned Cart Recovery (Lifetime)

Carts Abandoned

989

Recovered

63

Revenue

$4,291

Win-Back Revenue Recovery

CAMPAIGN REV

$4,892

REPURCHASES

$5,806

TOTAL RECOVERED

$10,698

Recovery by Lapse Timeframe

Timeframe	Customers	Revenue	AOV	% Rev
60-179 days	54	$3,780	$70.01	77%
180-359 days	10	$782	$78.25	16%
360+ days	6	$329	$54.85	6.7%
Total	70	$4,892	$69.89	100%

All Time Revenue Recovered

$62,724

Revenue Recovery — Past Months

(last 6 months only)

Month	Revenue Recovered	Campaign Revenue	Past Cohort Repurchases	Repurchase Share
July 2026	$10,698	$4,892	$5,806	54%
June 2026	$14,184	$4,073	$10,111	71%
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	$62,724	$26,945	$35,779	57%

Revenue Recovery — All Time by Timeframe

Bucket	Customers	%	Revenue Recovered	AOV	Avg Days Lost	Repurchase Value	%
60-90 days	114	29%	$7,646	$67.07	73	$13,927	36%
91-120 days	67	17%	$4,123	$61.54	105	$5,257	14%
121-180 days	86	22%	$4,724	$54.92	146	$14,383	38%
181-365 days	88	22%	$5,477	$62.24	255	$3,057	8.0%
365+ days	42	11%	$2,619	$62.35	550	$1,511	4.0%
TOTAL	397	100%	$24,589	$61.94	185	$38,136	100%

List Health & Subscriber Intelligence

Total Customers (All-Time)

22,646

Known customers with purchases

Total Reachable

9,436

42% reachable

Ghosts

13,210

No email or SMS on file

Email List

Total Email Opt-Ins (real customers)5,833 26%

New Opt-Ins This Month321

Opt-Outs This Month87

Net List Growth+234

SMS List

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

New Opt-Ins This Month118

Opt-Outs This Month60

Net SMS Growth+58

Channel Mix

Email Only

2,900

31%

SMS Only

3,603

38%

Email + SMS

2,933

31%

Spin Wheel Acquisition

Lifetime Stats

Unique Visitors

68,425

Conversions

2,747

Conversion Rate

4.0%

July 2026 Stats

Signups

176

Customers

62

Non-Customers

114

First Purchase Conversions

All Time

New Customers

449

Revenue

$26,119

Avg Order

$58.17

Conv. Rate

16%

July 2026

New Customers

40

Revenue

$2,369

Avg Order

$59.23

Conv. Rate

23%

Campaigns

Campaign Performance — July 2026

Strategy	Sends	Revenue	MoM	Conversions	AOV	Email Open	SMS Open	Conv Rate	Unsub Rate
Active	17,816	$23,852	-50%	389	$61.32	28%	3.7%	2.2%	0.17%
Winback	19,797	$2,834	-3.8%	49	$57.83	43%	1.9%	0.25%	0.15%
Weekly Lost	13,512	$1,589	+2.4%	18	$88.29	40%	0.81%	0.13%	0.07%
Total	51,125	$28,275		456	$62.01	39%	3.0%

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,727	$8,756	122	$71.77	21%	12%	3.3%	Jan 2025
Abandoned Cart	2	965	$3,621	56	$64.65	41%	21%	5.8%	Mar 2026
Birthday	1	6,486	$12,988	230	$56.47	32%	8.9%	3.5%	Jan 2025
Points Reminder	1	89,729	$90,892	1,084	$83.85	40%	2.8%	1.2%	Feb 2024
Total	5	100,907	$116,256	1,492	$77.92	36%	4.8%

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