Hi,
Thank you for sending us your screenshot privately. The API unfortunately can only report on individual production accounts and not in one shot on all of an mcc's underlying accounts. I will bring up with my team a request to supply that capability to API reports. You may monitor our
blog for an update.
Regarding a query that can match your report taking into account the above mentioned restriction on API reports, I tried this:
"SELECT customer.descriptive_name, metrics.cost_micros, metrics.conversions, segments.date,
campaign.name, customer.currency_code FROM geographic_view WHERE segments.date BETWEEN '2021-10-01' AND '2021-10-20'"