ReportDefinition "Cost" field format change?

[stiggywigget]

Cost field is a decimal value "7.44" in XML format for API v201309 (PHP)

Cost field is a integer value "7440000" in XML format for API v201402 (PHP)

I haven't found an explanation for this change.

TIA.

[Jean-Fabrice Rabaute]

The money fields are returned in micro starting with v201402 API:

https://developers.google.com/adwords/api/docs/guides/reporting-concepts?hl=lt (see section "Money fields in reports")

Starting with v201402, fields of type Money are returned in micro currency units (micros) by default, e.g.: $1.23 will come back as 1230000 (1.23 x 1,000,000). The header value that determines whether money fields are returned in micros or whole dollar (1.23) currency units is returnMoneyInMicros; setting this to true (default) selects micros. Micro amounts always refer to the account's local currency.

Hope this helps.

Cheers.

--

Fabrice.

https://www.sunnyreports.com/

[stiggywigget]

The docs clearly state that for a CAMPAIGN_PERFORMANCE_REPORT field "Cost" is type Money.

$user->LoadService('ReportDefinitionService', ADWORDS_VERSION);

// Create selector.

$selector = new Selector();

$selector->fields = array('CampaignId', 'CampaignName', 'Status', 'Clicks', 'Cost', 'Date');

// Report definition.

$reportDefinition = new ReportDefinition();

$reportDefinition->reportName = 'Report';

$reportDefinition->dateRangeType = 'LAST_7_DAYS';

$reportDefinition->reportType = 'CAMPAIGN_PERFORMANCE_REPORT';

$reportDefinition->downloadFormat = 'XML';

$reportDefinition->selector = $selector;

$xml_data = DownloadReport($user, $reportDefinition);

For v201309:

    <row campaignID='1234' campaign='Cmp Name' campaignState='active' clicks='15' cost='40.24' day='2014-06-30' />

For v201402:

    <row campaignID='1234' campaign='Cmp Name' campaignState='active' clicks='15' cost='40240000' day='2014-06-30' />

Please help!

[stiggywigget]

Minor correction. 

$xml = ReportUtils::DownloadReport($reportDefinition, $filepath = NULL, $user, NULL);

[Oliver]

In the v201402 release notes:

https://developers.google.com/adwords/api/docs/reference/

there is a section that says:

ReturnMoneyMicros defaults to true

Money fields will be returned in micros by default. You can enable the old behavior by sending the ReturnMoneyMicros header with the value of false. Note: This field will be removed in the future.

Maybe that's what happened?

Oliver

[Danial Klimkin]

Oliver is correct, this has been changed as outlined on the release notes and in the migration guide:

  https://developers.google.com/adwords/api/docs/guides/migration/v201402

For v201402 you can send "returnMoneyInMicros: false" to see the old behavior. In the next API version this header will no longer be valid, so we recommend migrating to micros as soon as possible.

-Danial, AdWords API Team.

[stiggywigget]

Thanks all. Obviously the change was well documented.

-Kirk