CRM & Renewals

Tuesday, 14 July 2026
Live warehouse aggregates · 14 Jul 2026 · people rows illustrative
FFB renewal rate
71%
44 of 62 eligible · 83% incl. FFM upgrades
Live subscribers
59
Avg tenure 14 months
Subscription MRR
$4,490
Active + past-due, annual prorated
Renewing in 30 days
$4,268
39 renewals
At risk
$214,600
23 past due or set to cancel

At risk

Past due or set to cancel. Combined lifetime value at stake: $214,600.

RiskMemberSubscriptionRenewsLTVProductsFlags
At risk
Danielle Foster
danielle.foster@gmail.com
Member 18 mo · customer 2y 4mo
$2,750/mo 3d overdue $44,300 FFMFFB payment failed twice
At risk
Priya Anand
priya.anand@gmail.com
Member 11 mo · customer 1y
$550/mo today $9,600 FFB low engagement 30d
Watch
Sophie Muir
sophie.muir@outlook.com
Member 8 mo · customer 8 mo
$49/mo 12d $1,180 SMS opened cancel page
Open question / new scope. "Draft save note" is copy only in the live build. Designed here as a real per-row action that opens a Kira chat pre-filled with the member's context. Confirm this is in scope.

Renewal money, next 13 weeks

Scheduled renewal value by week. Tall bars are the weeks to be present for.

$12kW1
$41kW2
$9kW3
$18kW4
$52kW5
$7kW6
$14kW7
$23kW8
$11kW9
$38kW10
$16kW11
$9kW12
$27kW13

Win-back bench

Cancelled in the last 6 months, no live subscription now, ranked by lifetime value. These 37 people have spent $284,900 with us. A personal note beats any ad money can buy.

CustomerLeftProducts ownedCustomer forLTV
Amanda Reid
amanda.reid@outlook.com
4 months ago · FFB FFBSMS 2 years $18,400
Rachel Kim
rachel.kim@gmail.com
5 months ago · FFM FFM 1 year 6 months $12,900

Renewing

In the next 30 days
MemberSubscriptionRenewsLTVProducts
Hannah Blythe
hannah.blythe@gmail.com
$2,750/mo9d$27,400FFM
Leah Osei
leah.osei@gmail.com
$550/mo21d$6,050FFB
Later
MemberSubscriptionRenewsLTVProducts
Nadia Rahman
nadia.r@gmail.com
$550/mo2mo$8,900FFB
Grace Whitmore
grace.whitmore@icloud.com
$49/mo3mo$1,470SMS
Preview state