On this page:
What does it do?
The Report Hourly Stats Enhanced Scripts allows you to view the 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 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 the 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 by selecting 'Create new setting' or 'Copy setting from an existing account'. To create a new setting, follow the steps below:
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 the 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.
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.
If you want to receive script notifications over a Slack channel, you can do so by specifying the email address of the desired channel in the 'Email Addresses of Slack Channels to Notify' setting. Multiple email addresses can be entered using a comma-separated list.
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 a Google Ads label) or the maximum number of campaigns to be tracked. We recommend tracking 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 a 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.
Note: This script uses the same spreadsheet each time it runs. You'll find the newer results included below the previous runs. This way, you can make sure all the information is saved. If you'd like to access the previous versions of this document, you can go to File > Version History > See version history.