Streaming Audio Ads: Listen-Through Rate, Companion Banners, Frequency, Dayparts, Cost per Listen & Promo-Code Response
Measure ads on music-streaming and radio apps with nothing but a spreadsheet. You will turn delivery reports into listen-through rates, eCPM and cost per completed listen, read quartile drop-off, size companion banners by device, split reach from frequency and find where response flattens. Then you compare dayparts and a daypart-by-weekday grid, price promo codes after the discount, climb the cost ladder to cost per redemption, read an order survey and test a brand-lift survey for significance. Later labs run a frequency-cap what-if, track creative wear-out with SLOPE and FORECAST.LINEAR, apply an attribution window to redemption lags, check pacing against the calendar, screen reports for bad lines, test a budget shift with diminishing returns, forecast the next flight, plan an A/B test and finish with a campaign dashboard. 20 hands-on labs, fictional Dunlin Trail Co. data, every cell checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
This course shows how to measure advertising on music-streaming and radio apps with a spreadsheet, using the numbers of Dunlin Trail Co., a fictional online shop for trail-running shoes. In 20 interactive labs you turn delivery reports into listen-through rates, eCPM and cost per completed listen, read quartile drop-off, measure companion banners by device and separate reach from frequency. You compare dayparts and a daypart-by-weekday grid, price promo codes after the discount, rank apps by cost per redemption, read an order survey and test a brand-lift survey for significance. Later labs cover a frequency-cap what-if, creative wear-out, redemption lag, pacing, data-quality checks, a budget reallocation scenario, a flight forecast and A/B test planning, and the course ends with a campaign dashboard. You use IF, SUMIFS, XLOOKUP, INDEX/MATCH, RANK.EQ, SLOPE and FORECAST.LINEAR, charts and conditional formatting. Podcasts are not covered. All companies, apps and figures are fictional, and benchmarks are illustrative.
Why learn with Tabellab
- Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
- Verifiable certificatePass the final exam and get a certificate with a public verification code.
- Try before you buyLesson 1 is free, with no sign-up or card needed.
- Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint
Lessons
- Listen-Through Rate: Ad Starts, Completed Listens, eCPM and the Cost per Completed Listen for Streaming Audio AdsFree
- Quartile Reports: Retention at 25, 50 and 75 Percent, Early Drop-Off, Seconds Heard per Start and a Retention Chart Locked
- Companion Banners: Render Rate, Companion CTR, Clicks per 1,000 Audio Impressions and the Device Split Locked
- Reach and Frequency: Unique Listeners, Average Frequency, Segment Reach and a Frequency-Cap Check Locked
- Frequency Response: Response Rate by Spots Heard, the Plateau, Buyers per 1,000 Impressions and Heavy-Listener Waste Locked
- Daypart Mix: Share of Ad Starts, Share of Orders, the Order Index and Cost per Order by Time of Day Locked
- Promo-Code Response: Redemptions per 1,000 Listens, Discount Cost, Net Revenue and Net Return per Euro Locked
- The Cost Ladder: Cost per Listen, per Click and per Redemption by App, with Ranks and a Bar Chart Locked
- Survey Response: Response Rate, the Audio Share of "How Did You Hear About Us" Answers and On-Air versus Off-Air Weeks Locked
- Brand-Lift Test: Awareness Lift in Points, Relative Lift, z-Score, p-Value and a Significance Verdict Locked
- The Daypart × Weekday Grid: Cost per Order for 35 Slots, Weekday versus Weekend, INDEX/MATCH and a Heat Map Locked
- Frequency-Cap What-If: Cost of Each Extra Play, Cost per Extra Buyer, a Keep or Cut Rule and the Savings Locked
- Creative Wear-Out: Weekly Response per 1,000 Ad Starts, an Index, the Weekly Slope, a Forecast and a Replacement Rule Locked
- Redemption Lag: Days from Spot to Order, an Attribution Window, Weekday Numbers and the Median Lag Locked
- Pacing Check: Flight Days, Days Elapsed, Expected Delivery, Pacing and Behind, On Track or Ahead Status Locked
- Data Quality: Impossible Completions, Implausible Redemption Rates, Flag Counts and Duplicate Report Lines Locked
- Budget Reallocation: Diminishing Returns with an Elasticity, Projected Redemptions, Cost per Redemption Now versus Proposed Locked
- Flight Forecast: Slope, Intercept and R Squared of Spend versus Redemptions, FORECAST.LINEAR and Forecast Cost per Redemption Locked
- A/B Test Planning: z-Values, Relative Uplift, Required Sample per Arm, Days Needed and a Fit-the-Window Check Locked
- Final Project: The Spring Audio Campaign Dashboard with Listen-Through Rate, Cost per Redemption by App, a Chart and a Highlight Rule Locked
Learner reviews
Be the first to review this course.