the values getting from the campaign reports and values present in Google ads API are different.

[Virat Chowdary]

Hi, 

   I'm trying to retrieve the data from the campaign reports through stream search. right now I'm able to get the results but metrics.cost_micros values are incorrect when I compared them with the cost value present in the Google Ads API Account (UI). I don't know why I'm getting different results. this is the query I returned for that:

GA_attributes = 'customer.descriptive_name, metrics.average_cost,metrics.average_cpc, metrics.cost_micros'
query = f"SELECT {GA_attributes} FROM campaign WHERE segments.date ='2022-06-26' ORDER BY campaign.id"

Can anybody help me out here on how to proceed with this? 

[Google Ads API Forum Advisor]

Hi Virat,

Thank you for raising this concern to the Google Ads API support team.

To investigate this discrepancy, could you please provide the complete API request and response logs with request-id and login-customer-id that generated on your end? Also, the screenshot of the Google Ads UI where we can see the different results? This information will help our team to better check this.

If you haven't yet, logging can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation, which you can access from this link. You can provide it via the Reply privately to author option. If this option is not available, then send it instead on this email address googleadsapi-support@google.com.

Best regards,

Jinky Google Ads API Team

ref:_00D1U1174p._5004Q2cDymC:ref