Change status service issue fetching more than 10k rows

[Rapolas]

Change event service issue fetching more than 10k rows (google.com)
Ran into the same problem, where in a split second there are more than 10k rows. This is with change status service. How can I fetch all the data in that split second? How do I know if all the data was fetched?

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to our API support team. To better assist you, could you elaborate on the "How can I fetch all the data in that split second?" concern?

As for your other question "How do I know if all the data was fetched?" you can also utilize the return_total_results_count setting to determine the total records that will match your query.

Best regards,

Peter Laurence Google Ads API Team

ref:_00D1U1174p._5004Q2dnbXD:ref

[Rapolas]

Hello,
There is a workaround to fetch change_events with LIMIT greater than 10000, as mentioned in this doc from Google 

which states,

The query must also include a LIMIT clause restricting results to at most 10,000 rows. If you're interested in more than 10,000 results, make a note of the timestamp of the last entry in the returned result set, and then set your date range on the following query to start after that time to continue where you left off.

But the `last_change_date_time` property of `change_status` returned by ChangeStatusService has the same value for multiple entries in the result set. So, is there a way to do the same with ChangeStatusService as with ChangeEventService?

[Google Ads API Forum Advisor]

Hi Rapolas.

Thank you for the reply.

I understand that there's documentation for the query that must also include a LIMIT clause restricting results to at most 10,000 rows, but please note that this doesn't mean that you can fetch all the data in a split second, Could you elaborate more on why you want to get all the records? I asked because this might cause issues like timeouts of requests. With this, I would suggest trying to add filters in your report or use segmentation to get a subset of data at a time. You can also check this documentation that supports paging by specifying page_size in your request. This will break up the result set of the query into multiple responses that each contains up to page_size objects.

Moving forward to this, “is there a way to do the same with ChangeStatusService as with ChangeEventService?” -Yes, you may use the change_event report but kindly note that change_status is more of a summary view, and for more details please use change_event report. ChangeEvent has the details you listed whereas ChangeStatus is missing some of these items:

• User making the change (user_email) - important: user_email
• Method (e.g. Google Ads UI, API, Script, Ads Editor etc.): client_type
• Change type (delete, update, create): change_operation
• Whats been changed/added/removed: change_resource_name

Also note that change_event is limited to the last 30 days and change_status is limited to the last 90 days.

Best regards,

Heidi Google Ads API Team

​​​​​​​

ref:_00D1U1174p._5004Q2dnbXD:ref