Hi Google Ads team,
We recently noticed a performance issue when we switch to use Google Ads API to download the adgroup structure report. It seems like Google Ads API is much slower than the Adwords API (v201809). To validate our observation, I have written 2 CLI programs in Java to log the time to download the adgroup structure data of 2 accounts with different APIs. We logged the time from the request being fired until we finish iterating over all the rows (do nothing in the loop) in the downloaded content.
The test results are as follows:
Google Adwords API
Run #1
Time to download and iterate by lines for account
5259617269 is 00:04 (165554 rows)
Time to download and iterate by lines for account 1497931133 is 00:08 (268578 rows)
Run #2
Time to download and iterate by lines for account
5259617269 is 00:03
Time to download and iterate by lines for account 1497931133 is 00:03
Run #3
Time to download and iterate by lines for account
5259617269 is 00:03
Time to download and iterate by lines for account 1497931133 is 00:07
---------
Google Ads API
Run #1
Time to download and iterate by lines for account
5259617269 is 01:26
Time to download and iterate by lines for account 1497931133 is 02:25
Run #2
Time to download and iterate by lines for account
5259617269 is 01:25
Time to download and iterate by lines for account 1497931133 is 02:35
Run #3
Time to download and iterate by lines for account
5259617269 is 01:27
Time to download and iterate by lines for account 1497931133 is 02:33
As you may find above, time consumed by Google Ads program was much longer than the program using Adwords.
Hope this issue could be brought into the team's attention. We are wondering if there is a better way to download reports with Google ads API or could you let us know if there will be any plan on improving this?
Thanks in advance!