How to choose and create the best calendar for your content

We all know what happens when editorial calendars don’t work. They can be time-consuming to create, and still leave your team uninformed and overwhelmed. Poorly constructed calendars become pain points for the people who need them the most—you and your team.

Editorial calendars that do work keep content creators in sync, and content flowing on schedule. With the right setup, it becomes a tool your team works in every day: it helps you collect inputs from stakeholders and manage your backlog, gives your partners just the right level of visibility, and allows you to customize your workflow to match the way your team works.

The right tools will make your editorial calendar easier to build, but it also matters how you build them. In this piece, we’ll walk through best practices for creating an effective editorial calendar. Read on for our step-by-step guide, or dive in and try our content calendar template yourself. 

What to include in an editorial calendar

Your editorial calendar should help you quickly understand and share production status—from granular, in-the-weeds details, to high-level, executive-level overviews. It may even be that the folks on your team need different views of your content...one designer may want far less detail than another, and your CEO may want more detail than your team lead. Because your calendar will (ideally) be used in so many different ways, it needs to be deeply flexible. 

At a glance, it should help you (and your stakeholders) answer questions like: 

  • Upcoming content — What assets will be live in the next week/month/quarter? 

  • Status updates — What content assets are at risk or delayed? 

  • Accountability — Who’s driving, contributing to, and approving each asset? 

  • Campaigns — What’s the full list of deliverables for our team’s campaigns?

  • Strategy — How does each asset map to our company goals?

The information you include about every asset will dictate the way your editorial calendar is used—and naturally, that’ll be a work in progress as your team evolves. You might, for example, realize that tagging assets by audience allows you to answer common questions from your performance marketing team, or that noting the original requestor makes follow-up research easier. Again: flexibility is key.

With that in mind, these are the pieces of information that most editorial calendars include:

  1. Due dates and publication dates

If your process is simple, you will probably have only one date for each asset—the date it goes live. If you have a more complex process, you probably need to capture intermediary steps, like the creative brief, author assignment, approvals, design, and publication. Mapping this workflow at the asset level will help you accurately predict production cycles—and hit your publication dates.

2. Status

Your stages should mirror the production phases for each asset, from ideation to publication. Lots of teams use statuses like: planning, writing, editing, production, staging, live (or published), on hold, or cancelled. There’s a strong correlation between due dates and status—you may even want to automate your status based on the due date.

3. Content type and channel

You’re probably producing multiple content types, and publishing to multiple channels. Noting these attributes will make it easier to filter views, map your workflow, and see your team’s capacity.

4. Headline and links

A proposed title and URL gives stakeholders a sense of topic and tone, and helps you keep track of multiple assets within the same theme or campaign. This is also one of the only unique attributes you’ll usually include—so it can serve as an identifier for each asset.

5. Content owner

The content owner should be the driver for each asset. As with any project, it's critical that you have one owner (not two, not none). If you want to get more granular, you can specify sub-owners at each stage of production, like: editor, writer, designer, legal, or web producer.

Examples of editorial calendars you can make with Airtable 

No two companies’ content programs are identical—and most content teams evolve their processes every year, if not every quarter.

Solo bloggers and creative types may need even further customization in their editorial calendars, as they target new audiences and channels. Alvern Bullard, a blogger and podcaster who runs the site Success Unscrambled, helps women entrepreneurs launch websites and market their content online. She says her clients have used Airtable for everything from organizing blog content to monitoring UTM tracking to managing their social media calendars.

Below are just a few examples of the way other editorial teams have customized their calendars using Airtable.

Editorial calendar example: Singularity Hub

Singularity Hub is a digital publication that covers tech and innovation. Their team uses Airtable’s digital media editorial calendar template to organize content production across different channels. They use a collection of views to organize their calendar, like “Grouped by author,” which shows a list of upcoming assets by author, or the “Publish” view, which maps those pieces out on a calendar. And their Kanban helps them see every asset by production stage.

Editorial calendar example: QuickBooks Resource Center

QuickBooks Resource Center makes resources to help small business owners start, grow, and manage a business. The QuickBooks team uses their Airtable editorial calendar template to strategize, edit, and publish content at scale. In their calendar, they have one main grid view that shows all content in production, including links to drafts, and eventually, the published piece. Editors use the calendar to filter the content by topic in their own views, which helps them find gaps in topic coverage. 

How to use Airtable’s editorial calendar template

Ready to customize your own? Kick things off with this calendar template. In it, you’ll find a handy pre-built, three-part content production system that’s ready for your original material. 

Here’s how to use each of the three tables (they look a lot like tabs in a spreadsheet) in the template:

  • Content pipeline: The content pipeline table is your place to organize all of your outbound assets. Use it to add key information about each asset, like: title, thumbnail image, status, publish date, channel, and more.  

  • Campaigns: The campaigns table lets you create and manage individual content campaigns. Use it to outline budget, notes, status, and start and end dates. You can use the “Related content” field to look up assets in the “Content pipeline” table, and link them to their respective campaigns. Once you do, this table will automatically count the number of total pieces in each campaign, and the number of pieces that are live (based on the statuses you inputted in the content pipeline table). 

  • Results: Here you’ll find a quick summary of how each campaign is doing. How many clicks did all the posts in a given campaign receive? What was the cost per click, and did it meet your established goal? This table gives you an instant snapshot of your content’s progress.

Then, it’s time to make it your own! Try customizing it to your team and workflow: 

  • Edit fields like “Channel” or “Status” in the content pipeline table to reflect your production workflow and publication channels 

  • Customize your own view using the “Views” panel on the left hand side. For example, you could start by using the “All content—by status” view in the content pipeline table. Then, customize it by using the “Filter” option at the top of the page to narrow the list down by publication channel, writer, campaign, and more. 

Create your own editorial calendar

An editorial calendar helps stakeholders stay aligned, and content publishing on time. Using this content calendar template, you can get your calendar running quickly and easily. And when you’re ready, you can customize your views, fields, and tables to make it custom to your workflow. 

For more inspiration, you can check out more templates in our template library

Sign up for free


About the author

Margaret Jonesis Head of Content at Airtable, with over a decade of experience in content strategy and production.

Filed Under

Marketing

SHARE

Latest in Content Marketing

How to create the perfect editorial calendar

How to choose the perfect content calendar

How to create the perfect editorial calendar

How to choose the perfect content calendar

How to create the perfect editorial calendar

How to choose the perfect content calendar

How to create the perfect editorial calendar

How to choose the perfect content calendar

Latest in Content Marketing

Browse all in Content Marketing

Join us and change how you work.