Loading...

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 report
    Each 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 combinations
    performance 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 only
    TikTok 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 detail
    With 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 limits
    TikTok 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 currency
    Dates and amounts follow the time zone and currency of the ad account, as in TikTok Ads Manager, not the sheet time zone.
  • Totals and filters
    Totals 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.