Marketing

How to Track Your Content Editorial Calendar in Databox

In this episode of Data Snacks, I walk you through how I built this simple editorial Databoard using only Databox and our native integration with Google Sheets.

John Bonini John Bonini on May 14, 2019 • 2 minute read

A couple of weeks ago I built a Databoard in order to track our editorial output here at Databox. (Seen below.)

Now, before I even finished that sentence, it’s likely your first thought was––just output, really? What about results? Traffic? Signups? What about quality over quantity? Isn’t volume for the sake of volume an exercise in vanity?

I hear you. Your reactions are valid.

However, we don’t track output from a content standpoint simply for the sake of volume.

Instead, because we know how our content efforts influence the rest of our business, we use output as a leading indicator for acquisition and sales.

We’re largely a content-driven organization. (Last month, 65% of our traffic came from organic search. )

So, since our acquisition model is largely dependent on our content efforts, tracking output gives our team a great starting point in terms of understanding performance in real-time. Most importantly, it’s a metric that even the individual writers can influence.

Often times, marketing teams are tasked with improving metrics that have multiple outputs across several teams. So, when you ask your team to improve signups, there are probably dozens of activities they can do in order to do so. 

However, if you have a good feel for how individual activities influence the rest of your business, then measuring those activities as leading indicators (in our case, content output) is a meaningful metric that individual contributors can influence.

In this episode of Data Snacks, I walk you through how I built this simple editorial Databoard using only Databox and our native integration with Google Sheets.

Oh, and also I’ve created a public link to the Google Spreadsheet I use to track all of this, which you can have. It’s basic so you can customize it however you’d like.

I’ve already included the formula in the ‘volume’ column which will automatically calculate a ‘1’ any time you add a new post to this spreadsheet. So, just make a copy of the spreadsheet and its plug-and-play.

Hope you find it helpful. Enjoy. 

About the author
John Bonini
John Bonini is Director of Marketing at Databox. He's passionate about building brands that tell great stories. Connect with him on Twitter @bonini84.
You may also like...
Read more

Conversion Rate Optimization: How to Discover Your Next A/B Test

95% of conversion rate optimization (CRO) experts prioritize their split-tests. Here’s how you can find (and test) the ones that are worth the effort.

Marketing   |  May 23

Read more

The 17 Essential Website KPIs for Measuring Your Website’s Performance

We polled more than 50 marketers to find out the most important website KPIs all of us should be tracking.

Marketing   |  May 22

Read more

Landing Page Optimization: How to Identify the Right Tests for Increasing Conversions

In this episode of Data Snacks, Juli Durante of Smartbug Media shows us how to identify the right CRO opportunities for increasing landing page conversions.

Data Snacks   |  May 22