How Can I Sync Facebook Pixel Data?

Question

How can I sync Facebook pixel data?

Environment

Connector: Facebook Ads

Answer

We get pixel data from Facebook's Graph API using the offsite_conversion.fb_pixel_* metrics in the action_type field. See Facebook's Ad Action Stats documentation for more information.

Available pixel metrics are listed below:

• offsite_conversion.fb_pixel_add_payment_info
• offsite_conversion.fb_pixel_add_to_cart
• offsite_conversion.fb_pixel_add_to_wishlist
• offsite_conversion.fb_pixel_complete_registration
• offsite_conversion.fb_pixel_custom
• offsite_conversion.fb_pixel_initiate_checkout
• offsite_conversion.fb_pixel_lead
• offsite_conversion.fb_pixel_purchase
• offsite_conversion.fb_pixel_search
• offsite_conversion.fb_pixel_view_content

To configure your Facebook Ads connector to include pixel data, do the following:

1. In your Facebook Ads connector dashboard, go to the Setup tab.
2. Click Edit connection details.
3. Add a new Custom Report table.
4. Under Action Breakdowns, include action_type.
5. Under Fields, include actions and any other required fields.
6. Click Save.
7. 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.

8. Search for offsite_conversion.fb_pixel_* under the action_type column.