Hello Ramon,
Both are known issues to us. The type issue should be resovled soon. "Parameter" is a bit more complicated but we also plan to fix it. The best approach I can suggest know is to pull the list of IDs (and all available fields) from a report, bucket them by campaign ID and then retrieve the missing data from the service. This way you can pull almost all data with one report and only make subsequent requests for the rows you need "Parameter" for. -Danial, AdWords API Team. On Tuesday, September 16, 2014 7:22:04 PM UTC+4, Ramon wrote: > > Thank you Danial for your kind answer. > I already tried using the Criteria report, but it doesn't give me the same > amount of information like the AdGroupCriterion Service does: > > I am using the following query: > > SELECT AdGroupId, ApprovalStatus, CriteriaDestinationUrl, CriteriaType, > FinalMobileUrls, > FinalUrls, Id, IsNegative, Status, > TrackingUrlTemplate, UrlCustomParameters, > Criteria, DisplayName, Parameter > FROM CRITERIA_PERFORMANCE_REPORT > WHERE CampaignStatus IN [ENABLED, PAUSED] AND > AdGroupStatus IN [ENABLED, PAUSED] AND > CriteriaType != "KEYWORD" > DURING TODAY > > One returned line is a negative webpage placement (PAGE_TITLE == "X") > With the AdGroupCriterionService, I am getting a nice object with all > necessary information, but the CRITERIA_PERFORMANCE_REPORT has a massive > lack of information. > > CriteriaType = " --" instead of "WEBPAGE" and Parameter has a weird > encoded string, containing the conditions - but they're not usable as long > as they're encrypted. > > So what's the result? I am getting a negative criterion, but I don't know > which type it is. > > Using the service and limiting by Campaigns or AdGroups has one big > disadvantage: I cannot push that to best performance, because some AdGroups > just have a handful of Criteria, others do have 20k - so the best method to > not hit tne START_INDEX_TO_HIGH exception is to limit it to 5 AdGroups in > parallel ... which takes ages with account with hundred thousands of > AdGroups > > > What's your suggestion especially for the consistency problem ? > > BR > Ramon > > On Tuesday, September 16, 2014 3:13:49 PM UTC+2, Danial Klimkin wrote: >> >> Hello Ramon, >> >> >> What are the fields you are missing? Please check out the Criteria report: >> >> >> https://developers.google.com/adwords/api/docs/appendix/reports#criteria >> >> There is a hard limit of start index, so for large accounts you would not >> be able to pull every item. If you pull a lot of columns, you hit this >> limitation sooner. >> >> If you absolutely need to use the service, add restriction by Campaign ID >> instead of paging. >> >> >> -Danial, AdWords API Team. >> >> >> On Tuesday, September 16, 2014 1:21:02 PM UTC+4, Ramon wrote: >>> >>> Hey API-devs, >>> >>> I am trying to get all AdGroupCriteria from a couple of accounts with >>> millions of keywords using an AQWL-statement like >>> >>> SELECT >>> Id, CampaignId, AdGroupId, CriterionUse, Status, KeywordText, >>> KeywordMatchType, DestinationUrl, >>> Labels, SystemServingStatus, ApprovalStatus, FinalUrls, FinalMobileUrls, >>> TrackingUrlTemplate, >>> UrlCustomParameters WHERE Status IN [ENABLED,PAUSED] LIMIT x,10000 >>> >>> and raising x by 10k everytime, but around 60k/70k/80k I am getting >>> the RESPONSE_SIZE_LIMIT_EXCEEDED exception. >>> Even if I lower the pagelimit down to 250, it raises this exception >>> around the same amount of entries. >>> >>> Since I like to download all criteria, AdHoc reports are not a solution >>> - they don't offer (yet?) all fields I need to have. >>> >>> Anyone has a solution for that problem ? >>> >>> Regards >>> Ramon >>> >> -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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. Visit this group at http://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/661ccf02-1730-4015-87fd-3f98d194b77b%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
