Question
I have attempted to create a Custom Report in Facebook Ad Insights and included the field outbound_clicks. Why is this field not being synced to my data warehouse?
Environment
Connector: Facebook Ad Insights
Answer
The field would be synced into a separate table: <schema.table>_<field_name>
Cause
We create separate tables for fields of the type list<AdsActionStats> listed in the Facebook Ad Insights field documentation.
Reference: https://fivetran.com/docs/applications/facebook-ads-insights