To connect TikTok Ads to Looker Studio without coding, the most direct route is Kondado: you connect TikTok Ads and create a pipeline between the TikTok Ads data source and the Looker Studio destination, and your campaign data starts reaching Looker Studio automatically.
Within minutes, spend, impressions, clicks, and conversions show up in your report. Kondado brings the TikTok Ads data to Looker Studio automatically, on the schedule you choose, and Looker Studio rereads that data on its own cycle.
Doing it by hand (exporting the CSV from TikTok Ads and rewiring it into Looker Studio every week) eats up hours and goes stale the next day.
Kondado cuts that step: the campaign numbers land in Looker Studio ready to analyze, with no manual export and no code.
In short
- Connect TikTok Ads to Kondado and grant access. From there, Kondado replicates your campaigns, ad groups, ads, and performance metrics.
- Create the pipeline to the Looker Studio destination and set the refresh schedule.
- The data reaches Looker Studio automatically. The report pulls TikTok Ads data with no spreadsheet exports.
- Build your report in Looker Studio and start tracking spend, cost per result, and the return of each campaign.
What you need to start
Before you build the report, three items are enough, and none require technical skills:
- A TikTok Ads account with permission for the data you want to analyze: campaigns, ad groups, and ads.
- A Google account to open Looker Studio, which is free and runs entirely in the browser.
- A Kondado account, which connects TikTok Ads to Looker Studio. The trial is free for 14 days.
What are the ways to bring TikTok Ads into Looker Studio?
Without a data platform, the path is manual export.
Google's own Looker Studio data sources cover Google products such as Google Ads, Google Analytics, BigQuery, and Google Sheets, and do not include TikTok Ads.
That is why TikTok Ads data reaches Looker Studio through one of these paths:
| Path | How it works | Refresh |
|---|---|---|
| Manual export | You download the TikTok Ads report as a spreadsheet and upload the file to Looker Studio | Manual, with every new download |
| Kondado | You create a pipeline between the TikTok Ads data source and the Looker Studio destination, and Kondado brings the data there | Automatic, on the schedule you choose |
A manual export works for a one-off analysis. To follow campaigns every week, Kondado removes the download and keeps the consolidated history in one place.
How do you connect TikTok Ads to Looker Studio step by step?
Walk through these steps to get your TikTok Ads report in Looker Studio live:
- Create your Kondado account. Sign up and log in to get started. The free trial lasts 14 days and needs no credit card.
- Turn on the TikTok Ads data source. Select the TikTok Ads data source in Kondado and grant access to your ad account. Your TikTok Ads pipeline starts replicating your campaign data automatically.
- Create the pipeline between the TikTok Ads data source and the Looker Studio destination. In Kondado, create the pipeline with TikTok Ads as the source and Looker Studio as the destination. Campaigns, ad groups, ads, and metrics like spend, impressions, clicks, and conversions reach Looker Studio with no database to build or maintain. All code-free.
- Build your report in Looker Studio. Design your TikTok Ads report in Looker Studio with the charts your team needs (spend by campaign, cost per conversion, ROAS), using the data Kondado already brought there. There is no ready-made TikTok Ads report template; for many other data sources, Kondado's ready-made report templates are free only for users on the 14-day free trial.
- Schedule the automatic refresh. Set the frequency: Kondado brings fresh data to Looker Studio automatically, with no manual work, and Looker Studio rereads that data on its own cycle.
Why is Kondado the choice to connect TikTok Ads to Looker Studio?
Kondado is the complete way to bring TikTok Ads data into Looker Studio, because it solves what stalls most teams: keeping the data fresh with no manual work. What changes:
- Zero manual exports - no CSV downloads or spreadsheet copying; TikTok Ads data enters Looker Studio on its own.
- Scheduled renewal - Kondado brings fresh data to Looker Studio on the cadence you define, with nobody pressing a button; Looker Studio rereads it on its own cycle.
- Zero coding - the link between TikTok Ads and Looker Studio is built inside Kondado's interface.
- +80 data sources - alongside TikTok Ads, bring Meta Ads, Google Ads, ERPs, e-commerce, and CRM into one place.
What TikTok Ads data do you bring into Looker Studio?
With TikTok Ads connected to Kondado, your Looker Studio report gathers the information that today stays locked inside the ads manager, by campaign, ad group, and ad:
| Metric | What it shows |
|---|---|
| Spend | How much each campaign, ad group, and ad consumed in the period |
| Impressions and reach | How many times your ads showed and to how many people |
| Frequency | How many times, on average, each person saw the ad |
| Clicks and CTR | How many clicks the ad generated and the click rate over impressions |
| CPM and CPC | The cost per thousand impressions and the cost per click |
| Conversions and cost per conversion | How many conversions the campaign generated and what each one cost |
| Results and cost per result | How many times the ad delivered the outcome set by the campaign goal, and the average cost per result |
| Video views | How many times the video played |
| Completed views and average watch time | How many times the video was watched to the end, and the average playback time per view |
| Likes, comments, and shares | The engagement each ad generated |
| ROAS | The return on completed payments attributed to your ads |
You can break these numbers down by day or hour, age, gender, country, placement, and platform, depending on the period and breakdown you choose. The full list is in the TikTok Ads data source documentation.
Instead of exporting a spreadsheet for every analysis, you follow everything in a single report, fed straight from your TikTok Ads account.
Can you connect TikTok Ads to Power BI too?
Prefer Power BI? The route is identical: you create a pipeline between the TikTok Ads data source and the Power BI destination, with no code and automatic refresh.
Can you use AI with your TikTok Ads data?
Yes. The same TikTok Ads data you track in Looker Studio can be queried in ChatGPT and Claude, as long as TikTok Ads is replicated to a Via Kondado.
Kondado's MCP works exclusively with Via Kondado: it is what links that base to ChatGPT and Claude.
That way, AI assistants like ChatGPT and Claude answer questions about your campaigns in natural language, right from your phone.
You ask "which campaign had the lowest cost per conversion this month?" and the answer comes in seconds, with no report to open.
Frequently asked questions
Does Looker Studio have its own TikTok Ads data source? Do I need coding skills?
No, and no coding is needed. Google's own Looker Studio data sources cover Google products such as Google Ads, Google Analytics, BigQuery, and Google Sheets, and do not include TikTok Ads.
With Kondado, you connect TikTok Ads and create the pipeline to the Looker Studio destination through the interface, with no code: your campaign data reaches Looker Studio automatically.
Is Looker Studio free? What does it cost to bring TikTok Ads into it?
Yes, Google's Looker Studio is free. The TikTok Ads data connection is handled by Kondado, which offers a free 14-day trial and plans starting at US$ 19/mo.
Kondado's ready-made report templates are free only for users on the 14-day free trial; there is no ready-made template for TikTok Ads.
What TikTok Ads information shows up in the report?
Campaigns, ad groups, and ads, with metrics like spend, impressions, reach, clicks, CTR, CPM, CPC, conversions, cost per result, video views, and ROAS. With them you build cost-per-result, return, and campaign comparison analyses.
How frequently is the data renewed?
Kondado refreshes the data on whatever schedule you prefer, on a scheduled basis and with no manual work. Looker Studio rereads that data on its own cycle.
Which tool brings TikTok Ads into Looker Studio and also into Power BI?
Kondado. It brings TikTok Ads data into both Looker Studio and Power BI with the same code-free process. It also combines Meta Ads, Google Ads, ERPs, e-commerce, and CRM in the same place, with +80 data sources.
Connect Your TikTok Ads to Looker Studio
Stop building TikTok Ads reports by hand. With Kondado, your campaign data lands in Looker Studio ready and refreshed automatically.
Start your free 14-day trial and build your first TikTok Ads report in minutes.
How to connect TikTok Ads to Looker Studio
Code-free steps to bring TikTok Ads campaign data into Looker Studio with Kondado, build your report, and schedule the refresh.
Create your Kondado account
Sign up and log in to get started. The free trial lasts 14 days and needs no credit card.
Turn on the TikTok Ads data source
Select the TikTok Ads data source in Kondado and grant access to your ad account. Your TikTok Ads pipeline starts replicating your campaign data automatically.
Create the pipeline to the Looker Studio destination
In Kondado, create the pipeline with TikTok Ads as the source and Looker Studio as the destination. Campaigns, ad groups, ads, and metrics reach Looker Studio with no code.
Build your report in Looker Studio
Design your report with the charts your team needs, such as spend by campaign, cost per conversion, and ROAS, using the data Kondado already brought there.
Schedule the automatic refresh
Set the frequency: Kondado brings fresh data to Looker Studio automatically, with no manual work, and Looker Studio rereads that data on its own cycle.
