You can view an updated tutorial, and download the new google analytics dashboard in excel here.
Enter your name and email to receive a download link for free!
Or download the new one here:
Google Analytics Dashboard in Excel
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.
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.
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
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?
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.
Glad you like it.
Something definitely seems wrong, and it could be the disconnection from the raw data, or the format being pasted in. I have since recreated the above, and updated it a little.
You can find a new tutorial here: http://seoinexcel.com/advanced/google-analytics-dashboard/
This might help you out a little bit more.
If it’s a data connection issue, you can find out how to fix that here;
Click here to cancel reply.
Copyright © 2014 SamPartland.com.au. All rights reserved.