Marketing & Advertising
Podcast Sponsorship Funnel Calculator
Estimate available, sold, and billable sponsor impressions, gross sponsor revenue, realized CPM, monthly contribution, revenue per episode, and the fill rate needed to break even.
Available monthly sponsor impressions-
Sold sponsor impressions-
Billable impressions after makegoods-
Gross sponsor revenue-
Network or agency share-
Incremental production cost-
Monthly sponsorship contribution-
Sponsor revenue per episode-
Realized CPM across available inventory-
Break-even inventory fill rate-
Decision view
Episode-slot inventory, billable delivery, and sponsor contribution
Episode-slot inventory, billable delivery, and sponsor contributionA four-episode inventory board separates open, sold, makegood, and billable impressions before revenue is recognized.
Exact scenario comparisonSponsorship inventory fill rate (%) changes while all other entered assumptions remain constant.
| Sponsorship inventory fill rate (%) | Available monthly sponsor impressions | Sold sponsor impressions | Billable impressions after makegoods | Gross sponsor revenue | Network or agency share | Incremental production cost | Monthly sponsorship contribution | Sponsor revenue per episode | Realized CPM across available inventory | Break-even inventory fill rate |
|---|
How to use Podcast Sponsorship Funnel Calculator
- Enter sponsored episodes, qualified downloads, and sellable ad slots using the contract's measurement window.
- Enter actual fill, expected makegoods, contracted CPM, and network or agency share.
- Add only sponsorship-driven production and sales costs when evaluating incremental contribution.
Calculator guide
Understanding Podcast Sponsorship Funnel Calculator
Podcast sponsorship inventory is created by episodes, downloads, and ad slots, but revenue exists only for inventory that is sold and delivered. This calculator keeps unsold slots, makegoods, CPM pricing, revenue share, and production cost visible.
Detailed calculation process
Detailed podcast inventory and sponsor-contribution calculation
The default month includes four sponsored episodes, 40,000 qualified downloads per episode, and two sellable slots.
General formula: I=ED AI_s=I fI_b=I_s(1-m)R=I_b c/1000C=R(1-n)-Ep-Sf_BE=(Ep+S)/[I(c/1000)(1-m)(1-n)] Episode-slot inventory is reduced first by unsold capacity and then by delivery reserve. CPM applies only to billable impressions, and the retained revenue must cover production and sales cost.
What each symbol means
Worked substitution with the default inputs
At default inputs, monthly sponsorship contribution is negative $385.34 and needs approximately 90.27% fill to break even.
Worked situations
Practical examples
- Four episodes with 40,000 downloads and two slots create 320,000 available sponsor impressions.
- An 85% fill rate and 4% makegood allowance leave 261,120 billable impressions, worth $7,311.36 at a $28 CPM.
Better inputs
Useful tips
- Use qualified downloads under the sponsor's attribution and timing rules.
- Reserve makegoods before recognizing revenue when delivery is uncertain.
- Keep host-read production and account-management time in incremental cost even when payroll is fixed.
Before relying on the result
Limitations and common mistakes
- The model uses one CPM and download count across all episodes and placements.
- Performance bonuses, affiliate revenue, frequency caps, cancellation terms, taxes, and collection timing are excluded.
- Brand lift and downstream advertiser value are not estimated.
Reference
Key terms
- Available impression
- One qualified download paired with one sellable ad slot.
- Fill rate
- Share of available inventory sold to sponsors.
- Makegood
- Replacement delivery reserved for underperformance or contractual shortfall.
Important note
Contract language governs qualified delivery, makegoods, cancellation, and revenue recognition; reconcile the calculator to insertion orders.
Frequently asked questions
Should pre-roll and mid-roll use one CPM?
Only if they are priced alike; otherwise calculate placements separately and combine their contribution.
Are downloads the same as impressions?
Not always. Use the sponsor agreement's qualified delivery definition and measurement window.
Why is realized CPM lower than contracted CPM?
Realized CPM divides revenue across all available inventory, including unsold and makegood capacity.