retrieve clicks/impressions, etc reports by the hour? For 24 hours a day in one report?

[Michael D]

Hi,

is it possible to retrieve  clicks/impressions, etc reports by the hour?


And also for example if I want a plot with clicks versus impressions for the last month, then im doing 30 seperate requests for every Day in this month. This takes too a lot of time.

Is there another way to do this in one request?

Thanks in advance

Cheers,
Michael

[Aditya]

Are you using ad hoc reports? https://developers.google.com/adwords/api/docs/guides/reporting

If not, try pulling one of these report types, and it should do the job for you. Here's a pretty thorough example. You can easily set the dateRange as the last 30 days, the last week, or any custom date range, and it'll pull all the relevant data (you can request whichever statistics you want) from that time period. I'm not sure if Google tracks the data on an hourly basis though.

[Raghavendra Soudala (AdWords API Team)]

Hi Michael,

You can use HourOfDay field, that allows you to retrieve report for each hour in one report. But that is only available in the ACCOUNT, CAMPAIGN, and ADGROUP performance reports.  

As Aditya mentioned, if you set the DateRangeType as LAST_30_DAYS then it would do the job for you. In addition here are the various Date range types and Report types that are supported. 

Thank you for your post@Aditya.

Cheers,

Raghavendra, Adwords API Team.

[Michael D]

Hi Aditya,

yes im using ad hoc reports.

At Raghavendra, HourOfDay field solved my issue.

There is also DayOfWeek and MonthOfYear what make sence if I want to plot over a longer Date Range.

Thank you,

Cheers,

Michael