Warning: Custom Report Returned No Data - Breakdown Requires Per-Account Enablement

Issue

A Facebook Ads custom report that includes one or more of the following breakdowns syncs successfully but returns no data, and the following Warning appears on the connection dashboard:

Custom Report Returned No Data - Breakdown Requires Per-Account Enablement

The Warning identifies the affected account, table, and breakdowns.

Affected breakdowns:

• impression_device
• hourly_stats_aggregated_by_audience_time_zone
• frequency_value

Environment

Connector: Facebook Ads

Resolution

To resolve this issue, enable the affected breakdowns for each affected ad account in Meta Ads Manager:

1. Go to your Meta Ads Manager account settings.
2. Activate the feature for each breakdown identified in the Warning. Enable each breakdown separately.
3. Repeat for each affected account listed in the Warning.
4. In Fivetran, re-sync the affected tables or wait for the next scheduled sync to confirm that the report now returns data.

Alternatively, remove the affected breakdowns from the custom report:

1. In Fivetran, go to your Facebook Ads connection page.
2. Select the Settings tab.
3. Click Edit connection.
4. Find the custom report, then click Edit.
5. Click Next.
6. In the Breakdowns drop-down menu, remove the affected breakdowns.
7. Click Save & Test.

Cause

Meta requires per-account enablement for certain Ads Insights API breakdowns before they return data. When an account has not enabled a breakdown, the API accepts the request and the sync completes without error, but the report returns no rows. Fivetran raises this Warning instead of a sync failure because the connector behavior is correct: the source returned an empty result.