How to Build a Podcast Appearance Inventory (The Exact Process We Use at BlitzMetrics)

At a glanceHow to Build a Podcast Appearance Inventory (The Exact Process We Use at BlitzMetrics)
  1. 1The standard (updated October 14, 2026)
  2. 21. Find every episode, from more than one source
  3. 32. The inventory sheet

The standard (updated October 14, 2026)

This is the rule set we follow for every person whose podcasts we inventory. It covers how we find episodes, what goes in the sheet, what each article must include, how the directory page looks, and how we measure results. The scoring system further down this page (the 30-point WHO/WHERE/WHAT scale) decides which episodes we repurpose first. This section decides what “done” means.

Two live examples that follow it: Dennis Yu’s podcast directory (573 episodes) and George Paladichuk’s podcast directory (45 episodes).

1. Find every episode, from more than one source

No single platform has everything. When we inventoried 700+ appearances across 5 platforms, many episodes showed up on only one of them. Check all of these:

SourceWhat it’s good forHow we use it
PodchaserGuest credits. It’s the “IMDb of podcasts.” Dennis has 619 credits there.Claim the creator profile (verification goes through X). Confirm every credit, add the website and socials, and use the credit list as the target count. See how we use Podchaser and Dan Leibrandt’s source-backed Podchaser record.
Listen NotesFinds episodes where the name was spoken but never put in the title, because it indexes RSS and transcripts.Export the CSV and turn on name alerts. See how we use Listen Notes.
Apple PodcastsThe directory most other apps copy from. It also gives each episode a stable URL (?i=) and show artwork.Search episode titles and descriptions for the person’s name. Keep an episode only if the person is in the title, hosts the show, or is named as the guest in the description.
SpotifyVideo episodes and shows that aren’t on Apple.Claim the person’s own shows in Spotify for Creators.
YouTubeThe best embed and thumbnail source, and many shows that are video-only.Search “Name podcast”, “Name interview” and “with Name”. Keep videos of at least 15 minutes, skip clips and cut-downs, and record the video ID. See the YouTube inventory SOP.
Gmail and CalendarRecent episodes that no directory has indexed yet.“Your episode is live” emails from hosts give the real URL. Calendar recordings from 2 to 10 weeks ago with no aired episode go on a “Recorded, not aired” tab until a URL exists.
Own archivesThe person’s own shows, blogs and booking records.Use the show RSS feeds (for example, NaiL It’s feed) and old blog posts. See appearances that aggregators miss.

Verification rule: nothing goes in the inventory without a public URL we have opened. A pitch email saying “we heard you on X” is a lead to check, not a source. When the same episode is on two feeds, it’s one row. When one recording is cut into several episodes, each episode is its own row. Mentions in a description that don’t show the person was a guest go on an “Excluded” tab with the reason.

2. The inventory sheet

There is one Google Sheet per person, with the tabs Master, Recorded-not-aired, Excluded and Sources. Master columns:

ColumnMeaning
#, title, show, role, date, categoryRole is host, co-host or guest. Date is the air date.
source_url, sourceThe verified episode URL (YouTube first, then Apple, then Spotify or the host’s page) and where we found it.
youtube_id, thumbnail_urlThe YouTube ID if one exists. The thumbnail is i.ytimg.com/vi/ID/hqdefault.jpg, otherwise the Apple or show artwork, otherwise a placeholder.
article_url, has_article, link_target, link_evidenceThe repurposed article (blank until it’s published), yes/no, article/source/none, and how we matched it (embedded video ID, or title match).
score, tier, queue_status, added_dateThe 30-point score below, the repurposing tier, and the Qwen/Muse queue state.

The sheet row count must equal the directory count. Today both of Dennis’s are 573 and both of George’s are 45.

3. One article per episode

