Revenue Intelligence

Stripe tells you what you made. We show you why.

Community analytics that join member behaviour to revenue, so you can see which channels produce customers, where members drop out, and which revenue is at risk this month.

Overview

Community revenue

Monthly recurring revenue

$61,230

+3.2% vs prior 90d

Paid members

1,236

+41 net

Activation rate

41.8%

+6.2 pts

Free → paid

6.3%

+0.9 pts

30-day retention

87.4%

+2.1 pts

Monthly churn

4.1%

−0.6 pts

ARPU

$49.54

+$1.52

Members at risk

107

$3,700 MRR

MRR · new vs churned revenue

■ new ■ churned

Insights this period

  • Acquisition

    Members acquired through YouTube retain 2.1× longer than TikTok members.

  • Activation

    Members who attend an onboarding call are 31% less likely to cancel in 90 days.

  • Affiliates

    Affiliate #4 drives the most joins but ranks #9 for customer value.

  • Retention

    Premium members active in #market-analysis show higher 60-day retention.

MRR by acquisition source

avg LTV

  • YouTube$18.8k$1575
  • Instagram$12.2k$1090
  • Affiliates$7.8k$1155
  • Newsletter$6.7k$1420
  • TikTok$5.6k$600
  • X$3.4k$875
  • Unattributed$6.6k-

Affiliates · joins vs value

AffiliateJoinsPaidLTVValue rank
#41,84041$520#9
#192088$1500#1
#761052$1255#2
#254029$965#5

Paid cohort retention

month 0 to 5

Apr1008881777472
May10086797471
Jun100908480
Jul1009186
Aug10092
Sep100
Community health72/100

Illustrative dashboard · switch the date range to see it update

Insights, not just charts

A dashboard should change a decision.

Every report we send ends with what we'd do next and why. The kind of finding we look for:

  • Acquisition

    “Members acquired through YouTube retain 2.1× longer than TikTok members.”

  • Activation

    “Members who attend an onboarding call are 31% less likely to cancel.”

  • Affiliates

    “Affiliate #4 generated the most joins but ranks #9 for customer value.”

  • Retention

    “Premium members engaging in #market-analysis have higher retention.”

  • Illustrative insights · not from client data

Attribution that ends at revenue

Rank channels by what they earn, not what they add.

Rank sources by

By joins, TikTok looks like your best channel.

StageTikTok#1YouTubeAffiliates
Joined Discord3,1021,823900
Activated68422% of joins71339% of joins40245% of joins
Converted to paid591.9% of joins1025.6% of joins616.8% of joins
Revenue$2,714$9,413$4,941
Avg. customer value$46.00$92.28$81.00

Illustrative example · 90-day cohort

Metric definitions

Every number, defined.

Analytics are only useful if everyone agrees what the numbers mean. These are the definitions we use by default, we adapt them to your model during the audit.

Monthly recurring revenue (MRR)Revenue
The normalised monthly value of all active subscriptions. Annual plans count as one-twelfth per month.
ARPURevenue
Average revenue per paying member per month. MRR divided by paid members.
Revenue per memberRevenue
MRR divided by all members, free and paid. Shows how well the whole community monetises.
Lifetime value (LTV)Revenue
Total revenue a member generates over their membership. We show actual LTV per member and projected LTV by cohort.
Affiliate revenueRevenue
Revenue from members attributed to each affiliate or creator partner, net of refunds.
New membersGrowth
Members who joined in the period, split by tracked acquisition source.
Activation rateGrowth
Share of new members who complete the actions you define as activation, for example onboarding plus one meaningful action within 7 days.
Free → paid conversionGrowth
Share of new members who start paying within a set window, usually 30 or 60 days.
Revenue by acquisition sourceGrowth
Revenue and LTV grouped by where members came from: video, post, affiliate, campaign or code.
30-day retentionRetention
Share of paying members still subscribed 30 days after their first payment.
ChurnRetention
Share of paying members who cancel or fail to renew each month, split into voluntary and involuntary (failed payment).
Members at risk / at-risk revenueRetention
Paying members whose risk score is above threshold, and the MRR they represent.
Community healthRetention
A composite of activation, engagement depth and retention trends, scored out of 100 and tracked over time.

Data sources we connect

Read-only wherever possible. No payment migration. How we handle data.

  • Discord activity & roles
  • Whop memberships & payments
  • Stripe subscriptions & invoices
  • Patreon pledges & tiers
  • LaunchPass & Skool memberships
  • Tracked links, invites & UTMs
  • Affiliate & promo codes
  • Email and CRM tools

Find the leaks in your community revenue engine

We'll analyse how members join, activate, convert and retain, then show you where the largest opportunities are.