blog post

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

Florian Cabirol
January 31, 2024
Import your TikTok profile data to Google Sheets : How-to, metrics and more

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

In this tutorial, we're on a mission to simplify your marketing data analysis by connecting TikTok to Google Sheets through Catchr. By the end, you'll be able to seamlessly import your TikTok analytics into a spreadsheet, making it easier for you to visualize and manipulate your data for better decision-making.

How to connect your TikTok account to Google Sheets

Add a Source on Catchr

Navigate to the Catchr homepage. From there, find 'Source' in the left-hand menu and select 'Add a Source' at the top right corner. Choose TikTok from the list of platforms and complete the necessary steps to grant Catchr access to your TikTok account.

Adding a source in Catchr

Create a New Query

Open Google Sheets and locate "Catchr" in the menu bar. Click on it, then select "New Query" to start pulling your TikTok data into the spreadsheet.

Select Your Data Source

In the query editor, select TikTok as your data source by clicking on it. Should you not see TikTok listed, simply add it as a new source by clicking the "+" icon.

Selecting TikTok as a data source

Select Your Account(s)

Under the "Select account(s)" section, choose the specific TikTok account(s) you wish to gather data from.

Selecting your TikTok account

Choose Metrics and Dimensions

Now, head over to the "Metrics" and "Dimensions" sections to specify the data you're looking to analyze. Here are a few examples:

Metrics:

  • Like Count: The total likes across all videos
  • View Count: The number of times videos have been viewed
  • Share Count: How many times videos have been shared
Choosing metrics for your data query

Dimensions:

  • Date: The date when data was extracted
  • Video Description: The descriptions set for videos
  • Duration: The length of videos in seconds

Select metrics and dimensions that align with your analysis goals.

Selecting dimensions for your data query

Set Date Range

Choose a preset or custom date range for your data import in the "Date Range" section.

Setting the date range for your query

Apply Filters

To refine your data further, use filters in the "Filters" section. For instance:

  • Field: Video Description
  • Operator: Contains
  • Value: Trending

This filter will include only the data for videos with "Trending" in their descriptions.

Applying filters to your query

Schedule & Customize Data Refreshness

In the "Options" tab, set up automatic data refreshes to keep your spreadsheet up to date. You may also choose to append new rows for each data pull or combine them.

Setting data refresh options

Following these steps will equip you with a dynamic and comprehensive overview of your TikTok marketing data directly in Google Sheets, boosting your analytical capabilities.

Example of Google Sheets You Can Create to Use with the TikTok Source

With TikTok data integrated into Google Sheets via Catchr, the possibilities are immense. Here are some practical examples of how you can leverage this powerful combination:

Content Performance Dashboard: Create a comprehensive dashboard that tracks the performance of your content on TikTok. Metrics such as like count, view count, and share count can give you a quick overview of what content resonates most with your audience. Engagement Analysis: By importing metrics like comment count and share count, you can delve into the engagement levels of your TikTok videos, identifying trends over time or pinpointing content that sparked considerable interaction. Followers Growth Tracker: Using the "User's followers count" dimension, set up a tracker that visually represents the growth of your follower base over time. This can help you evaluate the effectiveness of your content strategy and growth campaigns. Trend Analysis: Employ dimensions such as "Video Description" and "Duration" alongside metrics like "View Count" to analyze what content types and topics are currently trending on TikTok, allowing you to adjust your content strategy accordingly. Competitive Analysis: By configuring data queries for your account and competitors', you can benchmark your performance against theirs across key metrics, gaining insights into your competitive standing and areas for improvement. Leveraging TikTok data with Google Sheets paves the way for deeper insights into your content performance, audience engagement, and market positioning, driving more informed decision-making and strategic adjustments in your digital marketing efforts. ```

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