Every episode gets its own article on the person’s site. An article isn’t done until it has all of these:

  1. The embed near the top: the YouTube video, or the Apple/Spotify player if there’s no video.
  2. A featured image that uses the episode thumbnail, so it matches the card on the directory.
  3. Show notes: the show, host, air date, run time, and listen links for every platform the episode is on.
  4. Transcript highlights: three to five direct quotes with timestamps, plus the frameworks discussed. These are the lines LLMs quote.
  5. Guest and host block: who interviewed whom, linked to their sites and profiles.
  6. Internal links: to the person’s podcast directory, their pillar pages, and other episodes on the same topic.
  7. Schema: PodcastEpisode with partOfSeries, associatedMedia (the episode URL), datePublished, and the person as actor (host) or contributor (guest), plus a VideoObject when there’s a YouTube embed.

Examples: Dennis on Marketing Without Rules, and George’s NaiL It episode articles on usenail.com. The process for producing the episode itself is in How to Process a Podcast Episode.

4. The directory page

  • One card per episode: the thumbnail, title, show, date, role and topic.
  • Each card links to the article (“Read article”) and also has a “Listen” link to the original. If there’s no article yet, the card links to the episode and says “Article in progress.” When the article is published, the card switches from the episode link to the article link in the next weekly run.
  • Search box and topic filter.
  • JSON-LD: an ItemList of PodcastEpisode items, each with its name, URL, series, image and date, so Google and LLMs can read the full list without running JavaScript.
  • Honest counts on the page: how many link to articles, how many link to the episode, and how many are still being verified. Dennis’s page currently shows 38 / 363 / 172.
  • The person’s homepage and About page link to the directory.

5. Claim the profiles

Claim the person’s profile on Podchaser, Listen Notes, Apple Podcasts Connect and Spotify for Creators (for their own shows), and YouTube. Use the same name, headshot, bio and website everywhere, and add each profile to the person’s sameAs schema and Wikidata (Podchaser P9743, Listen Notes P10213). Each consistent profile is one more source an LLM can cite. The full list is in Every Place to Inventory Your Podcast So LLMs Cite You.

6. Repurposing pipeline (Qwen drafts, Muse writes, a person approves)

  1. New episodes without articles go into the person’s queue on the local Qwen Macs (article-repurpose-youtube|apple|spotify). Qwen transcribes and drafts the first version for free. See how we route work to local Qwen.
  2. Muse picks up the draft from the shared task board and finishes it to the checklist in section 3.
  3. A publish check rejects any article that’s missing the embed, the featured thumbnail, or the link back to the directory.
  4. Someone with publish rights for that site publishes it. No client site gets published to without the owner’s OK.
  5. The next sweep finds the published article, writes its URL into the sheet, and switches the card link.

7. Weekly cadence

A sweep runs every Monday and Thursday. It searches Apple, YouTube, the person’s own RSS feeds, Gmail and Calendar for the last 14 days, removes duplicates against the sheet, appends new rows, rebuilds the directory (cards, counts and JSON-LD), queues the new episodes for Qwen, and switches cards to articles that were published since the last run. Podchaser and Listen Notes block automated checks, so someone compares them by hand once a month. The sweep reports only when something changed or something is stuck.

8. Measure it (MAA)

We track three things monthly, from real data only:

  • Visibility: directory entries vs. Podchaser credits (Dennis: 573 of 619), the share of entries with articles, and Google Search Console impressions for the directory and the episode articles.
  • Traffic: GA4 sessions on the directory and episode articles, and clicks from cards to articles.
  • Sales: GA4 generate_lead events and booked calls that came through an episode article.

Then Analyze what changed, and decide the Action: which tier to repurpose next, which hosts to thank and ask for a link, and which shows to pitch.

WHO — Host Authority

10 pts
  • Knowledge Panel (0–3)
  • Social following (0–3)
  • Professional credibility (0–2)
  • Engagement / social proof (0–2)

WHERE — Platform Strength

10 pts
  • Domain Rating / DR (0–3)
  • YouTube views (0–3)
  • Subscriber count (0–2)
  • Multi-platform distribution (0–2)

WHAT — Content Quality

