Summarize this blog post with:
Did you know that 36% of direct purchases made via social media were on TikTok? This demonstrates the significant impact of TikTok on driving conversions.
But here’s the challenge: If you’re running TikTok Ads and manually tracking performance, you’re drowning in data and spreadsheets, struggling to visualize the insights you need to optimize your campaigns.
This tiring process not only slows down decision-making but also makes scaling your client campaigns a nightmare. The solution is to streamline your TikTok Ads reporting in Google Sheets by using a reliable PPC reporting software such as Two Minute Reports.
In this guide, I’ll walk you through two effective ways of connecting your TikTok Ads data to Google Sheets. By the end, you’ll get a clear understanding of tracking key metrics, measuring campaign performance, and creating custom reports to strengthen your ROI.
Let’s get started.
How to connect TikTok Ads to Google Sheets?
You can import your TikTok Ads data to Google Sheets via two methods:
Method 1: Connecting TikTok Ads to Google Sheets using the Two Minute Reports Hub.
Method 2: Connecting TikTok Ads to Google Sheets using the pre-built templates.
Let’s get started with the first method.
Method 1: Connect TikTok Ads to Google Sheets using the Two Minute Reports Hub
The Two Minute Reports Hub is your centralized workspace for managing all your TikTok Ads accounts. Here’s how to get started.
Step 1: Creating a Connection
1. Go to hub.twominutereports.com and click Connections → Create Connection.
2. Inside the dialog box, complete these three steps:
- Select the TikTok Ads connector from the list of options.
- Enter the name for your Connection and authorize it by logging in with your credentials.
- Enable the TikTok Ads accounts you want to measure performance. Please note that you can’t query the disabled accounts.
Note: With Speedboost, you can handle high-volume TikTok Ads datasets and create blazing-fast reports without any delays. This is a proprietary technology of Two Minute Reports built to scale client reporting.
3. Once done, navigate back to the Hub Homepage and click Google Sheets → New Google Sheets Report.
4. Click Use Template and follow the on-screen instructions to launch the Two Minute Reports add-on in your spreadsheet.
Step 2: Configure and Run Your Query
1. Once you’ve installed the add-on, navigate to Menu → Data Queries and click Add.
2. Select the TikTok Ads accounts that you want to include from the sidebar.
3. If you're managing multiple clients, go to Clients → Manage Clients, map your TikTok Ads accounts to the relevant clients, and click Save & Close.
4. Choose relevant TikTok Ads metrics and dimensions and select your date range.
5. Click Run Query to pull the data into your chosen sheet and cell.
6. The next step is to Save & Automate your query.
Pro Tip: You can set up custom refresh schedules to automate daily, weekly, and monthly TikTok Ads performance reporting to your clients. Choose your preferred format – PDF, Excel, or Spreadsheet and keep reports updated automatically without manually exporting data every time.
Prefer to work directly inside Google Sheets? You can also connect TikTok Ads to Google Sheets by installing the Two Minute Reports add-on from Google Workspace Marketplace, following the steps below:
- Open a spreadsheet. Launch the add-on from Extensions → Two Minute Reports → Launch.
- Click Menu → Connections → Add and select the TikTok Ads connector.
- Authorize your account and enable the accounts you want to query.
- Click Refresh Connections to confirm your accounts appear in the sidebar.
Once connected, follow the same query steps above to start pulling your TikTok Ads data directly into Google Sheets.
Method 2: Using TikTok Ads Google Sheets Template
With Two Minute Reports’ pre-built TikTok Ads templates for Google Sheets, you can create custom reports within minutes. Here’s how you can:
1. In the template gallery, select the TikTok Ads template; let us choose the TikTok Ads - Monthly Overview Report.
2. Next, click ‘Get Template for Free’ to open the Google Sheets template.
3. Then, click Use Template. You’ll land on the Google Sheets dashboard.
4. Click Use to launch the Two Minute Report sidebar in your Google Sheets.
5. Finish importing your template by selecting the required TikTok Ads accounts from the dropdown. Once done, click Submit to create your report.
6. Click Run Query to fill this template with the necessary data.
7. And that’s it. Your TikTok ads data is populated across relevant sections, helping you give a detailed overview of what’s happening and what needs to be improved.
Why choose Two Minute Reports to import TikTok Ads to Google Sheets?
With its quick, no-code integration, you can automate data import, track campaign performance, and gain actionable insights – without the need for technical skills. Here's why Two Minute Reports is the best choice for effortless TikTok Ads reporting.
1. Centralized data integration: Create a seamless data flow from TikTok Ads to Google Sheets by consolidating key metrics in a single Google Sheets dashboard. This eliminates the need for manual CSV exports, so you can focus on refining and optimizing your strategy.
2. Intuitive reporting: With Two Minute Reports, you can create professional, white-label TikTok Ads reports that are fully customizable to match your brand’s style. The easy-to-use interface allows you to blend data from multiple PPC channels, enabling you to measure cross-channel ad spend and ROI.
3. Faster data syncs: Load complex dashboards faster with our exclusive Speedboost technology. With 99.9% uptime, you can deliver blazing-fast TikTok Ads reports to clients without the wait. No manual setup required.
4. Automatic data refreshes: Never miss a deadline. With automatic updates (daily, weekly or monthly), you can keep clients informed with real-time insights. You can implement proactive measures to address underperforming areas, instead of waiting for manual reports.
5. Unlimited reporting: No matter which plan you choose, you can create unlimited TikTok Ads reports, especially with no data volume limits. Whether you are handling multiple clients or managing large volumes of data, you can generate as many reports as you need, all while maintaining faster performance and reliability.
Overall, whether you are a marketer, agency owner, or freelancer, Two Minute Reports makes TikTok Ads reporting faster, easier, and more effective.
How to build a strong TikTok Ads analytics strategy?
To build a strong TikTok ads analytics strategy, you must first identify the key KPIs that add significance to your goals and ROI. Here’s how you can easily get the hang of things if you understand these five metric categories:
1. Basic insights: Like most advertising platforms, you can visualize the overview of your campaign performance by tracking the following metrics:
- Clicks, impressions, conversions.
- Cost Per Click
- Cost Per Mille
- Cost Per Acquisition
- Conversion Rate
- Click-through Rate
2. Attribution insights: With TikTok Pixel, you can set attributions or triggers for specific activities that meet your requirements. You can get insights about:
- CTA Conversions
- VTA Conversions
- CTA registrations
- VTA registrations
- CTA purchases
- VTA purchases
In summary:
- CTA – Direct interaction (clicks)
- VTA – Indirect interactions (views, followed by actions)
- Conversions, registrations, and purchases – Different types of desired actions that happen as a result of the ad, either directly (CTA) or after viewing the ad (VTA).
3. In-App Event: Refers to the specific actions or interactions that users take within the app after they view or interact with your ad. The common types of in-app events include:
- App installs
- Unique registration
- Add to cart events
- Purchase events
- Total checkout value
4. Video insights: This is one of the most crucial metrics to monitor, as the platform’s core strength lies in video advertising. Some of the prominent metrics include:
- 2, 6-second video views
- 6, 15 focused video-views
- Video views at 25%, 50%, 75%, 100%
- Average video watch time per person
- Average video watch time per video view
5. Instant page insights: When advertising with TikTok for Business, you can create pages that load instantly upon users’ clicks. These pages, known as Instant Pages, function just like a landing page but are highly mobile-optimized. You can optimize by tracking metrics such as:
- Complete payment ROAS
- Cost per Complete Payment
- Landing page views
- Total button click value
- Total add to cart value
- Total form submission
- Download button click cost
Regularly monitoring and optimizing your TikTok Ads based on real-time data will ensure sustained campaign performance, allowing you to refine your targeting and maximize ROI.
Connect your advertising platforms with Google Sheets
Bring together your PPC reporting by blending all your data sources in a single dashboard. Connect Facebook Ads, LinkedIn Ads, Snapchat Ads, etc and unlock true cross-channel ROI. Identify winning opportunities, areas of optimization, and make quick, real-time changes without having to wait for manual updates. Streamline multi-client reporting, save time and drive better results for your clients.
Frequently Asked Questions
You can install the Two Minute Reports add-on from the Google Workspace Marketplace. Next, open your spreadsheet, launch the sidebar, and connect your TikTok Ads accounts. Then specify your metrics, dimensions, date range and click Run query. Visualize actionable performance insights without having to manually switch spreadsheets.
With Two Minute Reports, you can set up custom refresh schedules – daily, hourly, weekly or monthly and ensure your campaign reports reflect the latest TikTok Ads campaign insights. Deliver professional, white-label reports directly from Google Sheets to your clients within minutes.
You can access our free, ready-to-share TikTok Ads Google Sheets templates to streamline campaign tracking. Once you click “Use Template”, you can launch the Two Minute Reports add-on, import your client’s TikTok ad accounts, run queries and auto-populate the dashboard with meaningful insights.
With data blending, you can compare TikTok Ads with other advertising platforms, such as Meta, LinkedIn Ads, etc, into a single dashboard and unlock cross-channel ROI. No need to toggle between platforms or copy-paste KPIs manually.
You can choose to directly select your client’s TikTok Ads accounts from the Two Minute Reports sidebar and consolidate key KPIs in one place. Alternatively, you can also reuse the existing reports across multiple clients, ensuring you focus more on strategy and accomplish your campaign goals.
You can connect Google Ads, Facebook Ads, and TikTok Ads to Two Minute Reports and bring all three data sources into one place. Use the Two Minute Reports Dashboard to track and compare your ad performance, or send the data to Google Sheets or Looker Studio for further analysis. You can also automate data refreshes to keep your cross-channel tracker up to date.
Meet the Author
Shabika VenkidachalamShabika, at her core, is a storyteller who believes even data-heavy topics can be infused with heart. At Two Minute Reports, she blends creative writing with user intent to create clear, purposeful content that is deeply human. Away from her desk, she finds inspiration in nature, where creativity flourishes without distractions.
