Change Status - get more than 10k records

[Danail Georgiev]

Hello,

I'm trying to get a list of new/changed campaigns and adgroups on a daily basis in order to maintain our internal database. I'm querying Change Status and it all works fine unless there are more than 10000 records per day. It's mandatory to include a LIMIT clause when querying Change Status and this limit should be no more than 10000. 

What would be the suggested approach to fetch all the records using Change Status.

Thanks,

Danail

[Google Ads API Forum Advisor]

Hi Danail,

Thank you for raising this concern to the Google Ads API forum.

With regard to your concern, "What would be the suggested approach to fetch all the records using Change Status." that you mentioned, could you please confirm if you are using the SearchStream method? Please note that the SearchStream method returns the entire result set back in a single response up to 10,000 records, which can be more efficient for bulk data retrieval. However, if you want to retrieve more than 10,000. You may use the Search method that uses pagination, with an adjustable pageSize parameter specified alongside the query.

For more information: 

• SearchStream versus Search
• Paging Through Results

Best regards,

Jinky Google Ads API Team

ref:_00D1U1174p._5004Q2a39yQ:ref

[Danail Georgiev]

Hello,

It seems the suggestion above was not at all verified.

Change Status requires a LIMIT clause, which can be up to 10000, regardless what method is used to fetch the data (Search or SearchStream) - https://developers.google.com/google-ads/api/docs/change-status

I've tried both methods, with and without LIMIT, with and without page size, etc. - the behaviour is basically as described in the docs.

Any other inputs would be appreciated.

Thanks,

Danail

[Google Ads API Forum Advisor]

Hi Danail,

Thanks for getting back to us.

For us to investigate and fetch all the records more than 10000 from change_status report, could you provide us with the complete request and response logs with the request-id, so our team can better check?

You may then send the requested information via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Regards,

Yasar Google Ads API Team

ref:_00D1U1174p._5004Q2a39yQ:ref