blog post

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

Florian Cabirol
November 28, 2023
Explore your TikTok profil data with PowerBI : How-to, metrics and templates

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

Welcome to this comprehensive tutorial designed to guide you through the process of connecting your TikTok marketing data to PowerBI by leveraging Catchr. By the end of this tutorial, you will have the know-how to visualize your TikTok analytics within PowerBI, creating powerful dashboards and reports to inform your marketing strategies.

How to Connect Your TikTok Account to PowerBI

Add a Source on Catchr

Navigating the Catchr interface is simple. Start on the homepage and look for the "Source" option on the left-hand menu. There, you will find the button "Add a Source" on the top right corner. Click on this to initiate the connection process. Select TikTok as your platform of choice and authenticate to bridge your TikTok account with Catchr.

Adding a source on Catchr

Create the Request to Transfer TikTok Data to PowerBI

Follow these clear steps to facilitate the seamless transfer of TikTok data into your PowerBI environment:

  • In Catchr, locate and click on "API" from the left menu.
Catchr API Section
  • Change the export setting to "PowerBI".
Selecting export format to PowerBI
  • Select "TikTok" in the "Source" tab as your data source.
Selecting TikTok as source
  • Choose the TikTok accounts and the necessary performance indicators.
Selecting TikTok accounts and KPIs
  • Handpick the metrics and dimensions for your data request.
Selecting metrics and dimensions
Selection of metrics and dimensions
  • Warning: If using a Catchr template, ensure that all the mandatory metrics and dimensions are selected as the template requires, which will then auto-fill with your data.
  • Define the timeframe for your TikTok data extraction. Options include both custom and preset time periods.
Selecting the time period for data extraction
  • Employ filters if needed to refine your data request.
Adding filters to the request
  • There are bespoke options for the TikTok platform that can be applied to your request.
Platform-specific options for TikTok
  • After setting up, a unique URL will generate. Review your data by clicking "Preview".
Previewing data
Data preview window
  • If the preview meets your expectations, copy the provided URL for subsequent use in PowerBI.
Copying the data request URL

Import TikTok Data and KPI to PowerBI

With PowerBI Desktop, you can source data from a plethora of origins. In our case, we use a web data source to import the TikTok data:

  • Initiate by selecting "Get Data" and then choosing "Web".
Getting data from web in PowerBI
  • Keep to the basic mode and paste in the URL collected from Catchr.
Pasting the request URL
  • Finalize by clicking “OK”.

It may take a moment for PowerBI to process and import your data. Once done, you're free to modify your query and start sculpting your dashboard to share splendid insights with your team or clients.

To extend the functionality to the PowerBI Web App, publish your dataset from the desktop version first, then pursue visualization construction within the web interface.

Congratulations! You've successfully imported your TikTok performance data into PowerBI and are well on your way to unlocking actionable insights and driving data-driven decision-making within your marketing efforts.

Example of Metrics You Can Use with the PowerBI Integration for TikTok

PowerBI can empower you to interpret TikTok data through various metrics available via Catchr's integration. Using such metrics allows deep dives into user engagement, content performance, and audience demographics. Transform numerical data into engaging and illustrative reports to present insights in a format that's easily digestible by stakeholders.

Here are examples of metrics you can analyze:

  • Followers Growth: Track the change in a user's follower count over time to gauge content influence and popularity.
  • Engagement Rate: Combining likes, shares, and comments to assess the effectiveness of content and strategies.
  • Traffic Peaks: Identify the best times for posting by evaluating metrics like "Hour of the day."

By integrating TikTok analytics within PowerBI, you can create custom dashboards that focus specifically on your marketing targets. Custom visuals and data transformations within PowerBI can take your reporting to the next level, allowing for rich context and benchmarking that elevates the decision-making process.

For the complete listing of TikTok fields and metrics available, visit Catchr's TikTok metrics page.

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