How Can I Sync Custom Conversions Data?

Question

How can I sync Facebook custom conversions data?

Environment

Connector: Facebook Ads

Answer

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

NOTE: 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 connector to include custom conversions, do the following:

1. In the connector dashboard, go to the Setup tab.
2. Click Edit connection details and add a new Custom Report table.
3. Under Action Breakdowns, include action_type.
4. Under Fields, include actions and any other required fields.
5. Click Save.
6. In the destination, locate the secondary table <custom_report_name>_actions.

   NOTE: Fivetran creates secondary tables for actions because it is considered a part of the list AdsActionStats field.

7. Search for offsite_conversion.custom.* under the action_type column to find different conversions based on their IDs.