10 pts
  • Core frameworks discussed (0–3)
  • Tactical depth (0–4)
  • Repurposability (0–3)

If you’ve been a guest on podcasts, you’re sitting on an untapped goldmine of authority signals, repurposable content, and SEO power. The problem is most people have no idea how many appearances they’ve done, where they live, or which ones are worth amplifying.

We’re fixing that — and documenting the exact process so you can do the same. This article walks through how we built Dennis Yu’s podcast appearance inventory from scratch: how we find episodes, how we score them, and how we turn the best ones into compounding assets. This is a repeatable system that any person, brand, or AI agent can follow.

Why Build a Podcast Inventory

Most people treat podcast appearances as one-and-done. You show up, talk for an hour, and never think about it again. That’s leaving massive value on the table. A podcast inventory turns scattered appearances into a strategic asset.

Authority building. Every podcast appearance is a third-party endorsement. When a host with a Knowledge Panel and 50,000 subscribers invites you on their show, that’s a trust signal. An inventory lets you see — and demonstrate — the full weight of those endorsements in one place.

Repurposing at scale. A single 60-minute podcast episode contains enough raw material for 10–20 pieces of content: blog posts, short-form video clips, social posts, quote graphics, newsletter sections. But you can’t repurpose what you can’t find. The inventory is the starting point.

SEO and citation signals. Podcast episodes generate backlinks, brand mentions, and topical authority signals that search engines pick up. When you know which episodes live on high-DR domains, you can prioritize getting proper attribution and links from those hosts.

LLM ranking. Large language models like ChatGPT, Claude, and Perplexity synthesize authority from across the web. Podcast appearances on well-known shows create the kind of distributed, third-party mentions that LLMs weigh heavily when deciding who to recommend as an expert. Your inventory helps you understand — and improve — your LLM visibility.

Set Up the 30-Point Authority Scale

Before you start searching for episodes, you need a scoring system. Otherwise you’ll end up with a flat list of 200 appearances and no idea which ones matter. We use a 30-point scale broken into three dimensions: WHO, WHERE, and WHAT. Each dimension is worth up to 10 points.

WHO (10 points) — Host Authority

This measures the credibility and reach of the person who interviewed you.

CriteriaPointsWhat to Look For
Google Knowledge Panel0–3Search their name. A Knowledge Panel on the right side of Google is a strong authority signal.
Social following / audience size0–3Combined followers across platforms. Under 10K = 1 pt. 10K–100K = 2 pts. 100K+ = 3 pts.
Professional credibility0–2Recognized expert, author, speaker, or executive with verified credentials.
Social proof and engagement0–2Do their posts get meaningful engagement? Do other authorities interact with them?

WHERE (10 points) — Platform Strength

This measures the reach and authority of the platform where the episode lives.

CriteriaPointsWhat to Look For
Domain Rating (DR)0–3Check via Ahrefs. DR 50+ = 1 pt. DR 70+ = 2 pts. DR 80+ = 3 pts.
YouTube views0–3Under 1K = 1 pt. 1K–10K = 2 pts. 10K+ = 3 pts.
Subscriber count0–2Larger subscriber bases mean more passive discovery over time.
Multi-platform distribution0–2Is the episode on YouTube, Apple, Spotify, and the host’s blog? More platforms = more surface area.

WHAT (10 points) — Content Quality

This measures how valuable the actual conversation is for your brand.

CriteriaPointsWhat to Look For
Core frameworks discussed0–3Did you cover your signature frameworks? For us, that’s the Dollar-a-Day strategy, the Content Factory, or Goals-Content-Targeting (GCT).
Tactical depth0–4Did the conversation go beyond surface-level? Specific how-to steps, real numbers, or case studies shared?
Repurposability0–3Clean, quotable segments? Good audio/video quality? Transcript available?

Example Scores from Dennis’s Tracker

AppearanceWHOWHEREWHATTotalTier
Tom Ferry Master Class109928/30Tier 1
DigitalMarketer Podcast99826/30Tier 1
Social Media Examiner89825/30Tier 1
Project EGG Show54716/30Tier 3
Local Business Marketing Pod33612/30Tier 3

