---
title: TikTok Ads BigQuery Tables Documentation
description: When importing TikTok Ads data into BigQuery via Dataslayer, you may get an &quot;invalid parameters combination&quot; error if you select certain dimensions and metrics that cannot be used together. The error
---

[Skip to content](https://support.dataslayer.ai/tiktok-ads-bigquery-tables-documentation#main-content)

- [English](https://support.dataslayer.ai/tiktok-ads-bigquery-tables-documentation)
- [Español](https://support.dataslayer.ai/es/documentación-de-las-tablas-de-bigquery-para-tiktok-ads)

English

Show submenu for translations

[![Dataslayer](https://support.dataslayer.ai/hs-fs/hubfs/Dataslayer_New_Logo.png?height=35&name=Dataslayer_New_Logo.png)](https://www.dataslayer.ai/)

Open main navigation

Close main navigation

- - [English](https://support.dataslayer.ai/tiktok-ads-bigquery-tables-documentation)
    - [Español](https://support.dataslayer.ai/es/documentación-de-las-tablas-de-bigquery-para-tiktok-ads)

  English
  
  Show submenu for translations

 Hello. How can we help you?

- There are no suggestions because the search field is empty.

1. [Knowledge base](https://support.dataslayer.ai/?hsLang=en)
2. [Data Sources](https://support.dataslayer.ai/data-sources?hsLang=en)

May 28, 2024

# 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](https://dataslayer.ai/) or via [email](mailto:info@dataslayer.ai) if you still have doubts or questions. We are happy to help!

- [General](https://support.dataslayer.ai/general?hsLang=en)
- [Billing & Pricing](https://support.dataslayer.ai/billing-pricing?hsLang=en)
- [Data Sources](https://support.dataslayer.ai/data-sources?hsLang=en)
- [Blended Connectors](https://support.dataslayer.ai/blended-connectors?hsLang=en)
- [Google Sheets](https://support.dataslayer.ai/google-sheets?hsLang=en)
- [Microsoft Excel](https://support.dataslayer.ai/microsoft-excel?hsLang=en)
- [Spreadsheets](https://support.dataslayer.ai/spreadsheets?hsLang=en)
- [Looker Studio](https://support.dataslayer.ai/looker-studio?hsLang=en)
- [Big Query](https://support.dataslayer.ai/big-query?hsLang=en)
- [API Query Manager](https://support.dataslayer.ai/api-query-manager?hsLang=en)
- [Power BI](https://support.dataslayer.ai/power-bi?hsLang=en)
- [Amazon S3](https://support.dataslayer.ai/amazon-s3?hsLang=en)
- [Amazon Redshift](https://support.dataslayer.ai/amazon-redshift?hsLang=en)
- [Snowflake](https://support.dataslayer.ai/snowflake?hsLang=en#main-content)

    - [Marketplace](https://support.dataslayer.ai/snowflake?hsLang=en#marketplace)
- [Google Cloud Storage](https://support.dataslayer.ai/google-cloud-storage?hsLang=en)
- [Database](https://support.dataslayer.ai/database?hsLang=en)
- [Azure SQL](https://support.dataslayer.ai/azure-sql?hsLang=en)
- [Azure Storage](https://support.dataslayer.ai/azure-storage?hsLang=en)
- [Dataslayer Atlas](https://support.dataslayer.ai/dataslayer-atlas?hsLang=en)
- [Morpheus](https://support.dataslayer.ai/morpheus?hsLang=en)
- [AI Looker Studio Analyzer](https://support.dataslayer.ai/ai-looker-studio-analyzer?hsLang=en)
- [Dataslayer MCP](https://support.dataslayer.ai/dataslayer-mcp?hsLang=en)
- [Dataslayer GPT](https://support.dataslayer.ai/dataslayer-gpt?hsLang=en)
- [Dataslayer AI Chat](https://support.dataslayer.ai/dataslayer-ai-chat?hsLang=en)

[![Chill listening crop-3](https://support.dataslayer.ai/hs-fs/hubfs/Dataslayer_New_Logo.png?width=142&height=24&name=Dataslayer_New_Logo.png "Chill listening crop-3")](https://dataslayer.ai/)

Dataslayer.ai: Digital Marketing Reporting Made Easy

<https://www.linkedin.com/company/dataslayer/> <https://www.youtube.com/@dataslayers>

Copyright © 2026, DATASLAYER SL