Negative values in Shopping Performance Report

201 views
Skip to first unread message

Adam Orczyk

unread,
Mar 30, 2017, 5:57:41 AM3/30/17
to AdWords API Forum
Hi,
Today we got a lot of negative values in Shopping Performance Report for many accounts, ex. (per row):
clicks='1' impressions='18' cost='-170000'
conversions='-1.0'
clicks='-1' impressions='21' cost='-10000'
impressions='-1' cost='0' conversions='0.0'
clicks='0' impressions='-2' cost='0'
clicks='1' impressions='239' cost='-280000'
clicks='-3' impressions='29' cost='-120000'

How to treat this kind of stats? Is it normal behavior or bug?

AdWordsApiUser

unread,
Mar 30, 2017, 7:49:18 AM3/30/17
to AdWords API Forum
We're seeing the same thing in PRODUCT_PARTITION_REPORT. We have seen negative impressions and negative cost. We think this started happening recently.

This is the query we used:

SELECT CampaignId, AdGroupId, Id, AdGroupName, Impressions, Clicks, Cost, CpcBid, Conversions, ConversionValue, SearchImpressionShare, BenchmarkAverageMaxCpc, BenchmarkCtr, ProductGroup FROM PRODUCT_PARTITION_REPORT WHERE IsNegative=FALSE AND CampaignStatus=ENABLED AND AdGroupStatus=ENABLED  DURING LAST_30_DAYS

Regards,
MG

Shwetha Vastrad (AdWords API Team)

unread,
Mar 30, 2017, 10:32:45 AM3/30/17
to AdWords API Forum
Hi Adam, 

Could you provide the complete report definition along with your clientCustomerId so I can take a look? 

MG, thank you for providing the report definition. Could you provide your clientCustomerId as well? 

Thanks,
Shwetha, AdWords API Team.

AdWordsApiUser

unread,
Mar 30, 2017, 10:48:32 AM3/30/17
to AdWords API Forum
I just sent you one example account. We've seen this for hundreds of accounts.

Thanks,
MG

Adam Orczyk

unread,
Mar 31, 2017, 3:58:02 AM3/31/17
to AdWords API Forum
Hi,
I've send you data, you asked for about an hour ago.

Regards,
Adam

Ronald Findling

unread,
Mar 31, 2017, 4:06:48 AM3/31/17
to AdWords API Forum

Shwetha Vastrad (AdWords API Team)

unread,
Mar 31, 2017, 11:10:44 AM3/31/17
to AdWords API Forum
Hi All, 

Thank you for providing additional information. We are working on this issue as our top priority. We've found that stats for shopping product groups are incorrect for March 29 - 31. For now, if you use Product Partition Report or the Shopping Performance Report to download stats, then do not include the stats from these dates on any analysis. We will let you know once it is safe to pull stats for these dates.

Regards,
Shwetha, AdWords API Team.

Shwetha Vastrad (AdWords API Team)

unread,
Apr 3, 2017, 5:39:44 PM4/3/17
to AdWords API Forum
Hi All,

We've identified the source of the issue and are in the process of implementing a fix. Meanwhile, please do not include the stats from Product Partition Report and Shopping Performance Report for March 29 - 31 on any analysis. I'll update this thread when it's safe to pull these reports for those dates.
Reply all
Reply to author
Forward
0 new messages