Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
Your file has been submitted successfully. We’re processing it now - please check back in a few minutes to view your report.
A mid-size music streaming platform operating across 10 global markets has accumulated four years of operational data but lacked a unified analytical layer to extract actionable intelligence. Leadership could observe that revenue was increasing in absolute terms, but could not answer the questions that govern sustainable growth:
The following six insights are the strongest signals in the data. Each is grounded in quantitative evidence and connected to a specific business mechanism, not merely an observation, but an explanation of why the pattern exists and what it means for decision-making.
a. Finding: Cumulative MRR grew from $1,249 in 2021 to $2,648 in 2024 — a 112% nominal increase. However, churn events account for $2,433 of MRR loss across the period, and the 68.3% overall churn rate means that for every three subscribers gained, roughly two are lost.
b. Why it matters: Streaming platforms operate on compounding MRR. A high churn rate acts as a tax on every new acquisition: marketing spend to acquire a user who churns within 60 days generates negative LTV. The platform is running an expensive growth treadmill rather than building durable ARR.
c. Business impact: If churn rate were reduced by 10 percentage points (e.g. from 68% to 58%), the retained subscriber base would generate an estimated $243–$265 of additional MRR monthly, compounding over 12 months into $2,900–$3,200 of incremental annual recurring revenue.
a. Finding: Users aged 25–35 show the lowest churn flag rate (58.9%) and highest track completion rate (80.4%) of any age group. Their skip rate (16.8%) is marginally above average, but they demonstrate the strongest engagement consistency across session frequency metrics.
b. Why it matters: This cohort is at a life stage where disposable income is present, subscription habits are being formed, and platform stickiness is highest. They are also the most responsive to organic upgrade triggers (117 organic upgrades vs 88 for content_launch), suggesting they convert on value rather than promotions.
c. Business impact: Directing retention campaigns at the 35–45 cohort (73.2% churn) and 45–60 cohort (73.6% churn) — the two highest-churn age groups — while doubling down on organic discovery pathways for 25–35 users would optimise CAC:LTV ratio across the subscriber base.
a. Finding: 50.2% of the user base (482 users) is flagged as is_fraud_cluster = True. However, these users exhibit an average skip rate of 10.8% versus 22.3% for organic users — meaning flagged users actually engage more consistently with content, not less. This is the inverse of what fraud behaviour (e.g. bot-driven streams for royalty gaming) should look like.
b. Why it matters: If the fraud classifier was trained on low-activity signals (few sessions, long gaps), it may be capturing disengaged legitimate users rather than actual bots. True streaming fraud typically presents as abnormally high play counts, very short listen durations, and suspiciously low skip rates — which partially matches the flagged cohort's low skip rate.
c. Business impact: Royalty leakage risk is real if legitimate users are being incorrectly withheld royalty payouts. A mis-flagged user base of 482 users, each generating modest royalty obligations, represents a compliance and reputational risk that warrants an immediate audit of the classifier logic and threshold settings.
a. Finding: Algorithmically recommended tracks account for 51.6% of all plays (36,586 sessions) and generate $138.08 in estimated revenue versus $125.38 from manually selected tracks. Skip rates are almost identical: 13.4% for algo vs 13.3% for manual. The recommendation engine is not degrading the listening experience.
b. Why it matters: The near-parity in skip rates validates the engine's relevance. However, the marginal revenue premium per algo play is tiny ($0.00377 vs $0.00377). This suggests algo recommendations are not currently being used to route users toward higher-monetisation content (e.g. premium artist catalogues, sponsored content, or upgrade prompts).
c. Business impact: The recommendation engine should be augmented with a revenue-weighting signal: tracks from artists with exclusive licensing agreements, or tracks that historically precede upgrade events, should be up-ranked. A 5% improvement in revenue-per-algo-play would yield an estimated $6.90 additional session revenue — modest in isolation but directionally significant if applied at scale.
a. Finding: Churned users average 11.7 total sessions versus 203.6 sessions for retained users — a 17× gap. Churners also show lower completion rates (73.2% vs 81.2%) but, counter-intuitively, lower skip rates (15.5% vs 18.8%). This suggests churned users do not abandon individual tracks; they abandon the platform entirely, playing fewer tracks but finishing the ones they start.
b. Why it matters: The skip rate divergence is the most actionable signal: a user who has stopped skipping but is no longer listening has entered a passive disengagement state — they have lost the habit rather than lost interest in specific content. This profile is amenable to re-engagement via new-release notifications or curated 'comeback' playlists.
c. Business impact: A churn early-warning trigger should be set at: (a) total sessions drops below 3 in a 30-day window, AND (b) skip rate is decreasing month-over-month. Users meeting both criteria should be enrolled automatically in a re-engagement email sequence before the churn event fires.
a. Finding: Canada ($34.44) and Germany ($33.40) rank as the top two revenue-generating markets, ahead of GB ($30.10), AU ($28.88), and the US ($28.39). Both markets also show balanced tier distributions. Notably, the US — despite being the world's largest music streaming market — ranks fifth in platform revenue per this dataset.
b. Why it matters: This likely reflects a market maturity effect: CA and DE users may have higher proportions of Premium/Family subscribers relative to free users, or may have higher session frequencies that generate more per-stream royalties. The US underperformance suggests either a higher free-tier concentration or a lower session frequency among US users in this cohort.
c. Business impact: CA and DE should be treated as proof-of-concept markets for feature launches and pricing experiments. The US gap warrants dedicated investigation: a free-to-paid conversion push in the US could yield disproportionate MRR uplift given the market's scale potential.
Recommendation — Target Segment — Expected Impact — Timeframe
Launch churn-rescue programme: 3-month Family trial for users with Churn Risk Score & 85% and recent session drop
Target Segment: 321 Premium + at-risk users
Expected Impact: Recover $500–800/month of MRR churn; improve net MRR retention by 10–15%
Timeframe: 0–30 days
Redeploy recommendation engine to surface revenue-weighted tracks for upgrade-primed users
Target Segment: Free tier, 25–35 cohort
Expected Impact: 3–5% uplift in free-to-paid conversion; +$90–150/month MRR
Timeframe: 30–60 days
Conduct fraud classifier audit; re-label users with low skip rate + consistent sessions as legitimate
Target Segment: 482 flagged users
Expected Impact: Eliminate royalty compliance risk; unlock accurate churn modelling
Timeframe: 0–30 days
Localise content investment for JP, BR, ZA based on genre affinity analysis
Target Segment: JP (Jazz/Electronic), BR (Latin), ZA (Reggae)
Expected Impact: Increase session frequency in low-performing markets by 10–20%
Timeframe: 60–90 days
Build pre-churn trigger automation: enrol users with & 3 sessions/30 days AND declining skip rate
Target Segment: All tiers
Expected Impact: Reduce churn events by 50–80 per year; protect ~$750–1,200 MRR annually
Timeframe: 30–60 days
Investigate US free-tier concentration; run a time-limited Premium trial campaign for US Free users
Target Segment: 311 US Free users (subset)
Expected Impact: If 15% convert, adds ~$140–160/month MRR from a single market
Timeframe: 60–90 days
eyJrIjoiYTgwYWU5NzMtYjE1MC00YTM5LWIzMzItYzM3MTUzYzhhMjYzIiwidCI6ImJlYjhjMzZmLWNhZDYtNDU5YS05MzBhLWZjYWUwMzAxODAxOCIsImMiOjEwfQ%3D%3D