Account totals that match Ads Manager
TikTok reports at four data levels: advertiser, campaign, ad group and ad. Whathead picks the level from the fields in your query. A plain "cost by date" query runs at advertiser level, which includes deleted entities and Branded Mission spend, so it matches the account total in TikTok Ads Manager. Adding a campaign, ad group or ad field moves the query down a level, and adding an audience dimension switches it to TikTok's audience report.
TikTok allows at most 30 days per daily request and 1 day per hourly request. Whathead splits longer ranges into allowed chunks and joins them, and it requests large metric sets in batches so you can pull hundreds of columns at once.
Metric groups
| Group | Examples |
|---|---|
| Delivery | Cost, net cost, cash and voucher cost, impressions, gross impressions, reach, frequency, CPM, destination clicks and CTR |
| Results | Results, cost per result, real-time results, conversions, conversions by conversion time, deep funnel results |
| Video | 2-second and 6-second views, 6 and 15-second focused views, 25% to 100% views, average watch time |
| Engagement | Paid likes, comments, shares, follows, profile visits, LIVE views, interactive add-on clicks |
| Website events (105) | Purchases, value and ROAS, adds to cart, checkouts, orders placed, landing page views |
| App events (154) and SKAN (118) | Installs, registrations, purchases, ROAS, retention and in-app events, with SKAdNetwork versions |
| TikTok Shop (21) and onsite (52) | Shop purchases, product page views, items purchased; onsite form submissions and purchases |
| Offline (80) and attribution | Offline purchases, CRM events, contacts; view-through, click-through and engaged view-through conversions |
Dimensions
| Level | Dimensions |
|---|---|
| Advertiser | Advertiser ID and name, currency, time zone |
| Campaign | ID, name, objective type, budget and budget mode, automation type, campaign type, status |
| Ad group | ID, name, budget, placement type, promotion type, optimization goal, billing event, bid strategy, status |
| Ad and creative | Ad name and text, call to action, ad format, landing page URL, video ID, thumbnail and video preview URLs, display name, post URL, TikTok post ID |
| Audience | Age, gender, language, device platform, placement, connection type, interest category, country |
Create a TikTok Ads report
Connect TikTok in Whathead
Authorize your TikTok advertiser accounts in the Whathead workspace.
Open the add-on
Extensions, Whathead for Google Sheets, Launch sidebar, then sign in.
Choose fields
Select TikTok Ads, the advertisers, metrics, dimensions such as campaign name or age, and a date range.
Write and schedule
Run the query at the selected cell and add a schedule (up to 5 per spreadsheet) so it refreshes without the file open.
Frequently asked questions
How do I install the TikTok connector?
It is part of the Whathead for Google Sheets add-on. The public Google Workspace Marketplace listing is not live yet, so email [email protected] from your Whathead account address and the team will help you get access.
Is the TikTok Ads to Google Sheets connector free?
The add-on is free to install. Queries need an active Whathead trial or any paid plan, from $29 a month with a 14-day free trial.
Can I split by age and gender?
Yes. Adding an audience dimension such as age, gender, country or placement moves the query to TikTok's audience report. Some combinations are limited by TikTok; for example, interest categories cannot be split by date.
Does it include Spark Ads and creative details?
Yes. Ad-level queries can include the TikTok post ID, post URL, video ID, thumbnails and preview URLs next to performance.
Can I report TikTok and Meta side by side?
Yes. Put a Facebook Ads query and a TikTok Ads query on the same sheet, each writing its own table, and combine them with your own formulas or a summary tab.
Run it from one workspace
Every plan starts with a 14-day free trial. Only successful live work is metered.