TikTok Ads & Google Sheets: how to integrate your data

This comprehensive guide is designed to show marketing professionals how to effortlessly integrate their TikTok Ads data with Google Sheets using Catchr. By following these steps, you’ll be able to automate the data import process, enabling easier analysis and reporting directly from Google Sheets.

How to Connect Your TikTok Ads Account to Google Sheets

Add a Source on Catchr

To start, navigate to the Catchr homepage. From there, find "Source" on the left-side menu and select "Add a Source" located at the upper right corner. Choose TikTok Ads from the platform list and complete the identification process to establish a connection between Catchr and TikTok Ads.

Create a New Query

Open Google Sheets and locate "Catchr" within the menu bar. Click on it and then choose "New Query" to initiate the creation of a new query, which will facilitate the transfer of your TikTok Ads data.

Select Your Data Source

In the query tab, select TikTok Ads as your desired source. If TikTok Ads is not displayed in the source list, conveniently add it by clicking on the "+" icon.

Select Your Account(s)

Proceed to the "Select account(s)" tab to select the specific TikTok Ads account(s) from which you wish to import data.

Choose Metrics and Dimensions

Next, visit the "Metrics" and "Dimensions" tabs to pinpoint the precise data points you'd like to incorporate into your query. Consider the following examples:

Metrics:

• Spend: The total ad spend.
• Impressions: The count of times your ads were on screen.
• Clicks: The number of clicks on your ads.

Dimensions:

• Country: The country where ads were viewed.
• Device: The type of device used to view the ads.
• Language: The language setting of the device.

Select metrics and dimensions that best align with your analysis and reporting objectives.

Set Date Range

After determining your metrics and dimensions, switch to the "Date Range" tab. Catchr allows the selection of preset date ranges like "Last month" or "This year", and also offers the option to specify custom start and end dates for your data import.

Apply Filters

To further refine your data, make use of the "Filters" tab where you can apply filters such as:

• Field: Country
• Operator: Equals
• Value: United States

This example demonstrates how to filter data for visitors solely from the United States.

Schedule & Customize Data Refreshness

Finally, navigate to the "Options" tab to schedule automatic updates for your query. You have the flexibility to choose options such as "Append rows" for adding new data at the query's end or "Combine rows" to update existing ranges.

By following these steps, you'll have successfully connected your TikTok Ads account to Google Sheets, simplifying the way you manage and analyze your marketing data.

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

With data seamlessly flowing from TikTok Ads to Google Sheets, the possibilities for data analysis and reporting are vast. Here are some practical examples of Google Sheets you can create:

• Performance Dashboard: Compile key performance indicators (KPIs) such as Impressions, Clicks, Spend, and Conversions to evaluate the efficiency of your ad campaigns over time.
• ROI Analysis: Merge ad spend data with conversion value to calculate the return on investment (ROI) of your campaigns, helping you identify the most profitable channels and creative assets.
• Geographic Insights: By aggregating data based on country or region, you can gain insights into market performance and tailor your campaigns to target areas with high engagement or untapped potential.
• Device Performance: Analyze how different devices (mobile, tablet, desktop) perform to optimize your ads based on device preferences and usage patterns of your audience.
• Trend Analysis: Utilizing the time-based dimensions and metrics, you can identify trends and seasonality in ad performance, aiding in strategic planning and budget allocation.

The customization capabilities provided by Google Sheets, combined with the wealth of data from TikTok Ads, empower marketers to craft tailored reports and dashboards that meet their specific needs. This enhances decision-making and strategic planning, leading to better performance and efficient use of marketing resources.

‍