David, Thanks for the log - in the log I do not see duplicate criterion Ids. There were 2 selects w/ the same LIMIT clause, however. Please also send me a log where the subsequent pages produces items that were returned in the previous pages.
Thanks! Ray On Thursday, July 3, 2014 5:50:08 AM UTC-4, david wrote: > > Thanks Ray. Logs PMs > > On Wednesday, 2 July 2014 20:03:35 UTC+1, Ray Tsang (AdWords API Team) > wrote: >> >> 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.
