How to get 'Hour and day of the week' report using AWQL

Question

Using ad scheduling on AdWords in my Search Network only campaign I can see 'Hour and day of the week' report. It shows campaign performance values on a given day and time. I would like to utilize this data in AdWords script. Is it possible to access them through AdWordsApp class or AWQL? If so then how can I do it?

Answer 1

DayOfWeek and HourOfDay are segments on a CAMPAIGN_PERFORMANCE_REPORT so you can certainly get the same thing using AWQL.

For example:

SELECT CampaignName,CampaignId,Impressions,Clicks,ConvertedClicks,DayOfWeek,HourOfDay
FROM CAMPAIGN_PERFORMANCE_REPORT
DURING LAST_MONTH