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.
High-confidence operating read using explicit active Stripe subscriptions plus active PayPal subscriptions visible through ThriveCart. This is a useful v1, not final accounting.
Owner-facing space for the expected subscriber count and recurring revenue before month close. Update this after each live billing/CRM pull.
Quick access to the two strategy reports David asked to keep visible from the KPI board.
What is loaded right now and how reliable it is for v1 decisions.
| Source | Rows loaded | Reliability | Use right now |
|---|---|---|---|
| Stripe subscriptions2025 Stripe + Stripe Podia exports | 3,941 | 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. |
Directional candidate revenue from normalized files. Do not use as final P&L yet.
Subscriber growth leverage hidden inside payment state cleanup.
| Pool | Count | Best next action |
|---|---|---|
| Clean Active KPI | 1,010 | Use for operating subscriber count. |
| Paused / Reactivation | 342 | Save/reactivation campaign opportunity. |
| Payment Risk | 18 | Dunning/payment-update follow-up. |
| Canceled / Winback | 1,894 | Winback segmentation opportunity. |
| Review / Edge Cases | 50 | Manual cleanup before final KPI trust. |
No fake precision. These are the gaps before this becomes board-grade.
Files currently backing the dashboard.
| Artifact | Current count / purpose |
|---|---|
build/review/clean_active.csv | 1,010 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. |