Fetch Metrics for large manager account

[Vipul]

Is there any way to fetch metrics from shopping_performance_view resource for all manager sub accounts using single query. I have large manager account which has more than 500 sub accounts.

Currently I making request for each sub account one by one and aggregating them manually but this causes huge performance issues and takes about 20-25mins to generate aggregated report.

Is there any work around in google ads API  V12 to fix this  or any other way in PHP?

Below is the query:

SELECT segments.product_item_id, metrics.cost_micros, segments.date,customer.id
FROM shopping_performance_view WHERE segments.date = '2023-01-05'

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API team.

Regarding your concern, please note that Google Ads API pulls metrics data through client accounts. So you need to retrieve metrics data by individually sending requests to client accounts.

Additionally, Google Ads API has this code sample which shows how to download a set of reports from a list of accounts in parallel. However, this code sample is not available in the PHP client library.

Let us know if this is what you're looking for.

Regards,

Carmela Google Ads API Team

ref:_00D1U1174p._5004Q2iyDHl:ref

[Vipul]

Hello 

After research I have found this API

https://developers.google.com/ad-manager/api/reporting

Can this API overcome this issue I mentioned previously ?

[Google Ads API Forum Advisor]

Hi,

Thank you for getting back to us. I hope that you are doing well today.

Moving forward to your concern, I can see here that the link that you have provided is an ad manager api link. Please note that our team only provides support for Google Ads API related concerns and when it comes to Google Ad Manager API, please be informed that this is beyond our scope and we cannot provide any comments if the link will help you fetch the metrics of your Ads using Manager account. With this, I would suggest that you visit this link (https://support.google.com/admanager/community?hl=en) to ask also for insights with regards to the documentation you found.

Regards,

Google Ads API Team

ref:_00D1U1174p._5004Q2iyDHl:ref