Excel Reporting Dashboard for Google Analytics

UPDATED DASHBOARD

You can view an updated tutorial, and download the new google analytics dashboard in excel here.

 

Or download the new one here:

Google Analytics Dashboard in Excel

 

6 Comments »

  1. Brittany September 1, 2015 at 6:58 am - Reply

    Hi!

    I absolutely love this report! The only issue I’m having with it, is that my company does weekly reporting so I wanted to convert the months to weeks (so that 12 weeks would show at a time and the year comparison would just be the previous 3 months) but I’m having so much trouble with it. Whenever I change the template to weeks instead of months I keep getting an error message when I go to refresh the table saying that “Excel can not open Pivot table report file”

    Would you be able to help me, or walk me through it? I’d really appreciate it. I love the report and would really like to apply it within my company.

    Thanks!

    • SamPartland October 16, 2015 at 10:33 am - Reply

      Hi Brittany,

      Glad you like the report!

      Sorry for the delay in getting back to you, but unfortunately this is an excel issue that I haven’t worked out a good solution for yet.

      If you delete the slicers (or change their settings so you disconnect them from the data temporarily), you can then change the data source for the tables. You do this by clicking on a table, then going to one of the tabs and you will see an option for ‘change data source’ or similar.

      You will then just need to change that to say the RAW tables name, and it should update to the new data.

      I will try get everything updated, and provide a bit more detailed response on how to update if it does break.

      Cheers,
      Sam.

  2. lazrak March 1, 2016 at 1:00 am - Reply

    Hi sir,
    first of all thank you for publishing such helpful document.
    When i try to copy the exported data from GA as your tutorial says in the channel box, it happens to be ok. However, i get some error message on the left side (year/month alone/ month and market).
    Could you tell me a little bit more about it?
    Thank you very much

  3. Louise May 10, 2016 at 10:41 pm - Reply

    Hi there!
    I’d love to use this spreadsheet as this would be perfect. However every time I enter in my own data, it doesn’t connect it to the front page… Not sure why as I have followed your instructions and I’ve tried it three times. Could it be that I am using a newer version of Excel?

    Kind regards,

    Louise

  4. Peter January 6, 2017 at 6:48 am - Reply

    Great template; however, when you follow your directions, it doesn’t work for me. I get a #N/A message for the Month, Month Alone, and Year columns.

Leave A Response »