June 2026
Retention Intelligence
Report
Report
Queen City
Wins
Engaged Customer AOV
$62.54
+15.8% vs store avg
Blast Campaign Revenue
$56,648
Total revenue from blast campaigns
Customers Kept Loyal
$54,574
from 416 customers kept loyal during June 2026
Revenue
Store Revenue
$320,627
-6.7% MoM
-20% YoY
Purchases
5,934
-2.4% MoM
-16% YoY
Customers
2,578
-2.5% MoM
-11% YoY
Campaign-Engaged $59,604 (19%)
Organic $261,023 (81%)
AOV Comparison
STOREWIDE
$54.03
ENGAGED CUSTOMERS
$62.54
+15.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
371
+22% MoM
Revenue
$23,997
$54.54 AOV
Opted-In (Reachable)
270
61% capture rate
Unreachable
101
27% — no contact info
Opted-In (Email)
256
of 371 new customers
Critical Opt-In Rate (Email) +19% MoM
58%
First-time buyers with email
Opted-In (Text)
103
of 371 new customers
Critical Opt-In Rate (Text) +43% MoM
23%
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,178
2 → 3
purchases
12
customers
$549
3 → 4
purchases
14
customers
$983
4 → 5
purchases
10
customers
$737
Kept Loyal
6+ purchases
416
customers
$54,574
Total
472
customers
$58,022
Churn Intelligence & Revenue Recovery
Total Lost Customers
18,678
60+ days lapsed
6,934 opted in
New Lost This Month
873
Newly crossed 60-day mark
481 opted in
Recovered This Month
67
0.97% recovery rate
of 6,934 opted-in lost
Recovery Revenue
$14,184
Campaign + repurchases
At-Risk Pipeline (45–60 Day Window)
Lost Customer Pipeline
Abandoned Cart Recovery (Lifetime)
Win-Back Revenue Recovery
CAMPAIGN REV
$4,073
REPURCHASES
$10,111
TOTAL RECOVERED
$14,184
Recovery by Lapse Timeframe
| Timeframe | Customers | Revenue | AOV | % Rev |
|---|---|---|---|---|
| 60-179 days | 46 | $2,843 | $61.81 | 70% |
| 180-359 days | 13 | $754 | $58.04 | 19% |
| 360+ days | 10 | $476 | $47.55 | 12% |
| Total | 69 | $4,073 | $59.03 | 100% |
All Time Revenue Recovered
$52,026
Revenue Recovery — Past Months
(last 6 months only)
| Month | Revenue Recovered | Campaign Revenue | Past Cohort Repurchases | Repurchase Share |
|---|---|---|---|---|
| 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 | $52,026 | $22,053 | $29,973 | 58% |
Revenue Recovery — All Time by Timeframe
| Bucket | Customers | % | Revenue Recovered | AOV | Avg Days Lost | Repurchase Value | % |
|---|---|---|---|---|---|---|---|
| 60-90 days | 97 | 28% | $6,249 | $64.43 | 73 | $11,716 | 37% |
| 91-120 days | 60 | 18% | $3,712 | $61.87 | 104 | $3,752 | 12% |
| 121-180 days | 71 | 21% | $3,758 | $52.93 | 146 | $12,067 | 38% |
| 181-365 days | 78 | 23% | $4,695 | $60.19 | 257 | $2,524 | 8.1% |
| 365+ days | 36 | 10% | $2,290 | $63.60 | 530 | $1,262 | 4.0% |
| TOTAL | 342 | 100% | $20,704 | $60.54 | 184 | $31,322 | 100% |
List Health & Subscriber Intelligence
Total Customers (All-Time)
21,821
Known customers with purchases
Total Reachable
9,041
41% reachable
Ghosts
12,780
No email or SMS on file
Email List
Total Email Opt-Ins (real customers)5,593 26%
New Opt-Ins This Month391
Opt-Outs This Month106
Net List Growth+285
SMS List
Total SMS Opt-Ins (real customers)6,293 29%
New Opt-Ins This Month210
Opt-Outs This Month128
Net SMS Growth+82
Channel Mix
Spin Wheel Acquisition
Lifetime Stats
June 2026 Stats
First Purchase Conversions
All Time
June 2026
Campaigns
Campaign Performance — June 2026
| Strategy | Sends | Revenue | MoM | Conversions | AOV | Email Open | SMS Open | Conv Rate | Unsub Rate |
|---|---|---|---|---|---|---|---|---|---|
| Active | 22,275 | $48,062 | -14% | 747 | $64.34 | 34% | 3.5% | 3.4% | 0.14% |
| Winback | 28,612 | $2,947 | -15% | 54 | $54.57 | 43% | 1.9% | 0.19% | 0.15% |
| Weekly Lost | 19,682 | $1,551 | +35% | 24 | $64.64 | 42% | 0.84% | 0.12% | 0.09% |
| Other | 9,815 | $4,088 | +13% | 83 | $49.26 | 26% | 2.9% | 0.85% | 0.65% |
| Total | 80,384 | $56,648 | 908 | $62.39 | 40% | 2.7% | |||
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,529 | $8,425 | 117 | $72.01 | 21% | 11% | 3.3% | Jan 2025 |
| Abandoned Cart | 2 | 891 | $4,382 | 52 | $84.26 | 41% | 20% | 5.8% | Jan 2025 |
| Birthday | 1 | 6,012 | $12,533 | 220 | $56.97 | 32% | 8.7% | 3.7% | Jan 2025 |
| Points Reminder | 1 | 82,667 | $90,451 | 1,073 | $84.30 | 40% | 2.8% | 1.3% | Feb 2024 |
| Total | 5 | 93,099 | $115,790 | 1,462 | $79.20 | 36% | 4.8% | ||
* Open rates derived from contact engagement data (rolling 90-day window).
Last Updated July 22, 2026 at 01:36 AM · PufCreativ Loyalty Intelligence Platform