Hi Takeshi, I'm having a difficulty trying to find the xml used for report downloads. The java lib logs the xml used when accessing the Service API, but there seems to be nothing there for report downloads.
I'm using the following AWQL to download the 2 reports I mentioned above. All downloads were for account ID *7582349760*: *Report 1 - download keyword structure data* SELECT AdGroupId, AdGroupName, ApprovalStatus, CampaignId, FirstPageCpc, Id, KeywordMatchType, KeywordText, MaxCpc, Status FROM KEYWORDS_PERFORMANCE_REPORT WHERE CampaignId IN [7136351] AND Status IN [ACTIVE, PAUSED] AND AdGroupStatus IN [ENABLED, PAUSED] AND IsNegative = FALSE DURING 20010101,20140214 *Report 2 - download keyword performance data* SELECT AdGroupId, CampaignId, Id, Clicks, Impressions, Cost, AveragePosition, Conversions, Ctr, AverageCpc, CostPerConversion, ConversionRate FROM KEYWORDS_PERFORMANCE_REPORT WHERE CampaignId IN [7136351] AND Status IN [ACTIVE, PAUSED] AND AdGroupStatus IN [ENABLED, PAUSED] AND IsNegative = FALSE DURING 20010101,20140214 Report 1 returns 9383 keywords when I run the report today. Report 2 returns 9421 keywords today, hence *38 more keywords.* There is no issue with "zero impression" being suppressed in Report 1 because there are actually *over 6,000 keywords with zero impression in Report 2*. Report 1 includes all but 38 of them. Why do you think the above is happening? Many thanks for your help Oliver On Thursday, February 13, 2014 5:05:31 AM UTC, Takeshi Hagikura (AdWords API Team) wrote: > > Hi Oliver, > > Sorry for the delay. > Can you share your request XML? > Let me pull reports against your campaigns and see the behavior. > > Best, > - Takeshi, AdWords API Team > > On Tuesday, February 11, 2014 11:44:09 PM UTC+9, Oliver wrote: >> >> Hi Takeshi, >> >> Sorry to chase this, do you have any idea why the keyword performance >> report is behaving in such an inconsistent way? >> >> There is no includeZeroImpression issue here because, as my test showed, >> the keywords have impressions, but they are just not returned in some of >> the reports. This is happening for a small set of campaigns only. We >> downloaded the keyword performance reports for thousands of campaigns every >> day but it's happening only with 7 of them. >> >> Oliver >> >> On Friday, February 7, 2014 9:18:02 AM UTC, Oliver wrote: >>> >>> Hi Takeshi, >>> >>> I'm not explicitly setting the includeZeroImpressions flag to any value. >>> But the documentation says that if we use predicates, then we will always >>> get back all the structural data. >>> >>> This works, by the way, *even for test accounts *where there are no >>> impressions at all. Our code still manages to download all structural data >>> when using test accounts because we're using predicates. >>> >>> I just did a small test; I downloaded *two *Keyword Performance reports >>> for one of the above campaigns I mentioned; >>> >>> *Report 1* >>> I requested structural data only. All report downloads require a date >>> range so I used ALL_TIME. I got back *X *keywords. >>> >>> *Report 2* >>> I requested the impressions, again using ALL_TIME. I got back *X + 29 * >>> keywords. >>> >>> >>> Both reports were downloaded using the same code. The only difference >>> is in the fields requested. >>> >>> So the question is, if *Report 2 *gave me the keywords that must have >>> had impressions, why didn't *Report 1 *give them the same number of >>> keywords (since they all had impressions)? >>> >>> >>> Oliver >>> >>> >>> On Friday, February 7, 2014 4:54:24 AM UTC, Takeshi Hagikura (AdWords >>> API Team) wrote: >>>> >>>> Hi Oliver, >>>> >>>> Even if you don't include "Impressions" reports should return the data >>>> where it has impressions unless includeZeroImpressions flag is true. >>>> (But as I said, Keyword Performance Report doesn't support the flag as >>>> of now) >>>> >>>> Best, >>>> - Takeshi, AdWords API Team >>>> >>>> On Thursday, February 6, 2014 4:33:46 PM UTC+9, Oliver wrote: >>>>> >>>>> Takeshi, >>>>> >>>>> I'm using the report to get structural data only, and not impressions. >>>>> The date a keyword was added does not matter for such data. If a >>>>> keyword >>>>> was added last week, it should still be returned in a report with an >>>>> ALL_TIME date range. That's how the system have worked from day one and >>>>> that's how it's documented. includeZeroImpressions does not play any >>>>> part >>>>> here. I am not requesting impressions. I'm simply requesting keyword IDs. >>>>> >>>>> There is something else going on, and it's only specific to a very >>>>> small number of campaigns. >>>>> >>>>> Any other ideas please? >>>>> >>>>> Oliver >>>>> >>>>> >>>>> On Thursday, February 6, 2014 7:28:31 AM UTC, Takeshi Hagikura >>>>> (AdWords API Team) wrote: >>>>>> >>>>>> Hi Oliver >>>>>> >>>>>> My guess is that those campaigns have impressions before the time >>>>>> range of requested ones (LAST_DAY, LAST_MONTH etc). >>>>>> As far as I remember includeZeroImpressions flag is not supported by >>>>>> Keyword Performance Report. >>>>>> >>>>>> Best, >>>>>> - Takeshi, >>>>>> >>>>>> On Wednesday, February 5, 2014 5:15:21 PM UTC+9, Oliver wrote: >>>>>>> >>>>>>> I forgot to mention we're using the keyword performance report to >>>>>>> get structural data *only*. There is no performance data and hence >>>>>>> no zero impression issues. >>>>>>> >>>>>>> The number of keywords returned in such a structural report should >>>>>>> always be the same, irrespective of the date range used when requesting >>>>>>> the >>>>>>> report. >>>>>>> >>>>>>> However, for only those specific campaigns, the report for ALL_TIME >>>>>>> date range gives different results. >>>>>>> >>>>>>> Any ideas? >>>>>>> >>>>>>> Oliver >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Monday, February 3, 2014 8:33:18 AM UTC, Oliver wrote: >>>>>>>> >>>>>>>> We download the keyword performance report for various date ranges. >>>>>>>> For a given campaign, the number of keywords in a report is always >>>>>>>> the >>>>>>>> same irrespective of the date range, which is what is expected. >>>>>>>> >>>>>>>> However, only for 7 campaigns of one of our clients, the number of >>>>>>>> keywords that come back in the *ALL_TIME* date range keyword >>>>>>>> report is *higher *than the number of keywords that come back in >>>>>>>> all other date ranges (LAST_&_DAYS, LAST_MONTH, etc.) >>>>>>>> >>>>>>>> This happens only for one client and only for 7 of his campaigns. >>>>>>>> The customer ID is 7582349760 and the 7 campaign IDs are: >>>>>>>> >>>>>>>> 7136351 >>>>>>>> 8075351 >>>>>>>> 6427991 >>>>>>>> 95861 >>>>>>>> 31699811 >>>>>>>> 5553191 >>>>>>>> 7146191 >>>>>>>> >>>>>>>> >>>>>>>> Any idea why this inconsistent behavior of the keyword performance >>>>>>>> report? >>>>>>>> >>>>>>>> Oliver >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and Google+: https://googleadsdeveloper.blogspot.com/ https://plus.google.com/+GoogleAdsDevelopers/posts =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 --- You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
