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 or via email if you still have doubts or questions. We are happy to help!