Using Airtable to manage editorial content

https://blog.airtable.com/content/images/2020/12/news.jpg

Manage and streamline your editorial process with a custom content calendar designed for your team’s workflow needs.

Editors—whether they’re working for a media company, a business’ in-house content team, or a content agency—need to be able to keep up with the frantic pace of the modern digital publishing cycle. They need to be able to execute on individual stories, maintain a consistent publishing schedule, and work cross-functionally with other teams, all with an eye to high-level strategy. Editorial calendars are an indispensable tool for making this all possible: streamlining the entire publishing process to ensure a consistent output of content.

Despite the name, the best editorial calendar isn’t just a calendar: it’s also a tool that allows your whole team to brainstorm ideas, give assignments, track the statuses of all pieces as they move through the content pipeline, and manage content review—all in one centralized, single source of truth. But most of all, the best editorial calendar is the one which matches the needs of your team.

Editors working as journalists, bloggers, content marketers, and more use Airtable to create their own custom editorial calendars. Here are 10 great example templates demonstrating how Airtable users have created their own editorial calendars:

These templates are all excellent starting points, but you can also make any of them even better for you with a bit of additional customization.

Case study: a journalist’s editorial calendar

Let’s take a closer look at one of these editorial calendar templates. This template was put together by writer and editor Laura Blackwell (previously of PCWorld and TechHive), and shows the workings of a fictional satirical news website.
This base uses different field types (which appear as columns, in this spreadsheet-like grid view) to hold different types of information related to each story. Date fields can be used to coordinate scheduling, embargoes, and due dates; colorful single select fields allow you to track the current status of each story, mark the section to which a story belongs, or assign a copy editor.

With single select fields, you can choose from a dropdown list of set options.

How to modify an Airtable template to match your editorial calendar needs

Laura Blackwell’s template demonstrates just one of many potential ways you could design an editorial calendar in Airtable. As mentioned previously, the best editorial calendar is one that incorporates the specific elements of your team’s processes and needs, so let’s walk through some of the ways you could adapt this template.

The more you know about your own needs, the easier it will be to make the right adaptations—so before starting, you should answer some questions about your teams’ processes:

What content formats does your team work with? Does your team exclusively write blog posts, or do you also make videos? What about shareable social images? If your team works with many different content formats, it might make sense to add a custom select field with the different format types to your base so that you can sort and filter by the different formats as necessary. What stages does your content go through before it’s published? No matter how complex or simple your pipeline is, you’ll need to make sure that you can easily identify what stage of the pipeline each piece is currently in. Depending on the quantity of content

Continue reading

This post was originally published on this site