Get Tiktok Ads data to Google Sheets

Easily automate and extract Tiktok Ads data to Google Sheets, simplifying data processing, visualization, integration with other sources, and collaboration with your team.

Why connect Tiktok Ads to Google Sheets

Track real-time performance of your ads

Track real-time performance of your ads

With TikTok Ads, you can monitor the performance of your ads in real-time. This includes data on views, clicks, conversions, and other key metrics. This real-time data allows you to quickly identify and respond to trends, ensuring that your ads are always performing at their best.

Create detailed reports for in-depth analysis

Create detailed reports for in-depth analysis

TikTok Ads allows you to create detailed reports based on your ad performance. These reports can include data on demographics, engagement, and conversion rates. By analyzing these reports, you can gain valuable insights into your audience and the effectiveness of your ads, allowing you to make data-driven decisions to improve your marketing strategy.

Combine TikTok Ads data with other platforms

Combine TikTok Ads data with other platforms

TikTok Ads allows you to integrate your ad data with other platforms, such as Google Analytics. This allows you to combine data from multiple sources, providing a more comprehensive view of your marketing performance. By blending TikTok Ads data with insights from other platforms, you can gain a deeper understanding of your customer acquisition performance and make more informed decisions about your marketing strategy.

Tiktok Ads to Google Sheets : what to export

Export all important Tiktok Ads Metrics and Dimensions for analysis in Google Sheets

Performance

Performance

Analyze your spend to determine if you’re getting the most out of your budget. Measure the effectiveness of your ad by tracking clicks and impressions. Assess CTR to understand how often people are clicking your ad after seeing it. Use CPC and CPM to optimize your bids and get more clicks or impressions for less money. Lastly, evaluate gross impressions to identify and eliminate any invalid views.

Account

Account

Identify the advertiser's Account name, ID, status, currency, balance, country, type, company, address, and contact person to gain valuable insights into operations. Benefit from tracking account balances and currency, reporting on company performance, and contacting key figures with ease. Use these dimensions to improve your reporting and better manage your TikTok Ads account.

Video

Video

Track your video views, replay rates and watch time to gain insights into audience behavior. Analyze the percentage of views at each stage of the video, identify key moments and optimize content to increase engagement. Use unique video IDs to tailor targeting and monitor ad performance.

Campaign

Campaign

Analyze campaign names, types, and objectives to identify which campaigns are most effective. Check campaign budget and optimization settings to ensure you're maximizing return on investment. Use operation and status metrics to monitor campaigns and make adjustments as needed. These insights will help you create stronger campaigns and improve overall operations.

Engagement

Engagement

Analyze the number of new followers gained, profile visits, likes, shares, and comments to gauge your ad's engagement. Track the overall engagement, including clicks, to see the ad's true impact. Calculate the engagement rate to measure the frequency of interactions. Monitor the clicks on music and sound usage to assess the effectiveness of your ad's audio. Use these TikTok Ads insights to report on and improve your campaign's success.

Page Event

Page Event

Analyze the total value returned from complete payment events using TikTok Ads to improve your operations. Use the number of add to cart and initiate checkout events to optimize your sales funnel. Measure total return on ad spend with complete payment ROAS for ads. Use form submissions and user registrations to gauge lead generation success.

Time

Time

Analyze the performance of your TikTok Ads by reviewing the date, month, and year. Determine the most profitable hours to run your ads and measure engagement during the week. Use the start date of the week to measure trends and make informed data-driven decisions to improve your operations.

Conversion

Conversion

Track the number of conversions, cost per conversion, conversion rate, real-time conversions, and real-time conversion rate with TikTok Ads. Measure how many times your ad met a secondary goal or achieved your objective. Understand your ad's effectiveness in attracting clicks. Use this data to optimize your campaigns and improve your ROI.

Onsite Event

Onsite Event

Analyze onsite events on TikTok Store to get insights on complete payment, checkout initiation, and cart addition. Check your ad's ROAS and total value returned for complete payment. Look at the total page views, product clicks, and add-to-wish-list events for awareness. The cost per complete payment can explain ad spend effectiveness. Use these metrics to improve your operations on TikTok Store.

Result

Result

Gain valuable insights from TikTok Ads by tracking your ad Results, Cost per Result, Result Rate, and Real Time Results. See how often your ad achieved its goal and how much it costs per outcome. Compare results to the number of views/clicks to visualize the effectiveness of your ads in real time. Optimize your campaign for maximum ROI.

How to export Tiktok Ads to Google Sheets & automate it

Google Sheets
Step 1

Install Two Minute Reports (TMR) for Google Sheets

Open Google Sheets and install Two Minute Reports from the add-ons menu. No credit card required.

Step 2

Connect your Tiktok Ads with Two Minute Reports

Open TMR add-on and select Data Source from the menu button. Click Add and add your new Tiktok Ads data source

