I have a data discrepancy between the Facebook UI and Destination. What may be causing this?
Facebook Ad Insights / Facebook Ads
Difference in Aggregation
Verify the aggregation level you are using in your connector config by checking which fields you have configured. When viewing the data in the Facebook UI, you must view it at the same aggregation level to get a correct comparison, or else you may see discrepancies.
Info on aggregation:
Depending on the breakdowns, action breakdowns and fields you selected while configuring the connector, we query at different levels:
Adlevel: If you select the
Adsetlevel: If you select the
Campaignlevel: If you select the
Accountlevel: If you selected none of the fields listed above
NOTE: If you selected fields that correspond to more than one level, we query at the most granular level. For example, if you select both the
adset_idfields, we query on
See our Schema Information docs for more info.
Summing Actions does not give the Sum of all actions
Summing Actions does not actually give you the sum of all actions as the data is hierarchical. This is outlined at the end of the Schema Information of our FB Docs:
Note: The action data is hierarchical: a simple sum of all actions will not equal the field
total_actions. See Actions you can measure in Facebook Ads Reporting for more information.
Use a query which doesn't include a SUM to do your data comparison.