AdWords Express Data Discrepancies

[Joseph Collins]

A user of our system is seeing a significant disagreement between our data and the AdWords Express interface. Below are user-provided screenshots of the AdWords Express CID in question, its dashboard and our API request / response.

The mismatch between the 'Hayworth Equipment AWX' account description and the 'Hayworth Equipment Sales' account label on the dashboard suggests that this issue is due to user error (navigating to the wrong Express dashboard), but the user is confident they are not making a mistake and they report that these issues affect several of their Express accounts.

For this specific account, you will notice that the API claims activity stopped on October 6th, yet the dashboard shows ongoing activity. On the days where both the dashboard and API show activity, the numbers do not come close to agreeing.

Any help in explaining or resolving this discrepancy would be greatly appreciated.

--------------------------------------------------------------------------------------------------------------------------------

User-Provided Evidence

--------------------------------------------------------------------------------------------------------------------------------

Request

Headers

(

    [0] => Authorization: Bearer XXXXXXXXXXXXXXXXXXXXX

    [1] => developerToken: XXXXXXXXXXXXXXXXXXXXX

    [2] => clientCustomerId: 5571930852

    [3] => includeZeroImpressions: true

)

<reportDefinition>

<selector>

<fields>Date</fields>

<fields>Impressions</fields>

<fields>Clicks</fields>

<fields>Ctr</fields>

<fields>Cost</fields>

<fields>ConversionValue</fields>

<fields>AverageCpc</fields>

<fields>Conversions</fields>

<fields>ConversionRate</fields>

<fields>CostPerConversion</fields>

<fields>ValuePerConversion</fields>

<fields>AveragePosition</fields>

<dateRange>

<min>20170906</min>

<max>20171104</max>

</dateRange>

</selector>

<reportName>Report</reportName>

<reportType>ACCOUNT_PERFORMANCE_REPORT</reportType>

<dateRangeType>CUSTOM_DATE</dateRangeType>

<downloadFormat>GZIPPED_CSV</downloadFormat>

</reportDefinition>

--------------------------------------------------------------------------------------------------------------------------------

Response

"Report (Sep 6, 2017-Nov 4, 2017)"

Day,Impressions,Clicks,CTR,Cost,Total conv. value,Avg. CPC,Conversions,Conv. rate,Cost / conv.,Value / conv.,Avg. position

2017-10-01,25518,37,0.14%,31820000,0.00,860000,0.00,0.00%,0,0.00,1.9

2017-10-04,16918,37,0.22%,33360000,0.00,901622,2.00,5.41%,16680000,0.00,2.2

2017-10-02,15028,37,0.25%,34240000,0.00,925405,0.00,0.00%,0,0.00,2.0

2017-10-06,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-10-13,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-09-17,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-11-03,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-11-02,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-10-26,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-10-03,20683,37,0.18%,33340000,0.00,901081,0.00,0.00%,0,0.00,2.1

2017-09-07,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-09-29,23472,34,0.14%,36070000,0.00,1060882,0.00,0.00%,0,0.00,1.9

2017-10-15,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-09-11,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-10-08,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-09-22,22885,38,0.17%,34380000,0.00,904737,0.00,0.00%,0,0.00,2.1

2017-09-08,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-09-14,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-09-06,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-10-05,436,1,0.23%,850000,0.00,850000,0.00,0.00%,0,0.00,2.2

2017-09-27,25856,28,0.11%,23210000,0.00,828929,0.00,0.00%,0,0.00,1.8

2017-10-27,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-10-30,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-10-25,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-10-14,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-09-15,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-10-09,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-09-13,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-10-12,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-10-20,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-09-24,25445,40,0.16%,33390000,0.00,834750,0.00,0.00%,0,0.00,2.1

2017-09-23,19092,23,0.12%,33870000,0.00,1472609,0.00,0.00%,0,0.00,1.7

2017-09-26,24668,39,0.16%,31860000,0.00,816923,0.00,0.00%,0,0.00,2.0

2017-10-10,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-10-11,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-10-24,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-10-22,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-11-01,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-10-23,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-09-10,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-10-28,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-09-12,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-09-09,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-09-21,23395,20,0.09%,33760000,0.00,1688000,0.00,0.00%,0,0.00,1.3

2017-09-30,21889,31,0.14%,31580000,0.00,1018710,0.00,0.00%,0,0.00,1.8

2017-09-25,22151,36,0.16%,29400000,0.00,816667,0.00,0.00%,0,0.00,2.2

2017-10-19,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-10-31,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-11-04,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-10-18,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-09-16,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-09-28,29174,48,0.16%,44360000,0.00,924167,0.00,0.00%,0,0.00,1.8

2017-10-21,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-09-18,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-10-07,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-10-29,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-09-19,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-10-17,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-09-20,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

2017-10-16,0,0,0.00%,0,0.00,0,0.00,0.00%,0,0.00,0.0

Total,316610,486,0.15%,465490000,0.00,957798,2.00,0.41%,232745000,0.00,1.9

[Josh Radcliff (AdWords API Team)]

Hi,

We're aware of this issue and I'm actively looking into it. I'll provide an update as soon as I have more information.

Thanks,

Josh, AdWords API Team

[Joseph Collins]

Josh,

Any update to this issue? I read the blog post about the AWX campaign migration, but there is no mention of when this migration begins (perhaps this issue is a symptom of an ongoing migration?) or when it is expected to be completed. Do we need a specific version of the AdWords API to see these additional campaigns in the campaign performance report? There is also no mention of a migration cutover delay to help explain the missing AWX performance as reported by our users.

[Josh Radcliff (AdWords API Team)]

Hi Joseph,

Please see my comments inline below.

Thanks,

Josh, AdWords API Team

On Tuesday, November 14, 2017 at 2:33:48 PM UTC-5, Joseph Collins wrote:

Josh,

Any update to this issue? I read the blog post about the AWX campaign migration, but there is no mention of when this migration begins (perhaps this issue is a symptom of an ongoing migration?) or when it is expected to be completed.

The migration began a few weeks ago and is ongoing. I would expect it to continue as campaigns created by AWX (including new campaigns created by AWX) are moved to the new structure.

Do we need a specific version of the AdWords API to see these additional campaigns in the campaign performance report?

The change to expose the new EXPRESS/UNKNOWN campaigns in the AdWords API will apply to all available versions of the AdWords API (currently, versions >= v201702).

 

There is also no mention of a migration cutover delay to help explain the missing AWX performance as reported by our users. 

The change above is specifically to address the missing AWX performance data. Since the EXPRESS/UNKNOWN campaigns are not exposed in the AdWords API, users are currently unable to get performance data for the migrated campaigns. Once the fix is rolled out, you will be able to retrieve performance data for the entire history of the migrated campaigns to fill in the gaps you're currently seeing.