Create Custom Google Analytics Report for Best Day of Week on Your Blog

by Robyn Wright on April 17, 2013

in Social Media,Tech

Tutorial on how to create a custom report in Google Analytics to see which day of the week has the best traffic on your blog Most of us have a vague idea on what days work best on our blogs. For me, I know that the weekends have lower traffic generally speaking. I was not quite sure of which day of the week was actually my best though so I thought I would find out with Google Analytics.

Now, I have to say that I am not a pro at Google Analytics in the least. Most of it confuses me to be honest. However, I was able to figure out how to make a custom report to help me find the answer to my day of the week question so I thought I would share with you all for Work Wednesday.

  1. Log in to your Google Analytics account and go to the blog (on the list) that you want to create the custom report for.
  2. Now click CUSTOMIZATION at the top of the screen
    Step 1 of creating custom days of the week report in Google Analytics
  3. Next click NEW CUSTOM REPORT
    Step 2 of creating custom days of the week report in Google Analytics
  4. You will then be presented with a form to complete. Enter the name you want – I used “Best Day of the Week”. Then in the “METRIC GROUPS” area click the “+ add metric” button and select “VISITS”, then from that menu scroll down and select “VISITS” again. Now in the “DIMENSION DRILLDOWNS” area click the “+ add dimensions” button. First select “OTHER”, then select “DAY OF WEEK”. Now the SAVE button.
    Step 3 of creating custom days of the week report in Google Analytics
  5. Once you save it will take you to the page with the report – scroll down just a bit past the regular chart you see and you will see a table. Note that Google Analytics uses numbers for days of the week instead of actual names. Why? I do not know. 0=Sunday, 1=Monday, 2=Tuesday, 3=Wednesday, 4=Thursday, 5=Friday, 6=Saturday
    Step 4 of creating custom days of the week report in Google Analytics
  6. You can change the style of report to what you prefer using the buttons at the upper right of the table. The above image is the default, then there is a pie chart, performance, and comparison. The last is a pivot which doesn’t work well for this type of report.
    Step 5 of creating custom days of the week report in Google Analytics Step 5 of creating custom days of the week report in Google Analytics

    Step 5 of creating custom days of the week report in Google Analytics

  7. To add this new custom report to your dashboard is easy also. On the custom report page you just made, at the top select ADD TO DASHBOARD and a box will pop up. Select “My Dashboard” (or whatever dashboard you like if you have changed the defaults), CHECK the box for TABLET, then click the ADD TO DASHBOARD button. Now when you go to your main Google Analytics dashboard you will see the table.
    Step 7 of creating custom days of the week report in Google Analytics

Again, I am not a pro at Google Analytics and there may even be an easier or better way to do this but this is how I managed to do it for myself and it worked.

Also – at the beginning of this post I stated weekends are not my strong days on my blog but the screenshot examples I shared show that Sunday is my best day. This is just a fluke because last Sunday I had a major Pinterest surge on one item that was 3 times my normal traffic. You can adjust the dates you are making the chart with in the top right just like all the Google Analytics reports if you need to. Normally my best days are Tuesday and Wednesday.

What is your blogs best day of the week for traffic?

© 2013, Robyn Wright. All rights reserved.

  • Leslie Mayorga

    FABULOUS!!!! I DID IT Robyn! Thanks for the great tutorial!

    Leslie

    • http://www.RobynsOnlineWorld.com/ Robyn Wright

      You are very welcome Leslie! Glad you found it helpful! Subject: Re: New comment posted on Create Custom Google Analytics Report for Best Day of Week on Your Blog

  • http://twitter.com/nicholee Nichole

    Very cool! My best days are Monday and Tuesday. The worst are Friday and Saturday.

    • http://www.RobynsOnlineWorld.com/ Robyn Wright

      Glad you found this useful!
      Subject: Re: New comment posted on Create Custom Google Analytics Report for Best Day of Week on Your Blog

  • Ravzie

    I didn’t realize blogging was so complicated!!!

    • http://www.RobynsOnlineWorld.com/ Robyn Wright

      LOL – well the blogging part isn’t complicated really, but if you are blogging and it turns into your work for you then there are some technical things like this that are helpful in working with brands and sponsors. Subject: Re: New comment posted on Create Custom Google Analytics Report for Best Day of Week on Your Blog

  • http://twitter.com/rkosully Robin

    I like how you provide screenshots for this step-by-step tutorial; that makes it very easy to follow!

    • http://www.RobynsOnlineWorld.com/ Robyn Wright

      Thanks Robin! I like screenshots on tutorials I use myself so I try to be visual when I make them for others too. Subject: Re: New comment posted on Create Custom Google Analytics Report for Best Day of Week on Your Blog

  • http://twitter.com/MoneywiseMoms Gina Lincicum

    Wow–I was so surprised at the results for my blog. Mon-Tue-Wed were almost identical and much higher than the other days. Then Thurs-Sun (even Sun!) were identical. Very interesting!

    Thank you so much for the tutorial!

  • http://twitter.com/4hatsandfrugal Amiyrah Martin

    Robyn, this just blew my mind! I followed all the steps and was surprised to see that Wednesdays are my biggest traffic days. I was so sure that Mondays were. Thanks so much for this tutorial!

    • http://www.RobynsOnlineWorld.com/ Robyn Wright

      So glad it was helpful! Seems like many of us thought Monday’s were best in error! Subject: Re: New comment posted on Create Custom Google Analytics Report for Best Day of Week on Your Blog

  • http://twitter.com/uncommonchick Lakesha Brown

    Gosh, thank you chica for this detailed tutorial! I’m surprised by my highest days which are Tuesdays and Wednesdays (both 18%) and here I thought it was Mondays (which a lot of people would think I presume) LOL …thanks boo!

    • http://www.RobynsOnlineWorld.com/ Robyn Wright

      Heck I’m surprised you needed a tutorial on this – you seem to do better on the technical end than I do! Subject: Re: New comment posted on Create Custom Google Analytics Report for Best Day of Week on Your Blog

  • http://thedeliberatemom.blogspot.com/ Jennifer | The Deliberate Mom

    This is GREAT! So helpful! My best day is Wednesday. I have no idea why. Interesting. My worst days are Fri-Sun.

    Thanks so much!

    Wishing you a lovely day!
    xoxo

    • http://www.RobynsOnlineWorld.com/ Robyn Wright

      Glad you liked the tutorial!
      Subject: Re: New comment posted on Create Custom Google Analytics Report for Best Day of Week on Your Blog

  • http://www.facebook.com/schultz.samantha Samantha Vales Schultz

    This tutorial is great! Thanks so much for sharing – I plan to implement this later today!

    have a fabulous Friday!

  • http://twitter.com/shan910 Shannan Younger

    Thanks so much for sharing this – great info!

  • Margaret

    Well Imma have to try this out and find my best day Thanks!

  • Danielle

    I just followed this tutorial and it worked great! My best day is Wednesday. Also…instead of “day of week” you should choose “day of week name” This way it will actually say the day of the week instead of a number!!

    Danielle at Framed Frosting

Previous post:

Next post: