Tiktok Ads to Looker Studio: setup guide

Looker Studio is a powerful free tool to visualize and analyze your marketing performance. If you advertise on TikTok Ads, connecting your account to Looker Studio allows you to monitor campaign performance, ad spend, and conversions, all in one place.

There are two main ways to connect your TikTok Ads data to Looker Studio:

• Automatically, using a partner connector like Catchr.
• Manually, using Google Sheets as an intermediary.

Why connect TikTok Ads to Looker Studio

Connecting your TikTok Ads account to Looker Studio helps you analyze campaign performance, monitor key KPIs, and automate reporting. Instead of switching between the TikTok Ads Manager and spreadsheets, you can visualize all your metrics in one dynamic report.

With Looker Studio, you can:

• Track your spend, impressions, clicks, CTR, conversions, and ROAS.
• Identify your best-performing campaigns, ad groups, and creatives.
• Combine TikTok Ads data with Meta Ads, Google Ads, or GA4 for a complete marketing view.
• Automate your reporting and share live dashboards with your team or clients.

In short, connecting TikTok Ads to Looker Studio gives you a centralized, real-time view of your advertising performance.

Method 1: Connect TikTok Ads to Looker Studio using Catchr (recommended)

For most marketers and agencies, the automated connection is the most efficient and scalable solution. It uses the TikTok Ads API to sync your data directly into Looker Studio.

How it works

Partner connectors like Catchr act as a bridge between TikTok Ads and Looker Studio. Once authorized, Catchr connects to your TikTok Ads account and automatically imports your ad performance data into Looker Studio.

Your metrics and dimensions refresh daily, ensuring your reports always reflect the latest results, no manual updates or exports needed.

Steps

1. Create a new data source on Looker Studio
   • Go to the Looker Studio homepage.
   • Click on Create → Data source.

2. Search for TikTok Ads
   • In the search bar, type TikTok Ads.
   • From the list, select a certified connector such as Catchr.

3. Authorize your Catchr and TikTok Ads accounts in Looker Studio
   • Click Authorize to link your Catchr account with Looker Studio.
   • Then, authorize again to sign in to TikTok Ads and allow access to your accounts.

4. Choose your account(s)
   • Select one or multiple accounts to include in your report.
   • (Optional) Start from a prebuilt Looker Studio template to save time.

5. Click Create report
   • Click Create Report to finish the setup.
   • Your TikTok Ads data, including impressions, clicks, spend, and ROAS, will automatically load into Looker Studio and refresh daily.

Common Use Cases

Connecting TikTok Ads to Looker Studio allows you to track ad performance in real time and automate cross-channel reporting.

• Marketers monitor performance KPIs like CTR, CPA, and ROAS across campaigns.
• Agencies automate client reports and build white-labeled dashboards.
• E-commerce brands combine TikTok Ads with Shopify, GA4, or Meta Ads for full-funnel insights.
• Media buyers analyze creative effectiveness and optimize budgets dynamically.

To help you get started faster, Catchr provides ready-to-use Looker Studio templates for TikTok Ads.

Tiktok Ads performance overview dashboard template

The TikTok Ads performance overview dashboard gives you a complete view of your advertising performance across all campaigns, ad groups, and creatives. Track key KPIs such as impressions, clicks, spend, CTR, conversions, and ROAS, all in one interactive Looker Studio report.

Tiktok Ads Budget dashboard template

The TikTok Ads budget dashboard helps you monitor your ad spend and pacing in real time.Compare daily, weekly, or monthly spend against your budget, track cost per result, and detect overspending early to optimize your ad strategy.

Method 2: Connect TikTok Ads to Looker Studio using Google Sheets

If you prefer a free, manual approach, you can use Google Sheets as an intermediary between TikTok Ads and Looker Studio. This method is simple but requires regular exports or an external automation tool (like Zapier or Make) to refresh data automatically.

How it works

You’ll export your TikTok Ads campaign performance data from TikTok Ads Manager and import it into Google Sheets. Then, you’ll connect that spreadsheet to Looker Studio using the Google Sheets connector.

Steps

1. Export your TikTok Ads data to Google Sheets
   • From your TikTok Ads dashboard, go to Analytics → Custom Reports.
   • Select the data you want to export by creating a new report or choosing an existing one. For a new report, pick the relevant dimensions and metrics.
   • Once your report is ready, click Export to download your data. Choose CSV and click again on Export to confirm.
   • Open the downloaded file and import it into Google Sheets.

2. Create a new data source in Looker Studio
   • Go to the Looker Studio homepage.
   • Click on Create → Data source.

3. Connect the Google Sheets connector
   • In the connector list, search for Google Sheets.
   • Select it and, if prompted, authorize access to your Google account.

4. Choose your TikTok Ads Google Sheets
   • Select the spreadsheet and worksheet containing your TikTok Ads export.
   • Click Connect to link your data to Looker Studio.

5. Create your Tiktok Ads report
   • Click Create Report to start building your dashboard.

Which method should you choose?

If you want dashboards that automatically refresh and always reflect your latest TikTok Ads data, Catchr is the most reliable option, especially for agencies and data-driven marketers. Google Sheets remains a good choice for occasional or one-time reports.

FAQ: TikTok Ads and Looker Studio

Can I connect multiple TikTok Ads accounts?

‍Yes. Catchr supports multiple TikTok Ads accounts in a single Looker Studio report.

‍Are TikTok Ads data updates automatic?

‍Yes, with Catchr your data refreshes daily. Google Sheets, however, requires manual exports or automation tools.

Can I combine TikTok Ads with other platforms?

‍Absolutely. You can blend TikTok Ads data with Meta Ads, Google Ads, or GA4 to get a full-funnel performance view.

What data can I pull from TikTok Ads?

‍You can access metrics such as impressions, clicks, spend, conversions, CTR, CPA, and ROAS. See Catchr’s documentation for the full TikTok Ads field list.

Is the Catchr TikTok Ads connector free?

‍Catchr offers a free trial to connect your TikTok Ads account to Looker Studio. After the trial, a paid plan is required to keep your data automatically synchronized and access advanced reporting features.

Make TikTok Ads work with Looker Studio

Connecting TikTok Ads to Looker Studio helps you visualize campaign performance, monitor KPIs, and make smarter, data-driven marketing decisions. Whether you use the manual Google Sheets method or automate everything with Catchr, you’ll turn your TikTok Ads data into actionable insights that fuel growth.