Missing Sums on Facebook Ads Campaign Reports

Missing Sums on Facebook Ads Campaign Reports

Info
Facebook's attribution reporting has undergone some changes that may affect your reports. This article will help you understand how to compensate for new challenges with their API.



This article will help you to resolve the following problem:

You may see zeroes or null values (dashes) in your Facebook Ads report.

Why has my report changed?

On April 26, 2021, Facebook updated their attribution capabilities to compensate for changes in Apple's iOS14.  Facebook users are now required to opt-in to tracking. Very few have opted in. Facebook is transitioning over to SKAdNetwork reporting, which tracks events and allows marketers to track attribution without the now-hidden device information. 

Ads data that was gathered before April 26, 2021 can still be sorted by "on impression date" or "on conversion date" while data gathered after April 26, 2021 can only be sorted by "on conversion date."

Power My Analytics will always do as much as we can to help you to get the best reports out of your data. We are continuously updating our connectors to do just that.

Cause

  1. Facebook does not provide sums for ad campaigns for multiple attribution settings. For example, if you have one ad campaign set to 7 day click, 1 day view, and another with 1 day click, 1 day view, then Facebook will not be able to calculate those together. 
  2. Specific settings are now required in order to accurately combine data generated before and after the change.
  3. Additionally, Results fields may no longer work.

Resolution

If it is necessary to have these sums, choose a specific Attribution Window in your Facebook Ads configuration (see step 1 below), or align all of the attribution settings in your Facebook Ads Manager account. With either approach, every ad set reports on the same attribution window, so the sums can populate.
Info
You can use our sheets add-on solution to create conversion scorecards in Facebook Ads.

Check your Facebook Ads dashboard. If there is a zero or dash on your dashboard, we will show the same.



If there is a number on your Facebook Ads dashboard, try these steps:

1. Set Attribution Window to a specific window, such as 7 Day Click or 7 Day Click + 1 Day View, in your Facebook Ads configuration. You'll find it next to Action Attribution Setting in your Data Studio data source, the Google Sheets and Microsoft Excel add-ons, and Data Builder. Every ad set then reports conversions on that same window, so campaign and account totals can add up. Note that unique metrics (such as Unique Purchases) read 0 on click + view options. To learn more, see Choose an Attribution Window.
2. If your numbers still do not align with what is shown on Facebook Ads, submit a ticket. Include:
  1. A screenshot from Facebook Ads
  1. A screenshot from Data Studio
  1. Edit level access to your Data Studio report
  1. The page number where you see the inconsistency