TikTok Ads budget tracking and pacing dashboard template for Google Sheets

Track your TikTok Ads budget pacing, compare actual vs. planned spend, and visualize performance across daily, weekly, monthly, quarterly, and yearly views.

By Porter

This template is built by the same marketers behind all our tutorials, support, and our template gallery.

Data sources included

+40,000 marketers have downloaded our dashboards

Questions you can answer using this TikTok Ads dashboard template

  • How is the current ad spend tracking against the budget across different time periods (day, week, month, quarter, year)?
  • What is the current pacing of ad spend in both dollar amounts and percentages?
  • Is the campaign currently underspending or overspending?
  • What is the suggested daily spend to stay on track with the budget?
  • How much of the total budget has been spent so far, and how much remains?
  • How does the daily ad spend compare to the daily budget over time?
  • How does the cumulative ad spend compare to the cumulative budget over the campaign period?
  • What are the start and end dates of the current campaign?
  • What is the current time progress of the campaign (e.g., how far are we into the day, week, month, quarter, and year)?

How to set up this Google Sheets template?

Copy the TikTok Ads budget tracking and pacing dashboard template for Google Sheets in one click and automate your reporting

Follow these steps:


  • Step 1: Make a copy of the template.

  • Step 2: Download the extension and authorize your profile.

  • Step 3: Choose the accounts you want to pull data from.

  • Step 4: Use our prebuilt queries or build one from scratch to automate your data collection. Alternatively, you can input data manually.

  • Step 5: Set up automatic refresh to keep your dashboard updated.


Metrics and dimensions included

Customize the template’s metrics and dimensions as you like. See all available TikTok Ads fields.

Metrics

  • Ad spend

    • Daily spend
    • Cumulative amount spend
    • Pacing ($) / Pacing %

  • Customizable charts

    • Predicted spend
    • Campaign budget
    • Budget remaining

Dimensions

  • Date

    • Time progress: hours, days, weeks, month, quarter, and year.
    • Status: overspending or underspending
    • By day, week, month, quarter, or year.

  • Audience

Features

You can customize your marketing reports directly in Google Sheets with your logo, colors, and branding.
Set up email alerts using conditional notifications when a cell value changes.
Edit all charts and change style values, and then paste them on your Google Slides so they can auto sync.

Utilize functions like SUMIF, VLOOKUP, IF, and ARRAYFORMULA to calculate key metrics like CPA, ROAS, and CTR, automating calculations and combining data fields.

Pull your historical marketing data automatically using our Google Sheets marketing extension.

Filter by date, campaign, channel, and more to get the insights you need.
Set, track, and achieve marketing goals with real-time updates.
Set sync intervals to match your reporting needs, whether daily, weekly, or monthly.
Connect Google Analytics, Facebook Ads, Instagram, LinkedIn, and more to create a unified view of your marketing performance.

FAQs

A TikTok Ads pacing dashboard should include these essentials:

  • Budget overview: Total budget, spend to date, remaining budget
  • Pacing metrics: Daily, weekly, monthly spend vs. targets

. You can also include metrics such as engagement rate, click-through rate (CTR), conversion rate, reach, frequency, video completion rate, follower growth rate, and share of voice. Visualizations of spend vs. budget and performance trends are important for quick insights.

Also ensure the dashboard auto-syncs with your TikTok Ads data for real-time updates and actionable information.

While this template is designed specifically for TikTok Ads, you can use Google Sheets’ multichannel connectors such as LinkedIn Ads, GA4, Shopify to integrate data from other marketing platforms. By combining insights from different sources, you can create a unified view of your overall marketing performance.

To set up email alerts, use the built-in notifications feature in Google Sheets. You can create custom rules to trigger email alerts based on specific conditions, such as when your actual spend exceeds the budget or when pacing percentages hit certain thresholds.

Yes, you can fully customize the charts in the dashboard. You can choose different chart types, adjust colors, fonts, and styles, add data labels, legends, and trendlines, and customize axes and gridlines to match your reporting needs.