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

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) / 100, 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

Java client dont have every segment in report response

I could't find the segments.ad_network_type on the SearchAds360Row resource Any thoughts -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message becaus

JSON return from Google Ads API is malformed

Hi, I am getting a malformed json after making a successful call to the API. The return json has the entire Body section in quotes - see the images attached. Do I need to alter my request or should I just handle this with text manipulation first, then read the file as a json after? -- -- =~=~