Retrospective data / total costs changing when running query vs. Google Ads dashboard - Google Ads V10

[Matt Osborne]

Hi,

I am having issues with results being returned from the Google Ads API (I am currently using v10) appearing to change when running queries either for different date ranges and/or running the same query on a different day.

For example, I could run the below query to get data for the 9th & 10th May, but when I run the same query again for the past 60 days, the figures being returned for the 10th May are different to my original results.

        SELECT

            ad_group.name,

            campaign.name,

            segments.date,

            campaign.id,

            ad_group.id,

            segments.ad_network_type,

            metrics.clicks,

            metrics.cost_micros,

            metrics.impressions

        FROM ad_group

        WHERE segments.date BETWEEN '2022-05-09' AND '2022-05-10'  

Not only are the two API call results different for the 10th May activity, the total cost in the Google Ads dashboard reports is different to the two API results?

It is not every single day in the date range that is incorrect, there appear to be individual days that seem to be changing in value in both what the API returns as well in the Google Ads dashboard.

I have examples of the above behaviour with the results from the API, screen grabs of the dashboard as well as the log files from the API calls, so any help would be appreciated.

Thanks in advance.

Matt

[Google Ads API Forum Advisor]

Hi Matt,

Thank you for reaching out to us.

For our team to further investigate and to compare the degree of the discrepancy, could you provide our team with the complete UI/Google Ads dashboard screenshot and complete API logs you are referring to that generated on your end (request and response logs with request ID) so our team can compare the exact data both UI and API retrieve?

You may then send the requested information via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Best regards,

Heidi Google Ads API Team

ref:_00D1U1174p._5004Q2bvkeL:ref