blog post

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

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

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

This tutorial is designed for marketing professionals who want to enhance their data analysis capabilities by connecting their TikTok Ads data to PowerBI. Our goal is to facilitate seamless integration so you can transform your marketing data into actionable insights. By the end of this tutorial, you will have successfully linked your TikTok Ads account to PowerBI, enabling you to create dynamic reports and dashboards for in-depth performance analysis.

How to Connect Your TikTok Ads Account to PowerBI

Add a Source on Catchr

Begin by visiting the Catchr homepage. From there, navigate to the Source option in the left menu, and select Add a Source located at the top right.

Choose TikTok Ads as the platform and proceed by authenticating to establish a connection between Catchr and TikTok Ads.

[Add a Source on Catchr screen snapshot]

Create the Request to Transfer TikTok Ads Data to PowerBI

Follow this detailed guide to transfer data:

  • Navigate to API in the Catchr left menu.
[API Access in Catchr]
  • Change the export format to "PowerBI".
[Export Format Selection]
  • Select "TikTok Ads" in the "Source" tab.
[Selecting TikTok Ads Source]
  • Choose the accounts from which to extract data. Multiple accounts are an option.
[Account Selection]
  • Pick desired metrics and dimensions. This can include multiple options.
[Metric and Dimension Selection]
[Continued Metric and Dimension Selection]
  • Select the time period for data extraction, whether custom or predefined.
[Time Period Selection]
  • Apply filters if necessary. You can use multiple filters.
[Applying Filters]
  • Customize your request with additional platform-specific options.
[Adding Custom Options]
  • An URL will appear. You can preview results by clicking "Preview".
[Data Preview Accessibility]
  • Review the data preview after a short time.
[Data Preview]
  • If satisfied, copy the generated URL for PowerBI use.
[Copy URL Field]

Note: For optimal results, if using a Catchr template, ensure all the specified metrics and dimensions required by the template are selected. This will auto-load the template with your TikTok Ads data which you can then customize.

Import TikTok Ads Data and KPIs to PowerBI

PowerBI Desktop allows for the importation of data from various sources. Here, we will use a web data source:

  • Under Get Data, choose Web.
[Get Data from Web Option in PowerBI]
  • Remain in basic mode and insert the URL from Catchr.
[URL Insertion]
  • Confirm by clicking OK.

PowerBI may take a short period to import your data. Once complete, utilize PowerBI Query to edit the query and field types. Now, you can begin crafting and sharing your polished dashboard.

For PowerBI Web App utilization:

  • Publish the data set from PowerBI Desktop for web access.
  • Navigate to New Report and choose a published data set.

You will have access to all your datasets, offering you the freedom to create new reports within the PowerBI web app.

Conclusion - Visualize TikTok Ads Data with PowerBI Integration

Our tutorial completes with your TikTok Ads data fully integrated into PowerBI, offering a robust visualization tool-set for your marketing metrics. By connecting these two powerful applications, you unlock deeper insights into your ads' performance, enabling more informed and strategic marketing decisions.

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

When you infuse PowerBI with your TikTok Ads data, a vast array of metrics become available for deep analysis. For marketers, understanding these metrics is fundamental for refining campaigns and optimizing performances. With PowerBI's advanced analytics and visualization capabilities, you could, for instance, create dashboards that:

  • Track Spend, CPC (Cost Per Click), and CPM (Cost Per Mille) over time.
  • Analyze trends in Impressions, Clicks, and CTR (Click-Through Rate) against campaign objectives.
  • Measure Conversion performance, such as Conversions, Cost Per Conversion, and Conversion Rate, through detailed funnel visualizations.
  • Dissect Reach metrics to evaluate campaign penetration and audience targeting effectiveness.
  • Utilize Geographic and Demographic data for advanced audience segmentations, aiding in personalized marketing strategies.

Moreover, the ability to customize and blend these datasets in PowerBI enables creation of composite KPIs, yielding bespoke insights tailored to your business objectives.

To explore the full list of TikTok Ads metrics available for your analysis and integration, please visit the Catchr's metrics list at TikTok Ads Metrics.

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