How to Improve Content Marketing with IQR: Part 2

Warning: this content is older than 365 days. It may be out of date and no longer relevant.

How do you know whether your content game is getting better or worse? It’s easy to rely on stock analytics tools, and for the beginning content marketer, tools such as Google Analytics are more than enough. For the veteran marketer who is creating content, how can we know with greater precision whether our content is getting better or worse? How can we more quickly diagnose the bad, double down on the good, and make our program sing?

In part 2 in this series, we start to dig into the data we’ve collected and identify early opportunities. If you haven’t read part 1 to get your data, go and do it first.

We left off with all of our data in columns. Let’s tackle the bad news. How bad is the bad? Because this is social media data, I’ll prune out replies, leaving only the content I want to share. Once I’ve correctly sorted and cleaned my data, I’m ready to analyze.

Take the bad stuff column and chart a simple line graph. Depending on how much data you have, this may be a taller order than it sounds. Below, I’ve taken the bad stuff – my lowest quartile – and charted it out:


This is tough to interpret, so let’s right click and add a trendline:


In general, we can see that the worst of my posts, the posts that got the least amount of exposure, have still been on the rise. If we zoom in a bit, we can see that the trend in the lowest quartile has gone from about 1,800 impressions to a little over 2,200 over the span of 6 months:


This is a solid improvement in the least well-performing content. The next step for me would be to go back over the data and identify when things changed. Was the improvement consistent over the same period of time?

What about my best stuff? How’s the boundary between good to great? Let’s repeat the same process, from making a chart to applying a trendline:


We see improvement… but look carefully. The improvement from beginning to end in this six month timespan is shallower than we saw in the bad stuff. This tells me that the best stuff resonated more, but didn’t grow as fast as the bad stuff.

So, we know what the good stuff did. We know what the bad stuff did. Is there a relationship between the two? Is there some insight we can glean from both of them together? Stay tuned; tomorrow, we’ll look at the difference between good stuff and bad stuff, and how to interpret it.

You might also enjoy:

Want to read more like this from Christopher Penn? Get updates here:

subscribe to my newsletter here

AI for Marketers Book
Take my Generative AI for Marketers course!

Analytics for Marketers Discussion Group
Join my Analytics for Marketers Slack Group!


Leave a Reply

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

Pin It on Pinterest

Share This