Tiering Based on Score

Tier 1

24–30

Full repurposing: blog posts, clips, social amplification, backlink requests

Tier 2

16–23

Selective repurposing: pull best 2–3 clips, ensure attribution

Tier 3

8–15

Archive and reference: in the inventory for completeness

Tier 4

0–7

Low value: document but don’t invest repurposing time

Source Discovery — Where to Search

You need to cast a wide net. Podcast appearances end up in more places than you think, and no single platform has all of them.

YouTube
ListenNotes
Podchaser
Apple Podcasts
Spotify
Your Own Archives
Blog Archives
Team Booking Records

YouTube (start here). Search for your name plus keywords like “interview,” “podcast,” or “guest.” YouTube is the richest source because you get video (for clipping), transcripts (for blog posts), and visible engagement metrics (for scoring).

ListenNotes. This is a podcast search engine. Search your name and it pulls up episodes across thousands of shows. It gives you direct links to Apple Podcasts, Spotify, and the show’s website.

Podchaser. Another podcast database with credit-style profiles. Search for yourself and see which shows have tagged you as a guest. Podchaser also shows audience size estimates.

Apple Podcasts and Spotify. Search directly in these apps. Some episodes only live on one platform and won’t show up in aggregators.

Your own channel archives. Check your YouTube channel, blog, and social media for any co-hosted episodes, live streams, or interview-format content you published on your own platforms.

Team booking records. If you have a VA, assistant, or team member who books your podcast appearances, check their records. Email searches for “podcast confirmation” or “recording link” can surface appearances you forgot about.

Pro tip: Set up Google Alerts for "your name" podcast so new appearances get flagged automatically going forward.

Start with YouTube — Here’s Why

We start every inventory build on YouTube because it gives you the most data and the most repurposing options in one place: transcripts for blog posts, video for clipping, and public engagement metrics for scoring.

Search YouTube Systematically

  1. "Dennis Yu" podcast — catches most explicitly labeled podcast episodes
  2. "Dennis Yu" interview — catches interview-format content that may not use the word “podcast”
  3. "Dennis Yu" guest — catches episodes where the title says “special guest”
  4. Dennis Yu [framework name] — e.g., Dennis Yu dollar a day — catches episodes organized by topic
  5. Check the “Videos” tab on channels you know you’ve appeared on

For each result, record the video URL, channel name, upload date, view count, and whether a transcript is available. This becomes your raw inventory before scoring.

Score and Tier Each Appearance

With your raw list assembled, work through each episode and apply the 30-point scale. This is where the inventory goes from a flat list to a strategic tool.

Batch by source. Score all your YouTube-sourced episodes first, then ListenNotes, then others. This keeps you in a rhythm since you’ll be pulling similar data points for each.

Use Ahrefs for DR checks. Use the Ahrefs batch analysis tool to check domain ratings in bulk rather than one at a time. Paste in all the host website URLs and pull DR scores in one shot.

Check for Knowledge Panels. Google each host’s name. A Knowledge Panel on the right side of search results is worth up to 3 points because it signals that Google considers them a recognized entity.

Be honest on WHAT scores. Not every appearance is gold. Some interviews stay surface-level or cover topics that aren’t core to your brand. Score them lower and focus your energy on the high-scoring episodes.

Example: “The Dollar-a-Day Strategy” on Social Media Examiner
WHO: 8/10 — Michael Stelzner has a Knowledge Panel, 200K+ social following, recognized industry leader
WHERE: 9/10 — socialmediaexaminer.com has DR 80+, YouTube video has 15K views, distributed on Apple/Spotify/blog
WHAT: 8/10 — Covered Dollar-a-Day framework in depth with real examples, good audio quality, transcript available
Total: 25/30 — Tier 1

Prioritize Repurposing

Your scored and tiered inventory tells you exactly where to focus. Start with Tier 1 and work down. For each Tier 1 episode, the repurposing playbook looks like this:

