What time to stop updating history data?

[SZ bcwldata]

SELECT customer.id,
            customer.descriptive_name,
            customer.currency_code,
            campaign.id,
            campaign.name,
            ad_group.id,
            ad_group.name,
            metrics.clicks,
            metrics.cost_micros,
            metrics.impressions,
            metrics.conversions
        FROM ad_group
        WHERE segments.date = '{begin_dt}'

When I query this SQL at 9:00 AM to retrieve yesterday's data, the metrics.cost_micros differs from the Google Ads UI.

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

From the provided query, you have encountered data discrepancy with the cost metrics report views.

In order to assist you further, please provide us with the uncropped UI screenshot with visible customer ID of the report that you are trying to replicate via the Google Ads API.

You can send the details via Reply privately to the author option, or direct private reply to this email.

This message is in relation to case "ref:!00D1U01174p.!5004Q02vEGlg:ref" (ADR-00259894)

Thanks,
 

Google Ads API Team