Issue

The conversions and actions fields are configured in the setup, but they are not synced to the warehouse.

Environment

Connector: Facebook Ads

Resolution

A custom report must be configured with certain fields. The data will then be outputted in a child table to the main report table.

Required fields in Custom Report

• action_type from the Action Breakdowns selection
• For conversions data: action_values from the Fields selection
• For action data: actions from the Fields selection.

How the data will look in the warehouse

A table will be created with the name report_name_<field>. This will contain a column action_type. From here you can view the values and type of the action_values or actions.

Additional Info

• Facebook's action_values field is "the total value of all conversions attributed to your ads".
• Facebook's actions field is "the total number of actions people took that are attributed to your ads. Actions may include engagement, clicks or conversions."
• Facebook's action_type breakdown is "the kind of actions taken on your ad, Page, app or event after your ad was served to someone, even if they didn't click on it. Action types include Page likes, app installs, conversions, event responses, and more."

Info can be found in Facebook Marketing API - Ads Action Stats documentation.

Additional notes: modifying a report

It is not recommended to modify a current connector as small changes in metrics (adding/removing fields) can result in changes to the aggregation of data which can appear as discrepancies with the UI.
To ensure data integrity, a re-sync will be required. 

Cause

If you select an action breakdown and field or fields, Fivetran creates a secondary table or tables. We name secondary tables with the main table name appended with the field names.

We create separate tables for fields of the list<AdsActionStats> and list<AdsHistogramStats> types listed in the Facebook's field documentation.

The action breakdowns are columns in the table, and the field value is the number of actions to occur.

This is outlined in Facebook Ads - Report schema information.