Tabellab
Marketing Analytics Intermediate

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.

20 lessons 20 labs Certificate

  • 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

  1. Listen-Through Rate: Ad Starts, Completed Listens, eCPM and the Cost per Completed Listen for Streaming Audio AdsLabFree
  2. Quartile Reports: Retention at 25, 50 and 75 Percent, Early Drop-Off, Seconds Heard per Start and a Retention ChartLab Locked
  3. Companion Banners: Render Rate, Companion CTR, Clicks per 1,000 Audio Impressions and the Device SplitLab Locked
  4. Reach and Frequency: Unique Listeners, Average Frequency, Segment Reach and a Frequency-Cap CheckLab Locked
  5. Frequency Response: Response Rate by Spots Heard, the Plateau, Buyers per 1,000 Impressions and Heavy-Listener WasteLab Locked
  6. Daypart Mix: Share of Ad Starts, Share of Orders, the Order Index and Cost per Order by Time of DayLab Locked
  7. Promo-Code Response: Redemptions per 1,000 Listens, Discount Cost, Net Revenue and Net Return per EuroLab Locked
  8. The Cost Ladder: Cost per Listen, per Click and per Redemption by App, with Ranks and a Bar ChartLab Locked
  9. Survey Response: Response Rate, the Audio Share of "How Did You Hear About Us" Answers and On-Air versus Off-Air WeeksLab Locked
  10. Brand-Lift Test: Awareness Lift in Points, Relative Lift, z-Score, p-Value and a Significance VerdictLab Locked
  11. The Daypart × Weekday Grid: Cost per Order for 35 Slots, Weekday versus Weekend, INDEX/MATCH and a Heat MapLab Locked
  12. Frequency-Cap What-If: Cost of Each Extra Play, Cost per Extra Buyer, a Keep or Cut Rule and the SavingsLab Locked
  13. Creative Wear-Out: Weekly Response per 1,000 Ad Starts, an Index, the Weekly Slope, a Forecast and a Replacement RuleLab Locked
  14. Redemption Lag: Days from Spot to Order, an Attribution Window, Weekday Numbers and the Median LagLab Locked
  15. Pacing Check: Flight Days, Days Elapsed, Expected Delivery, Pacing and Behind, On Track or Ahead StatusLab Locked
  16. Data Quality: Impossible Completions, Implausible Redemption Rates, Flag Counts and Duplicate Report LinesLab Locked
  17. Budget Reallocation: Diminishing Returns with an Elasticity, Projected Redemptions, Cost per Redemption Now versus ProposedLab Locked
  18. Flight Forecast: Slope, Intercept and R Squared of Spend versus Redemptions, FORECAST.LINEAR and Forecast Cost per RedemptionLab Locked
  19. A/B Test Planning: z-Values, Relative Uplift, Required Sample per Arm, Days Needed and a Fit-the-Window CheckLab Locked
  20. Final Project: The Spring Audio Campaign Dashboard with Listen-Through Rate, Cost per Redemption by App, a Chart and a Highlight RuleLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy