I have been using spreadsheets to organise my blog now since August and it has made a huge difference to how I keep track of everything that I need to be doing. There’s actually a lot more admin than I had first anticipated when starting a blog so it’s good to have everything all written down in one place to revert back to. I save my spreadsheet on a pen drive and then that goes everywhere with me! I’ve kept my spreadsheet pretty basic but it has all the information on it that I need.
I currently have 6 tabs that I work with and they are Blogging Schedule, Monthly Stats, Income, Expenses, PR Samples and Blog Events.
This tab contains the yearly calendar and each date is filled in with the blog post I have published / plan to publish on that date. I also fill out future dates with possible blog post ideas that I can work on.
I have a coloured coded key so I can easily see at a glance what posts need working on and which ones are ready to publish.
Green = Post Completed
Red = No Post Day
Yellow = Photos Taken
Orange = Writing Done
I currently track all my Social Media accounts stats, my DA and my Monthly Views. I think those are more than enough to see how your blog is doing and what areas you need to work on most.
Green = Increased Stats
Red = Decreased Stats
Yellow = Stayed Level
Sometimes I get paid for working with Brands and Companies and for Tax purposes you should always keep a record of what you are paid as well as your outgoings. I keep my Income and Outgoings spreadsheets separate at the moment as I don’t have many outgoings.
I write the date of the income & the type of income it was. If it was for a particular post I include the link to that once it has been published. I write the amount I am due and then mark it off once it has been paid in full. I also include the total at the end so I can see how much I have made that month.
The expenses section is very straightforward and just contains the date the item was purchased, what I purchased and the total cost it came to. It is always important to keep a track of what you are spending on your blog for future tax purposes.
I used to just keep track of my PR samples via Emails I had been sent but in the end that got too confusing and I was forgetting to post about certain products. I now keep a short and simple spreadsheet with the date I received the sample, the item I was sent and by who, the date the blog post was published and whether I have contacted the company to let them know the review is live.
Red = Not Writing about the Product
Green = Product Review Completed
I have recently started listing the events I plan to attend / have attended so I can look back quickly over the year to see where I have been.
I hope this quick tutorial on how I use spreadsheets for my blog has been helpful. If you want you can download your very own copy here:
Let me know if you found this helpful and if you are going to start using spreadsheets to manage your Blog.