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 20, 2026 · 19:17 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

932

Clean active subscriptions after live Stripe refresh + available ThriveCart/PayPal lifecycle audit.

18.6% of 5,000 subscriber goal.

Estimated MRR

$34,008

Collected recurring subscription amounts only; paused and not-collected rows excluded.

Estimated ARR

$408,096

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

Remaining to Goal

4,068

Active subscribers still needed to reach 5,000.

Stripe Main Active

733

Clean active from live Stripe API after excluding lifecycle conflicts.

Stripe Podia Active

Clean active from live Stripe Podia API refresh.

PayPal Active via TC

115

Clean active PayPal recurring subscriptions via last available ThriveCart pull.

Active Candidate Pool

1,364

Broader candidate count before final lifecycle/customer dedupe review.

Interpretation: The best current operating number is now 932 clean active subscriptions. The broader candidate pool is 1,364, but should not be treated as the subscriber count until ThriveCart and CRM review are 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

932

Fresh Stripe baseline plus available ThriveCart/PayPal lifecycle data. Needs ThriveCart token for high confidence.

Expected Recurring Revenue

$34,008

Current clean-active MRR from refreshed Stripe plus available PayPal/ThriveCart lifecycle data.

Forecast Confidence

Partial

Stripe refreshed May 20. ThriveCart API token is still missing; CRM/GHL API returned 403.

Next Forecast Update

Need TC token

Next accuracy jump comes from live ThriveCart lifecycle and PayPal subscription refresh.

Board rule: this forecast should show expected active subs and expected recurring revenue/MRR before month end. Treat this as the refreshed partial baseline, not a final month-end projection until ThriveCart live lifecycle data is pulled.

Strategic Reports

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

Reference

LYS Differentiation Scorecard

📈 Market Position

How Last Year Single stands apart in the relationship and faith-based singles market.

Relationship Intelligence Market Deep Dive

🧠 Category Strategy

Market research and positioning analysis for relationship intelligence and LYS growth opportunities.

Source Coverage

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

Data spine

Source	Rows loaded	Reliability	Use right now
Stripe subscriptionsLive Stripe main + Stripe Podia API refresh	4,700	High	Primary active subscription truth where status is explicit.
ThriveCart eventsAll-time export/API layer	40,408	High for lifecycle context	Best source for PayPal-active subs, cancels, pauses, refunds, and product context.
PayPal transactions	6,194	Partial	Processor/reconciliation layer; Transaction Search permission still needs cleanup for final truth.
Podia transactions	13,522	Legacy layer	Useful for legacy history; not enough alone for final subscriber truth.
GHL contacts	694	Funnel subset	March/April webinar funnel context, not whole CRM.
TribeSocial users	3,886	Access snapshot	Access 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

Pool	Count	Best next action
Clean Active KPI	932	Use as refreshed partial operating subscriber count.
Paused / Reactivation	239	Save/reactivation campaign opportunity from current audit layer.
Payment Risk	8	Dunning/payment-update follow-up from current audit layer.
Canceled / Winback	241	Winback segmentation opportunity from current audit layer.
Review / Edge Cases	8	Manual 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.
Add the missing ThriveCart API token, then rerun live lifecycle pull for current pauses, cancels, refunds, failed payments, and PayPal-through-ThriveCart rows.
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

Artifact	Current count / purpose
`build/review/clean_active.csv`	932 corrected clean active subscriptions.
`build/normalized/active_subscriber_candidates.csv`	1,364 broader active-subscriber candidates before final review.
`build/normalized/monthly_revenue_candidates.csv`	143 monthly source-specific revenue candidate rows.
`build/review/product_family_review.csv`	346 product/source combinations requiring review.
`build/review/monthly_revenue_review.csv`	71 source-specific monthly revenue review rows.
`build/reports/clean_active_subscription_audit.md`	Clean-active methodology and reclaim pool exports.
`build/reports/qa_summary.md`	Source row counts, product-family summary, GHL quick counts, TribeSocial roles.