Movie Performance on TV
For a multinational broadcaster, I designed a Tableau report that compares movie performance by airing, title and channel through scores and operating filters.
- My contribution
- I designed the analysis model and Tableau reports to compare movies by airing, title and channel.
- Who it serves
- Content programming teams at a multinational broadcaster.
- Scope
- Seven views with scores and filters to study viewing hours and performance.
Case overview
Multi-tab Tableau report for a multinational broadcaster, designed to measure performance of movies, airings, content and channels.
- Tool
- Tableau
- Metrics
- Scores by airing, content and channel
- Read
- Main usage hour
- Source
- 7 views and 21 worksheets
Programming Linear Channel Schedule
A Tableau workbook for linear-channel programming with 7 views, 21 worksheets, consumption metrics, ad-inventory reads and schedule analysis by hour.
Plays/TS reaches 97 at 18:00
Prime reaches an 88 Schedule Score and 41.8 VT+2/TS. The team can concentrate the schedule on slots with stronger consumption and inventory.
Consumption by hour
Performance by slot
- Morning · 06-1254
- Midday · 12-1561
- Afternoon · 15-1867
- Prime · 18-2188
- Late · 21-2472
Complete Tableau replica
All seven views and 21 worksheets retain their filters, tables, heatmaps and hourly comparisons.
LC KPIs DTV
Eight colored-tile worksheets cross the same battery of measures by market, channel or inventory source, monthly or semesterly. The matrix includes month-over-month change.
- Plays
- 1,840
- Total Viewtime (hrs)
- 612
- Avg VT +2 (min)
- 28.4
- Fill Rate
- 71%
| Measure | Total | MoM |
|---|---|---|
| Plays | 1,840 | +4.2% |
| Plays +2 | 1,282 | +5.1% |
| Streams | 865 | +3.4% |
| Total Viewtime (hrs) | 640 | +6.8% |
| Total VT +2 (hrs) | 510 | +7.4% |
| Avg VT +2 (min) | 27.5 | +1.9% |
| Ad Inventory | 523 | +5.6% |
| Fill Rate | 72% | +2.2% |
| Gross Ad Revenue (index) | 97 | +8.3% |
| % Plays +5 min | 62.7% | +1.4% |
| % Replay rate | 8.9% | -0.6% |
| Buffering >0.3% (devices) | 0.43% | -0.05% |
Analytical architecture
Linear-programming model with consumption metrics, ad-inventory reads and scheduling decisions.
- Views
- 7 views covering KPIs, performance, charts, schedule, content/series, hourly comparison and definitions
- Metrics
- CAV+2, TS, MUH, Schedule Score, Ad Inventory/TS, Fill Rate and Watch %
- Privacy
- The public version uses anonymized channels, titles, markets and values; no extracts, clients or sensitive metrics are exposed
- Source
- Snowflake, Tableau extract and modeling by market, channel, inventory source and time window
Case decisions
Analytical design
The report separates airing, content and channel performance to identify what worked, where, at what hour and through which television consumption pattern.
Programming decisions
Seven views compare content, schedules and channels through metrics built for linear television.
Facets
Tools
- Tableau
- 7-view, 21-worksheet programming workbook
- SQL / Snowflake
- source and modeling of linear consumption data
- Broadcast analytics
- custom metrics such as CAV+2, TS, MUH and Schedule Score
- Data modeling
- joins across channels, markets, EPG and content