• Skip to main content

Annielytics.com

I make data sexy

  • About
  • Services
  • Tools
  • Blog
  • Portfolio
  • Contact
  • Log In

Jul 15 2013

How To Create Month-Over-Month Custom Reports In Google Analytics [VIDEO]

month-over-month Google Analytics reports

If you have to run a report in Google Analytics that shows traffic over time, you’ll need to use a custom report. Custom reports allow you to choose Month of Year from the Dimension drop-down. Then all you have to do is choose your date range, and the report will break down traffic by month. There are a couple gotchas along the way, which I point out in this short, three-minute video.

One caveat to be aware of though is the formatting for Month of Year is jacked up. So you’ll need to take a few additional steps to format them as dates in Excel.

Learn More

If you want to learn more about working with custom reports in Google Analytics, check out the other video I did demonstrating one and this post describing how to create a pivot table-friendly custom report in GA. Of course, you’ll need to know how to use pivot tables in Excel for that second post to be of value. If you don’t, I provide a soup-to-nuts video tutorial on how to create and work with pivot tables here.

I rarely ever work with standard reports anymore. And neither will you when you see how much more powerful custom reports are, especially because they include report filters. If you ever have to choose between working with a filter or advanced segment, choose filter every time to avoid sampling.

If you want to become crazy marketable with advanced analytics skills, check out my Analtyics Audit Template, a self-guided, 147-page audit template that is regularly updated and will teach you how to do detailed analytics audits like a pro.

Image by Mark Faviell.

Written by Annie Cushing · Categorized: Analytics

Reader Interactions

Comments

  1. Matthew Kushinka says

    October 7, 2016 at 10:36 am

    Thanks for this post and video, Annie. Exactly what I was looking for!

    Reply
    • Annie Cushing says

      October 7, 2016 at 11:13 am

      Perfect! ?

      Reply
  2. Tharindu says

    September 17, 2018 at 5:38 am

    Annie, Thanks for this. Small issue. So if we get that monthly report as per the video and get the month selected by date from Google Analytics, numbers are different. Can you please explain that?

    Reply
    • Annie Cushing says

      September 18, 2018 at 7:25 pm

      Hard to know without seeing. Could you email me w/ screenshots and more details? annie@annielytics.com

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Copyright © 2025