Re: Cross referencing AD_PERFORMANCE_REPORT and KEYWORDS_PERFORMANCE_REPORT

2012-02-29 Thread Anash P. Oommen
Hi Steve, Here are the rules about id uniqueness to go by when joining reports: CampaignId is globally unique AdGroupId is globally unique AdGroupId + Criterion Id (keyword id, placement id, etc.) is globally unique. KeywordId alone isn't. AdGroupId + Ad Id (keyword id, placement id, etc.) is gl

Re: Cross referencing AD_PERFORMANCE_REPORT and KEYWORDS_PERFORMANCE_REPORT

2012-02-28 Thread Steve B
Oops - should add that *definitely* you need a minimum of adgroupid and keywordid -- I definitely get back entries which are different in this way. Not sure if campaignid is necessary, but I'm using it to be safe. On the other hand, while I have no examples of keyword id reuse across acco

Re: Cross referencing AD_PERFORMANCE_REPORT and KEYWORDS_PERFORMANCE_REPORT

2012-02-28 Thread Steve B
I'm likewise using the accountid, campaignid, adgroupid, and keywordid - I think that's probably best if you want to be safe. Also noticing a small percentage of missing keywords, however. Still trying to track this one down and see if I can solve it. - latest I have is that they were reported

Re: Cross referencing AD_PERFORMANCE_REPORT and KEYWORDS_PERFORMANCE_REPORT

2012-02-28 Thread mmasters
>> 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 re

Re: Cross referencing AD_PERFORMANCE_REPORT and KEYWORDS_PERFORMANCE_REPORT

2012-02-28 Thread Thomas Beavers
gt; > 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 under

Cross referencing AD_PERFORMANCE_REPORT and KEYWORDS_PERFORMANCE_REPORT

2012-02-27 Thread mmasters
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