Day of the Week & Time of the Day Google Ads Report in Looker Studio

If you're running your Google Ads campaigns at all times, then you might benefit from creating a Day of the Week and Time of the Day Report in Looker Studio. This report allows you to examine the day of the week and time of the day when ads are most effective, which you can use to make informed decisions about when and how to allocate your advertising budgets. This quick and easy guide will show you how to create a Day of the Week and Time of the Day Google Ads Report in Looker Studio. Let's dive in!

➡️🎥 Check our YouTube Channel for more Looker Studio Tutorials!

➡️ Say something nice! or ask me anything!✨💬

How to Create a Day of the Week and Time of the Day Google Ads Report in Looker Studio

1. Click on Insert and add any visualization of choice

2. From the SET-UP column, under Dimension, select Day of week or Hour of day

3. Add any Metric of choice

4. Change the Sort to Day of week or Hour of Day

5. Customize your report's look and feel accordingly

1. Use the Combo chart to add multiple metrics of choice

2. Add the dimension Day of week or Hour of Day and add the metrics of choice

3. Navigate to the STYLE column and change Series #1 and Series #2 to Line / Bars accordingly

4. Set the axis of Series #1 to the Left Axis and Series #2 to the Right Axis

5. Show data labels

6. Compact the numbers

7. Change the grid color to Transparent

6. Repeat the same steps for any visualization of choice

7. Add a drop-down list (filter) for Day of week or Hour of day (Optional)

You can add a drop-down list and set the dimension to Day of week or Hour of day. You can then use it as a filter to look at performance on a specific day or hour.

Frequently Asked Questions on Day of the Week and Time of the Day Google Ads Report in Looker Studio

📈 What can I learn from day & time performance data in Google Ads?

• Best times when people click your ads

• Which days get the most sales

• Patterns in how people interact with ads

• When to increase or decrease your ad spending

🔍 Can I filter by both day and time together?

Yes! Here's how to do it:

1. Click "Add a Filter" on your report

2. Choose "Day of Week" and "Hour"

3. Select the times and days you want to see

4. Apply to see results for specific time periods
   

⚡ How can I spot the best-performing times?

Look for these patterns:

• Hours with highest conversion rates and lowest cost per acquisition

• Days with highest conversion rates and lowest cost per acquisition

📋 What are the most important metrics in Google Ads?

Key metrics to watch:

• Conversions

• Cost per Conversion

• Conversion Rate

• Cost / Conv. Value (ROAS) for eCommerce accounts

🔄 How often should I review time-based performance?

Best practices for review:

• Weekly for large Google Ads accounts, spending upwards of $10K / month

• Monthly for medium-size Google Ads accounts, spending up to $10K / month

• Quarterly: for small Google Ads accounts, spending less than $5K / month