Step 3

Select the Tiktok Ads data you need

Open the Queries menu and create a new query. Select the Tiktok Ads data source you added along with the Tiktok Ads metrics and dimensions you want.

Step 4

Automate Schedules to Tiktok Ads export to Google Sheets

Create a new schedule to automatically fetch live data from Tiktok Ads at periodic intervals. You can even send emails, PDFs or Excel sheets on schedule.

Step 5

Skip steps and jump start Tiktok Ads with Templates

Instead of creating a report from scratch use our premade Tiktok Ads templates below and get started in no time

Start using these quick templates Now

TikTok Ads - Overview Report
Looker Studio

Automate Tiktok Ads to Google Sheets export & do more with Two Minute Reports

Two Minute Reports for Google Sheets has these features for you

Ease of Use

Ease of Use

Two Minute Reports is designed to be user-friendly and easy to navigate. With its intuitive interface, you can quickly generate reports and track your marketing campaigns without the need for extensive training or technical knowledge.

Battle tested by Millions of Users

Battle tested by Millions of Users

By working with BI platforms developed with Billions of Investment by Google - like Google Sheets and Looker Studio, Two Minute Reports provides robust capabilities and a secure infrastructure for your Reporting

Data Integration and more

Data Integration and more

Two Minute Reports integrates with Tiktok Ads and over 30+ Marketing platforms so that you can analyse and visualize your data in the BI platform of your choice.

Why use Two Minute Reports to import Tiktok Ads data to Google Sheets

Marketers know how critical it is for a business to correctly measure the performance of ad campaigns. Using standard Tiktok Ads tools, the in-line performance analytics are pretty straightforward. But things can change if you need to analyse custom metrics over an extended period. Generic Tiktok Ads dashboard tools are simply not intended for more detailed analysis that includes customizing filters and analysing the performance of multiple campaigns from multiple accounts. That is where Two Minute Reports steps in. Its Tiktok Ads to Google Sheets integration allows you to automate the process of extracting data from Ads on a custom schedule. You can merge data on multiple campaigns and ads in a single sheet, applying all the powerful tools Google provides. These include pivot tables, graph visualization, formulas, and team sharing capabilities.

Tiktok Ads

Tiktok Ads

88arrow
Google Sheets

Google Sheets

88arrow
fads

Manage, Share, Analyze

Do more with Google Sheets + Tiktok Ads

With Two Minute Reports, you can get Tiktok Ads data in Google Sheets and also merge it with other Advertising data from platforms like Facebook Ads, Google Ads, Linkedin Ads, Snapchat Ads, Tiktok Ads, Microsoft/Bing Ads, Pinterest Ads, Apple Search Ads, Amazon Ads. Not just that, you can also get data from different types of Mobile, Database, Advertising (PPC), Web Analytics, SEO, E-Commerce, Other sources, Social Media, Email, Customer relationship management Data Sources.

fads

Facebook Ads

gadw

Google Ads

lads

Linkedin Ads

snapads

Snapchat Ads

ttads

Tiktok Ads

Get Tiktok Ads data in other tools too

We also help get your Google Sheets to the following Tools

Looker Studio

Looker Studio

Two Minute Reports for Google Sheets helps you to get your Tiktok Ads data to Google Sheets. You can not just analyse data you do much more there. By running on top of Google Sheets, we support a range of customization options, including the ability to create custom formulas and functions, unlimited formatting and sharing capabilities, Google Sheets has a friendly interface that many of us are familiar with. Spreadsheets are easier to handle when you are looking at a lot of Data and you dont have to learn a new tool.

Connect other Ad Platform Data Sources with Google Sheets

You can combine data from other Ad data sources with your Tiktok Ads Reports

Image
Facebook Ads

Facebook Ads

Social media ad platform for targeted audience reach.

Google Ads

Google Ads

Advertising platform for displaying ads on Google's search results pages.

Linkedin Ads

Linkedin Ads

Professional social media platform's advertising data source.

Snapchat Ads

Snapchat Ads

Social media advertising platform for Snapchat users.

Connect other Marketing Channels with Google Sheets

You can combine Tiktok Ads data with not just Ad Platforms but also with other Platforms too

Mobile

Mobile

The category includes Data Sources like the Apple App Store and Google Playstore. That have information on apps that are provided to the data sources.

Database

Database

The category includes SQL based data sources connectors such as Cloud Firestore, MariaDB, MySQL, Postgre SQL.

Advertising (PPC)

Advertising (PPC)

This falls in the advertising category, more evidently Pay Per Click Connectors, for Facebook Ads, Google Ads, Snapchat Ads, LinkedIn Ads, TikTok Ads and Miicrosoft Ads

Web Analytics

Web Analytics

Data Sources like Google analytics, that analyzes the behaviour of visitors to a web site, falls in this category.