Cold Case~69min
The Artist Whose Plays Were Mostly "Promotional"
Nova Ashworth (ARTIST-11) has 61.87% of her plays classified as "promotional" (which pay no royalty) — flat and consistent across all 6 months — versus a 5.96%-6.95% peer baseline (avg 6.62%) among 5 comparable artists. Reclassified to the peer-baseline ratio, she's owed $5,432.61 in underpaid royalty at $0.003/play. Wren Castellano (ARTIST-19) also shows an elevated overall promotional ratio (42.6%), but broken out by month, it's a normal ~7% every month except March 2024, which spikes to 82% during a documented radio promo campaign — explained, not misclassification.
Tables you'll query
artiststracksplays
What you'll learn
JOINsAggregations & GROUP BYDate & Time Functions