Documentación de tablas de TikTok Ads en BigQuery
Al importar datos de TikTok Ads a BigQuery utilizando Dataslayer, puede producirse un error de "invalid parameters combination" (combinación de parámetros no válidos) si se seleccionan determinadas dimensiones y métricas que no pueden utilizarse conjuntamente.
El error de "invalid parameters combination" proviene de la API nativa de la fuente de datos, no de Dataslayer.
Las fuentes de datos agrupan las métricas y dimensiones en grupos. Todas las métricas del mismo grupo tendrán la misma compatibilidad con las métricas de otros grupos.
Para evitar este error, puedes importar las siguientes tablas:
Datos de anuncios
Ejemplo:
| Tabla de datos de anuncios |
|---|
| 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 |
Datos geográficos
Ejemplo:
| Tabla de datos geográficos |
|---|
| 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 |
Datos de género
Ejemplo:
| Tabla de datos de género |
|---|
| 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 |
Actualizado el: 19/01/2024
¡Gracias!