Goal: 1,000 gross signups by Dec 31, 2026 | Source of truth: Keap (Infusionsoft) RepWorks dashboard, Aug 8 2026
114
Gross signups today
99
Active (Keap)
~13%
Overall churn
1,000
Goal (gross)
1,051
Projected Dec 31
773
Net active Dec 31
Progress to goal
114 / 1,000 (11%)
886 more gross signups needed over 21 weeks = ~42 per week average.
Signup trajectory - cumulative gross vs. net active
Cumulative gross signupsNet active (after churn)Goal line
Even hitting 1,051 gross, only ~773 are still paying at year end at 12% monthly churn. The gap between the two lines is your churn tax.
Plan mix (active)
Starter89
Professional9
Enterprise1
Billing mix (active)
Monthly83
Annual16
Signups by month (last sheet sync)
June46
July26
August1*
Marketing plan - full-period totals
Channel
Events
Yield
Signups
Email sends
42
5 / send
210
TRN webinars
11
15 / webinar
165
Partner webinars
9
15 / webinar
135
Paid promos ($2k)
19
5 / promo
95
Essential -> RepWorks nurture
-
ongoing
101
Integration partners (Ignition)
-
ramping
70
Organic / word of mouth
-
baseline
161
Total new signups
937
Churn watch
The June cohort lost ~23% in about 7 weeks. 14 of 15 churns were monthly billers; 13 of 15 were Starter plans. Monthly Starter is the leaky bucket. Every point of churn you fix is worth more than another email blast at year end.
Levers: onboarding/activation for new Starters, annual-plan incentives, and the Essential -> RepWorks upsell (stickier bundle). Churn count is from the last Google Sheet sync; refresh from Keap.
Metrics to wire in next (need Stripe / product data or your metrics screenshot)
--
MRR ($)
--
MRR churn ($/mo)
--
Net revenue retention
--
ARPU
--
CAC (blended)
--
LTV
--
LTV : CAC
--
Trial -> paid %
--
Activation rate
--
Essential -> RepWorks upgrade %
--
Signup -> active %
--
Payback period (mo)
These are blank on purpose. Send the screenshot of the metrics you want, or connect Stripe, and I'll populate these tiles and add them to the model.
Built for Eric Bristol / Demand Inbound. Editable forecast model delivered as a separate .xlsx. Assumptions: email 5, TRN webinar 15, partner webinar 15, paid promo ($2k) 5, monthly churn 12%.