Welcome to my 23rd monthly blog update, all about what I got up to behind the scenes of Charlotte’s Lively Kitchen in May 2016.
This month I’m going to be sharing an awards update, my new photography boards and a little bit of technical geekery (embedding excel calculations into wordpress posts).
A little bit of background…
For anybody that’s new to these updates and is wondering what on earth I’m going on about, I write these posts each month as a way to keep me focussed on building my blog (fear of sitting down to write the report and finding I have nothing to say is great for ensuring I keep trying new things). It is also to try and help other bloggers (or people thinking of getting started) to learn from what I’ve tried and to copy the good bits and avoid some of my mistakes. I also share all of my blog’s key stats so you can see how it’s going and decide whether my advice is worth listening to or not!
A big thank you
A couple of weeks ago I discovered that I made it through to the final 5 in the Britmums Brilliance in Blogging Awards – Best Food Blog category so I need to say a massive “thank you” for all of your votes, I wouldn’t have made it though without all of your support xx.
This means I’ll be heading down to London for the Britmums Live conference on the 25th June and then the awards are announced in the evening. If you’re also going to Britmums Live then let me know as I’d love to say hi.
While I’m busy celebrating achievements, I also discovered that I’m the Foodies 100 Blog of the Month for June. There are around 5000 blogs in the Foodies 100 so it was a huge honour to be selected. I’ve done a little interview with them which you’ll find here if you’d like to take a look.
New food photography boards
Recently I’ve been scrolling through the pictures from some of my favourite food photographers (as I do regularly) and I’ve been increasing convinced that the boards I’ve been using could be better. Previously I’ve used laminate floorboards stuck to MDF, but these really lack the texture of real wood and also have a slight shine which can make lighting a photograph awkward.
I decided I needed to get some real wood and after browsing a few local garden centres (there was a lovely lady in one who I’m convinced thought I was mad as I explained that I wanted planks of wood to make a pretend table top, but that they had to look a bit worn and manky). In the end I opted for buying some decking planks from B&Q (the fact that they’re stored outside and therefore open to the elements helps them to look weathered). They were an absolute bargain – a 3m board was only £9 and in my local store they have a woodshop where they cut them to size for you so I got them to cut them down into 1m strips which I lay side-by-side for photography. I’m still on the lookout for more different textures/colours of wood to use, but I’m already a lot happier with how much easier it is to take pictures on the new boards than the old shiny ones.
One of my new boards in use in my recipe for 3-minute Mediterranean vegetable lasagne
If you’re after some cheap boards, I’d definitely recommend heading over to B&Q or you local builders merchants, as there’s a huge selection of wood and it’s all pretty cheap, especially compared to what you can pay for antique table tops. If you’re more DIY minded than me you can then paint them whatever colour you want (there’s absolutely loads of tutorials online for creating boards with all sorts of different colours and effects – search “food photography board tutorial” on Pinterest and you’ll come across all sorts).
Embedding an excel calculator in a blog post
OK, this is a bit of a geeky one that very few (if any) of you will want to try but I thought I’d mention it just in case you’ve been desperately wanting to add a calculator to a blog post and didn’t know how!
My birthday cake recipe is very popular and I often get comments asking for the ingredients needed to make it in different sizes. I’ve tried out a few different sizes and within reason you can simply factor the ingredients up or down to the size of the tin. To save me having to get my calculator out each time someone asked, and also so that people could get an instant response rather than waiting for me to reply to my comments, I decided to embed a calculator directly into a post. All they now need to do is enter the size of the tin and the number of layers and it lists out all of the ingredients you need.
Here’s an example if you want to have a little play and see how it works…
Embedding an excel workbook is really simple…
- If you don’t already have one, create a Microsoft one drive account online.
- Upload the file to your one drive account.
- Select the file and click “embed”. If you want to embed the entire workbook, simply copy the code on the righthand side of the screen into your wordpress text editor.
- If you only want to display a section of the workbook (I only wanted to show the inputs and outputs and hide all of the ugly calculations), select “customise how this embed will appear to others” and specify the range of cells you wish to show. Also, tick the box saying “let people type into cells”.
- Copy the embed code and paste it into your text editor in wordpress.
To ensure that people could only type in the input boxes (tin size and number of layers). I originally saved the workbook with all other cells protected. If you try to type into any other cell an error message comes up.
Once again, sorry if this one isn’t for you, I just thought I’d share in case you could do with a calculator of some type on your blog and weren’t sure how to add one in.
All the numbers…
All in all May has been a pretty unexciting month with visitor numbers remaining flat and pageviews up very slightly. I’ve definitely noticed that I have quieter days when the sun’s shining, I suspect that people want to be outside rather then spending hours at a computer browsing recipes on Pinterest!
One thing I’m pleased about is that despite visitor numbers remaining flat there has been a little growth in pageviews. I’ve been actively trying to increase pageviews per session over the past few months by looking at which posts have a high bounce rate and then seeing if I can link to other posts that might interest people viewing those pages. It’s great to see that effort paying off.
Charlottes Lively Kitchen – Visitors
Charlottes Lively Kitchen – Pageviews
If you’re looking at these graphs and wondering what caused any changes in the past you can find all my old reports in my monthly reports index.
So where did all of these visitors come from…
- Google – 35,443 (+6%)
- Pinterest – 11,937 (+84%)
- Direct – 11,172 (-30%)
- Yummly – 1,458 (-28%)
- Tumblr – 879 (+19%)
- Foodgawker 781 (+70%)
- UK Pinterest – 521 (-25%)
- CraftGossip EdibleCrafts – 375 (-33%)
- Dan 330 – 351 (-25%)
- Facebook Mobile 340 (+222%)
After an odd few months it feels as though Pinterest is finally settling down again. You can see a huge rise in Pinterest visits (up 80%) but this corresponds to a drop in Direct, overall the level from both has stayed about the same. Sadly the combined level seems to have settled down at about 24k per month compared to peaking at around 30k earlier in the year, but at least it’s starting to be a bit more predictable again (I like predictable!). One thing I’ve noticed is that I’m seeing different boards doing well to the ones that had been doing well before. If you’re using group boards I’d definitely suggest taking a look through at re-pins on each board (or saves as Pinterest now likes to call them) and see which boards are doing well and therefore worth a bit more focus. There’s a couple of boards that had been hugely successful for me and are now performing terribly. I fear that they got too big and Pinterest started identifying them as spammy, I’ve really been cutting back from pinning to those as I really don’t want Pinterest deciding I’m spammy by association (no idea if that would happen but as Pinterest is my 2nd largest visitor source I need to be a bit cautious).
Still pretty boring, although Pinterest leapfrogged Twitter, becoming my 2nd most popular social network.
Charlottes Lively Kitchen – Social Media Followers
My plans for June
I always used to share what I had been planning to focus on over the coming month in these reports, but then as I started writing them later and later in the month it because a strange “this is what I’ve already done but I’m not going to tell you how it’s gone for another month” basically it stopped making any sense. Now that I’ve started writing these reports earlier again, I thought it would be worth sharing my plans . So here they are…
- I’ve just joined Food Blogger Pro (run by the people behind the hugely successful Pinch of Yum blog). They only open for new joiners every now and again so I thought I really should give it a go while I could. I’m going to be having a good look around and I’ll feed back next month on whether you should be getting your name onto the waiting list.
- Making some changes to my Food Year Linkup – over the past few months I’ve been mulling over some changes I’d like to make (nothing too drastic) and I’ve decided to finally get on and do it.
- Sorting out my Pinterest – creating some new boards and reviewing the ones I already have.
- Improving my photography – all the pinning I’ve been doing over the past few days has given me food photography envy and quite simply I want to get better.
What are you planning for your blog over the next month?
That just leaves me to say thanks for reading. As always, if you’ve got any questions then I’m more than happy to help xx