How I use Spreadsheets to Organise my Blog

How I use Spreadsheets to Organise my Blog

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.

Blogging Schedule

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

Spreadsheet Blogging Schedule

Monthly Stats

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

Spreadsheet Blogging Monthly Stats

Income

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.

Spreadsheet Blogging Income

Expenses

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.

Spreadsheet Blogging Expenses

PR Samples

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

Spreadsheet PR Samples

Events

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.

Spreadsheet Blogging Events

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:

Blog Organiser Spreadsheet 

Let me know if you found this helpful and if you are going to start using spreadsheets to manage your Blog.

Instagram | Bloglovin’ | Twitter | Pinterest

Follow:
Share:

4 Comments

  1. January 14, 2016 / 10:47 pm

    Wow you got this post up quick! Thanks for sharing your tips. I do use a spreadsheet to keep a track of income and expenses and I will set one up for stats (only just started recording stats). As for scheduling, I have a notebook and use CoSchedule for that. x

  2. January 15, 2016 / 11:31 am

    So useful, thanks for sharing!

    hannahsnotebook.net

  3. January 25, 2016 / 10:22 am

    This is SO useful 🙂

    sophie-rose.co.uk x

Leave a Reply

Your email address will not be published. Required fields are marked *