blog post

Connect TikTok Ads to Looker Studio : How-to, templates and metrics...

Florian Cabirol
November 21, 2023
Connect TikTok Ads to Looker Studio : How-to, templates and metrics...

Quick steps to create a TikTok Ads report with Google Sheets:

You can easiliy create a TikTok Ads report following this step :

  1. Get informations from the data integration from our TikTok Ads connector.
  2. Create a source on catchr.io.
  3. Download our Google Sheets extensions.
  4. Configure and run your request
If you need more informations, you can follow the tutorial.

How to install Google Sheets Catchr Add-on.

To start exporting your TikTok Ads data to Google Sheets, you need to install the Catchr add-on. You currently have two options :

Option A: Via the marketplace:

  1. Visit the Catchr Add-on page on the Google Workspace Marketplace and click "Install."
  2. Grant the necessary permissions for the add-on.
  3. Upon successful installation, open a Google Sheets to proceed.
Connect Google Sheet to Facebook Ads
Install Catchr Google Sheets Add-on

Option B: Directly within a Google Sheets:

  1. Open a new Google Sheets.
  2. In the top menu, click "Extensions", then hover over "Add-ons" and select "Get add-ons."
  3. Search for "Catchr" and choose "Catchr - data connector."
  4. Click "Install" and grant the required permissions.
  5. Close the installation pop-up when completed.
  6. Start using the Catchr add-on.
Install Catchr Add-on for Google Sheets
Install Catchr Add-on for Google Sheets

Once you have installed the add-on, you can start making requests.

The tutorial

Quick steps to create a TikTok Ads report with Looker Studio:

You can easiliy create a TikTok Ads report following this step :

  1. Get informations from the data integration from our TikTok Ads connector.
  2. Create a datasource and new report on Looker Studio.
  3. Choose your metrics and dimensions.
  4. Use charts with your metrics and dimensions.
If you need more informations, you can follow the tutorial. You can also find a template for TikTok Ads at the end of the page.

The tutorial

Quick steps to create a TikTok Ads report with PowerBI:

You can easiliy create a TikTok Ads report following this step :

  1. Get informations from the data integration from our TikTok Ads connector.
  2. Create a source on catchr.io.
  3. Configure your request on the PowerBI request manager.
  4. Copy the given URL in PowerBI
If you need more informations, you can follow the tutorial. You can also find a template for TikTok Ads at the end of the page.

The tutorial

Welcome to an essential tutorial designed for marketing professionals who seek to harness the analytical power of Looker Studio—formerly Google Data Studio—by incorporating their TikTok Ads data. By the completion of this guide, you will be empowered to create dynamic reports and dashboards that effectively visualize your TikTok Ads marketing metrics, leading to more informed decision-making and strategy optimization.

How to Connect Your TikTok Ads Account to Looker Studio

Create an Account on Looker Studio

For the uninitiated, the first step is to establish your Looker Studio presence. If you're already a Google user, you'll find the process smooth sailing. Simply log in using your existing Google credentials to link it to Looker Studio.

Looker Studio Sign-up Page

Connect TikTok Ads to Looker Studio

Engage Looker Studio with your TikTok Ads account by following these detailed instructions. Remember, clarity is key for a successful setup. Shall we begin?

  • Navigate to the Looker Studio dashboard and select "Create".
Looker Studio Dashboard
  • Choose the "Report" option to proceed.
Create Report Option
  • From the data sources gallery, track down the Catchr TikTok Ads data connector.
Data Sources Gallery

Step-by-Step Guide on the Authorization Step

If you're new to this, you'll need to authorize the connection to your TikTok Ads data. Let's wade through this authorization together:

  • Start by providing Looker Studio with authorization to employ this community connector.
Authorize Looker Studio
  • Pick the Google Account intended for connection.
Google Account Selection
  • Review the access permissions needed by Looker Studio and proceed by scrolling to the bottom.
Permission Details
  • Grant the permission by clicking "Allow".
Allow Access Confirmation

