Download Custom Report to Compare Days of the Week in Google Analytics

by Tim Leighton-Boyce

Screenshot: Google Analytics Daily Report by Day of WeekHere’s a great custom report for you to try. There’s a link below to import the report straight into GA, but first let me explain why I think this is so exciting.

Retailers and other web sites with strong weekly visitor patterns need to be able to compare Mondays with Mondays and Saturdays with Saturdays.

Comparing the same day of each week over a long period is also very useful for any site planning emails or any other form of on-line campaigns.

So I was really excited when a comment on Linked In from Mike Sullivan of Nextanalytics provided me with the key to doing this.

Although I’m a huge fan of Custom Reports, for some reason I had not noticed that ‘Day of Week‘ is available as one of the dimensions.

In v1 of Google Analytics you used to be able to select all the ‘Mondays’ in a month by clicking on the top of the column in the calendar. But you could only do one month at a time and even that ability disappeared in later versions. It became necessary to do this kind of reporting outside of GA using Excel or a dashboard client.

Now you can do it all in a custom report, so I’ve made an example ‘weekday‘ report which you can download using a link at the end of this article.

Using Custom Reports is so much better and allows you to experiment with using secondary dimensions at the top level of the report. ‘Dimensions’ is the GA word for ‘what the data is that you’re looking at the numbers for’ — the information in the first column of the table. Dates or Days in this case. So you could add the source/medium for each day next to it in a second column, for example.

But first take a look at this standard version:

Screenshot: Google Analytics Custom Report by Day Tips

But my favourite view at the moment is to use ‘Day of Week’ as the top level dimension, and then drill down to ‘Date’. By using Custom Reports you can add a new tab to view the data that way round:

Screenshot: Google Analytics Custom Report by Day of Week

I’ve added the names of the days to the screenshot so you can see what’s happening. The report just shows the number of the day: 0 for Sunday, the first day of the week and 6 for the last day, Saturday.

This version of the report means you can see the average figures for all 7 days of the week compared to each other over an extended period. You can then drill down to see how each of the ‘Tuesdays’ compare with each other. That’s the insight which interests me most. The chart also updates to match, so you can choose whether to leave it with a single spike for one day each week, or change to ‘Graph by week’ view to see a continuous line.

Screenshot: Google Analytics Comparison ViewThese reports work really well in ‘Comparison View’ and ‘Performance View’, so be sure to experiment with those. But I’ve discovered that you can’t sort by the day of the week when you’re using that view, so you’ll need to be careful. There have been changes to the sorting functions during the last few weeks (weighted sort appeared and then disappeared), so this situation may well change.

How to Make a Day of the Week Custom Report in Google Analytics

The simple clue that ‘Day of Week’ is available as a dimension will have been enough for some people.

If you’d prefer to see how it’s done, I’ve made a 5 minute video showing each step.

Or if you’d prefer to save some time, use the link below the video to import a copy of the report and then edit it to match your business needs.

You’ll see in the video that I ran up against a problem when I went for overkill and tried to include all 20 goals and a load of extra ecommerce metrics. I was doing that because I thought it would be helpful to make a report which would work for everyone no matter which goals they use.

The final report does not include the final few goals, but you can download it into your own GA and see for yourself. Have a play with it and edit it to suit.

How to Import the Days of Week Google Ananlytics Custom Report

  1. Log into GA
  2. Click this link: http://bit.ly/GaDayOfWeek [opens in new tab] to import the report
  3. Don’t forget to scroll down to choose your profiles and then click save!

Things to Watch Out For

When you’re doing this kind of comparison it makes sense to use a date range which includes full weeks

If you’re using the ‘View by Day of Week’ approach it is vital to choose full weeks

The default sort order in GA is based on the first column of metrics in the data. I always repeat ‘visits’ in each metric group because it’s important to always be aware of the size/significance of the group of visits you’re looking at. But in these reports you will almost certainly want to sort by the dimension, not the metrics (the date or the day of the week). Don’t forget to click at the top of the dimensions in the table to change the sort order.

In the screenshots I’ve added the names of the days of the week. GA just gives you the numbers! 0 is your first day of the week, 6 the last.

Resources Relating to Custom Reports and Days of Week

Before you go, please give one of these sharing buttons a click:

{ 7 comments… read them below or add one }

Goran Giertz July 2, 2012 at 11:11 pm

Why does Google define the day of the week as a number and not the name itself. Is there anyway that we can exchange the number with the name. It confuses clients. Is there a way for us to change this.

Tim Leighton-Boyce July 3, 2012 at 8:39 am

I agree: it’s confusing for people using the reports. I expect that the reason is that the numerical value is convenient in data terms for sorting and because there are no translation issues, but it would be helpful if the information was converted at the reporting stage.

Goran Giertz July 3, 2012 at 9:37 am

Always the question is, is the 0 a Sunday or a Monday… Thanks for the speed response. Do you know a way of removing the year from the time to only show the hour in the day and not the date at the same time. Thanks.

Tim Leighton-Boyce July 5, 2012 at 6:13 pm

@Goran There is an ‘hour’ metric which you can use as a dimension in custom reports. But the effect of this would be to group the total for all the 14:00 metrics for all the days in the date range, which is not what I think you want.

I wondered if it was possible to do something useful with one of these dimensions as a secondary dimension, but that does not seem to work. I even took a look in the pivot table view, just in case. But no luck.

Salman July 19, 2012 at 7:29 pm

@Goran:

1) 0 is a sunday.

2) do not confuse the “hour” dimension with “hour of day” dimension. The “hour” dimension in fact represents hour of the day (00 thru 23) where as “hour of day” consist of the entire date except minutes and seconds (think of it as hour of year). Both type of reports are discussed here:

http://911-need-code-help.blogspot.com/2012/07/analytics-day-of-week-hour-of-day-report.html

Jemma October 19, 2012 at 1:14 pm

This link http://goo.gl/EluNF isn’t working…

Tim Leighton-Boyce October 19, 2012 at 2:36 pm

@Jemma: thank you for pointing that out. I’ve replaced it with a new link.

Leave a Comment

This blog is kept spam free by WP-SpamFree.

Previous post:

Next post: