RE: [Google Ads Query Language] Get every day of last month in one call ?

2019-10-15 Thread Google Ads API Forum Advisor Prod
Hi Jason, Thank you for reaching out. In order to get every day, you need to add "segments.date" to your SELECT clause. Your AWQL statement should look as follows: SELECT campaign.id, campaign.name, metrics.cost_micros, segments.date FROM campaign WHERE campaign.statusIN [ENABLED] AND segment

[Google Ads Query Language] Get every day of last month in one call ?

2019-10-14 Thread Jason.B
Hi, I use the google ads api beta, try to take last month cost_micros for all my campaigns group by day, but, after testing and reading documentation, I still didn't find a solution to take every day of the last month like : (month/day) 01/01 : cost_micros => 5 01/02 : cost_micros => 4