Question

I have attempted to create a Custom Report in Facebook Ad Insights and included the field outbound_clicks. This field is 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