Nuurek Nuurek - 7 months ago 36
Javascript Question

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

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

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