YouTube Analytics Tracker

Built for YouTube creators, channel managers, and content professionals who want a single place to log every upload, monitor growth, and master their revenue — without juggling five different tools.

This fully interactive tracker gives you six professionally designed tabs with live formulas, auto-updating charts, colour-coded progress bars, and dropdown menus. Enter your numbers in the lightly shaded cells — everything else calculates itself.

What's Inside

• Dashboard — eight live KPI tiles (total views, watch time, subscribers, net subs gained, total revenue, avg RPM, videos tracked, avg engagement) plus four auto-updating charts: Monthly Views, Subscriber Growth, Monthly Revenue, and Revenue by Source pie.
• Video Performance — one row per upload. Type impressions, views, watch time, likes, comments, shares, and revenue. CTR, average view duration, engagement rate, and RPM calculate automatically. Category and Status dropdowns keep things organised.
• Monthly Growth — subscriber and viewership trends month by month. Each month's starting sub count rolls forward from the previous month, with net growth and MoM growth-rate columns.
• Revenue — income split across AdSense, Sponsorships, Affiliate, Merch, Memberships, and Other, with totals that feed straight into the Dashboard.
• Goals — set targets and watch red progress bars fill. Colour-coded status labels (Achieved / On Track / Behind) update automatically. Several goals pull live numbers from the other tabs.
• Start Here — a branded welcome guide with step-by-step instructions and a tab-by-tab overview so you're up and running in minutes.

Key Features

• 194 live formulas — every total, rate, and chart updates automatically
• Colour-scale conditional formatting highlights your best and worst performers
• Dropdown menus for video category and status
• Pre-loaded with realistic sample data so you can see every feature in action — just type over it
• Works in Excel and Google Sheets — no macros, no add-ins

Who It's For

• YouTube creators who want analytics clarity without Studio's clutter
• Channel managers reporting on performance and revenue
• Content professionals tracking multiple uploads and revenue streams
• Anyone who'd rather see their channel story in one clean spreadsheet than across five browser tabs

How It Works

1. Download the file and open it in Excel or Google Sheets.
2. Read the Start Here tab for a quick walkthrough.
3. Log your videos, monthly stats, and revenue in the lightly shaded input cells.
4. Check the Dashboard any time for a live snapshot of your channel.

Instant digital download · Lifetime free updates · No subscriptions

Designed and sold by Spreadsmart.store — smart spreadsheets for creators & small business.