Receiving negative values for Cost/Impressions in ADGROUP_PERFORMANCE_REPORT

[Will Percival]

I'm pulling down an ADGROUP_PERFORMANCE_REPORT to track hourly impression/cost/click data. Starting last night, my automated pull started erroring out, and when I did some digging this morning, I found that it's because negative values in double quotes are being returned for metrics that cannot be negative.

Here's an example row from my resulting dataframe (with sensitive data redacted):

      Campaign ID     Campaign      Ad group ID      Ad group    Impressions    Clicks       Cost          Day      Hour of day
242          C_ID       C_NAME            AG_ID       AG_NAME             32         0   "-41741"   2019-05-01                0

Is this some sort of data correction? I'm also seeing values like "-1" for Impressions.

Any insights would be much appreciated. 

W

[googleadsapi...@google.com]

Hi Will,

We have an ongoing issue that's affecting all reporting stats in AdWords API, Google Ads API, and Google Ads Scripts. Basically, the stats are incorrect for Apr 30 - May 1. Please keep an eye on our blog for the updates regarding this issue. 

Regards,

Hiroyuki

Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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+unsubscribe@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 the Google Groups "AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscribe@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/32286152-59f7-4834-97ef-939cf2499bdd%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[wper...@gmail.com]

Hi Hiroyuki,

Is there any update on this? The last update to the blog was 4 days ago. We need this reporting data for our clients...

W

[googleadsapi...@google.com]

Hi Will,

Our team is still working on this. Rest assured that we will provide updates in our blog and this thread once we receive any.

Regards,

Hiroyuki

Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/61a56802-40f5-4437-a519-f5f3c86b3e1e%40googlegroups.com.

[Zweitze]

Based on these findings we activated a similar check and noticed negative impressions (impressions = -1, once -2). This happens in over 10% of our accounts.

The report definition:

<?xml version="1.0" encoding="utf-8"?>
<reportDefinition>
   <selector xmlns="https://adwords.google.com/api/adwords/cm/v201809">
       <fields>CampaignId</fields>
       <fields>AdGroupId</fields>
       <fields>KeywordId</fields>
       <fields>Query</fields>
       <fields>QueryMatchTypeWithVariant</fields>
       <fields>Device</fields>
       <fields>AdNetworkType2</fields>
       <fields>AbsoluteTopImpressionPercentage</fields>
       <fields>TopImpressionPercentage</fields>
       <fields>AveragePosition</fields>
       <fields>Clicks</fields>
       <fields>Cost</fields>
       <fields>Impressions</fields>
       <fields>Interactions</fields>
       <predicates>
           <field>CampaignStatus</field>
           <operator>IN</operator>
           <values>ENABLED</values>
           <values>PAUSED</values>
           <values>REMOVED</values>
       </predicates>
       <predicates>
           <field>AdGroupStatus</field>
           <operator>IN</operator>
           <values>ENABLED</values>
           <values>PAUSED</values>
           <values>REMOVED</values>
       </predicates>
       <dateRange>
           <min>20190411</min>
           <max>20190508</max>
       </dateRange>
   </selector>
   <reportName xmlns="https://adwords.google.com/api/adwords/cm/v201809">872-671-3425 QueryResult</reportName>
   <reportType xmlns="https://adwords.google.com/api/adwords/cm/v201809">SEARCH_QUERY_PERFORMANCE_REPORT</reportType>
   <dateRangeType xmlns="https://adwords.google.com/api/adwords/cm/v201809">CUSTOM_DATE</dateRangeType>
   <downloadFormat xmlns="https://adwords.google.com/api/adwords/cm/v201809">GZIPPED_XML</downloadFormat>
</reportDefinition>

Unfortunately I can't show snippets of the resulting report - maybe other fields were negative too.

Is this the same issue?

[googleadsapi...@google.com]

Hi,

Yes, our team is actively working on correcting the data from 12:01am on May 1 to 4:00am May 2 (PDT). You may check our blog for more details about the issue.

Regards,

Hiroyuki

Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/efa1007e-bcb1-4483-b8bc-ba669ae86f14%40googlegroups.com.