Planning your editorial content

Learn how to plan and keep track of your editorial content on a spreadsheet

Intro

Content marketing isn't new, sure. But that doesn't mean every business is truly exploiting all its potential. If your content strategy looks like a sporadic collection of random blog posts and social media updates, you're treating customers more like a group of curiosity seekers than an audience of targeted users.

In this short guide, we will show how to use Rows to create a flexible and customizable starting solution to organize and track your editorial plan.

Here is a sneak peek of what you will get:

content calendar intro

What is content marketing

Content marketing is the process of creating and distributing a variety of digital assets, from blog posts to video tutorials, guides, white papers and ebooks, with the ultimate aim of providing information to your tareget audience.

When organizing your editorial plan, it's important to understand how your team works and what are your ultimate needs: this will allow you to come up with a easy to use and effective solution. Spreadsheets are a very flexible tool, and perform pretty well in this regard.

But of course, there's no such thing as the perfect editorial plan. Nonetheless, the following questions will help you shape the tool based on your actual needs:

  • How frequently are you going to publish content? Daily, weekly? Finding out how often you publish can tell you how to structure and visualize the plan.
  • How the approval process look like? What are the various stages content needs to go through before it's published? Knowing this will help you define the fields and the values you need to keep track of all the steps.
  • Do you create more than one type of content? Do you just have a blog, or you run a more articulted social media strategy? Based on the answer, you want to customize fields based on the type of content you are going to deliver.

Let's go!

To start, use visit Rows' Content calendar template page, click on Use template and save it in one of your workspace’s folders.

This template offers you an easy user interface to keep track of all the important information about your content that needs tracking, all in one convenient place.

Let's go through its logic together.

Use Column A to input the date in which you aim to publish your content. Columns B, C and D contain the main features of the content, such as the headline, the copy and the external link.

Screenshot 2022-09-15 at 11.45.34

Columns E, F and G are devoted to project management: they help you keep track everything related to the author, the status and the channel on which you plan to publish.

Screenshot 2022-09-15 at 11.46.31

All dropdown lists can be personalized with custom inputs in the 'Settings' page, to best fit your internal processes and organization. Just add or edit any content of the cell, and the new item will appear in the respectve dropdown.

Screenshot 2022-09-15 at 11.49.15

You might also like