actions fields are configured in the setup, but they are not synced to the warehouse.
Connector: Facebook Ads
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_typefrom the Action Breakdowns selection
- For conversions data:
action_valuesfrom the Fields selection
- For action data:
actionsfrom 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.
action_valuesfield is "the total value of all conversions attributed to your ads".
actionsfield is "the total number of actions people took that are attributed to your ads. Actions may include engagement, clicks or conversions."
action_typebreakdown 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.
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<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.