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.
