Google reports contains negative keyword ids

[Kim]

I have been using Google Reports for a long time, however, this is the
first time I have been presented with a report with negative keyword
ids.

I have a problem similar to the one described here:

http://groups.google.com/group/adwords-api/browse_thread/thread/b78796bd40560ba6/ca0d64a258a4d8bc?q=negative+keyword+id&rnum=1#ca0d64a258a4d8bc

I have included a sample report below. Notice keywordid="-2125206613"

<?xml version="1.0" standalone="yes"?>

<report><table><columns><column name="date"></column><column
name="campaignid"></column><column name="adgroupid"></column><column
name="keywordid"></column><column name="imps"></column><column
name="clicks"></column><column name="cpc"></column><column
name="cost"></column><column name="pos"></column></columns><rows><row
date="2005-09-21" campaignid="5589633" adgroupid="212257293"
keywordid="14817211" imps="3" clicks="0" cpc="0" cost="0"
pos="4.0"></row><row date="2005-09-21" campaignid="5589633"
adgroupid="212257293" keywordid="112509260" imps="1" clicks="0" cpc="0"
cost="0" pos="2.0"></row><row date="2005-09-21" campaignid="5589633"
adgroupid="212257293" keywordid="509821083" imps="2" clicks="0" cpc="0"
cost="0" pos="3.5"></row><row date="2005-09-21" campaignid="5589633"
adgroupid="212257293" keywordid="544950513" imps="1" clicks="0" cpc="0"
cost="0" pos="3.0"></row><row date="2005-09-21" campaignid="5589633"
adgroupid="212257293" keywordid="1226367723" imps="1" clicks="0"
cpc="0" cost="0" pos="2.0"></row><row date="2005-09-21"
campaignid="5589633" adgroupid="212257293" keywordid="1375837353"
imps="2" clicks="0" cpc="0" cost="0" pos="3.5"></row><row
date="2005-09-21" campaignid="5589633" adgroupid="212257293"
keywordid="-2125206613" imps="13" clicks="0" cpc="0" cost="0"
pos="1.0"></row><row date="2005-09-21" campaignid="6968823"
adgroupid="335910723" keywordid="14817211" imps="6" clicks="0" cpc="0"
cost="0" pos="3.3333333333333335"></row><row date="2005-09-21"
campaignid="6968823" adgroupid="335910723" keywordid="565763883"
imps="2" clicks="0" cpc="0" cost="0" pos="4.0"></row><row
date="2005-09-21" campaignid="6968823" adgroupid="335910723"
keywordid="1226367723" imps="6" clicks="0" cpc="0" cost="0"
pos="2.1666666666666665"></row><row date="2005-09-21"
campaignid="6968823" adgroupid="335910723" keywordid="1350444063"
imps="16" clicks="0" cpc="0" cost="0" pos="5.8125"></row><row
date="2005-09-21" campaignid="6968823" adgroupid="335910723"
keywordid="1375837083" imps="7" clicks="0" cpc="0" cost="0"
pos="7.714285714285714"></row><row date="2005-09-21"
campaignid="6968823" adgroupid="335910723" keywordid="1375837233"
imps="13" clicks="0" cpc="0" cost="0"
pos="4.461538461538462"></row><row date="2005-09-21"
campaignid="6968823" adgroupid="335910723" keywordid="1375837263"
imps="1" clicks="0" cpc="0" cost="0" pos="5.0"></row><row
date="2005-09-21" campaignid="6968823" adgroupid="335910723"
keywordid="1375837383" imps="8" clicks="0" cpc="0" cost="0"
pos="1.0"></row><row date="2005-09-21" campaignid="6968823"
adgroupid="335910723" keywordid="1375837413" imps="2" clicks="0"
cpc="0" cost="0" pos="2.5"></row><row date="2005-09-21"
campaignid="6968823" adgroupid="335910723" keywordid="-2125206763"
imps="3" clicks="0" cpc="0" cost="0" pos="1.0"></row><row
date="2005-09-21" campaignid="6968823" adgroupid="335910723"
keywordid="-2125206613" imps="9" clicks="1" cpc="190000" cost="190000"
pos="1.0"></row></rows></table><totals><subtotal imps="96" clicks="1"
cpc="190000" cost="190000" pos="3.3541666666666665"
name="2005-09-21"></subtotal><grandtotal imps="96" clicks="1"
cpc="190000" cost="190000"
pos="3.3541666666666665"></grandtotal></totals></report>

[Kostas]

Can you run the same report but specify as a custom option the keyword
text as well?
Then you can use the Keyword service to find the real ID of that
keyword.

One guess is that the keyword ID in reports is a (32 bit) integer
whereas the ID of keywords in the other services is a (64 bit) long. So
if an ID happens to be > 2147483647, then in the report it would appear
as a negative number. Or it could be something completely different!

[Kostas]

hmm... I think I was right. I just ran a report for an account that had
a keyword with an ID > 2147483647 and in the report it was a negative
number.

[dr7d7]

Hi,
I am also seeing a couple hundred negative keyword ID's in my report
as well. This is probably due to Google's data type being an int (in
the XSD??) and therefore overflowing its value. Hopefully the fix would
be for Google to change there underlying data type to a larger one, as
more and more of these errors will be seen as more people start to
cross the Integer.MAX_INT barrier.
Thanks!

[Kostas]

As a temporary workaround you can do:
if keywordId < 0
keywordId = 4294967296 + keywordId;

e.g. if in the report the keyword id is -2,146,677,973, the real ID
would be 2,148,289,323.
This should work for some time until IDs start getting greater than
2^32, by when the problem should hopefully be fixed.

[dr7d7]

Thanks for the formula

[dr7d7]

Hi,
I did not see any negative IDs in the latest report I got. This
leads me to believe that this problem has been resolved by Google. Does
anyone know if this is the case?
Thanks!

[Kim]

I think you were just lucky. I run reran a report to check. I still get
the negative keyword ids.
I have not heard from Google, though I have e-mailed the problem to
adwordsap...@google.com

[Kim]

I got response from Daniel O'Brien from adwordsap...@google.com:
"I've confirmed the problem and will start following up on it
internally."

[dr7d7]

You are right... I am now seeing the negative IDs again

[Kim]

Latest update from Google is, that this issue is slated to be rectified
in early November.