Extremely long query times on getting a lot of data.

[AVB Analytics]

Hello everyone,

I work for a private company where we deal with Google Ads. We have approximately around 600 accounts under our manager account. Each of the manager account has around 10 campaigns, and each campaign has around 10 ad groups. And each ad group has around 20 ads. We are developing auditing tool that will be checking inputs of our employees to Google Ads account. So we can squeeze 100% out of Google Ads platforms. Less errors higher results and performance. For this tool we are getting data from Google Ads API via JSON object. The problem is in the qureing time. For example I query all of the ads under 50 accounts and it takes around a minute to query all of them. The object that I get back is around 250000 lines. If I will do the same thing for all of our accounts that will grow exponentially and take around 10-15 min to just get all of the ads. That is too long of a response. I am looking for a way to solve this issue. As I understand in order for me to audit the data I will have to get all of tit or at least chunks, but that does not matter will take a long time .... Also we are going to be expanding in couple years so our accounts will double. What would you suggest ?

Thank you.

[Google Ads API Forum Advisor Prod]

Hi Team,

The Google Ads API is put back into 'beta' phase due to performance concerns. We recommend to continue running production systems using the AdWords API. While Google Ads API is in “beta”, you may use the new API for testing and development work in preparation for future migration. Please keep in mind that during this "beta" phase, there may be breaking changes in the Google Ads API.

Regards,
Nikisha Patel, Google Ads API Team

ref:_00D1U1174p._5001UHHoe0:ref

[Google Ads API Forum Advisor Prod]

Hi Team,

Apologies for rewriting. Could you please share the complete request and response logs along with the client customer id for our team to look into the performance issue faced while querying ads via Google Ads API? Please use Reply privately to author option while sharing the details.

Regards,
Nikisha Patel, Google Ads API Team

ref:_00D1U1174p._5001UHHoe0:ref

[AVB Analytics]

Hi I never got your response. Did you look into the staff that I sent in the private message.

[Google Ads API Forum Advisor Prod]

Hi Team,

We are awaiting the requested information from your end to investigate this issue further. Could you please share the requested information in private message for us to assist you better? Please use Reply privately to author option while sharing the details.

Regards,
Nikisha Patel, Google Ads API Team

ref:_00D1U1174p._5001UHHoe0:ref