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'

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/7a319977-08da-4791-9b67-25df56991114n%40googlegroups.com.

Reply via email to