---
title: Facebook Insights BigQuery tables documentation
description: When importing Facebook Insights 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
---
[Skip to content](https://support.dataslayer.ai/facebook-insights-bigquery-tables-documentation#main-content)
- [English](https://support.dataslayer.ai/facebook-insights-bigquery-tables-documentation)
- [Español](https://support.dataslayer.ai/es/documentación-de-tablas-de-facebook-insights-en-bigquery)
English
Show submenu for translations
[](https://www.dataslayer.ai/)
Open main navigation
Close main navigation
- - [English](https://support.dataslayer.ai/facebook-insights-bigquery-tables-documentation)
- [Español](https://support.dataslayer.ai/es/documentación-de-tablas-de-facebook-insights-en-bigquery)
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 17, 2024
# Facebook Insights BigQuery tables documentation
When importing Facebook Insights 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:
> ### **Advanced Engagement**
This table contains advanced engagement of your posts and pages on Facebook.
Example:
| **Advanced Engagement data table** |
| --- |
| **Metrics** |
| Post Engagements |
| Total Post Reactions |
| Post Shares |
| Post Comments |
| Total Video Views |
| Total Impressions |
| Total Reach |
| Engaged users |
| **Dimensions** |
| Date |
| Post Type |
| Post Creation Time |
| Post ID |
| Post Name |
| Post Description |
| Post Status Type |
| Post thumbnail URL |
| Post Image URL |
| Post Image |
| Post Message |
| Page Name |
| Page ID |
> ### **Audience Insights**
This table contains information to obtain insights about your audience.
Example:
| **Audience Insights data table** |
| --- |
| **Metrics** |
| Total Likes |
| Page Post Engagements |
| Total impressions |
| Total Reach |
| Total Page Views |
| Page Followers |
| Page comments |
| Page shares |
| Clicks |
| Organic reach |
| Organic impressions |
| Paid impressions |
| Paid reach |
| Unlikes |
| Engaged users |
| Viral impressions |
| Viral reach |
| Viral impressions of posts |
| Viral reach of posts |
| Non-viral impressions |
| Non-viral reach |
| Non-viral reach of posts |
| Non-viral impressions of posts |
| Total impressions of posts |
| Paid impressions of posts |
| Total reach of posts |
| Paid reach of posts |
| Organic impressions of posts |
| Organic reach of posts |
| Negative actions |
| Positive actions |
| Check-ins |
| Check-ins using mobile |
| People checking in |
| People checking in using mobile |
| People visiting your page |
| **Dimensions** |
| Date |
| Page Name |
| Page ID |
> ### **Post Engagement**
This table contains an exhaustive engagement about your posts on Facebook.
Example:
| Post Engagement data table |
| --- |
| Metrics |
| Metrics |
| Post shares |
| Post link clicks |
| Post unique link clicks |
| Post other clicks |
| Post unique other clicks |
| Post reactions: angry |
| Post reactions: haha |
| Post reactions: like |
| Post reactions: love |
| Post reactions: sad |
| Post reactions: wow |
| Total post reactions |
| **Dimensions** |
| Date |
| Post creation time |
| Post Description |
| Post Image URL |
| Post ID |
| Post shared link |
| Link to post |
| Post Message |
| Post name |
| Post object ID |
| Post thumbnail URL |
| Post Privacy |
| Post status type |
| Post story |
| Post type |
| Page name |
| Page ID |
> ### **Post comments**
This table contains information about the comments on your Facebook posts.
Example:
| **Post Comments data table** |
| --- |
| **Metrics** |
| Post Comments |
| **Dimensions** |
| Date |
| Post comment author |
| Post comment date |
| Post comment text |
| Post comment time |
| Post ID |
| Post name |
| Page ID |
| Page name |
> ### **Video Engagement**
This table contains an exhaustive engagement about your videos on Facebook.
Example:
| **Video Engagement data table** |
| --- |
| **Metrics** |
| Total video view time (s) |
| Total video views |
| Unique video views |
| Paid video views |
| Auto-played video views |
| Clicked to play video views |
| Total 10s video views |
| Unique 10s video views |
| Organic 10s video views |
| Paid 10s video views |
| Auto-played 10s video views |
| Clicked to play 10s video views |
| 10s video views with sound on |
| Total video views with sound on |
| Total 30s video views |
| Unique 30s video views |
| Organic 30s video views |
| Paid 30s video views |
| Auto-played 30s video views |
| Clicked to play 30s video views |
| Total video reactions |
| Video reactions: like |
| Video reactions: love |
| Video reactions: wow |
| Video reactions: haha |
| Video reactions: sad |
| Video reactions: angry |
| **Dimensions** |
| Date |
| Video length (s) |
| Video title |
| Universal video ID |
| Video ID |
| Video description |
| Video content category |
| Video live status |
| Video post publish status |
| Video image URL |
| Video source URL |
| Video permalink URL |
| Video embeddable |
| Video embed HTML |
| Is crossposting eligibility |
| Is Instagram eligibility |
| Video creation time of the day |
| Video backdated time |
| Page ID |
| Page name |
> ### **Reels Engagement**
This table contains an exhaustive engagement about your reels on Facebook.
Example:
| **Reels Engagement data table** |
| --- |
| **Metrics** |
| Reels play count |
| Reels Unique Impressions |
| Reels average video time watched |
| Reels likes |
| Reels Shares |
| Reels total view time |
| **Dimensions** |
| Date |
| Video length (s) |
| Video title |
| Universal video ID |
| Video ID |
| Video description |
| Video content category |
| Video live status |
| Video post publish status |
| Video image URL |
| Video source URL |
| Video permalink URL |
| Video embeddable |
| Video embed HTML |
| Is crossposting eligibility |
| Is Instagram eligibility |
| Video creation time of the day |
| Video backdated time |
| Video backdated time granularity |
| Page ID |
| Page name |
> ### **Location insights**
This table contains the location of your audience on Facebook. You can do a table with the dimensions of the Country or with the City.
Example:
| **Location Insights Country** |
| --- |
| **Dimensions** |
| Date |
| Country |
| Page name |
| Page ID |
| **Metrics** |
| Total likes |
| Total reach |
| **Location Insights City** |
| --- |
| **Dimensions** |
| Date |
| City |
| Page name |
| Page ID |
| **Metrics** |
| Total likes |
| Total reach |
> ### **Demographic insights**
This table contains demographic information about your audience on Facebook.
Example:
| **Demographic Insights data table** |
| --- |
| **Dimensions** |
| Date |
| Age |
| Gender |
| Gender Age |
| Page name |
| Page ID |
| **Metrics** |
| Total likes |
| Total reach |
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)
[](https://dataslayer.ai/)
Dataslayer.ai: Digital Marketing Reporting Made Easy
Copyright © 2026, DATASLAYER SL