Google analytics tip: easy insights with day of the week data

Google Analytics’ day of the week custom report lets you compare data specific to the days of the week. You can take a big picture comparison – which day of the week are you receiving the most site visitors, for example – or you can compare days of the week against each other – was Friday’s site traffic an improvement over the previous Friday’s? Unlike more complicated analytics reports, the day of the week custom report is extremely simple to set up and easy to understand, and the quick-look insights will entice you to make immediate adjustments to your marketing strategy.

Day of the week custom report
A ton of manpower goes into strategizing, creating, and updating content on your website and in your emails. Comparing day of the week analytics data can help you determine when to make updates. For example, if you are getting the highest website traffic numbers on Saturday mornings, you should evaluate what kind of content you offer on Saturdays that entices more people to browse your site. You can then create like-minded messaging to publish on another day of the week, and measure whether this improves your site traffic that day.

Conversely, if you have the highest sales and receive the most revenue Friday mornings, than you might offer a discount on Mondays, when your revenue is the lowest, and see whether the promotion boosts sales.

Perhaps, you need to take down your site for maintenance or a big update. Use the day of the week report to determine when your site is least trafficked for the best day to perform the update. The day of the week report is only your starting point, but by making small changes to your marketing plan and measuring the results, you can develop a winning weekly strategy.

Setting up your Day of the Week report
Let’s pretend you want to set up a custom report to measure which day of the week your e-commerce site receives the most revenue. You also want to measure site visits and average order value, to see whether the day of the week with the most revenue correlates to larger traffic and order values on that day.

    1. In your Google Analytics dashboard, click on ‘Customization’ at the top of the page.google analytics customization reportDay of the Week custom report

 

  1. Click New Custom Report.
  2. Give your new report a Title and a Name. We chose: Day of the Week for both fields.
  3. Select your metric group. We chose three: Revenue and Average Order Value (under Conversions) and Visits (under Visitors).
  4. Add your dimension under the Dimension Drilldowns. For this report, our dimension is Day of the Week Name, listed under Time.
  5. Save your report.

Below is your sample report. Sorting by revenue, you can see that Monday is the day your site collects the most revenue and receives the most traffic, but Wednesday is the day of the week the average order value is the highest. These results are for one month’s time (set at the top of the Analytics page). By comparing results for other weeks and months, you can drill down to what makes Mondays special – do you offer a weekly discount or post a certain kind of blog post? You can then begin strategizing on how to replicate Monday’s success on other days of the week.

google analytics Day of the Week report

Analytics insight is all about making incremental changes and measuring the success. Play around with the metric groups and days of the week dimension to gain insight into how weekly and daily traffic is affecting your overall bottom line. Than tweak, measure, and repeat!

  • TheRunnerDad

    Very helpful. Thanks!

    • Thank you for reading! Let us know if you have any questions or if we can help you further.

  • Pingback: Custom Reports in Google Analytics – Day of Week | theanalyticsworld()

  • Tara

    Great resource! I learned something new today. Thank you!

  • Thanks, this was a big help!

  • We’re glad you found it helpful @disqus_pQRrNgDJHP:disqus! Please reach out if we can help you further.

  • Would be nice if Analytics had a feature to get average day of the week or (day of week)/(Count of particular day). Easy to do in a spreadsheet but another step. Maybe I am missing something?

    • Ben

      agree!

  • funkdified

    Once you have followed the walkthrough above, you may be frustrated that the days cannot be sorted in chronological order. The solution is to add a secondary dimension for “day of week” (which assigns an integer to the days of the week Sunday=0, Saturday=7), and sort by that column.

  • Juan Betancourt

    Just what I was looking for, thanks

  • Pingback: How to Create a Simple Content Calendar in Under 60 Minutes()