David, Please send me a couple of logs (in private using the reply to author) with a smaller limit, e.g., 0 to 10, 11 to 20, etc. with order.
Thanks, Ray On Wednesday, July 2, 2014 7:06:24 AM UTC-4, david wrote: > > > We in the process of migrating to Shopping campaigns. > > In our test system we have a single ad group within a shopping campaign > which contains product groups for each product we have (segmented on Offer > ID). There are about 12,000. > > As products come and go we need to be able to maintain the list of product > groups. So, if one day product xxxx goes inactive, we need to be able to > map that product (OfferId) to the product group's criterionId and delete > that criterionId (using the AdGroupCriterionService). > > I'm attempting to do this by building a lookup table > (product->criterionId) by using the following query on > AdGroupCriterionService. > > select > Id, > PartitionType, > ParentCriterionId, > CaseValue, > MaxCpc > where > AdGroupId = $my_shopping_ad_group > during TODAY > > This will return an Id and "value" within the CaseValue clause for each > product group. > > Since we have so many products I really need to do this in batches like so: > > select > Id, > PartitionType, > ParentCriterionId, > CaseValue, > MaxCpc > where > AdGroupId = $my_shopping_ad_group > during TODAY > order by Id > limit 0,1999 > > ..then progressing though the products by incrementing the limit statement > to 2000,3999... 4000,5999 etc. > > But this seems to be failing to bring back the results in a consistent > order even though I'm ordering by Id. > > limit 0,1999 brings back criterionIds 61603285321 to 74610692467 > limit 2000,3999 brings back 74610692707 to 74642907427 > But limit 4000,5999 starts over at 74642667067 creating duplicate entries. > > Am I misunderstanding how the limit clause works? > > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 [email protected] To unsubscribe from this group, send email to [email protected] 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
