I don’t always write an entire post when I make a new one (that takes time and I’m very
lazy busy). But this one is particularly awesome and helpful for you, my fellow bloggers. It’s a spreadsheet/printable for tracking blog stats, popular posts and social media following.
I’ll go through it step by step and share some tips on how you can improve your blog by using stats.
WHY STATS MATTERS
Do they really? Eh. Meh. Kinda.
It’s not unimportant to get views, but it’s not necessarily a sign of quality either cough clickbait cough.
For a lil’ blogger like me, stats help me figure out what content I should be making more of. But the master of my content is still my gut feeling because the most important thing is that I enjoy writing for my blog.
A recent example of how stats have helped me is the printables. I didn’t really think it was something you’d like. Only some of them fitness or health related, the main themes of my blog. But the stats clearly proved me wrong! Rather than hardcore athletes, you’re a regular person like me. You want to get fitter and eat a bit healthier – but you still have other interests, including blogging. Numbers can’t tell me that, that comes from analyzing my community – what do people talk about in the comments? What kind of people follow me on social media? Honestly, a lot of spam accounts, but there’s a ton of lovely people in there too.
FREE PRINTABLE + SPREADSHEET
The printable (pdf-file) comes with editable fields, so you can change the month, social media names, and fill out the tables before (or instead of) printing.
Are you ready?
Grab a hypothetical pen and paper, and let’s get started.
The first table is for the generic stats. Depending on your blogging platform, you might not be able to get all data, but you can find everything but comments and likes with Google Analytics. WordPress.com stats only have the number one, three and the bottom two.
- Views: The number of time a page/post is loaded.
- Sessions: 1 session = 1 person has visited your site and seen one or more pages within 30 minutes.
- Unique visitors: The number of people that has visited your blog.
- Views/session: How many pages a person views when they visit your blog on average (automatically calculated in the spreadsheet).
- Duration: How much time the average person spends on your blog. Use decimals 1.5 instead of 01:30
- Bounce rate: % of people visiting your blog from a bouncy castle. Or was it the number of people leaving your blog after viewing just 1 page rather than continuing to browse.
- %New visitors: Regular readers vs new readers.
- Comments: The total number of comments left on your posts this month.
- Likes (only for wordpress.com): The number of times WordPress users have liked your posts.
Take some time to look at the changes from last month and decide if there’s something you want to improve for the next month, or what you’ve done in the past month that helped grow your stats.
Use this table to figure out what kind of content your readers love. In the spreadsheet, you can click the little arrow next to views and choose sort by – the same goes for comments and likes – What kind of content gets a lot of views and what kind gets most engagement?
Take a look at last month, and see how those posts performed compared to this month. Do you notice any patterns?
Social media is the death of real relationships, am I right?
Except for the fact that I have met some of the sweetest, kindest and most inspirational people and friends because of social media. And I love it! Where else would I meet people as crazy as me?
If you have more/fewer accounts, you can just add/delete a column.
- Followers: So on most social media, you have this option to “Follow” people. You might have heard of it.
- Referrals: You thought you were done with the blog analytics? No! Head back there and figure out how many views you get from each
- Posting frequency: How often do you post? Twice a day? Once a month?
- If you want the spreadsheet to calculate the change, enter posts per day. So twice a day=2, twice a week =2/7, twice a month=2/30.
Do you see a connection between the numbers? Is the number of followers or the posting frequency most important for driving traffic to your blog? Are you missing out on potential views because of a low posting frequency?
You can use the note field to write out goals for the next month. Instead of just writing xxx followers, try thinking a little further – Do you want to post more of a kind of content? Do you want to engage more, find new people to follow? Streamline what you post on your accounts?
To get a new month in the spreadsheet, duplicate the current one by right clicking on the tab at the bottom.
Take some time not only to write down you stats, but also to consider why they are the way they are. This can help you plan what direction you should take your blog and how you can improve it. Doing it too often can make you doubt small decisions without reason, but a monthly review can help you to continue to grow. But the most important thing is still that you enjoy what you do!
If I didn’t answer a question you have about the spreadsheet, don’t be afraid to ask.
Did you find this helpful? Did your stats reveal something new? Let me know in the comments if you would like to see more posts like this