Campaign Charges by Month

[Jessica Owen]

https://groups.google.com/g/adwords-api/c/FiU9iW0hNFw/m/rpM-vRXRAQAJ

Per the above conversation, it's determined we cannot retrieve invoice cost breakdowns...only totals. A recommendation was made "to query the metrics.cost_micros field from the campaign resource and set the date range to be a monthly range"  to try and replicate. 

I'm using the Google Ads Query Builder and can't figure out what date range I'm suppose to set.  Can you confirm what date range field I use to filter? Also am I able to retrieve other cost details that would be in a monthly invoice such as adjustments?

So far I figured it's this:

SELECT metrics.cost_micros FROM campaign WHERE campaign.id = [CAMPAIGN ID]

[Google Ads API Forum Advisor]

Hi,

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

I would recommend you to try the below query where the date range is set from Aug 1st to Aug 30th 2023. Moreover, I would like to inform you that you cannot retrieve adjustments since the adjustments field is incompatible with cost_micros. Please refer to the Google Ads Query Builder and Query Validator tools for building and validating your queries.

Query : "SELECT metrics.cost_micros FROM campaign WHERE campaign.id = [CAMPAIGN ID] AND segments.date BETWEEN '2023-08-01' AND '2023-08-30'"
 

This message is in relation to case "ref:_00D1U1174p._5004Q2p0NsT:ref"

Thanks,
 

Google Ads API Team