Hi Oliver, Sorry for taking it long.
Looks like the difference is the rows with KeywordId = 3000004. (That is not appearing with the first query) (FYI there was a discussion about KeywordId 3000004 https://groups.google.com/d/msg/adwords-api/3fu-_GCznP4/75iLU20BMlAJ ) I'm checking the behavior with the relevant engineer. Best, - Takeshi On Wednesday, February 19, 2014 1:22:45 AM UTC+9, Takeshi Hagikura (AdWords API Team) wrote: > > Hi Oliver, > > Thanks for the the query. I'm looking it now. > > Jeremy, > I think the feature for logging report downloads is worth filing a feature > request. > Can you please file an issue on > GitHub<https://github.com/googleads/googleads-java-lib> > ? > > Best, > - Takeshi, AdWords API Team > > On Friday, February 14, 2014 11:30:14 PM UTC+9, Jeremy Aube wrote: >> >> I just wanted to mention that we've also been unable to get soap logs for >> report downloads with our java library, even with the log threshold set to >> debug. >> >> I'm also very interested in how this issue ends up being resolved. We >> happen to pull down impressions for all of our structure reports, but if we >> ever decided we didn't need impressions, it would be good to know that the >> results would be consistent. >> >> On Friday, February 14, 2014 6:10:56 AM UTC-5, Oliver wrote: >>> >>> 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.
