2025 SONY PROMOTION
Centralization Analysis & Strategic Opportunities
Innovate • Modernize • Unify • Amplify
Innovate • Modernize • Unify • Amplify
Key Finding: Analysis reveals a 81.4% variance in cost efficiency across labels, with 45 projects where promotional spend exceeded 50% of consumption value. This represents a significant opportunity for centralization and standardization of best practices.
| Label | Song Count | Total Spend | Total Spins | Total Consumption | Cost per Spin | Consumption per $ |
|---|---|---|---|---|---|---|
| Arista | 13 | $ 2,864K | 1.9M | 21M | $1.471 | 7.3 |
| Columbia | 75 | $22,817K | 21.6M | 215M | $1.055 | 9.4 |
| Epic | 73 | $15,295K | 8.7M | 139.8M | $1.764 | 9.1 |
| RCA | 116 | $18,233K | 24.5M | 232.3M | $0.746 | 12.7 |
Insight: The table above shows significant variation in efficiency metrics across labels. Columbia and Epic show different cost structures despite similar objectives, indicating an opportunity to standardize best practices. Only records with given budget are included (277/320).
Strategic Insight - Top Right Quadrant: Songs in the top-right quadrant achieve both high efficiency (more spins per dollar) and high reach (total spins). These represent best-in-class campaigns that should inform standardized practices.
ROI Insight: This chart directly shows return on investment. Songs in the top-right deliver both high absolute consumption and high consumption per dollar spent - the ultimate goal of radio promotion.
| Bracket | Count | Avg Spend | Avg Consumption | Cost per Spin | Spend % Consumption | Consumption per $ |
|---|---|---|---|---|---|---|
| 500k+ Spins | 35 | $341K | 6.12M | $0.4383 | 5.6% | 18 |
| 100k-500k Spins | 87 | $251K | 2.65M | $1.256 | 9.5% | 10.6 |
| 50k-100k Spins | 71 | $195K | 1.34M | $2.8006 | 14.5% | 6.9 |
| Under 50k Spins | 84 | $138K | 0.82M | $4.0443 | 16.8% | 5.9 |
Critical Finding: Any bracket where “Spend % Consumption” exceeds 50% indicates alarming ROI.
Alarming Projects: 45 songs had promotional spend exceeding 50% of their consumption value.
This section analyzes performance by musical format, comparing top performers, bottom performers, and overall averages for each genre.
| Genre | Count | Total Spend | Total Spins | Avg Spend |
|---|---|---|---|---|
| R&B/Hip-Hop | 91 | $21,624,026 | 19.2M | $237,627 |
| Pop | 89 | $20,902,128 | 24.8M | $234,855 |
| Rap | 40 | $9,076,818 | 7.5M | $226,920 |
| Rock | 37 | $3,805,769 | 2.8M | $102,859 |
| EDM | 5 | $783,532 | 0.5M | $156,706 |
| Afrobeats | 4 | $672,688 | 0.8M | $168,172 |
| Country | 4 | $754,586 | 0.3M | $188,646 |
| Alternative | 2 | $338,117 | 0.2M | $169,059 |
| K-Pop | 2 | $955,339 | 0.5M | $477,669 |
| Euro Hip-Hop | 1 | $22,130 | 0M | $22,130 |
| Gospel | 1 | $127,500 | 0M | $127,500 |
| Punk | 1 | $146,086 | 0M | $146,086 |
Analyzing all genres with 5+ songs
| Segment | Songs | Avg Spend | Avg Spins | Spins per $1k | Cost per Spin | Consumption per $ |
|---|---|---|---|---|---|---|
| Top 10% | 10 | $115,996 | 492K | 48275.8 | $0.20 | 733.7 |
| Overall Avg | 91 | $237,627 | 211K | 5980.9 | $2.45 | 91.5 |
| Bottom 10% | 10 | $336,620 | 45K | 133.4 | $7.64 | 6.0 |
| Segment | Songs | Avg Spend | Avg Spins | Spins per $1k | Cost per Spin | Consumption per $ |
|---|---|---|---|---|---|---|
| Top 10% | 9 | $218,088 | 795K | 10299.8 | $0.24 | 115.0 |
| Overall Avg | 89 | $234,855 | 279K | 1840.2 | $2.17 | 19.6 |
| Bottom 10% | 9 | $277,949 | 40K | 149.9 | $6.95 | 4.6 |
| Segment | Songs | Avg Spend | Avg Spins | Spins per $1k | Cost per Spin | Consumption per $ |
|---|---|---|---|---|---|---|
| Top 10% | 4 | $351,350 | 994K | 2829.8 | $0.35 | 13.0 |
| Overall Avg | 40 | $226,920 | 187K | 676.8 | $3.11 | 9.3 |
| Bottom 10% | 4 | $225,150 | 32K | 142.8 | $7.02 | 1.6 |
| Segment | Songs | Avg Spend | Avg Spins | Spins per $1k | Cost per Spin | Consumption per $ |
|---|---|---|---|---|---|---|
| Top 10% | 4 | $36,087 | 77K | 24614.6 | $0.37 | 194.4 |
| Overall Avg | 37 | $102,859 | 75K | 3262.0 | $1.83 | 25.0 |
| Bottom 10% | 4 | $190,756 | 40K | 248.5 | $4.97 | 3.5 |
| Segment | Songs | Avg Spend | Avg Spins | Spins per $1k | Cost per Spin | Consumption per $ |
|---|---|---|---|---|---|---|
| Top 10% | 1 | $127,885 | 95K | 741.5 | $1.35 | 24.5 |
| Overall Avg | 5 | $156,706 | 95K | 580.1 | $1.98 | 12.1 |
| Bottom 10% | 1 | $103,311 | 29K | 285.0 | $3.51 | 9.9 |
Genre Insights: This analysis covers ALL genres in the dataset. Genres in the upper-right of the scatter plot deliver the best efficiency on both spins and consumption. Use these benchmarks to understand the true cost of promoting each format.
table_data_enhanced <- data %>%
filter(`Project Spend` > 0, `Total Consumption` > 0) %>%
mutate(
Genre = ifelse(is.na(Genre) | trimws(Genre) == "", "Unknown", trimws(Genre)),
Spend = `Project Spend`,
`Consumption (M)` = round(`Total Consumption` / 1000000, 2),
`Spins (K)` = round(`Total Spins` / 1000, 0),
`ROI Multiple` = round(`Total Consumption` / `Project Spend`, 1),
`Spend % Consumption` = round((`Project Spend` / `Total Consumption`) * 100, 1),
`Spins per $1k` = round((`Total Spins` / `Project Spend`) * 1000, 1),
`Cost per Spin` = round(`Project Spend` / `Total Spins`, 4)
) %>%
select(Title, Label, Genre, Spend, `Spins (K)`, `Consumption (M)`,
`ROI Multiple`, `Spend % Consumption`, `Spins per $1k`, `Cost per Spin`) %>%
arrange(desc(`Consumption (M)`))
datatable(table_data_enhanced,
extensions = 'Buttons',
options = list(
pageLength = 25,
scrollX = TRUE,
autoWidth = TRUE,
dom = 'Bfrtip',
buttons = list(
'copy',
list(extend = 'csv', filename = 'sony_radio_data_with_genre'),
list(extend = 'excel', filename = 'sony_radio_data_with_genre')
),
columnDefs = list(list(className = 'dt-right', targets = 3:9))
),
filter = 'top', # Filter boxes at top - including Genre!
class = 'cell-border stripe compact display',
rownames = FALSE) %>%
formatCurrency('Spend', digits = 0) %>%
formatStyle(
'Spend % Consumption',
backgroundColor = styleInterval(50, c('#1a1a1a', '#2a1414')),
fontWeight = styleInterval(50, c('normal', 'bold')),
color = styleInterval(50, c('#ffffff', '#ff4444'))
) %>%
formatStyle(
'Cost per Spin',
color = '#10b981'
) %>%
formatStyle(
'Spins per $1k',
color = '#3b82f6'
) %>%
formatStyle(
columns = 1:10,
backgroundColor = '#1a1a1a',
color = '#ffffff'
)How to Use Enhanced Explorer:
Key Metrics Explained: - Spins per $1k: Higher = more radio airplay per dollar (spin efficiency) - Cost per Spin: Lower = more efficient spending - Consumption per $: Higher = better overall ROI - Spend % Consumption: <50% = healthy ROI, >50% = concerning
Key Findings:
Format-Specific Insights:
Genre-level analysis reveals significant variation in promotional costs and efficiency across musical formats. The data explorer allows filtering by any genre to identify best practices and benchmarks for future campaigns in each format.
A unified radio promotion team would enable Sony Music to leverage its combined scale, standardize best practices, and improve ROI across all labels while maintaining the distinct artist identities that make each label unique.