Change Status Service Internal Errors for Certain Date Ranges

[Jonathan Stack]

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

[Google Ads API Forum Advisor]

Hi Jonathan,

Thank you for raising your concern.

To investigate, could you provide the complete request and response logs with request ID generated on your end where we can see the error? 

If you haven't enabled the logging of the API transactions for the specific client library that you are using, then please refer to the specific guide below:

• Java - https://developers.google.com/google-ads/api/docs/client-libs/java/logging
• .Net - https://developers.google.com/google-ads/api/docs/client-libs/dotnet/logging
• PHP - https://developers.google.com/google-ads/api/docs/client-libs/php/logging
• Python - https://developers.google.com/google-ads/api/docs/client-libs/python/logging
• Ruby - https://developers.google.com/google-ads/api/docs/client-libs/ruby/logging
• Perl - https://developers.google.com/google-ads/api/docs/client-libs/perl/logging

You can provide it via Reply privately to author option. If this option is not available, then send it instead on this email address googleadsa...@google.com.

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q2NURhK:ref

[Jonathan Stack]

Hello,

Checking in on the status of this. Any updates?

Thanks

[Google Ads API Forum Advisor]

Hi Jonathan,

Thank you for bumping this thread.

We currently do not have updates yet on the issue. However, I have already sent a follow up to our team before responding to you here. We'll reach out once we receive feedback.

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q2NURhK:ref

[Jonathan Stack]

Hello,

Can I get a status update on this please?

Thank you!

[Google Ads API Forum Advisor]

Hello,

I've bumped up the priority of this investigation internally so I hope to have some information soon, but unfortunately I don't have anything quite yet. I'll let you know as soon as I do have something to share.

Regards,
Mike, Google Ads API Team

ref:_00D1U1174p._5004Q2NURhK:ref

[Jonathan Stack]

Hello,

May I get an update on this please? Also would it be possible to get an ETA so I'm not constantly bugging you. 

Thank you

[Google Ads API Forum Advisor]

Hello,

I've followed up even more aggressively to try to get some information here. I will let you know if I learn anything that can help.

Unfortunately, we can't provide any ETA for when this might happen. Please don't worry about following up for updates. I understand that this is negatively impacting you and I'm trying to get someone to help.