How can I get the date when cost was greater than or equal a certain value in PHP?

[Κωστας Μαυρογαλος]

Hey yall.

As the title suggests, I want to build a query which returns the date when the total cost of an account was greater than or equal to a certain value.

So far, I have made this: $query = 'SELECT campaign.start_date FROM campaign WHERE metrics.cost_micros >= 700 LIMIT 1'; which isn't right, as it doesn't return the date where $700 were spent, but rather the start date of the campaign that surpassed $700.

Thank you in advance

[Google Ads API Forum Advisor]

Hello,

Thanks for reaching out to the Google Ads API Team.

I understand that you want to obtain the date when you spent $700. I would like to suggest adding segments.date to your query to segment your result for by day. Kindly refer to the provided segmentation guide as this will explain how segmentation will affect the data that you are pulling. Please also refer to the campaign query builder and query validator to create and validate your query.

• segmentation guide - https://developers.google.com/google-ads/api/docs/reporting/segmentation 
• campaign - https://developers.google.com/google-ads/api/fields/v14/campaign_query_builder 
• query validator - https://developers.google.com/google-ads/api/fields/v14/query_validator 

If you have further data that you want to retrieve via the Google Ads API, then you may send us the uncropped Google Ads UI screenshot as the API mirrors the UI so our team can provide precise recommendations

I hope this information is helpful. 

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

Thanks,
 

Google Ads API Team