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:

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
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
platform position
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
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

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
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/05/2023