How to track your podcast ad inventory and sponsor deliverables

What ad inventory actually is

Inventory is a countable asset, not a vague idea. Take the ad slots each episode carries, multiply by the number of episodes in the flight, and subtract what is already sold. What remains is what you can still sell. Most hosts have never done that arithmetic once.

Say your show runs one pre-roll, one mid-roll, and one post-roll, and you publish weekly. A quarter is thirteen episodes, so a quarter holds thirty-nine slots. Hold the post-rolls back for your own promos and you have twenty-six sellable units. That is a number you can quote to a sponsor on a call, and it is the number that tells you whether a season-long ask is even possible. Without it you are guessing, and guessing is how one slot gets promised to two people.

Sponsors also buy flights, not single slots. A flight is a defined run: four episodes, one season, one quarter. Rate, exclusivity, and reporting all attach to the flight, so your ledger should show which flight every sold slot belongs to. The free sponsorship calculator tells you what one slot is worth. Your inventory count tells you how many of them exist to sell.

The ledger, one row per slot

One row per slot, not one row per sponsor. A sponsor who buys six mid-rolls across a season creates six rows, because six separate things have to happen on six specific dates. Five columns carry almost all of the weight: episode, slot, sponsor, rate, status.

What each column is for

• Episode. A specific episode number or release date, never "sometime in March". A slot without a date is a slot you will forget.
• Slot. Pre-roll, mid-roll, or post-roll. Positions are priced differently, so blending them into one line item quietly loses money.
• Sponsor. Who owns it, or open if nobody does, or house if you are keeping it for your own offers.
• Rate. What this specific slot is worth, and whether it was sold alone, bundled, or discounted as part of a season.
• Status. Open, sold, recorded, published, invoiced, paid. A slot is not finished when the episode ships. It is finished when the money lands and the recap is sent.

Deliverables are more than the read

The read is the visible part. The rest of the deal lives in an email thread: a link in the show notes, a social post on release day, a promo code that has to work, a recap at the end of the flight, and an exclusivity window you agreed to keep. Miss one and the sponsor notices.

• The read itself, in the position and the episode you sold.
• A link in the show notes, with the tracking parameters the sponsor gave you, spelled exactly the way they sent them.
• A social mention on release day, on the platforms named in the deal, not only the one you feel like posting on.
• A promo code that actually works. Test it yourself before the episode goes out, not after the sponsor emails you.
• A recap at the end of the flight, showing what ran and how it performed.
• An exclusivity window, if you promised one. Write down the category and the dates, because that is the promise easiest to break by accident.

Put these in the same ledger as the slots, one checkbox per promise. The reason is simple. Every item on that list has its own deadline, and most of them fall due on release day, which is already the busiest day of your month. Anything living only in your head competes with editing, guest logistics, and the show itself, and the show wins every time.

The four ways this goes wrong

Every expensive sponsor problem traces back to inventory nobody wrote down. The slot sold twice. The read that never went out. Exclusivity promised to two companies in the same category. The renewal window that closed while everyone was busy. All four are bookkeeping failures, not selling failures.

• The double-sold mid-roll. Two sponsors, one position, one episode. Somebody has to be moved, and the one you move remembers.
• The missed read. A four-episode flight where week three quietly went out clean. That is not an apology, that is a refund conversation, and it usually takes the renewal with it.
• Exclusivity promised twice. You gave one sponsor category exclusivity in the spring, then sold a competitor a mid-roll in the summer, because nobody wrote the window down anywhere.
• The renewal nobody asked for. The flight ended, no recap went out, no conversation happened, and the budget moved to a show that stayed in touch.

A slot is not sold when the sponsor says yes. It is sold when the read is recorded, the episode is published, the deliverables are done, and the invoice is paid. Track all four states, not just the yes.

When the spreadsheet stops holding

A spreadsheet is a fine first ledger, and it holds longer than most software companies want to admit. It stops holding when the same fact has to live in three places at once: the sponsor agreement, the episode calendar, and your follow-up list. A guest reschedule moves an episode, and a static sheet does not know that.

Three signals say it is time to move. More than one sponsor running at once. More than one position sold per episode. A publishing calendar that shifts. Pod Green Room handles that as a podcast CRM, with sponsor tracking and follow-ups sitting beside the episodes and guests they depend on, so a moved episode carries its sold slots along with it.

The recap that wins the renewal

Renewals are won with a recap, not a reminder. At the end of a flight, send one document showing every slot that ran, the episode it ran in, the deliverables you completed, and the numbers you can honestly report. Most hosts send nothing, then ask for another quarter.

1. Every slot that ran, by episode and position, so the sponsor can check it against what they bought.
2. The deliverables you completed, including the show-notes link, the social posts, and the dates the promo code was live.
3. Download numbers for the episodes their reads ran in, reported the same way every single time.
4. Anything you can honestly attribute: code redemptions they shared with you, listener replies, a question the read prompted.
5. What is open next, with specific episodes and dates. A renewal is easier to say yes to when the ask is a calendar rather than a concept.

If the ledger is current, that recap takes twenty minutes, because it is the ledger filtered to one sponsor. It is also the strongest material you own for the next pitch. Pod Green Room builds a media kit from your real show data, and a finished flight with clean delivery records is the most persuasive thing that kit can carry into a cold conversation.

Inventory tracking is the unglamorous half of sponsorship, and it is the half that decides whether the first deal becomes a second one. What a sponsor is actually buying, how to price it, and how to run the pitch is all in the guide on how to get podcast sponsors. If you want a read on whether the show is ready to sell inventory at all, the sponsor readiness grader will tell you where the gaps are.