When importing Facebook Ads 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:

Note: The Facebook Ads connector allows you to analyze data from both Instagram and Facebook ads. All tables that include the dimension "publisher platform" indicate the platform on which the Ad is located.

If you want to isolate only Facebook or Instagram data, you can filter on the tables that include the "publisher platform" dimension to isolate only the platform you are interested in.

Basic Fields

This table contains the basic data of a Meta campaign and its ads.

Example:

Basic Fields data table
Dimensions
date
campaign name
adSet name
ad name
ad ID
campaign ID
adSet ID
objective
buying type
ad status
ad set status
campaign status
publisher platform
Metrics
impressions
clicks
CTR (all)
CPC
CPM
total cost
actions
conversion rate ranking (number)
return on ad spend (ROAS)
frequency
unique clicks
unique CTR (all)

Placement Fields

This table contains information about the placement of an advertising campaign.

Example:

Placement Fields data table
Dimensions
date
campaign name
ad set name
ad name
device platform
publisher platform
targeting device platforms
targeting publisher platforms
Metrics
impressions
clicks
CTR (all)
CPC
CPM
social spend
conversion rate ranking (number)
total cost
ROAS
frequency
reach
unique clicks
unique CTR (all)
unique inline link clicks

Creative Fields:

This table contains information about creatives

Example:

Creative Fields data table
Dimensions
date
campaign name
adset name
ad name
ad creative image
publisher platform
Metrics
impressions
clicks
CTR (all)
CPC
CPM
social spend
total cost
conversion rate ranking (number)
ROAS
frequency
reach
unique clicks
unique CTR (all)
link clicks

Audience Age and gender

This table contains information about your ads audience. Note that this table does not work with the "publisher platform" dimension.

Example:

Audience Age and gender data table
Dimensions
account id
account name
action type
ad id
ad name
campaign id
campaign name
adset id
adset status
age
objective
date
gender
Metrics
clicks
total cost
impressions
on facebook leads
reach

Conversion Fields

This table contains information about conversions

Example:

Coversion Fields data table
Dimensions
date
campaign name
adset name
ad name
action type
publisher platform
Metrics
impressions
clicks
CTR (all)
CPC
CPM
social spend
conversion rate ranking (number)
total cost
ROAS
frequency
reach
unique clicks
unique CTR (all)
unique inline link clicks

Updated on: 10/08/2023