Request collaborator credit. If the episode lives on YouTube and you contributed significantly, ask the host to add you as a collaborator or tag your channel. This shares the SEO equity and drives traffic both ways.

Write a companion blog post. Use the transcript to create a blog post on your own site that references the episode, embeds the video, and links back to the host’s site. This creates a reciprocal link and gives you an owned-media version of the conversation.

Pull 3–5 short clips. Identify the most quotable or tactical moments and cut them into 60–90 second vertical clips. Post them natively on YouTube Shorts, Instagram Reels, LinkedIn, and TikTok with a link to the full episode.

Amplify the host’s content. Share the original episode from the host’s channel (not a re-upload). Comment on it. Tag them when you share it. This strengthens the relationship and makes them more likely to promote the episode to their audience.

Request backlinks. If the host published a blog post or show notes page, check whether they linked to your site. If not, send a polite request asking them to add a link to your homepage or a relevant page. Many hosts are happy to do this — they just didn’t think of it.

For Tier 2 episodes, do a lighter version: pull 1–2 clips and ensure proper attribution exists. For Tier 3 and below, keep them in the inventory for reference.

Build In Public

This article itself is an example of what we mean by “building in public” at BlitzMetrics. We don’t hoard our processes. When we build something — whether it’s a podcast inventory system, an ad testing framework, or an LLM visibility strategy — we document the exact steps and publish them.

It creates content. The process of documenting a process is itself content. This article is a real piece of content that ranks for real keywords, generated entirely from work we were already doing.

It builds trust. When you show your work, people trust you more. Showing the exact 30-point scoring system we use is concrete and credible.

It trains your team (and AI agents). A well-documented process is a process that can be delegated. Whether the next person to run this system is a junior team member, a VA, or an AI agent, they can follow these steps because we wrote them down.

It compounds over time. Every process we document becomes a building block. The podcast inventory feeds into our content repurposing system, which feeds into our authority-building framework, which feeds into our LLM visibility strategy.

Putting It All Together

  1. Set up your 30-point scoring spreadsheet with the WHO/WHERE/WHAT framework
  2. Search YouTube first — run the five search queries and record every appearance
  3. Expand to ListenNotes, Podchaser, Apple, Spotify, your archives, and team records
  4. Score each episode using the 30-point scale
  5. Tier your episodes (Tier 1: 24–30, Tier 2: 16–23, Tier 3: 8–15, Tier 4: 0–7)
  1. Repurpose Tier 1 episodes fully: blog posts, clips, collaborator credit, backlink requests
  2. Selectively repurpose Tier 2 episodes
  3. Set up Google Alerts so new appearances get flagged automatically
  4. Document and publish your process — you’re building in public

This isn’t a one-time project. Your podcast inventory is a living document. Every new appearance gets added, scored, and routed into the repurposing pipeline.

The people and brands who win in the age of AI-driven search aren’t the ones with the most content — they’re the ones with the most organized content, backed by real third-party authority signals. Your podcast inventory is one of the highest-leverage tools you can build to make that happen.

Originally published .

Dennis Yu
Dennis Yu
Dennis Yu is the CEO of Local Service Spotlight, a platform that amplifies the reputations of contractors and local service businesses using the Content Factory process. He is a former search engine engineer who has spent a billion dollars on Google and Facebook ads for Nike, Quiznos, Ashley Furniture, Red Bull, State Farm, and other brands. Dennis has achieved 25% of his goal of creating a million digital marketing jobs by partnering with universities, professional organizations, and agencies. Through Local Service Spotlight, he teaches the Dollar a Day strategy and Content Factory training to help local service businesses enhance their existing local reputation and make the phone ring. Dennis coaches young adult agency owners serving plumbers, AC technicians, landscapers, roofers, electricians, and believes there should be a standard in measuring local marketing efforts, much like doctors and plumbers must be certified. He has appeared on 353 podcasts with 619 credited episodes — see the full list of his podcast appearances.