Jane Media Operating System

LYS KPI Dashboard v1

Truth-first dashboard for Last Year Single subscriber and revenue visibility. Updated as-is from currently available local exports, review files, and API pulls. Incomplete sources are labeled instead of guessed.

Last updated: May 13, 2026 · 18:55 UTCGoal: 5,000 active subscribersRevenue goal: $2M in 2026Status: Current available data

North Star Metrics

High-confidence operating read using explicit active Stripe subscriptions plus active PayPal subscriptions visible through ThriveCart. This is a useful v1, not final accounting.

Incomplete but useful

Clean Active Subs

1,010
Clean active subscriptions after lifecycle audit.
20.2% of 5,000 subscriber goal.

Estimated MRR

$36,894
Collected recurring subscription amounts only; paused and not-collected rows excluded.

Estimated ARR

$442,728
Current MRR × 12. Subscription revenue only; excludes launches, retreats, coaching, books, and one-time offers.

Remaining to Goal

3,990
Active subscribers still needed to reach 5,000.

Stripe 2025 Active

783
Clean active after excluding lifecycle conflicts.

Stripe Podia Active

112
Clean active from Stripe Podia active export.

PayPal Active via TC

115
Clean active PayPal recurring subscriptions via ThriveCart.

Active Candidate Pool

1,364
Broader candidate count before final lifecycle/customer dedupe review.
Interpretation: The best current operating number remains 1,010 clean active subscriptions. The broader candidate pool is 1,364, but should not be treated as the subscriber count until review/dedupe is complete.

Month-End Forecast

Owner-facing space for the expected subscriber count and recurring revenue before month close. Update this after each live billing/CRM pull.

Month-end watch

Expected Subs by Month-End

1,010+
Baseline is current clean active subscriptions. “+” leaves room for new net adds once May purchases/cancels are reconciled.

Expected Recurring Revenue

$36,894+
Baseline MRR from collected recurring subscriptions only; excludes one-time launches, books, retreats, and coaching.

Forecast Confidence

Needs pull
Use as board space now; refresh from Stripe, ThriveCart, PayPal, and CRM before final month-end call.

Next Forecast Update

Month close
Recommended cadence: refresh weekly, then daily during final 3 days of campaign periods.
Board rule: this forecast should show expected active subs and expected recurring revenue/MRR before month end. Until live billing is refreshed, treat these as conservative baseline floors, not final projections.

Strategic Reports

Quick access to the two strategy reports David asked to keep visible from the KPI board.

Reference

Source Coverage

What is loaded right now and how reliable it is for v1 decisions.

Data spine
SourceRows loadedReliabilityUse right now
Stripe subscriptions2025 Stripe + Stripe Podia exports3,941HighPrimary active subscription truth where status is explicit.
ThriveCart eventsAll-time export/API layer40,408High for lifecycle contextBest source for PayPal-active subs, cancels, pauses, refunds, and product context.
PayPal transactions6,194PartialProcessor/reconciliation layer; Transaction Search permission still needs cleanup for final truth.
Podia transactions13,522Legacy layerUseful for legacy history; not enough alone for final subscriber truth.
GHL contacts694Funnel subsetMarch/April webinar funnel context, not whole CRM.
TribeSocial users3,886Access snapshotAccess reconciliation only, not billing truth.

2026 Revenue View

Directional candidate revenue from normalized files. Do not use as final P&L yet.

Directional

2026 Candidate Revenue

$234,848
Source-specific candidate totals; overlap risk remains.
  • thrivecart: $191,658
  • paypal: $27,946
  • podia: $15,244

Lifecycle Pools

Subscriber growth leverage hidden inside payment state cleanup.

Action pools
PoolCountBest next action
Clean Active KPI1,010Use for operating subscriber count.
Paused / Reactivation342Save/reactivation campaign opportunity.
Payment Risk18Dunning/payment-update follow-up.
Canceled / Winback1,894Winback segmentation opportunity.
Review / Edge Cases50Manual cleanup before final KPI trust.

What is still missing

No fake precision. These are the gaps before this becomes board-grade.

Needs reconciliation
  • Deduplicate duplicate humans/customers across email variants and multiple billing systems.
  • Enable/verify PayPal reporting access for processor-level payment truth.
  • Reconcile ThriveCart product/order context against Stripe and PayPal processor records.
  • Confirm whether $20 retention subscriptions belong in main active subscriber KPI or a sub-segment.
  • Turn monthly close into a recurring process so revenue pacing updates without manual rebuilds.

Audit Trail

Files currently backing the dashboard.

Local artifacts
ArtifactCurrent count / purpose
build/review/clean_active.csv1,010 corrected clean active subscriptions.
build/normalized/active_subscriber_candidates.csv1,364 broader active-subscriber candidates before final review.
build/normalized/monthly_revenue_candidates.csv143 monthly source-specific revenue candidate rows.
build/review/product_family_review.csv346 product/source combinations requiring review.
build/review/monthly_revenue_review.csv71 source-specific monthly revenue review rows.
build/reports/clean_active_subscription_audit.mdClean-active methodology and reclaim pool exports.
build/reports/qa_summary.mdSource row counts, product-family summary, GHL quick counts, TribeSocial roles.