Re: AdWords Express Data Discrepancies

2017-11-15 Thread 'Josh Radcliff (AdWords API Team)' via AdWords API Forum 
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.


>
> On Monday, November 6, 2017 at 2:00:08 PM UTC-5, Josh Radcliff (AdWords 
> API Team) wrote:
>>
>> 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
>>
>> On Sunday, November 5, 2017 at 1:36:16 PM UTC-5, Joseph Collins wrote:
>>>
>>> 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 X
>>> [1] => developerToken: X
>>> [2] => clientCustomerId: 5571930852
>>> [3] => includeZeroImpressions: true
>>> )
>>> 
>>> 
>>> Date
>>> Impressions
>>> Clicks
>>> Ctr
>>> Cost
>>> ConversionValue
>>> AverageCpc
>>> Conversions
>>> ConversionRate
>>> CostPerConversion
>>> ValuePerConversion
>>> AveragePosition
>>> 
>>> 20170906
>>> 20171104
>>> 
>>> 
>>> Report
>>> ACCOUNT_PERFORMANCE_REPORT
>>> CUSTOM_DATE
>>> GZIPPED_CSV
>>> 
>>>
>>>
>>> 
>>>
>>> *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%,3182,0.00,86,0.00,0.00%,0,0.00,1.9
>>>
>>> 2017-10-04,16918,37,0.22%,3336,0.00,901622,2.00,5.41%,1668,0.00,2.2
>>> 2017-10-02,15028,37,0.25%,3424,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%,3334,0.00,901081,0.00,0.00%,0,0.00,2.1
>>>

Re: AdWords Express Data Discrepancies

2017-11-14 Thread 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.


On Monday, November 6, 2017 at 2:00:08 PM UTC-5, Josh Radcliff (AdWords API 
Team) wrote:
>
> 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
>
> On Sunday, November 5, 2017 at 1:36:16 PM UTC-5, Joseph Collins wrote:
>>
>> 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 X
>> [1] => developerToken: X
>> [2] => clientCustomerId: 5571930852
>> [3] => includeZeroImpressions: true
>> )
>> 
>> 
>> Date
>> Impressions
>> Clicks
>> Ctr
>> Cost
>> ConversionValue
>> AverageCpc
>> Conversions
>> ConversionRate
>> CostPerConversion
>> ValuePerConversion
>> AveragePosition
>> 
>> 20170906
>> 20171104
>> 
>> 
>> Report
>> ACCOUNT_PERFORMANCE_REPORT
>> CUSTOM_DATE
>> GZIPPED_CSV
>> 
>>
>>
>> 
>>
>> *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%,3182,0.00,86,0.00,0.00%,0,0.00,1.9
>>
>> 2017-10-04,16918,37,0.22%,3336,0.00,901622,2.00,5.41%,1668,0.00,2.2
>> 2017-10-02,15028,37,0.25%,3424,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%,3334,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%,3607,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%,3438,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%,85,0.00,85,0.00,0.00%,0,0.00,2.2
>> 2017-09-27,25856,28,0.11%,2321,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
>>

Re: AdWords Express Data Discrepancies

2017-11-06 Thread 'Josh Radcliff (AdWords API Team)' via AdWords API Forum 
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

On Sunday, November 5, 2017 at 1:36:16 PM UTC-5, Joseph Collins wrote:
>
> 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 X
> [1] => developerToken: X
> [2] => clientCustomerId: 5571930852
> [3] => includeZeroImpressions: true
> )
> 
> 
> Date
> Impressions
> Clicks
> Ctr
> Cost
> ConversionValue
> AverageCpc
> Conversions
> ConversionRate
> CostPerConversion
> ValuePerConversion
> AveragePosition
> 
> 20170906
> 20171104
> 
> 
> Report
> ACCOUNT_PERFORMANCE_REPORT
> CUSTOM_DATE
> GZIPPED_CSV
> 
>
>
> 
>
> *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%,3182,0.00,86,0.00,0.00%,0,0.00,1.9
> 2017-10-04,16918,37,0.22%,3336,0.00,901622,2.00,5.41%,1668,0.00,2.2
> 2017-10-02,15028,37,0.25%,3424,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%,3334,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%,3607,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%,3438,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%,85,0.00,85,0.00,0.00%,0,0.00,2.2
> 2017-09-27,25856,28,0.11%,2321,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%,3339,0.00,834750,0.00,0.00%,0,0.00,2.1
> 2017-09-23,19092,23,0.12%,3387,0.00,1472609,0.00,0.00%,0,0.00,1.7
> 2017-09-26,24668,39,0.16%,3186,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
>

AdWords Express Data Discrepancies

2017-11-05 Thread 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 X
[1] => developerToken: X
[2] => clientCustomerId: 5571930852
[3] => includeZeroImpressions: true
)


Date
Impressions
Clicks
Ctr
Cost
ConversionValue
AverageCpc
Conversions
ConversionRate
CostPerConversion
ValuePerConversion
AveragePosition

20170906
20171104


Report
ACCOUNT_PERFORMANCE_REPORT
CUSTOM_DATE
GZIPPED_CSV




*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%,3182,0.00,86,0.00,0.00%,0,0.00,1.9
2017-10-04,16918,37,0.22%,3336,0.00,901622,2.00,5.41%,1668,0.00,2.2
2017-10-02,15028,37,0.25%,3424,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%,3334,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%,3607,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%,3438,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%,85,0.00,85,0.00,0.00%,0,0.00,2.2
2017-09-27,25856,28,0.11%,2321,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%,3339,0.00,834750,0.00,0.00%,0,0.00,2.1
2017-09-23,19092,23,0.12%,3387,0.00,1472609,0.00,0.00%,0,0.00,1.7
2017-09-26,24668,39,0.16%,3186,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%,3376,0.00,1688000,0.00,0.00%,0,0.00,1.3
2017-09-30,21889,31,0.14%,3158,0.00,1018710,0.00,0.00%,0,0.00,1.8
2017-09-25,22151,36,0.16%,2940,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