In this world you’ll either be really organised, or not organised at all. I’m afraid I’m really lame and I’m as organised as they come, because I’m SUCH a perfectionist. Don’t get me wrong, it’s a good trait to have but I’d much rather be one of those people that run on 3 hours of sleep every night or something. Anyhoo, I thought I’d put my organisation skills to good use and share my top tips with you all, including some documents I use for organisation and things like that. After reading this post all of you messy lot will fall in LOVE with spreadsheets (basically, I’m gonna give you templates).
This one may be self explanatory, but as a blogger I use billions of pictures and if I didn’t store them in an organised way I’m pretty sure I’d go mad. In my pictures I have a blog folder, and then I have every folder named “POST #…” (with the number and name of post) for each blog post so that way they stay in order of most recent blog posts and when I want to look for old photos I know whereabouts to look. I’m sure this one is pretty basic, but I bet there are some of you out there that search through 200 post folders to find the one you’re looking for.
When it comes to naming the folder, the number comes first then I name the folder with the name of the blog post – sometimes I’ve no idea what the blog post title will be until I’ve written the post but I always go back and change it (that way you won’t get confused about which ‘pretty dress’ folder to look in).
I have other folders, one called ‘Important’ which is for invoices, another for my media kit, and of course another folder for Instagram Photos (I hate it when they just get lost in my downloads when I get them from Dropbox). I also keep my Instagram photos in monthly folders, fyi!
ONGOING WORD DOCUMENT.
One thing I always have open on my laptop is a Blog Word Document. In this I have random lists of posts to-do, money I’m owed, collaborations that are outstanding and things like that. Sometimes I find paper to-do lists get lost and I always forget to keep up with them, but because I’m always on my laptop I can always jot down random light-bulb moments.
Click the link below to see a template of my document (also this is mega simple don’t expect anything special and you’re all fully capable of doing it, but if you cba then you have no excuse).
THE BLOGGER SPREADSHEET.
If you’re a blogger and don’t have a blog spreadsheet then HOW DO YOU COPE?! When I first started blogging I created a huge spreadsheet to keep track of everything I was receiving, any income I was getting and things like that. I’ve got tabs for different categories (for example, fashion, beauty, homeware) and then a tab for income, with amounts and the dates they were paid. This is the most helpful thing in the world because everything I’ve achieved is in one place – it’s also great to see what brands you’ve worked with if you want to add them to your media kit or mention them in emails to PR companies, and it’s also great to look at and create monthly/yearly goals to better yourself. I update my spreadsheet every two weeks or so with my latest blog post collabs.
Below I’ve added the template to my spreadsheet, there’s a homepage which directs to other pages so you can download it and change around the names/categories etc – hope some of you find this helpful!
Side note: fully aware of how boring and plain my documents are but I have mine spruced up with my blog font and whatnot, so play around with it to make it all look funkaaay! It’s worrying how I actually enjoy having this spreadsheet, but it makes me feel so stress-free because I’ve got everything documented in one place!
THE STATS SPREADSHEET.
Not gonna lie, I’m not sure why I have my statistics in a different spreadsheet to my blogger one, but I find the other is for post links and income, whereas this one is literally just for my statistics. I basically have simple monthly columns for my views, users and whatnot. I find it really helpful having all of this because you can compare views from month to month and see when your posts are doing best. Even though a lot of people say statistics aren’t important – if you want to work with companies they might ask for your statistics. Think about it, if you were a brand you’d want to be able to see how many views you get. I have a separate page on this spreadsheet for my followings on social media which I update monthly too.
Like before, click the link below to download the template of my spreadsheet!
Well guys, I really hope some of you are gonna get super organised with your blog – I’m sure most of you already are, but for some the idea of creating a spreadsheet might be their idea of hell… So I hope you find it useful!