Our account had a large volume of label changes for keywords in the
timespan given. Our change status query
SELECT
change_status.ad_group_criterion,
change_status.ad_group_feed,
change_status.campaign,
change_status.campaign_criterion,
change_status.campaign_feed,
change_status.feed,
change_status.feed_item,
change_status.resource_status,
change_status.resource_type,
change_status.last_change_date_time
FROM
change_status
WHERE
change_status.resource_type IN ('AD_GROUP_CRITERION') AND
change_status.last_change_date_time >= '2021-09-13 13:20:00.0000000'
AND
change_status.last_change_date_time < '2021-09-13 14:32:00.0000000'
ORDER BY
change_status.last_change_date_time
LIMIT 10000
returns with internal error consistently. If I change the time ranges, I
can eventually find a range that will succeed.
Example of successful range
SELECT
change_status.ad_group_criterion,
change_status.ad_group_feed,
change_status.campaign,
change_status.campaign_criterion,
change_status.campaign_feed,
change_status.feed,
change_status.feed_item,
change_status.resource_status,
change_status.resource_type,
change_status.last_change_date_time
FROM
change_status
WHERE
change_status.resource_type IN ('AD_GROUP_CRITERION') AND
change_status.last_change_date_time >= '2021-09-13 13:20:00.0000000'
AND
change_status.last_change_date_time < '2021-09-13 14:15:00.0000000'
ORDER BY
change_status.last_change_date_time
LIMIT 10000
Please advise
Thank you
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads 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 and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/8a04cb5c-4dd3-4d4b-bd24-b70bbae46ab5n%40googlegroups.com.
