TikTok Ads BigQuery Tables Documentation

When importing TikTok Ads data into BigQuery via Dataslayer, you may get an "invalid parameters combination" error if you select certain dimensions and metrics that cannot be used together.

The error "invalid parameters combination " comes from the native API of the data source, not from Dataslayer.


To avoid this error, you can import the following tables:

Ads data Table

Example:

Ads data Table
Dimensions
ad group name
ad group id
ad group status
ad group operation status
optimization goal
cpv video duration
pacing
bid method
bidding strategy
deep bid type
bid
conversion bid
conversion bid statistic type
deep cpa bid
placement type
ag placement
are comments disabled
schedule type
schedule start time
schedule end time
ad group budget
ad group budget mode
ad name
ad text
ad id
ad status
ad operation status
ad created date
ad created hour
call-to-action
landing page url
creqative image url
creative image
creative video cover url
creative video cover
creative video preview url
video id
image mode
advertiser name
advertiser id
advertiser status
advertiser balance
advertiser adress
advertiser country
advertiser license number
advertiser contact email
advertiser contact phone number
time zone
audience type 
audience rule 
campaign name  
campaign id 
type of campaign 
campaign budget 
campaign budget mode 
campaign status 
campaign operation status 
campaign objective type 
campaign creation date 
campaign creation date
campaign modify date
age targeting 
languaje targeting 
gender targeting 
operating type targeting 
device price targeting
minimum android version 
minimum iOS version 
date
Metrics
add billing 
button click events 
clicks 
conversions 
cost 
paid comments 
total engagement 
engagement rate 
profile visits 
paid likes 
paid shares 
paid follows 
form submissions 
details page browse events (form) 
impressions 
checkout initiations 
online consultation events 

page browser events 

product details page browse events 
real-time app installs 
real-time conversion rate 
real-time results 
results 
secondary goal result 
total achieve level value 
avhieve level events 
total add billing value 
add payment info events 
add to wishlist events 
add to cart events 
total add to cart value 
total button click value 
checkout events

 

Geographic data

Example

Geographic data
Dimensions
date
ad group id
ad group name
ad id
ad name
ad text
advertiser id
advertiser name
campaign id
campaign name
campaign objective type
country code
country name
date
Metrics
clicks
cost
impressions

Gender data

Example:

Gender data
Dimensions
date
ad group id
ad group name
ad id
ad name
ad text
advertiser id
advertiser name
campaign id
campaign name
campaign objective type
gender
date
Metrics
clicks
cost
impressions

 

As always, please contact us via our live chat on our website or via email if you still have doubts or questions. We are happy to help!