Error: The Newly Selected Table Report Fields/Breakdowns/Action Breakdowns Are Causing a Change in the Sync Level

Issue

While modifying an existing custom report, the following error appears:

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.

Environment

Connector: Facebook Ads

Resolution

To resolve this error, 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.

Cause

We query data from Facebook's API at different levels depending on the fields, breakdowns, or action breakdowns you have included 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, it's not possible to add or remove fields that may change the level of data we query from Facebook's API. See our Facebook Ads documentation for more information.