Pulling Daily Metrics Data while accounting for 7-day attribution

[Nathaniel Soon]

Hey all, first time working with the Google ads API through Mixed Analytics. Use case is that I'm trying to pull data on a daily basis to feed into a historical record of Google Ads performance data. 

What I've done at this point is to export the historical data from Google Ads Manager platform from a certain date, and have set up the API call to pull for "where segments.date during yesterday". But checking the daily data over the past few days, there are metrics that come in later on (whether impressions or conversions) so the data that was pulled into the sheet is now "under-reporting". 

My understanding is that this happens because of the 7-day attribution window. Question: Is there a better suggested way to set up the API call to account for this? 

I'm also open to other suggestions, as I'm not fully aware of the limitations and don't know what the typical best practice is for Ad reporting or data pulling 😅

For context, here's the request body for the API call.

{"query": " SELECT campaign.id, campaign.name, segments.date, metrics.cost_micros, metrics.impressions, metrics.clicks, metrics.interactions, metrics.conversions, metrics.all_conversions, metrics.all_conversions_value, metrics.bounce_rate, metrics.search_impression_share, metrics.top_impression_percentage, metrics.absolute_top_impression_percentage, metrics.search_top_impression_share, metrics.search_absolute_top_impression_share, metrics.search_budget_lost_impression_share, metrics.search_budget_lost_absolute_top_impression_share, metrics.search_rank_lost_impression_share, metrics.search_rank_lost_absolute_top_impression_share, metrics.search_budget_lost_top_impression_share, metrics.search_rank_lost_top_impression_share FROM campaign WHERE segments.date DURING YESTERDAY "
}

[Google Ads API Forum Advisor]

Hi Nathaniel,

Under reporting and over reporting issues are based on product support's data freshness guide. The API can only be a conduit for the product. For best practices you may reach out to product support's.

Regards,

Aryeh Baker Google Ads API Team

ref:_00D1U1174p._5004Q2TKvxB:ref