The FACEBOOK_INSIGHTS_ACTION_VALUES Table Is Missing From the Schema Tab

Issue

The FACEBOOK_INSIGHTS_ACTION_VALUES table is missing from the Schema tab in Fivetran.

Environment

Connector: Facebook Ads

Resolution

To resolve this issue, include action_type as an action breakdown and action_values as a field in your custom report:

1. In Fivetran, go to your Facebook Ads connection page.
2. Select the Setup tab.
3. Click Edit connection details.
4. Locate your custom report and click Edit.
5. Click Next.
6. In the Action Breakdowns drop-down menu, select action_type.
7. Select action_values and any other metrics you want to include.
8. Click Save & Test.
9. Go to the Schema tab.
10. Find the FACEBOOK_INSIGHTS_ACTION_VALUES table and click Re-sync.
11. In the confirmation pop-up window, click Start re-sync.

For more information about how breakdowns affect report results, see How Can I Ensure My Custom Report Matches the Report I See in Facebook?.

Cause

This issue occurs when your custom report does not include the action_type action breakdown. When this happens, the Meta API omits action_values data, so Fivetran has no data to populate the secondary table.

When both action_type (under Action Breakdowns) and action_values (under Fields) are included, Fivetran creates a secondary table using one of the following naming formats:

• <REPORT_NAME>_action_values
• <REPORT_NAME>_facebook_insights_action_values (older connections)