Summary
Custom insights schema in Facebook Marketing source sets ‘ad_id’ as primary key regardless of breakdown level, resulting in ‘ad_id’ field being null in BigQuery table.
Question
Hi all!
When adding custom insights to Facebook Marketing source, the schema seems to always set the custom streams’ schema with an ‘ad_id’ as primary key, even when selecting ‘campaign_id’ or other as the breakdown level. Furthermore, the ‘ad_id’ field in the final BigQuery table is always null, even when selecting ‘ad_id’ as the breakdown dimension level. Am I the only one experiencing this?
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.