blog post

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

Florian Cabirol
April 30, 2024
Connect TikTok Pages to Looker Studio : How-to, templates and metrics...

Quick steps to create a TikTok report with Google Sheets:

You can easiliy create a TikTok report following this step :

  1. Get informations from the data integration from our TikTok 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 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 report with Looker Studio:

You can easiliy create a TikTok report following this step :

  1. Get informations from the data integration from our TikTok 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 at the end of the page.

The tutorial

Quick steps to create a TikTok report with PowerBI:

You can easiliy create a TikTok report following this step :

  1. Get informations from the data integration from our TikTok 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 at the end of the page.

The tutorial

As the digital landscape constantly evolves, marketers need the right tools to monitor, analyze, and draw actionable insights from their marketing data. This tutorial will guide you through the process of connecting your TikTok account with Looker Studio, formally known as Google Data Studio, to streamline your data visualization efforts. In mastering these steps, you'll be able to create custom reports and dashboards that reflect the performance of your TikTok marketing initiatives.

How to Connect Your TikTok Account to Looker Studio

Create an Account on Looker Studio

If Looker Studio is uncharted territory for you, let's start with the basics. Set up your Looker Studio (formally Google Data Studio) account by signing in with your existing Google account — it’s fast and efficient.

Looker Studio sign-in page

Connect TikTok to Looker Studio

Ready to blend TikTok data with Looker Studio's magic? Here's how you can establish a connection with ease:

  • Begin from the Looker Studio dashboard and click on "Create".
Looker Studio dashboard with the Create button
  • Then, choose "Report".
Selecting Report option in Looker Studio
  • Search for the Catchr TikTok data connector in the data sources gallery.
Catchr TikTok data connector search

Step-by-step guide on the authorization step:

If this is your first rendezvous with this connector, here’s what you need to do:

  • Authorize the community connector to access Looker Studio.
Authorization step for Looker Studio
  • Select the Google Account you wish to connect.
Selecting Google Account for Looker Studio
  • Review the necessary permissions, scroll, and provide consent.
Looker Studio permissions for TikTok connector
  • Click "Allow" to grant access.
Allowing permissions
  • For Catchr's end, click the 'Authorize' button for TikTok data access.
Catchr authorization button
  • Follow on-screen instructions to permit Catchr to interface with your TikTok account.
Catchr to TikTok authorization pop-up
  • Post-authorization, select the TikTok account Catchr should access and click on "Add".
Selecting TikTok account to add to Looker Studio
  • If you're struggling to find 'Add', it could be labeled as "Create Report" in the top right.
Alternative location for Add/Create Report button

That's it! Your TikTok data now stands ready to be morphed into insightful visuals in Looker Studio.

Example of Metrics You Can Harness with Looker Studio Integration for TikTok

Looker Studio's integration with TikTok opens a treasure trove of metrics that can transform how you comprehend your TikTok engagement and reach. Explore the full list of metrics to understand the depth of data available at your disposal.

Here are a few powerful examples of metrics and how you can use them:

  • View Count: Track the performance of your content by analyzing the views over time. Use this to understand peak engagement periods and tailor your posting schedule.
  • Like and Comment Counts: Gauge audience sentiment by observing the balance between likes and comments. High engagement is indicative of resonant content.
  • Followers and Like Counts: Measure your brand’s growth trajectory by comparing follower increases to likes across videos, revealing content that drives fandom.
  • Avatar URL metrics: Keep branding consistent by monitoring profile picture updates and ensuring all visuals align with your aesthetic.
  • Share URL: Examine how widely your content is shared to understand its viral reach potential and create shareable, quotable, and memorable moments.
  • Created Time and Duration: Analyze post timing and video duration to deduce the sweet spots for audience retention and potential advertising opportunities.

With these building blocks, the Looker Studio integration for TikTok positions you to harvest data-rich insights, crafting compelling stories out of patterns and guiding informed marketing decisions. Embrace these capabilities to remain agile in a platform that thrives on the pulse of cultural immediacy.

Bonus : Your free Tiktok Profil Report Template

In this TikTok 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 Profil Video InsightTemplate for PowerBI

In this TikTok 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

Import your TikTok profile data to Google Sheets : How-to, metrics and more

Unlock the potential of your TikTok marketing data with our comprehensive guide on integrating it into Google Sheets via Catchr. Designed for marketers seeking to enhance their data analysis, this tutorial simplifies the process of visualizing TikTok analytics for improved decision-making. Learn to connect your account, choose relevant metrics, and create dynamic reports, enabling you to track content performance, analyze engagement, and monitor follower growth with ease. Ideal for those aiming to leverage TikTok insights for strategic marketing advancements.

Florian Cabirol

Explore your TikTok profil data with PowerBI : How-to, metrics and templates

Unlock the power of TikTok marketing analytics with our detailed guide on integrating TikTok data into PowerBI using Catchr. Learn to create dynamic dashboards for insightful marketing strategies.

Florian Cabirol

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

Get all the information about the views, shares, and likes from your TikTok video inside beautiful reporting tools thanks to Looker Studio. A free template is included!

Florian Cabirol

The Most Useful TikTok KPIs to Optimize Your Digital Marketing Strategy

TikTok KPIs are crucial for achieving organic growth and enhanced user engagement. Read our blog to find the best KPIs and watch them transform your online presence on the platform!

Florian Cabirol