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:
|
Conversion 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 |
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!