Most performatic way to fetch amount spent on ads per day

[Andre Luis Zipf]

Greetings!

I need to fetch the total amount spent on ads on a per day basis. The query I created for this is the following:

SELECT metrics.cost_micros,
                campaign.id
FROM ad_group
WHERE segments.date = '%s'
AND metrics.cost_micros > 0

Is this the correct way to fetch this information? is there a way to improve the performance of this query, as I usually need to fetch at least a month of costs per request.

Thanks!

[Google Ads API Forum Advisor]

Hi Andre,

Thank you for posting your concern to my team.

If you want to get the cost on each ad, then the correct report type that you can use is ad_group_ad and add the metrics.cost_micros and campaign.id.

Let me know if you have further questions.

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q2Llsqe:ref