With your Google Account set, it's time to enable TikTok Ads data in Looker Studio by Catchr.

  • Click on the other 'Authorize' option that pertains to TikTok Ads and follows Catchr's instructions.
Authorize TikTok Ads Connector
  • A dialog will provide the necessary directions for authorizing Catchr to interface with your TikTok Ads account. Once you've completed the steps, a confirmation popup will appear.
Catchr Authorization Popup
  • After a brief wait, you'll be redirected to a page where you need to scroll down.
Post-Authorization Page
  • Select which account you'd like Catchr to access and click on "Add". If the button isn't visible, it might also appear as "Create Report" or "Report" in different corners of the interface.
Select TikTok Ads Account

With these steps concluded, your TikTok Ads data will flow into Looker Studio, where it awaits your analytical expertise and storytelling skills to bring your marketing narratives to life.

Example of Metrics You Can Use with the Looker Studio Integration for TikTok Ads

With Catchr's Looker Studio integration for TikTok Ads, marketing professionals can explore a treasure trove of data to craft compelling stories. Let's unravel the diverse metrics available to you and how they could be leveraged for insightful visualizations and data-driven decisions.

Harnessing metrics such as Advertiser ID, Spend, Impressions, Clicks, and Conversion Rate, you can construct a comprehensive overview of your campaign's performance. You can delve deeper with metrics like Video Views, Reach, and Engaged Views to gauge content engagement and refine your media strategy.

Advanced analytics could include Spend trends over time, or mapping Click-through Rates against different creative iterations to identify your most compelling content. With Looker Studio's robust features, like blending data sources, you could even correlate campaign metrics with other marketing data or CRM outcomes, bringing you closer to a 360-degree customer view.

For a detailed understanding of all the available fields, ensure to visit the Catchr TikTok Ads fields listing at https://www.catchr.io/metrics/tik-tok-metrics.

Take advantage of Looker Studio's custom reporting capabilities: visualize conversion funnels, map user journeys, build cohort analyses, and track lifetime value (LTV) with ease. Turn data points into strategic insights that reveal trends, inform content creation, optimize budgets, and ultimately drive your bottom-line forward.

Unite these metrics with your unique marketing savvy in Looker Studio, and transform the abstract numbers into actionable wisdom. Happy analyzing!

Bonus : Your free Template Tiktok Ads Overview Ecommerce Template

In this TikTok Ads template, you will find all the metrics and dimensions you would need to get a better view of your data.

If you need more templates, you could look at our looker studio template gallery.

Bonus : Your free Tiktok Ads - OverviewTemplate for PowerBI

In this TikTok Ads template, you will find all the metrics and dimensions you would need to get a better view of your data thank to our integrations.

If you need more templates, you could look at our PowerBI template gallery.

Unlock Insights with Style!

Transform your marketing data into stunning dashboards.

Integrate, visualize, and impress with Catchr's seamless dashboards. Elevate your data game now!
Build your first report
14 days free-trial - No credit card required 🎉

More blog post about TikTok Ads

Import your TikTok Ads KPI to Google Sheets : How-to, metrics and more...

Learn to connect TikTok Ads to Google Sheets via Catchr for simplified data analysis and reporting, empowering marketers with automated import processes and enhanced decision-making capabilities.

Florian Cabirol

Explore your TikTok Ads KPI with PowerBI : How-to, metrics and templates

Master TikTok Ads data analysis with PowerBI through our step-by-step guide. Learn to connect, import, and visualize key metrics for strategic insights and enhanced campaign performance.

Florian Cabirol

Connect TikTok Ads to Looker Studio : How-to, templates and metrics...

Extract all the data you need from your TikTok Ads to get better insights and value, thanks to Looker Studio. Free templates are included.

Florian Cabirol

Must-Know TikTok Ads KPIs to Upgrade Your Digital Marketing Strategy

TikTok Ads KPIs are essential for promoting your brand and achieving a high return on investments. Here are the top KPIs you should be tracking in 2023 to make your marketing campaign a success!

Florian Cabirol