TikTok Ads
Spend, impressions, reach, clicks, conversions, video and engagement metrics of your TikTok ad accounts, by campaign, ad group, ad or audience.
The TikTok Ads connector brings the performance data of your TikTok ad accounts into your sheet: spend, impressions, reach, clicks, conversions, video and engagement metrics, by ad account, campaign, ad group or ad.
The connection uses TikTok for Business's official authorization: on TikTok you choose which ad accounts to authorize, with read-only permissions. Magic Reports never creates, edits or deletes campaigns or ads. You can revoke access at any time from Magic Reports or from your TikTok for Business account settings.
In the report you pick the ad account as the "property": one report reads one ad account, so amounts in different currencies are never added together.
Metrics and dimensions are split into two categories, one per report: performance (data by ad account, campaign, ad group or ad, also by country) and audience (the same data broken down by age, gender, country, language, operating system, placement or connection type).
Available metrics
| Metric | Period | Aggregation | Note |
|---|---|---|---|
| Cost | period | sum | Spend in the ad account currency. |
| Impressions | period | sum | |
| Reach | period | unique | Unique people reached. performance category only. Not additive across days: with Week or Month TikTok calculates it for the whole period. |
| Frequency | period | avg | Average times each person saw the ad. performance category only. |
| Clicks (Destination) | period | sum | Clicks that lead to the ad destination. |
| CTR (%) | period | avg | Clicks / impressions x 100. |
| CPC | period | avg | Cost per click. |
| CPM | period | avg | Cost per 1,000 impressions. |
| Cost per 1,000 People Reached | period | avg | |
| Results | period | sum | Actions tied to the optimization goal. By ad group or ad only, performance category. |
| Cost per Result | period | avg | By ad group or ad only, performance category. |
| Result Rate (%) | period | avg | By ad group or ad only, performance category. |
| Conversions | period | sum | By ad group or ad only, performance category. |
| Cost per Conversion | period | avg | By ad group or ad only, performance category. |
| Conversion Rate (%) | period | avg | By ad group or ad only, performance category. |
| Complete Payment Value | period | sum | Value of website purchases (Complete Payment event) in the ad account currency. |
| Complete Payments | period | sum | Number of Complete Payment events on the website. |
| Complete Payment ROAS | period | avg | Complete payment value / cost. |
| Purchase Value (App) | period | sum | Value of in-app purchases. |
| App Installs | period | sum | performance category only. |
| Form Submissions | period | sum | |
| Landing Page Views | period | sum | |
| Cost per Landing Page View | period | avg | |
| Landing Page View Rate (%) | period | avg | |
| Video Views | period | sum | |
| 2-Second Video Views | period | sum | |
| 6-Second Video Views | period | sum | |
| 6-Second Focused Views | period | sum | performance category only. |
| 15-Second Focused Views | period | sum | performance category only. |
| Video Views at 25% | period | sum | |
| Video Views at 50% | period | sum | |
| Video Views at 75% | period | sum | |
| Video Views at 100% | period | sum | |
| Average Watch Time per Video View (s) | period | avg | |
| Average Watch Time per Person (s) | period | avg | performance category only. |
| Paid Likes | period | sum | |
| Paid Comments | period | sum | |
| Paid Shares | period | sum | |
| Paid Follows | period | sum | |
| Paid Profile Visits | period | sum |
Available dimensions
| Dimension | Note |
|---|---|
| Date | Day, in the time zone of the ad account. |
| Week (Mon-Sun) | ISO week, format 2026-W46. One value per week, exact reach and frequency. |
| Month | Format 2026-11. One value per month, exact reach and frequency. |
| Ad Account ID | All categories. |
| Ad Account Name | All categories. |
| Currency | Currency of the ad account: all amounts in the report are in this currency. |
| Time Zone | Time zone of the ad account, used by TikTok for dates. |
| Campaign ID | Makes the report by campaign (or more detailed). |
| Campaign Name | Makes the report by campaign (or more detailed). |
| Campaign Objective | Advertising objective of the campaign, as returned by TikTok (e.g. TRAFFIC, CONVERSIONS). |
| Campaign Status | Current status of the campaign (not the status during the report period), as returned by TikTok. |
| Ad Group ID | Makes the report by ad group (or by ad). |
| Ad Group Name | Makes the report by ad group (or by ad). |
| Ad Group Status | Current status of the ad group. |
| Placement Type | Automatic or manually selected placement, set in the ad group. |
| Ad ID | Makes the report by ad. |
| Ad Name | Makes the report by ad. |
| Ad Text | Makes the report by ad. |
| Ad Status | Current status of the ad. |
| Country | Country code. Available in both categories; in audience it counts as the audience dimension. |
| Age | audience category. Age range (e.g. AGE_25_34). Can be combined only with Gender. |
| Gender | audience category. Can be combined only with Age. |
| Language | audience category. |
| Operating System | audience category (e.g. ANDROID, IOS). |
| Placement | audience category. Where the ad was shown. |
| Connection Type | audience category (e.g. WIFI, 4G). |
Known limits
- One ad account per reportEach report reads a single ad account, so amounts in different currencies are never added together. For several accounts use separate reports.
- Two categories and allowed combinationsperformance and audience cannot be mixed in one report. Audience reports need a single audience dimension (the only allowed pair is Age + Gender) and do not include reach, frequency, results, conversions, app installs and focused views: TikTok does not provide them by audience. Invalid combinations are blocked before saving.
- Conversions and results by ad group or ad onlyTikTok provides conversions and results (and their costs and rates) only at ad group or ad level: to use them add an ad group or ad dimension.
- Period per request and hourly detailWith the Date dimension TikTok accepts at most 30 days per request: the connector splits long periods automatically. Without a time dimension the maximum period is 365 days. Hourly detail is not available.
- TikTok call limitsTikTok limits the number of requests per second and per minute. When the limit is reached the connector waits and retries; if TikTok keeps throttling, the report stops with a message asking to retry after 5 minutes. Very large reports (many ads per day over long periods) can exceed the maximum run time: in that case use a shorter period, Week or Month, or a less detailed level.
- Ad account time zone and currencyDates and amounts follow the time zone and currency of the ad account, as in TikTok Ads Manager, not the sheet time zone.
- Totals and filtersTotals are calculated by TikTok over the whole period and ignore filters, which apply to rows only. Beyond 365 days TikTok does not calculate totals: they are rebuilt from the rows and left blank for reach, frequency and results.
Execution notes
The report level depends on the dimensions you choose: if you pick an ad field (name, ID, text, status) the report is by ad, otherwise by ad group, by campaign or for the whole ad account. Campaign and ad group names remain available in ad-level reports too.
With the Date dimension data is daily, and the connector automatically splits long periods into 30-day blocks, the maximum TikTok accepts per request. With Week (Monday-Sunday) or Month the connector asks TikTok for one value per week or month: this way reach and frequency are exact and not the sum of the days.
Totals are calculated by TikTok over the whole period, so total reach and frequency are exact too. Filters apply to rows, not to totals.
Dates and amounts follow the time zone and currency of the ad account, as in TikTok Ads Manager: you can add them to the report with the Time Zone and Currency dimensions.