Issue with results from performance report returning wrong value

33 views
Skip to first unread message

teste...@gmail.com

unread,
Jul 10, 2016, 4:24:31 AM7/10/16
to AdWords API Forum
Hello guys,

When I run the below query:
$reportQuery = "SELECT Date, Cost, Conversions, CostPerConversion, ConversionRate FROM ACCOUNT_PERFORMANCE_REPORT DURING $year, $today";


I get all the accurate data, but for cost and costperconversion i receive some weird data for example.

$178.54 will return as 178540000
$203 will return as 203000000

Is there a reason for this and a way to receive the results correctly formatted.

Thank you.

Joyce Lava

unread,
Jul 10, 2016, 10:24:46 PM7/10/16
to AdWords API Forum
Hi,

The Cost and CostPerConversion and other currency related fields are of type Money. This is represented in micros; one million is equal to one unit. This is the reason why the values are returned as it is. You need to convert them from micros to get the desired format.

Thanks and Regards,
Joyce, AdWords API Team

teste...@gmail.com

unread,
Jul 10, 2016, 10:56:20 PM7/10/16
to AdWords API Forum
Thank you joyce that was it.
Reply all
Reply to author
Forward
0 new messages