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:
- The Basic Truth of Mental Health
- How To Start Your Public Speaking Career
- The Biggest Mistake in Marketing Data
- Marketing Data Science: Introduction to Data Blending
- You Ask, I Answer: Google Tag Manager and Google Analytics Integration?
Want to read more like this from Christopher Penn? Get updates here:
Get your copy of AI For Marketers