Inventorying a YouTube channel is the process of cataloging every video on a channel into a structured Google Sheet that captures the video title, URL, publish date, featured speaker, Google ranking data, social media links, view count, duration, and word count from the transcript. This is a foundational analytics task in the Content Factory because the inventory reveals exactly what content exists, how it performs, and where the gaps are.
A YouTube inventory belongs to the Process stage—specifically the “Organize and Catalog” sub-component. Before you can decide what new pillar content to produce, you need to understand what already exists. The inventory tells you which speakers generate the most views, which topics rank on the first page of Google, and where the channel has untapped potential. It also feeds into positive mentions collection and content authority scoring.
🔄 YouTube Inventory Process Overview
📋
Step 1
Load Videos Page
→
📝
Step 2
Gather Core Info
→
🔍
Step 3
Check Rankings
→
👤
Step 4
Find Social Profiles
→
👁️
Step 5
Views & Duration
→
📊
Step 6
Word Count
→
✅
Step 7
Summary Tab
Repeat Steps 1–6 for each video · Average time per video: < 1 min 45 sec
Where YouTube Inventory Fits in the Content Factory
Produce
Process
← You are here
(Organize)
Post
Promote
This task bridges the Produce and Process stages. It is an analysis task that informs content strategy. The inventory depends on having an active YouTube channel with published videos. Once complete, it feeds into decisions about which content to repurpose, which speakers to feature more, and which topics deserve new pillar content recordings.
⏱️
Time Estimate
Each video entry should take no more than 1 minute 45 seconds. Total time depends on the number of videos in the channel. Accuracy is essential—bad data equals bad analysis.
Step-by-Step Inventory Process
Step 1: Load the Videos Page
Navigate to the YouTube channel’s Videos tab. Start with the first video on the list. For YouTube Shorts, replace “shorts/” in the URL with “watch?v=” to access the full video page with view count, duration, and transcript.
Step 2: Gather Core Information
For each video, copy the video name, URL, and publish date into the appropriate columns. Identify the featured speaker—if the client is interviewing someone, record that person’s name. Check the video description for additional details about the speaker including their company affiliation.
💡 Pro Tip for YouTube Shorts: Shorts don’t show view count, duration, or transcript in their default view. Replace
shorts/ in the URL with watch?v= to access the full video page with all the data you need.
Step 3: Check Google Rankings
Search the featured speaker’s name on Google. Record whether the client or their company appears on the first page of results under “First Page.” Check if the specific video appears in search results and record the ranking under “Video Ranking.” Use “1st” for first-page results and “n/a” when not found.
Step 4: Find Speaker Social Profiles
Locate the featured speaker’s LinkedIn and Twitter/X accounts. Check the video description first, then Google their name with their company name in quotes for more specific results. Verify you have the correct person before recording the URLs. If no account exists, record “n/a.”
Step 5: Record View Count and Duration
Copy the video’s view count and duration from the YouTube video page into the appropriate columns. For Shorts, make sure you are viewing the “watch?v=” version to see accurate counts.
Step 6: Get the Word Count from the Transcript
Click “Show Transcript” on the YouTube video page, select all transcript text from the first to last timestamp, and copy it. Paste it into a timestamp removal tool to strip the timestamps. Then paste the clean text into a word counter tool or MS Word to get the word count. Record this number in the spreadsheet.
Step 7: Complete the Summary Tab
After inventorying all videos, update the Summary tab with the analysis date, total number of YouTube videos, total channel views, total duration, and total words. Verify that the formulas capture all populated cells. Calculate your time to completion, time per entry, and cost per entry.
Related Resources
YouTube inventory is just one type of content audit. The same process applies to podcasts, conference appearances, blog posts, and social media profiles. Once you understand how to catalog what already exists, you can identify gaps, find repurposing opportunities, and build a complete content authority profile for any brand or business owner.
See how we applied this inventory process across different channels and clients:
- How We Built Brady Sticker’s Podcast Inventory
- How We Built George Leith’s Podcast Inventory
- How to Inventory a Podcast on YouTube: The Definitive SOP
- How We Inventoried 700+ Podcast Appearances Across 5 Platforms
- How to Find 62+ Hidden Podcast Appearances That Aggregators Miss
Beyond YouTube, there are dozens of things to audit for a local service business including Google Business Profile, website SEO, social media presence, review profiles, directory listings, and paid ad performance. Our Quick Audit analyzes all of these areas and shows exactly what to fix to start getting more calls. For businesses ready to implement the full system, the Maps Visibility program on Local Service Spotlight handles everything from content production to local ranking.
Take the Next Step
YouTube inventory is the foundation of data-driven content strategy. Once you know what content exists and how it performs, you can make informed decisions about what to produce next, what to repurpose, and where to focus your energy.
If you run a local service business and want a complete audit that goes beyond YouTube, request a Quick Audit to see where you stand across all channels. To learn the full Content Factory system yourself, explore our training courses.
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.