What does it do? 

The Report Hourly Stats Enhanced Scripts allows you to view hour-by-hour progression of your account performance. It runs once every hour, and stores the daily stats for the selected metrics during every hour of your defined time.

Why should you use it?

  • It automatically gets hourly stats for your most important campaigns, ad groups and keywords from Google Ads.
  • It keeps track of attributes that the Google Ads system does not provide historical data for. For example, you can use this script to record the Quality Score of your most important keywords every hour. Google Ads does not store historical QS so the only way to get this data is to save it.
  • It understands the delivery curve for your ads, so you can understand if most of your budget is spent at a particular time of the day. 
  • It records stats to know which time of the day has most conversions.
  • You can monitor your top 10 most important keywords more closely than the rest of your account by automatically putting their latest stats into a spreadsheet, which you can then use to feed into a dashboard.

How does it work?

Choose the account you want to run the script in and go to the All Enhanced Scripts page. The script lets you set basic and advanced settings. 

You can either create a new setting selecting 'Create new setting' or 'Copy setting from an existing account'. To create a new setting, follow the steps below:

Basic Settings

Setting Name

Enter the name you want to give the setting. You can have multiple settings for the same script, and you can choose to pause and enable these settings as you wish. 

Name of Label to Track

Specify which items to include in the report by using a Google Ads label. Enter the exact name of the label that you applied to the items in Google Ads that should be included in this report. This can be helpful if you have a very large account or well-segregated campaigns based on product category. For example, if you put 'Brand' in this field, the script will run for all campaigns that have 'Brand' in their name. 

Sort Results by this Metric

When you have set a numerical limit for how many keywords, ad groups, or campaigns to include in the report, use this field to determine the sort order so that the report will include the items in the order which is most important to you.

Email Addresses To Notify

If you would like to send a notification email every time a new report is ready, you can enter the recipients' emails in the 'Email Addresses To Notify' setting and they will be notified. Multiple email addresses can be entered using a comma separated list.

Advanced Settings

Maximum Number of Campaigns to Track

If you collect hourly data for all campaigns, you may quickly exceed the capacity of a Google sheet. So we give the option to either specify which campaigns to include (using Google Ads label) or the maximum number of campaigns to be tracked. We recommend to track up to 50 campaigns.

Maximum Number of Ad Groups to Track

Specify which ad groups to include in the report by using a Google Ads label or you can specify the maximum numeric value. We recommended no more than 50.

Maximum Number of Keywords to Track

If you collect hourly data for all keywords, you may quickly exceed the capacity of a Google sheet. So, you can either specify which keywords to include in the report by using an Google Ads label or you can specify the maximum number of keywords to include with this field. We recommended no more than 50.

Share Results Spreadsheet with these Google Accounts

The email address associated with the Google account of everyone who should have access to the spreadsheet generated by this script. Use a comma separated list for multiple email addresses. 

Did this answer your question?