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/06190422-87f9-4a81-a423-3249533b817d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
