How to get cost and revenue metrics properly from Big query data?

[Analytics Team]

Hi
I have linked GAds account with big query and is using the following logic to get the cost and revenue metrics:
ROUND(SUM(cs.metrics_cost_micros) / 1000000, 2) AS ad_spend, ROUND(SUM(cs.metrics_conversions_value), 2) AS Total_Conversion_Value,

However, the value that shows as a result are not matching with the actual value of Cost and Revenue. Can you please let me know how can I transform this data properly?

Thanks

Asad

[Google Ads API Forum Advisor]

Hi,

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

To check this 'mismatching metrics’ issue further from our end, kindly provide the uncropped UI screenshot where the correct and actual ‘Cost’ and 'Revenue' are presented so that we verify from our end and get back to you.

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.!5004Q02vGh01:ref" (ADR-00273605)

Thanks,
 

Google Ads API Team

[Harvey Nguyen]

Hi GG support team, 

I also faced this issue. Could you please advise?

Thanks,

Harvey N.

[Google Ads API Forum Advisor]

Hi Harvey,

I understand that you are encountering an issue while fetching the cost and revenue metrics using the BigQuery Data Transfer Service for Google Ads.

Note that this concern is out of scope for the Google Ads API support team. So, I would recommend you reach out to the GCP Product support team, as they are better equipped to assist you on this.

Our team can only help you with technical queries or concerns related to direct interaction with the Google Ads API.