How can I request metrics form shopping_performance_view for all sub accounts of google ad manager account in single query ? I have more than 500+ active sub accounts.
Currently I making request for each sub account one by one and aggregating them manually but this causes huge performance issues and it takes around 20-25min to generate a aggregated report. is there any work around in google ads api V12 to fix this or is there 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 [email protected] To unsubscribe from this group, send email to [email protected] 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/c969981b-48d4-44c7-8aa1-e11261b6d156n%40googlegroups.com.
