Exponential format for conversion_value

[Oksana Sulyma]

Hello Google Ads API team!

I get "conversionsValue":1.0000000000000001e-05 querying landing_page_view (Ads API). 

Request:
{"customerId":"hidden","query":"SELECT campaign.id, ad_group.id, expanded_landing_page_view.expanded_final_url, landing_page_view.unexpanded_final_url, segments.ad_network_type, segments.date, metrics.speed_score, metrics.clicks, metrics.cost_micros, metrics.impressions, metrics.all_conversions, metrics.conversions, metrics.conversions_value, metrics.cross_device_conversions, metrics.mobile_friendly_clicks_percentage, metrics.valid_accelerated_mobile_pages_clicks_percentage FROM landing_page_view WHERE segments.date>='2022-01-20' AND segments.date<='2022-01-20'  ORDER BY segments.date DESC "}

I wonder if there is some API setting to not get numbers in exponential format.

Can provide more details of request / response if needed. 

Please help!

Thanks,

Oksana

[Google Ads API Forum Advisor]

Hi Oksana,

Thank you for posting your concern.

To take a closer look at the issue, could you provide the complete request and response logs with request ID and request header generated on your end where we can see the value that you are referring to?

Regards,

Ernie John Google Ads API Team

ref:_00D1U1174p._5004Q2Wxgl6:ref

[Google Ads API Forum Advisor]

Hi Oksana,

Also, please provide the information that I requested via Reply privately to author option. If this option is not available, then send it instead on this email address googleadsa...@google.com.

[Oksana Sulyma]

Hi Ernie!

Sent the details in private message, thank you!

[Google Ads API Forum Advisor]

Hi Oksana,

Thanks for getting back to us with the requested information.

Allow me to raise the behavior observed with my team. We will reach out to you as soon as possible.

In the meantime, you may also consider converting to number format as mentioned in this stackoverflow thread for further processing in PHP code.

Regards,

Yasar Google Ads API Team

ref:_00D1U1174p._5004Q2Wxgl6:ref

[Oksana Sulyma]

Thanks Yasar! 

Yes we added number format conversion at our side, but we are still interested in this question comments from your team!

Thanks,

Oksana

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to a topic in the Google Groups "Google Ads API and AdWords API Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/adwords-api/3pkEdYQui8o/unsubscribe.
To unsubscribe from this group and all its topics, send an email to adwords-api...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/SvvOR000000000000000000000000000000000000000000000R7QOBJ00X6X7nLb8TF6MVlFYiMuJZw%40sfdc.net.

[Google Ads API Forum Advisor]

Hi Oksana,

I'll file an issue to see if we can get it fixed. Meanwhile, please use the workaround you are using to convert from exponential format to regular numeric format.

Cheers
Anash

ref:_00D1U1174p._5004Q2Wxgl6:ref

[Oksana Sulyma]

Hi Anash, thanks for the update!

Is there any resource where we can track the progress on this issue?

Thanks,

Oksana

[Google Ads API Forum Advisor]

Hi Oksana,

You can either ask on this thread for updates in the future, or keep an eye on our release notes for newer API versions: https://developers.google.com/google-ads/api/docs/release-notes

If I get an earlier update on a change in behaviour, I can also share updates on this thread.
 

[Oksana Sulyma]

Hello! Just wanted to ask for updates on my question! The more reports types we request fromAds API, the more cases of ConversionValue field in exponential format we see. And it doesn't seem to happen for any other reports fields. 

Thanks for any info on this question!

Oksana