Using Excel To Analyse Your Blog Statistics: Part One – Referral Pie Charts

Using Excel To Analyse Your Blog Statistics

How important are Stats to Bloggers?

I think that every blogger will admit that they check their stats fairly often. WordPress provides a great tool with figures and graphics allowing for us to check our stats in an simple way to pick out lots of useful info.

However, it’s quite limited and not very exciting.

Can we make our stats look more sexy?

What if we want to show to prospective collaborators how well our blog is doing? Or…what if we’re just sad and a little geeky and love to mess about in Excel? What’s possible with our WordPress stats and some Excel loving? Let’s find out…

Using Excel charts to visualise Wordpress stats

This isn’t going to be a step by step tutorial but merely showing the end results. A step by step tutorial can be provided (that’s my day job and I’m not at work right now) if required.

Pie Charts

The simplest of the chart family. Simple and very effective if used correctly. They always work best with one data series with only a few categories. You can have them flat, 3D and if you are feeling really adventurous – exploding! Oh yes – who said Excel wasn’t fun?

What can I use a Pie Chart for on my WordPress stats?

If I wanted to know where all the traffic in the year 2016 was coming from to reach my blog – I could use a Pie Chart for that.

Pie Chart: Traffic Referrals

This does it’s job really well and tells me that the majority of my traffic comes from search results. As this is the first time I’ve seen this in graphical form I’m quite surprised by the small amount that comes from Twitter – some work obviously needing done there then!

The section in green above represents ‘others’ – all the other miscellaneous items that couldn’t have been included as it’s own data point in this Pie Chart otherwise it would have just looked too busy.

However, these ‘others’ are important too and they need to be represented too – so let me introduce the Pie Of Pie Chart.

What is a Pie Of Pie Chart?

When you have a small piece of the pie that is made up of a number of categories that don’t have big enough numbers to part of the big pie – put them in a separate pie. Think of it as when you are eating a lovely apple pie and some of the filling has oozed out and is dribbling down your chin!

Pie Of Pie Chart: Traffic Referrals

What do you think? Easy as pie, right? Now when someone asks ‘where does all your blog traffic come from?’ it’s much easier to show this than having to go into your Stats page and try and work it out from there.

This was all done using only Microsoft Excel and is the first in a series of posts that will explore all the chart types in Excel and how you can use them to analyse your blog’s stats.

Would you find this useful? Do you love Excel as much as I do? Let me know in the comments below or tweet @SteveSays2014

Using Excel To Analyse Your Blog Statistics

 

 

Advertisements

14 thoughts on “Using Excel To Analyse Your Blog Statistics: Part One – Referral Pie Charts

  1. Very eye-catching pie charts, Mr McPherson, but I’ve never really been able to trust those WordPress stats. They just don’t always make sense. For example, at The Bloggers Bash, Suzie showed me how many times people had visited my blog as a referral from her blog, yet my own stats show a completely and far lower figure. I could go on, but it’s just one example. These days I only use the stats to see which blog posts are the most popular so I can write more posts about those subjects. However, nothing stopping you showing us all those other excel charts.

    Like

    1. Thanks Hugh, yeah I only use them mostly for posts etc but it’s quite interesting to see other stuff too. Especially when you see a view from a country you thought was a made up country lol…oh and yeah, any excuse to use Excel 🙂

      Liked by 1 person

    1. Yeah kinda but you can post your own stuff sometimes so long as it’s not all the time. There’s no crazy mods like reddit is. Mind you reddit quite good if you stick by their rules. I enjoy the popheads subreddit 🙂

      Liked by 1 person

      1. Ha! I like Christmas (although this year will be tough) but I don’t like all the craziness in the run up. This has just reminded me I need to douse the Chrimble cake though!

        Like

That's what I thought, tell me what you think...

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s