TikTok Organic & TikTok Ads

Get a free Google Sheets template to track your TikTok Organic and TikTok Ads performance.

14 days free-trial
No credit-card required
Access all features
No items found.
TikTok Organic & TikTok Ads
TikTok Organic & TikTok Ads
TikTok Organic & TikTok Ads

TikTok Organic & TikTok Ads

Google Sheets template report for TikTok Organic & TikTok ads

Use a free Google Sheets template to analyze both your TikTok organic content and ads. Monitor views, likes, followers, spend, and conversions in one place.

✳️ Organic performances

✳️ Ads results

✳️ Audience

Metrics used

TikTok Organic

  • User's followers count
  • Video Like Count
  • Video View Count
  • Video Comment Count
  • Video Share Count

TikTok Ads

  • Spend
  • Total Complete Payment Value (Page)
  • Total Complete Payment (Page)
  • Complete Payment ROAS (Page)
  • Impressions
  • Clicks (destination)
  • Conversions

"CPM", "CPC", "Cost per Conversion" are calculated fields.

Dimensions used

TikTok Organic

  • Display name
  • Created time
  • Video description

TikTok Ads

  • Date
  • Advertiser name
  • Advertising Objectives
  • Campaign name
  • Ad name
  • Age
  • Gender

How to use this Google Sheets template

Catchr sends the selected marketing data into the workbook. Google Sheets then controls formulas, formatting, refresh routines, collaboration, and sharing.

Connect one marketing source

Authorize the marketing platform you want to query. One query uses one source, but it can include multiple accounts from that source.

Make a copy in Google Sheets

Open the template from the button above, make your own Google Sheets copy, then follow the instructions tab inside the workbook.

Refresh your report

Use the Catchr add-on to import your data, refresh the workbook, and keep the report ready to share with your team.

Looking for other Google Sheets templates?

Move from connected data to useful reporting faster with spreadsheet templates built around real marketing workflows.

Questions before you copy the template?

Yes. You can copy the template at no cost. Connecting live marketing data requires Catchr, which includes a 14-day free trial with no credit card required.

Is this Google Sheets template free?

MCP stands for Model Context Protocol. It is an open standard that lets AI applications connect to external data sources and tools through a common interface.

What is included in a Google Sheets template?

The spreadsheets includes a reporting structure, formulas, charts, and the tabs needed to organize the metrics and dimensions listed on this page.

How do I connect my marketing data?

Make a copy of the template, open the Catchr add-on, authorize one marketing source, select the accounts to query, and follow the workbook instructions to import the data.

Who controls data refresh?

Catchr sends the selected source data to the workbook. Refresh schedules, formulas, transformations, and how the workbook is used remain under your control in Google Sheets.

Can I customize the spreadsheet?

Yes. You can edit formulas, charts, tabs, formatting, and calculated fields. Keep a clean copy if you want an easy way to return to the original structure.

Can I share the finished report?

Yes. Share the Google Sheets file using its usual viewer, commenter, or editor permissions. Access to the data source and Catchr workspace is managed separately.

Which data sources are available?

Catchr supports more than 100 platforms across advertising, analytics, CRM, ecommerce, email, SEO, and social. Explore the connector directory to confirm a specific source.

Still have a question ? 

Our teams is always here to responds to any question you could have about our data connector. 

Your next report should not start with five exports.

Connect your marketing platforms and build a data workflow your entire agency can use.

14 days free-trial
No credit-card required
100+ sources