The Short-Form Video Performance Tracker in Google Sheets logs every Reel, TikTok and Short in one 16-column table and turns it into a Total Views card plus 4 live charts. It ships with 15 fictional sample videos across 6 platforms, 10 content pillars and 4 publishing statuses, adding up to 783.3K total views, so every chart is already working before you type a single number of your own.
🎯 Engagement Rate and a Viral / Strong / Average / Low Reach performance label are calculated for you. Your only job is copying the numbers each platform already shows you in its own analytics screen.
✅ Instant download · One-time payment · No subscription · No per-user fees · Lifetime access
🔑 Key Features of the Short-Form Video Performance Tracker
📊 Total Views card – A large headline card adds up the Views column for every video in the log. With the sample data it reads 783.3K, and it changes the moment you update a view count on any row.
🥧 Video Count by Platform – Shows how your output splits across Instagram Reels, TikTok, YouTube Shorts, Facebook Reels, LinkedIn Video and Pinterest Idea Pin, so you can see at a glance where most of your posting effort goes.
🍩 Video Count by Status – Counts Published, Scheduled, Draft and Archived videos. Your upcoming pipeline and your back catalogue sit in the same view instead of in separate notes.
📈 Views by Video – Ranks each video by views. In the sample, “3 Editing Hacks in 15s” leads with 184,200 views, followed by “Trend: Transition Challenge” at 132,400.
💬 Engagement Mix by Video – Plots Likes, Comments and Shares for each video side by side, which makes it easy to spot a clip that collected views but very little conversation.
🧮 Automatic Engagement Rate – Calculated as (Likes + Comments + Shares + Saves) ÷ Views. A video with no views yet shows a dash instead of an error, so scheduled and draft posts sit neatly in the table.
🏷️ Performance label – The Performance column flags every published video as Viral, Strong, Average or Low Reach, telling you which formats and hooks deserve a follow-up.
🔽 Dropdowns that expand – Platform, Content Pillar and Status pull their options from a List tab (rows 2-500). Add a new platform or pillar there and it appears in the dropdowns with no re-setup.
⚡ Charts that grow with your log – All 4 charts read the data columns directly (rows 16-1000) with the built-in Aggregate option. There are no hidden helper tables to maintain.
📦 What’s Inside the Short-Form Video Performance Tracker in Google Sheets
Page 1: Tracker – Total Views Card, 4 Charts and Video Log
The main tab places the Total Views card and the charts Video Count by Platform, Video Count by Status, Views by Video and Engagement Mix by Video above a 16-column log: Video ID, Video Title, Platform, Content Pillar, Publish Date, Views, Avg View Duration (s), Likes, Comments, Shares, Saves, New Follows, Engagement Rate, Performance, Status and Notes.
Page 2: How to Use
Plain-language instructions covering which columns you fill in, which ones are formulas, how the List-driven dropdowns work, how to switch the dropdowns to Google’s chip display style, and how the charts pick up new rows.
Page 3: Explore More Templates
A list of related NextGenTemplates marketing templates plus the WELCOME15 coupon code for 15% off your next purchase. A separate List tab holds the Platform, Content Pillar and Status options behind the dropdowns.
📊 Google Sheets Video Tracker vs. Excel Workbook vs. Paid Social Analytics Tools — Where It Fits
| Feature | Short-Form Video Performance Tracker in Google Sheets | Microsoft Excel video tracker | Paid social analytics suite (e.g. Sprout Social, Hootsuite, Later) |
|---|---|---|---|
| Cost | ✅ $6.99 one-time | Excel licence plus the time to build it | Recurring monthly subscription |
| Platform | ✅ Any browser with a free Google account | Excel desktop or Microsoft 365 | Vendor web app |
| Setup time | ✅ Make a copy and replace 15 sample rows | Build columns, formulas and charts yourself | Connect accounts and configure reports |
| Data entry | Manual – you type views and engagement | Manual | ✅ Automatic import from connected accounts |
| Real-time team collaboration | ✅ Built-in sharing and live co-editing | Co-authoring through OneDrive or SharePoint | Extra seats usually cost more |
| Mobile access | ✅ Google Sheets mobile app | Excel mobile app | Vendor mobile app |
| Customizable fields | ✅ Edit columns, platforms and pillars freely | Fully editable | Limited to the vendor’s metrics |
| Share with link | ✅ Yes, with view or edit rights | Via OneDrive link | Report exports, plan-dependent |
| Year-1 cost at 5 users | ✅ $6.99 once | 5 Excel licences | 12 months of subscription, often per seat |
| Engagement Rate and performance label | ✅ Built in | Build it yourself | ✅ Built in, vendor-defined |
For creators and small teams who want to see which Reels, TikToks and Shorts earn views and engagement without paying for a monthly analytics subscription, this Google Sheets tracker sits in the sweet spot.
👥 Who This Template Is For — and Who It’s Not For
✅ This template is built for:
- Solo creators posting Reels, TikToks and Shorts who want one log across every platform
- Social media managers at small businesses who report monthly on short-form output
- Freelancers and small agencies tracking a client’s short-form videos in a shared sheet
- Brands testing content pillars such as tutorials, trends and UGC testimonials to see what earns engagement
❌ This template is NOT for:
- Teams that need numbers imported automatically – there is no TikTok, Instagram, YouTube, Facebook, LinkedIn or Pinterest API connection, so every figure is typed in
- Agencies that need post scheduling, auto-publishing, sentiment analysis or audience demographics
- Anyone tracking ad spend or creator revenue – those columns are not included
⚙️ How to Use the Video Tracker
- Open the PDF in your download and click its link to make your own editable copy in Google Drive.
- Replace the 15 sample rows with your videos: Video Title, Platform, Content Pillar, Publish Date, Views, Avg View Duration, Likes, Comments, Shares, Saves and New Follows.
- Leave Video ID, Engagement Rate and Performance alone – they are formulas.
- Refresh Views and engagement every few days; short-form videos keep earning views for weeks.
- Add new platforms or content pillars on the List tab and they appear in the dropdowns.
- Optional: switch the dropdowns to chip style under Data → Data validation → Advanced options (see Google’s data validation help).
💼 Real-World Use Cases
Maya is a fitness coach who posts to Instagram Reels and TikTok. She logs every clip on publish day and updates the numbers each weekend. Views by Video and the Performance column show her which workout demos are worth turning into a series, and the Notes column records which trending audio she used.
Daniel manages social media for a local bakery. He tags each video with a content pillar – Product Demo, UGC / Testimonial or Promo / Offer – and compares Engagement Rate across them before planning next month, without paying for an analytics seat.
A two-person video studio shares the sheet with a client. The Status column shows what is Scheduled or still in Draft, Video Count by Platform shows where the effort went, and the client sees the Total Views card update after every refresh.
❓ Frequently Asked Questions
Does the Short-Form Video Performance Tracker connect to TikTok, Instagram or YouTube?
No. The tracker has no API connection or auto-import. You copy views, likes, comments, shares, saves and new follows from each platform’s own analytics screen. Engagement Rate, Performance, the Total Views card and all 4 charts then update automatically from what you type.
How is Engagement Rate calculated in this Google Sheets tracker?
Engagement Rate is (Likes + Comments + Shares + Saves) divided by Views, calculated per video. When a video has no views yet – for example a Scheduled or Draft post – the column shows a dash instead of a divide-by-zero error, so the table stays clean.
Which platforms does the tracker cover?
The Platform dropdown ships with Instagram Reels, TikTok, YouTube Shorts, Facebook Reels, LinkedIn Video and Pinterest Idea Pin. Because the options live on the List tab, you can add another short-form platform in one cell and it appears in the dropdown straight away.
How long does setup take?
There is nothing to install. Make a copy from the link in the PDF, delete or overwrite the 15 fictional sample rows, and start typing your own videos. The formulas and charts are already in place, so most of your time goes into entering your real numbers.
How does it compare to Sprout Social, Hootsuite or Later?
Those paid suites import data automatically and add scheduling, but they charge a recurring subscription. This template costs $6.99 once and runs in Google Sheets. It suits creators and small teams who are happy to enter numbers by hand in exchange for a simple, fully editable log.
Is the sample data real, and is this affiliated with the platforms?
The 15 sample videos and all their figures are fictional and meant to be replaced. Instagram, TikTok, YouTube, Facebook, LinkedIn and Pinterest are trademarks of their respective owners; NextGenTemplates is not affiliated with or endorsed by any of them.
👤 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.
🔗 Explore Related Templates
🎬 YouTube Video Ideas & Upload Tracker in Google Sheets – plan video ideas and track them through to upload, a natural partner for logging results here.
📺 YouTube Channel Performance Tracker in Google Sheets – follow long-form channel performance alongside your Shorts.
🎙️ Podcast Episode Planning Tracker in Google Sheets – plan and track podcast episodes if audio is part of your content mix.
🤝 Social Media Influencer Tracking Dashboard in Google Sheets – step up to a full dashboard for influencer partnerships.
📣 Influencer Marketing Campaign Performance Dashboard in Google Sheets – measure paid influencer campaigns.
🗂️ Browse every Google Sheets tracker template or the full Google Sheets sales and marketing collection.
📖 Click here to read the Detailed Blog Post
🎥 Visit our YouTube channel for step-by-step video tutorials
👉 YouTube.com/@NextGenTemplates
Watch the step-by-step video Demo:
📅 Last updated: September 2026
