Conversions or Action Data Not Synced to Destinationlink
Questionlink
Why are the conversions
and actions
fields configured in the setup not synced to the destination?
Causelink
If you select an action breakdown for a field or fields, Fivetran creates a secondary table or tables. For more information about secondary tables and how Fivetran works with Facebook Ads, see our documentation.
Resolutionlink
To sync the conversions
and actions
fields, your custom report must be configured with certain fields. The data will then be outputted in a child table of the main report table.
Fields required in Custom Report are:
action_type
field from the Action Breakdowns selectionaction_values
field from the Fields selection (for conversions data)actions
field from the Fields selection (for action data)
How will the data look in the destination?link
Fivetran will create a REPORT_NAME_<FIELD>
table. It will contain a column named action_type
, where you can see the values and types of the action_values
or actions
.
Additional Infolink
Facebook Field | Description |
---|---|
action_values | The total value of all conversions attributed to your ads. |
actions | The total number of actions people took that are attributed to your ads. Actions may include engagement, clicks or conversions. |
action_type | 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. |
For information on other Facebook fields, see the official Facebook Marketing API documentation.