Google Ads Audit Overview:

This is part 12 in our Google Ads Audit tutorial series where we review Hour Analysis.

We'll use Data Studio Report, Google Sheets/Excel and Google Slides to help collect and analyze the data. This can be used to perform bid adjustments, exclusions, and campaign strategy changes. Also, much of the campaign management can be automated through Google Script so it can be adjusted monthly.

6.      Now Sort the data by Cost. We want to see the biggest cost subjects here. This is in military time; it’s Eastern.

Take a look and determine what are the most expensive times. I would do bid adjustments on these top ones. This is a visual cue.

Now you will need to update the spreadsheet, which has the script of the 24/7 bidder. If it’s not here, then go to the Ad Account Maintenance Checklist.

From there, go down to the bottom and click 24/7 Bid Multiplier.

Copy the blue highlighted text.

Go back to the account, then go to Scripts.

Click 24/7 Bid Multiplier, create new script.

And paste it in here.

Once that is in place, make sure this spreadsheet has changed.

And that's how you do the hour of the day analysis.

The next tutorial in this series will tackle Auction Insights.