How to Connect TikTok to Looker Studio

Getting your TikTok Ads data into Looker Studio (now officially Google Data Studio) can feel surprisingly difficult. You've got valuable performance data on one platform and a powerful reporting tool on the other, but they don't seem to want to talk to each other. This guide will show you exactly how to bridge that gap and get your TikTok metrics into an automated Looker Studio dashboard.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Can’t You Directly Connect TikTok to Looker Studio?

The first thing to understand is that Google does not offer a native, built-in connector for TikTok Ads. While Looker Studio seamlessly connects to Google products like Google Analytics, Google Ads, and Google Sheets, it relies on third-party developers, known as "partner connectors," to pull data from other major platforms like Facebook Ads, LinkedIn Ads, and of course, TikTok.

This means you can't simply open Looker Studio, click "Add Data," and find TikTok in the list of Google Connectors. It’s an extra step, but it’s a standard and secure practice for bringing non-Google data into the ecosystem. The good news is that setting it up is straightforward once you know which tools to use.

Solution 1: Use a Third-Party Connector (Recommended)

The easiest and most reliable way to create a live, automated dashboard is by using a third-party data connector. Think of these tools as a secure bridge that automatically pulls data from the TikTok Ads API and feeds it directly into your Looker Studio report. Once set up, your dashboard will refresh automatically, saving you hours of manual work each week.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Popular TikTok Connectors for Looker Studio

While there are many services available, a few are well-known in the marketing analytics community for their reliability and ease of use:

• Supermetrics: One of the most popular and robust connectors on the market. It's known for its reliability and a wide range of available metrics and dimensions.
• Windsor.ai: Another excellent option that is often praised for its pricing structure and strong customer support.
• Power My Analytics: A solid competitor that offers a suite of connectors for various marketing platforms, making it a good choice if you need to connect more than just TikTok.

Step-by-Step: How to Connect With a Partner Connector

The exact user interface will vary slightly between tools, but the overall process is nearly identical for all of them. Here’s a general walkthrough using a tool like Supermetrics as an example.

Step 1: Get started in Looker Studio

Open a new or existing Looker Studio report. In the top menu, choose "Add data". This will open the data source gallery.

Step 2: Find the TikTok connector

In the search bar at the top of the gallery, type "TikTok Ads." You will see connectors from various partners like Supermetrics and Windsor.ai appear. Select the one you’ve chosen to use.

Step 3: Authorize the Connector and Your TikTok Account

You’ll need to grant authorization in a two-part process:

1. Authorize Looker Studio: First, you will be prompted to authorize the partner connector to be used within your Google account. Click "Authorize."
2. Authorize TikTok Ads: Next, you'll be redirected to a login prompt for the connector service itself. Once logged in, you'll be asked to connect and authorize your TikTok Ads account. Sign in with your TikTok credentials and grant permission for the service to access your advertising data.

This process is secure and only gives the connector read-only access to your performance data. It cannot be used to make changes to your campaigns.

Step 4: Configure Your Data Source

Once you’ve successfully authorized your accounts, you’ll be taken to the configuration screen. This is where you tell the connector which data you want to pull. You'll typically have options such as:

• Ad Accounts: Select the specific TikTok ad account(s) you want to report on.
• Report Type: Choose the level of data you need. Do you want to see performance by campaign, ad group, or individual ad?
• Date Range: Select a default date range (this can always be changed within your Looker Studio report later).
• Optional Settings: Some connectors allow you to set marketing attribution windows or other advanced settings.

Step 5: Add Data to Your Report

After confirming your data source settings, click the "Add" or "Connect" button in the top right corner. You'll see a final confirmation pop-up. Click "Add to Report."

That's it! Your TikTok Ads data source is now connected. You'll be taken back to your report canvas, and you can start building charts and tables using the metrics and dimensions from your TikTok account.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Solution 2: The Manual Method (CSV and Google Sheets)

If you prefer not to pay for a third-party connector or only need to create a one-off report, you can use a manual workaround with Google Sheets.

The biggest drawback to this method is that it is not automated. Your dashboard will not update in real-time. You will have to repeat this process every time you want to refresh your data.

Step 1: Export Data from TikTok Ads Manager

Log into your TikTok Ads Manager. Navigate to the campaign, ad group, or ad level you want to analyze. Select the appropriate columns and date range for your report, and then find the "Export" button to download your data as a CSV file.

Step 2: Upload to Google Sheets

Create a new Google Sheet. Go to File > Import > Upload and select the CSV file you just downloaded from TikTok. Your data will now be in the spreadsheet.

Step 3: Connect Google Sheets to Looker Studio

Go back to your Looker Studio report and click "Add data". This time, select the official Google connector for "Google Sheets." Choose the spreadsheet and specific worksheet you just uploaded your data to, and click "Add to Report." Your static TikTok data is now available to visualize.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

What TikTok Data Can You Visualize?

Once connected, you can pull in all the essential metrics and dimensions you’re used to seeing in the TikTok platform. This allows you to build custom reports that track exactly what matters to your business.

Common Metrics

• Spend & Performance: Cost, Impressions, Clicks, CPM (Cost Per 1,000 Impressions), CPC (Cost Per Click), CTR (Click-Through Rate).
• Conversions: Total Conversions, Conversion Rate, CPA (Cost Per Action/Acquisition).
• Video Metrics: Video Views, Average Watch Time, Video Quartile Views (25%, 50%, 75%, 100%).

Common Dimensions

• Campaign Structure: Campaign Name, Ad Group Name, Ad Name/ID.
• Time: Date, Week, Month.
• Audience: Demographics like Age and Gender (depending on connector capabilities).

Tips for Your TikTok Dashboard

Now that your data is flowing, you can start building. Here are a few quick tips for a powerful dashboard:

• Start with a high-level overview. Use scorecards at the top for your most important KPIs: Total Spend, Impressions, Conversions, and CPA. This gives anyone who views the report an instant performance summary.
• Visualize your funnel. Create a bar chart showing Impressions > Clicks > Conversions. This helps you quickly spot where users might be dropping off in your process.
• Map performance over time. A time-series line chart showing Spend vs. Conversions is invaluable for understanding how performance changes from day to day or week to week.
• Use filters. Add controls for Date Range and Campaign Name. This makes your dashboard interactive and allows your team to drill down into specific campaigns without needing you to create a new report.

Final Thoughts

Connecting TikTok Ads to Looker Studio unlocks powerful, automated reporting that simply isn't possible within the native TikTok platform. While Google doesn't offer a direct connection, third-party connectors provide a simple and reliable way to link your accounts, and the Google Sheets method offers a free, albeit manual, alternative.

Our goal with Graphed was to eliminate this kind of frustrating, connector-hunting process entirely. Instead of struggling with separate connectors for different platforms, we automatically sync your tools like TikTok, Google Analytics, Shopify, and Facebook Ads with one click. Then, you can just describe the report you need in plain English - like "create a dashboard comparing our main TikTok campaigns by spend and conversion rate this month" - and we instantly build the real-time dashboard for you, saving you even more time.