Hi Kelvin, As I explained in the other thread, although it isn't guaranteed under the current implementation identical keywords should share the same ID. Are you sure the match type is the same on these two keywords?
It is also possible for the same keyword to appear twice in a report, if the bid changed for that keyword over the duration of the report. That way you can measure the performance under the original bid and under the modified bid. Best, - Eric Koleda, AdWords API Team On Jan 4, 12:07 pm, Kelvin <[email protected]> wrote: > Any thought on that? > > On Jan 3, 12:27 am, Kelvin <[email protected]> wrote: > > > > > HI,Ewan. > > > Thanks for your explanation. I checked your post just now and you're > > right on the issue of uniqueness of keywordId. I have to redesign the > > primary key in the table of my local database... > > However, I still have to get the keywordId from the report because the > > problem is: under the same adgroup, there're two identical keywords > > with only differences in keywordId and bid. So When I try to reconcile > > the data from the report, I need to identify the keywords by their ids > > and adgroupIds. In another word, without keywordId, I still couldn't > > tell which keyword is the one I want. > > > By the way, what do you mean by using account structure report? Is it > > the one that is scheduled by defining and executing reportjob in local > > application? If so, that takes time and api everyday, which sounds not > > ideal at all. > > > Regards, > > > Kelvin. > > > On Jan 2, 1:44 pm, ewan <[email protected]> wrote: > > > > Hi Kelvin, > > > > I just posted a similar question on this forum about the keyword id's > > > uniqueness. You'll find that it's not actually unique anyway so you > > > also need the adgroup id to identify a keyword using the id that comes > > > from the API. I think you also need the campaign id to uniquely > > > identify the adgroup. I usually just create my own unique key based > > > on the campaign name, adgroup name, keyword text and match type. If I > > > need the ids for making calls back to the API, I usually just use the > > > account structure report. I think this is only available via the API > > > but one call to this at the keyword level will give you all the ids > > > you need. The report only needs to be run periodically to keep the > > > database up to date so doesn't consume too many API units. > > > > Regards, > > > > Ewan- Hide quoted text - > > > - Show quoted text - -- You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en.
