The YouTube Channel Performance Tracker in Google Sheets records every upload across 16 columns, calculates 4 of them automatically, and feeds 1 headline KPI card plus 4 live charts from one page. The sample file ships 15 videos worth 1.0M total views, and the formulas and charts cover rows 16 to 1000, so roughly 985 uploads fit before anything needs extending.
Most creators already have the numbers. They are sitting in YouTube Studio, one video at a time, and they vanish the moment the 28-day window rolls forward. What is missing is a durable record you own: a single sheet that says which video, which format, how it did, and what you decided to do about it. That is the whole job of this tracker, and it is deliberately a small one.
One thing to be clear about first: this is a manual template. It does not connect to the YouTube API, it does not import anything on a schedule, and it is not affiliated with YouTube or Google. You copy your figures across from YouTube Studio yourself, and the calculated columns and charts update as you type. It is also a different product from the multi-page YouTube Channel Analytics Dashboard sold on the same store — that one is an analytical dashboard, this one is a log.
Key Features of the YouTube Channel Performance Tracker in Google Sheets
- 16 columns, one row per video. Video ID, Video Title, Content Type, Format, Status, Publish Date, Views, Watch Time (hrs), Likes, Comments, Subs Gained, Est. Revenue, Engagement %, RPM, Performance Rank and Notes.
- 4 automatic columns. Video ID numbers each row. Engagement % is (Likes + Comments) / Views. RPM is revenue per 1,000 views. Performance Rank orders the catalogue so the most-viewed video is Rank 1. All four stay blank on empty rows and never display errors.
- 1 KPI card and 4 charts. A full-height TOTAL VIEWS tile sits to the left of Video Count by Content Type, Video Count by Status, Views by Video and Likes vs Comments by Video.
- No helper tables. Every chart reads the data columns directly using the built-in Aggregate option across rows 16 to 1000, so a new video appears in the charts the moment you add it.
- Dropdowns that grow with you. Content Type, Format and Status pull from a separate List tab covering rows 2 to 500. Add a value there and it shows up in the dropdown without any re-setup.
- 8 content types, 3 formats, 4 statuses. Tutorial, Review, Vlog, Shorts, Q&A, Unboxing, Gaming and Livestream; Long-form, Short and Live Stream; Published, Scheduled, Draft and Idea.
- One-edit rebrand. The palette lives in a single
const C = {...}block at the top of the script, and the $ currency on Est. Revenue and RPM switches to ₹, € or £ through Format → Number.
Sheets Explanation
The Tracker Sheet
This is where the work happens. The TOTAL VIEWS card reads 1.0M against the sample data. Four charts run across the top, and beneath them the 16-column log carries colour-coded pills for Content Type, Format and Status, conditional shading on Engagement %, and a free-text Notes column for the context a number cannot hold — “Viral short”, “High comment ratio”, “Not monetized”. In the sample data the Shorts take ranks 1 and 3 on views while earning $0.61 and $0.74 RPM, which is exactly the kind of tension the sheet is built to make visible.
The How to Use Tab
A written setup guide in four numbered steps, plus notes on which columns calculate themselves and how often to refresh. It also documents the one task the script cannot perform: switching the three dropdown columns to Google’s “Chip” display style through Data → Data validation → Advanced options. That takes roughly ten seconds per column and is what produces the coloured pills you see in the screenshots.
The Explore More Templates Tab
A catalogue page listing recommended Google Sheets, Excel and Power BI templates with their categories and prices, a block of Popular Categories links, and a WELCOME15 coupon good for 15% off a next purchase.
The List Tab
A plain reference sheet holding the dropdown values for Content Type, Format and Status across rows 2 to 500. It is the only place you edit to change what the three dropdown columns offer.
This Tracker vs. a Microsoft Excel Log vs. TubeBuddy / vidIQ — Feature Comparison
| Feature | This Google Sheets Tracker | Microsoft Excel log | TubeBuddy / vidIQ / Social Blade |
|---|---|---|---|
| Cost | $6.99 one-time ✅ | $0 if you build it yourself | $9–$99 / month, per channel |
| Platform | Google Sheets, any browser ✅ | Excel desktop or Microsoft 365 | Browser extension + web app |
| Setup time | Under 10 minutes ✅ | Hours to build the charts and formulas | Minutes, but account linking required |
| Data source | Manual entry from YouTube Studio | Manual entry | Automatic API sync ✅ |
| Real-time team collaboration | Yes, native in Sheets ✅ | Only via OneDrive co-authoring | Paid seats per user |
| Mobile access | Google Sheets app ✅ | Excel mobile, limited charts | Yes |
| Customisable columns and colours | Fully editable ✅ | Fully editable | Fixed vendor layout |
| Tracks ideas, drafts and scheduled videos | Yes — 4 statuses ✅ | Only if you build it | Partly, in the paid tiers |
| Year-1 cost at 5 users | $6.99 total ✅ | $0–$400 in build time | $540–$5,940 |
For creators who want a permanent, shareable record of what they published and how it did, without a monthly bill or an API connection, this tracker sits in the sweet spot. If automatic data pulls are the point, buy vidIQ instead.
Who Should Use This Template
Perfect for:
- Solo creators with 10 to 500 published videos who want one view of what worked
- Two- and three-person channel teams who all need the same numbers
- Freelance channel managers and agencies reporting monthly to clients
- Creators who plan ahead and need Idea, Draft and Scheduled rows next to Published ones
Not a fit if:
- You expect the data to arrive by itself — every figure here is typed in
- You run a network with thousands of videos or need cross-channel roll-ups
- You need retention curves, traffic sources or demographic splits
- You want an Excel workbook; this is a Google Sheets template only
Real-World Use Cases
Dev runs a 40,000-subscriber tutorial channel alone. He logs each upload the week it publishes, then sorts by Performance Rank at month end. Watching his Shorts hold ranks 1 and 3 on views while returning under $0.75 RPM settled a long argument with himself: Shorts for reach, long-form for revenue, and no guilt about either.
Priya handles content at a small SaaS company. Because Status carries Idea, Draft and Scheduled as well as Published, the same sheet is both a production pipeline and a performance report. She shares a view-only link in the Monday stand-up rather than rebuilding slides every week, much as she does with her copywriting and content dashboard.
Marco manages three client channels as a freelancer. One copy of the tracker per client, the currency switched to € on two of them, and the Views by Video chart pasted straight into his monthly invoice email — a routine he runs alongside his billable hours and time tracker.
Advantages of This Tracker
It costs once. $6.99 against $9 to $99 a month for a creator analytics subscription. Over a year with a small team that is a difference of hundreds to thousands of dollars, for a file you keep forever.
The history is yours. YouTube Studio’s default windows roll forward and older comparisons get awkward. A sheet you own keeps every video you ever logged, in the shape you chose, with your own notes attached.
Nothing to authorise. There is no script to approve, no OAuth prompt, no third-party extension reading your channel. For anyone managing a client’s channel, that alone removes a conversation.
It is genuinely editable. Add a column for thumbnail style or hook length and the existing charts keep working, because they read the data columns rather than a fixed helper block. Google Sheets handles the rest.
Opportunities for Improvement
Honest limitations, because they matter more than another feature list. Manual entry is real work — budget a few minutes per video, and expect to fall behind if you publish daily. There is one KPI card, not a suite; TOTAL VIEWS is the only headline tile, so watch-time or revenue totals mean adding your own. The Chip display style is a manual step Google does not yet let a script set, so the pills look plain until you spend thirty seconds on it. And the four charts are fixed in kind — they answer “how much of what, and which videos led” rather than “why did retention drop at 0:45”. For that, you still need YouTube Studio.
Best Practices
- Log on a schedule, not on impulse. One pass a week beats a heroic catch-up every quarter, which is how trackers die.
- Wait before you judge a video. Enter it on publish, then update the numbers at 7 and 28 days so ranks compare like with like.
- Use Notes properly. “Viral short” and “Not monetized” are the entries that explain an outlier a year later, when the figures alone will not.
- Extend the List tab early. If you post formats the eight defaults miss, add them before you have 200 rows of “Other”.
- Keep one copy per channel. Performance Rank is computed within the sheet, so mixing two channels produces a ranking that means nothing.
- Share view-only. Collaborators rarely need edit rights, and a stray sort on a shared tracker is a bad afternoon.
Explore Relevant Templates
- YouTube Channel Analytics Dashboard in Google Sheets — the multi-page analytical edition, for when one log page is no longer enough.
- Content Creator Revenue Dashboard in Google Sheets — for income split across ads, sponsorships and affiliates.
- Podcast Analytics Dashboard in Google Sheets — the audio equivalent, if you publish both.
- Side Hustle Income Tracker in Google Sheets — useful once the channel starts paying.
Also available as the Power BI edition of the YouTube channel analytics template. If you came here for freelance tooling rather than channel tooling, our write-ups of the freelance marketplace gig tracker, the freelance gig and deadline tracker and the side hustle income tracker cover the same ground for client work.
Frequently Asked Questions
Does the YouTube Channel Performance Tracker in Google Sheets connect to YouTube automatically?
No. It is a manual template with no API connection, no add-on and no scheduled import. You copy Views, Watch Time, Likes, Comments, Subs Gained and Est. Revenue across from YouTube Studio, and the calculated columns and all four charts update as soon as you do.
Which columns calculate themselves?
Four of the sixteen: Video ID, Engagement % as (Likes + Comments) / Views, RPM as revenue per 1,000 views, and Performance Rank where the most-viewed video is Rank 1. They stay blank on empty rows rather than showing error values, so a half-filled sheet still looks clean.
How many videos does it hold?
The formulas and charts cover rows 16 to 1000, which is about 985 videos, and the List tab feeding the dropdowns runs to row 500. Both ranges can be extended if you outgrow them, though most channels never will.
How long does setup take?
Under ten minutes. Open the PDF, click the Google Sheets link to make your own copy, paste your videos over the 15 sample rows, and set the three dropdown columns to Chip display style. No scripts to authorise and no permissions to grant.
How does this compare to paying for TubeBuddy or vidIQ?
Those services sync automatically and cost $9 to $99 every month. This tracker is $6.99 once and needs manual entry, but the file is yours, you can add any column you like, and no subscription lapse can lock you out of your own channel history.
Can I change the currency and the colours?
Yes. Est. Revenue and RPM default to $. Select those two columns and switch to ₹, € or £ through Format → Number. The full palette lives in one const block at the top of the script, so re-theming the whole tracker is a single edit.
Is this the same as the YouTube Channel Analytics Dashboard?
No. The Analytics Dashboard is a multi-page analytical template with its own data sheet and several report pages. This is a one-page tracker: a single log of every video with one KPI card and four charts above it. They are separate products with separate files.
About the Author
Built by PK — Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels (@PKAnExcelExpert, @NextGenTemplates, @NeoTechNavigators). Every template is hand-built and tested before release.
Conclusion
The YouTube Channel Performance Tracker in Google Sheets does one job well: it turns a scattered publishing history into 16 columns you can sort, share and keep. Four of those columns fill themselves, four charts redraw as you type, and there is nothing to subscribe to and nothing to authorise. Type the numbers in, and the questions that used to need a spreadsheet rebuild answer themselves.
👉 Click here to Purchase the YouTube Channel Performance Tracker
✅ Instant download · One-time payment · No subscription
🎥 More Google Sheets walkthroughs: Youtube.com/@NeoTechNavigators
Last updated: September 2026
