I have been using Google Analytics for a few years now and it has been really useful to modify my websites so they are more useful to my readers.
So, all my efforts modifying my sites, are they paying off? Do I get new readers? Is my site growing?
Google Analytics helps you with the technical details, (screen size, speed, etc) with the behavioral details (pageviews, time on page, etc) and even with your traffic sources (social, organic, etc). Everything is geared so you can grow your site, but to see how much growth you are getting on a daily/ weekly/monthly or year basis, you need to do it manually.
I want to find out in one single click, how much my sites are growing, and I can finally do it using Power BI. My site growth in one click. Excellent! I will show you what you will create, so you can decide right now if this for you or not already now.
Here is the dashboard (see picture below):
- The column to the left represents the actual number of sessions this year, month, week up to yesterday’s date, yesterday and today’s date
- The middle column represents the number of sessions last year at the exact same Week Day. For example, if today is 2015-12-02, this column will give the number of sessions up to 2014-12-01 (the day before)
- The column to the right represents the growth in percent.
NOTE: Why I am using Yesterday’s date instead of Today’s? Check the end of the post for the answer.