Thanks for the reply! I'm currently using just the keywordId, which "seems" to be working for now. I'm following the information under 'Report Fields Normalization' on http://code.google.com/apis/adwords/docs/reportguide.html#normalization.
Someone told me that keywordId is not unique to a campaign and that uniqueness is defined by an adgroupId/keywordId combination. It would be great to get some clarification on this. Thanks, Mike On Tuesday, 28 February 2012 10:15:02 UTC-5, Thomas Beavers wrote: > > I ended up joining on accountid, campaignid, adgroupid, and keywordid. It > may be over kill, but it has worked for me. > > If you are using .net 3.5 or higher take a lookat the the linq join. That > is how I did it. > > On Monday, February 27, 2012 9:53:33 AM UTC-5, mmasters wrote: >> >> Hello, >> >> I'm migrating v13 reporting and I'm trying to get the same report by >> cross referencing AD_PERFORMANCE_REPORT and KEYWORDS_PERFORMANCE_REPORT. >> >> What's the best way to 'join' these two reports to get the same >> information into one report? My understanding is that I should use >> KeywordId and Id from AD_PERFORMANCE_REPORT and >> KEYWORDS_PERFORMANCE_REPORT, respectively. >> >> My understanding is that uniqueness is defined by a combination of >> keywordid and adgroupid. Is this correct? >> >> >> Thanks, >> Mike >> > On Tuesday, 28 February 2012 10:15:02 UTC-5, Thomas Beavers wrote: > > I ended up joining on accountid, campaignid, adgroupid, and keywordid. It > may be over kill, but it has worked for me. > > If you are using .net 3.5 or higher take a lookat the the linq join. That > is how I did it. > > On Monday, February 27, 2012 9:53:33 AM UTC-5, mmasters wrote: >> >> Hello, >> >> I'm migrating v13 reporting and I'm trying to get the same report by >> cross referencing AD_PERFORMANCE_REPORT and KEYWORDS_PERFORMANCE_REPORT. >> >> What's the best way to 'join' these two reports to get the same >> information into one report? My understanding is that I should use >> KeywordId and Id from AD_PERFORMANCE_REPORT and >> KEYWORDS_PERFORMANCE_REPORT, respectively. >> >> My understanding is that uniqueness is defined by a combination of >> keywordid and adgroupid. Is this correct? >> >> >> Thanks, >> Mike >> > On Tuesday, 28 February 2012 10:15:02 UTC-5, Thomas Beavers wrote: > > I ended up joining on accountid, campaignid, adgroupid, and keywordid. It > may be over kill, but it has worked for me. > > If you are using .net 3.5 or higher take a lookat the the linq join. That > is how I did it. > > On Monday, February 27, 2012 9:53:33 AM UTC-5, mmasters wrote: >> >> Hello, >> >> I'm migrating v13 reporting and I'm trying to get the same report by >> cross referencing AD_PERFORMANCE_REPORT and KEYWORDS_PERFORMANCE_REPORT. >> >> What's the best way to 'join' these two reports to get the same >> information into one report? My understanding is that I should use >> KeywordId and Id from AD_PERFORMANCE_REPORT and >> KEYWORDS_PERFORMANCE_REPORT, respectively. >> >> My understanding is that uniqueness is defined by a combination of >> keywordid and adgroupid. Is this correct? >> >> >> Thanks, >> Mike >> > -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
