TikTok Ads
Free — Excel + AI Prompts

TikTok Ads Report Template

Weekly and monthly TikTok Ads reporting in Excel and Google Sheets. Track video performance, creative fatigue and CPA with auto-charts, WoW and MoM comparisons, plus 6 AI prompts to analyse creatives and write client reports.

Get the Free Template →

Free download  •  Excel + Google Sheets  •  AI Prompts included

What You Get

Everything You Need in a TikTok Ads Report Template

Stop building reports from scratch. Open the file, enter your data, done.

📅

Weekly Report Tab

Track 4 weeks of TikTok Ads data with automatic week-over-week percentage change calculations and bar charts.

  • 4-week performance table
  • WoW % change (auto-calculated)
  • Best week column
  • Auto-updating bar charts
📊

Monthly Report Tab

12-month performance tracking with month-over-month comparison and trend line charts. Perfect for annual reviews.

  • Full-year performance table
  • MoM % change (auto-calculated)
  • Annual totals column
  • Auto-updating line charts
🤖

AI Prompts Tab

6 ready-to-use prompts for ChatGPT and Claude. Copy your data from the report tabs, paste into AI, get a written analysis instantly.

  • Weekly TikTok Ads summary
  • Monthly campaign analysis
  • Creative performance review
  • Client TikTok Ads report
  • Video hook analysis & variations
  • Scaling strategy prompt
How It Works

From Data Export to TikTok Ads Report in Minutes

Three steps. No design skills needed.

1 📥 Download & Open Open in Excel or upload to Google Drive. Works in both. No plugins needed.
2 📝 Enter Your Data Paste your TikTok Ads numbers into the yellow cells. WoW/MoM and charts update automatically.
3 🤖 Use AI Prompts Copy a prompt from the AI tab, add your data, paste into ChatGPT or Claude. Get a written report in seconds.
Get the Free Template →

Free download  •  Excel + Google Sheets  •  AI Prompts included

Metrics

Every TikTok Ads Metric That Matters

Pre-built rows for all key metrics. Just enter your numbers.

Impressions Reach Views View Rate Link Clicks Link CTR CPM CPC Conversions Cost per Conversion Cost Revenue ROAS

TikTok Ads move fast — your reporting should too.

Track video views, creative fatigue and CPA weekly.

Get the Free TikTok Ads Report Template →

Works with ChatGPT and Claude

Want a hands-on TikTok Ads creative review?

Book a 90-minute coaching session and we'll review your creatives, hook strategy and scaling plan together.

Book a Coaching Session
Keep Learning

Related TikTok Ads Resources

More tools to get better results from your TikTok Ads campaigns.

FAQ

TikTok Ads Report Template, FAQ

Common questions about the template.

Does this work in Google Sheets?

Yes. Upload the Excel file to Google Drive and open it with Google Sheets. All formulas, charts and formatting carry over. You can then share it as a Google Sheets link with clients or teammates.

What's in the AI Prompts tab?

Six structured prompts: weekly TikTok Ads summary, monthly campaign analysis, creative fatigue diagnosis, video hook analysis, scaling strategy, and client report narrative. Each prompt has placeholder fields — add your numbers, paste into ChatGPT or Claude, and receive a written analysis in under 30 seconds.

Do I need Excel skills to use this?

No. All formulas are already built in. You only enter numbers in the yellow input cells. Everything else — WoW percentages, MoM changes, charts — updates automatically. If you can type a number into a cell, you can use this template.

How do I spot creative fatigue in this template?

Watch View Rate week-over-week. If View Rate drops while spend stays flat or increases, creative fatigue is the likely cause. The AI Prompts tab includes a "Creative Performance Review" prompt to diagnose which ads are fatiguing and what to replace them with.

How do I get the template?

Submit the form and you'll receive the free Excel template by email within a few minutes. No payment required. Check your inbox and spam folder if it doesn't arrive promptly.