Pfthb

I'm pulling some simple stats from the AdWords API and I want to enhance it to bring back YoY data.

I want to get total clicks, impressions, ctr for a month in 2017 and 2018.

My Goal: pull this data in 1 call...I don't want to have to call the API twice every time I need to compare 2 date ranges.

I'm not certain AWQL can cater for this though. Can anyone advise? Here's my code...

var googleService = adClient.GetService(Services.V0.GoogleAdsService);

string query = @"SELECT date, metrics.impressions, metrics.clicks, metrics.ctr
FROM campaign
WHERE date BETWEEN '2018-10-01' AND '2018-10-31' 
OR date BETWEEN '2017-10-01' AND '2017-10-31' // <- this bit is not working
LIMIT 50";

 PagedEnumerable<SearchGoogleAdsResponse, GoogleAdsRow> response =
 googleService.Search(customerId.ToString(), query);


if(response!=null && response.Count()>0)

 //then (just as an example), I could extract my info like...

 long clicks2018 = Convert.ToInt64(response.Where(n => n.Date.StartsWith("2018")).Sum(n => n.Metrics.Clicks));
 long impressions2018 = Convert.ToInt64(response.Where(n => n.Date.StartsWith("2018")).Sum(n => n.Metrics.Impressions));
 double ctr2018 = Convert.ToDouble(response.Where(n => n.Date.StartsWith("2018")).Sum(n => n.Metrics.Ctr));

 long clicks2017 = Convert.ToInt64(response.Where(n=>n.Date.StartsWith("2017")).Sum(n => n.Metrics.Clicks));
 long impressions2017 = Convert.ToInt64(response.Where(n => n.Date.StartsWith("2017")).Sum(n => n.Metrics.Impressions));
 double ctr2017 = Convert.ToDouble(response.Where(n => n.Date.StartsWith("2017")).Sum(n => n.Metrics.Ctr));