When importing Facebook insights data into BigQuery using Dataslayer, you may encounter an "invalid parameters combination" error if you select certain dimensions and metrics that cannot be queried together.

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

Data sources group metrics and dimensions into groups. All metrics in the same group will have the same compatibility with metrics in other groups.

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
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
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
Metrics
Post comments
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
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
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
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 about your audience on Facebook. You can do a table with the dimension Country or with 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:

Location insights
Dimensions
Date
Age
Gender
Gender Age
Page name
Page ID
Metrics
Total likes
Total reach

Updated on: 08/09/2023