Tiktok to Looker Studio
Step 1: Create a TikTok Source on Catchr
First, create a TikTok source on Catchr. Follow this tutorial to add your new source: Create a source on Catchr.
Step 2: Install the Connector
Open Looker Studio and log in with your Google account.
On the Home page, click the Create button in the top-left corner.
Select Data Source.
In the search bar, type "Catchr".
Click on the TikTok connector and press Authorize.
Step 3: Authenticate Your TikTok Account
If you did not add a source on Catchr in Step 1, you will be prompted to do it here:
Grant the connector permission to access your TikTok data.
This will link your TikTok account to Looker Studio via the Catchr connector.
Step 4: Configure Your Data Source
After authentication, select the TikTok account you want to pull data from (if you manage multiple accounts).
There aren’t any special configurations for TikTok data (such as attribution models or custom settings).
If you want to use the default template, leave the checkbox "Use default template" checked.
Click Connect to create your data source.
Step 5: Review Data Source Fields
You'll now see the list of available fields for TikTok. Here, you can:
Modify field types (e.g., set a field as currency, percentage, etc.).
You can return to this section later to make further modifications if needed.
Step 6: Create Your Report
Once connected, click Create Report in Looker Studio.
If you didn’t use the template, you’ll see a blank report page. If you used the template, you can add a new page by clicking the page number in the top menu, then selecting Add a page at the bottom right.
Start by clicking Add a Chart and selecting your preferred chart type (e.g., time series, bar chart).
Choose the metrics and dimensions you wish to display in each chart (e.g., views, engagement, followers).
Continue adding multiple charts to visualize various aspects of your TikTok performance.
Step 7: Customize Your Report
Date Range Filters: Add a date range filter to allow users to select specific time periods.
Custom Calculations: You can create calculated metrics (e.g., engagement rate, follower growth) directly in Looker Studio.
Blending Data: If you want to compare TikTok data with other platforms (e.g., Instagram, Meta Ads), use the data blending feature.
Step 8: Share or Schedule Reports
To share the report, click the Share button in the top right corner and enter the email addresses of recipients.
You can also schedule the report to be sent periodically (e.g., weekly or monthly) by setting up email delivery under File > Schedule email delivery.
First, create a TikTok source on Catchr. Follow this tutorial to add your new source: Create a source on Catchr.
Step 2: Install the Connector
Open Looker Studio and log in with your Google account.
On the Home page, click the Create button in the top-left corner.
Select Data Source.
In the search bar, type "Catchr".
Click on the TikTok connector and press Authorize.
Step 3: Authenticate Your TikTok Account
If you did not add a source on Catchr in Step 1, you will be prompted to do it here:
Grant the connector permission to access your TikTok data.
This will link your TikTok account to Looker Studio via the Catchr connector.
Step 4: Configure Your Data Source
After authentication, select the TikTok account you want to pull data from (if you manage multiple accounts).
There aren’t any special configurations for TikTok data (such as attribution models or custom settings).
If you want to use the default template, leave the checkbox "Use default template" checked.
Click Connect to create your data source.
Step 5: Review Data Source Fields
You'll now see the list of available fields for TikTok. Here, you can:
Modify field types (e.g., set a field as currency, percentage, etc.).
You can return to this section later to make further modifications if needed.
Step 6: Create Your Report
Once connected, click Create Report in Looker Studio.
If you didn’t use the template, you’ll see a blank report page. If you used the template, you can add a new page by clicking the page number in the top menu, then selecting Add a page at the bottom right.
Start by clicking Add a Chart and selecting your preferred chart type (e.g., time series, bar chart).
Choose the metrics and dimensions you wish to display in each chart (e.g., views, engagement, followers).
Continue adding multiple charts to visualize various aspects of your TikTok performance.
Step 7: Customize Your Report
Date Range Filters: Add a date range filter to allow users to select specific time periods.
Custom Calculations: You can create calculated metrics (e.g., engagement rate, follower growth) directly in Looker Studio.
Blending Data: If you want to compare TikTok data with other platforms (e.g., Instagram, Meta Ads), use the data blending feature.
Step 8: Share or Schedule Reports
To share the report, click the Share button in the top right corner and enter the email addresses of recipients.
You can also schedule the report to be sent periodically (e.g., weekly or monthly) by setting up email delivery under File > Schedule email delivery.
Updated on: 17/09/2024
Thank you!