How Can I Sync Facebook Custom Conversions Data?

Custom conversions data is available through Facebook's Graph API using the offsite_conversion.custom.<custom_conv_id> action in the action_type field. For more information, see Facebook's Ad Action Stats documentation.

The custom conversions data we receive doesn't include the name of the custom conversion, but rather the ID in the following format: offsite_conversion.custom.<custom_conv_id>. The ID represents the custom conversion ID defined by the advertiser.

To configure your connection to include custom conversions, do the following:

In the connector dashboard, go to the Setup tab.
Click Edit connection details and add a new Custom Report table.
Under Action Breakdowns, include action_type.
Under Fields, include actions and any other required fields.
Click Save.
In the destination, locate the secondary table <custom_report_name>_actions.
Fivetran creates secondary tables for actions because it is considered a part of the list AdsActionStats field.
Search for offsite_conversion.custom.* under the action_type column to find different conversions based on their IDs.