Facebook Ads Error: Table Reports Are Causing a Change in the Sync Level

While modifying an existing Facebook Ads custom report, the following error may appear:

The newly selected table report fields/breakdowns/action breakdowns are causing a change in the sync level. You are attempting to change the level for table <table_name> from <level1> to <level2> by adding new fields/breakdowns/action breakdowns. This is not possible because it requires a change in the primary key for the report table. Our recommendations are as follows: 1. Remove fields [<culprit field>], breakdowns [<culprit field>], action breakdowns [<culprit field>] that have been added. 2. Create a new report with your required fields/breakdowns/action breakdowns.

What causes the Table reports are causing a change in the sync level error?

We query data from Facebook's API at different levels depending on the fields, breakdowns, or action breakdowns you include in your custom report:

• We query data at anAd level if you include the ad_id or ad_name fields, the product_id breakdown, or the action_target_id action breakdown.
• We query at an Ad Set level if you include the adset_id or adset_name fields.
• We query at a Campaign level if you include the campaign_id, campaign_name, or any objective fields.
• We query at an Account level if you do not include any of the fields mentioned above.

The level at which we query data also impacts the corresponding table's primary key in the destination. As a result, this issue may occur when you add or remove fields that may change the level of data we query from Facebook's API. To learn more, see Fetching Facebook Ads reports at different levels.

How to resolve the Table reports are causing a change in the sync level error?

To resolve this issue, do the following:

1. Remove the new fields, breakdowns, or action breakdowns you added to the custom report.
2. Save the report.
3. Create a new custom report with your required fields, breakdowns, and action breakdowns. For more information, see our Facebook Ads Custom Reports documentation.