Data-Driven Content, Blog Post Ideas & Spreadsheets For Social Media Analytics

Data-driven content, dealing with blogger’s block, how to use spreadsheets for social media analytics and tips for quitting a bad habit, are some of my favourite finds that I’ve decided to share by creating this weekly round-up.

Here’s some of this week’s cool posts:

• 5 Steps To Creating Data-Driven Content: Information rich content and relevant data are king! Gone are the days of fluffy content and space fillers. With the amount of data available online, it has never been easier to cite the sources where you’ve gathered your data be they academic journals, research reports, white papers or authoritative blogs. This article shows you how and where to find valuable information to make your content shine.

• WordPress 3.4 “Green”: It’s that time again when the fantastic folk at WordPress release a new version of this popular platform, codenamed “Green”. This update includes some nifty new features like significant improvements to theme customisation, custom headers, Twitter embeds, and image captions. If you’re running your site(s) on WordPress, get the update now to take a test drive.

• Spreadsheets For Social Media Analytics: This post is an oldie but a goodie! You can use these ready-made spreadsheets to do things like; fetch Twitter search results, count Facebook “Likes”, compare Facebook Pages, monitor social media reputation and  extract or archive your Twitter followers.

• 20 Techniques To Help You Counter Blogger’s Block: If you’re struggling to come up with fresh content ideas for your blog, this collection of tips should help you keep your editorial calendar nicely filled! I’ve been playing around with point 15 in this post – compilations of other bloggers’ posts – which allows a really easy way for me to generate a blog post from content I’ve read over the course of the week. A great read if you want to brainstorm some blog topics.

• Track Your Shares, Likes, Tweets & More: If you’d like an overview on where a specific post has been shared, SharedCount is the tool for you. It provides you with web-based social URL analytics so you can see where your content gets shared and currently displays shares on Facebook, Twitter, Google+, Digg, Pintrest, LinkedIn, StumbleUpon, Delicious and Reddit.

• How Your Rankings Are Influenced By Authoritative Links, Likes & Shares: Google loves fresh content! Google also loves content that people share on Google+, Facebook, Twitter and through the social-sphere. Social signals are very important to Google and to your rankings. This post provides some interesting details about research that was carried out by Philip Petrescu.

• How To Make Your Meta Descriptions Get More Clicks: I’ve been tweaking and optimising some meta data for 4 large websites over the last 3 months and this post interested me because it details how you could get more clicks from rankings you already have.


  • and last but not least:

• 12 Tips For Quitting A Bad Habit: Everybody has bad habits, right? So how do you go about quitting doing something that you know is bad for you? Some of my current bad habits are smoking, not exercising and not getting enough sleep. Using some of the tips in this infographic I hope to get ready for quitting some of them…

Pedro Da Silva

Online Marketing Junkie

My name is Pedro Da Silva. I have built-up a wide range of digital media skills over the last 13 years working in the web industry. From front-end web design and graphics, to SEO and online marketing. I'm creatively, commercially and technically minded. South African born & bred, I work in the UK online marketing industry. I'm a proud dad & husband that loves music, photography and mixed martial arts.

Leave a Reply

Your email address will not be published. Please enter your name, email and a comment.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>