Airbyte is an open-source data integration engine that helps you consolidate your data in your data warehouses, lakes and databases.

Airbyte

*Facebook Spend not matching Ads Manager??*
I am syncing from facebook to BQ in two ways (same source) and then BigQuery &amp; BigQuery Denormalized  destinations. Both are providing data daily for weeks, no problems with the sync.

However, if I compare my monthly totals for Oct, Nov &amp; Dec to those reported in the Facebook Ads Manager Reporting Interface - they are off. For example, in facebook Ad Manager Nov total is $3,069. In denormalized &amp; standard bigquery tables (Ad Insights) my Nov total is $2432.41 in both cases. What can account for this difference?? I am using the __airbyte__emitted_at field within my WHERE statements as well.

Any ideas?

Hi, what are your replication settings for the Facebook connector?

I had an issue like this when using LinkedIn and Incremental load.

I think for Facebook you can set a lookback window.

Hey <@U04AR745G3Y> did you determine what the issue was? If not then please share your replication settings, and a sync log in case there is info about the missing data.

I believe this is related to attribution window issues, and giving the reports 72hr for accurate data to come in.

Sounds good, feel free to share here if we can help

hi did you ever have feedback on this? we are experiencing similar issues and have setup the atribution window to the maximum of 28 days just in case
we see that it works ok for a while and when the time from the start date is greater than the window we start to lose data

also there is a timezone issue, we have a customer in australia so when airbyte goes to look data for UTC today it misses that in the TZ of the customer its already _tomorrow_ and the API works with the TZ set by the user :confused: