Your editorial calendar is the single source of truth for everyone on your team involved with content production. Whether you’re publishing content for an internal company blog or running a digital publication, an editorial calendar helps you store critical information around articles, stories, and distribution.
The problem is that editorial calendars get messy fast. When trying to cobble together an editorial calendar across several different tools, like Google Sheets, Google Calendar, and Trello, information gets lost.
Providing the right structure to your editorial calendar helps you eliminate the logistical overhead and spend most of your time where it counts — actually writing content. Organizations that publish 12 times a month see up to 3.5x the traffic of organizations that publish once a month.
As with most things, the hardest part is getting started. That’s why we’ve put together some of the most helpful editorial calendar and content marketing templates that people have built on Airtable below. We’ve collected five of our favorites from various Airtable users across blogs, digital publications, and marketing agencies. Feel free to rip and mix them as you like!
1. Centralize your editorial calendar and content pipeline
If you’re doing content marketing by publishing posts on a company blog, you want to grow traffic by targeting an audience of people who are likely to be interested in your product. That means producing content along specific verticals and user personas.
The difficulty with traditional editorial calendars is that they often disperse the information you need across different tools — you might have your buyer personas mapped out in a Google Doc, deadlines in Google Calendar, and article drafts in Dropbox Paper. Switching between these tools means that information can slip through the cracks, making it difficult to track how your content is performing and how best to meet business goals.
We put together this starter content marketing template to help content marketing teams consolidate all the information they need into a single database.
For day-to-day collaboration and logistics, the editorial table contains a kanban view that makes it easy for everyone on the team to see the status of each article in the pipeline. In the same table, a calendar view keeps track of the deadlines for every article. Another editor view shows only articles that have been drafted and need editing.
While the editorial table keeps track of logistics and production, additional tables for verticals and SEO keywords help tailor each piece of content according to bigger business objectives. In the database, each record links to a specific keyword as well as a user persona.
2. Manage a digital publication
With a small team, the primary constraint to producing and publishing content is sheer manpower.
There are only so many hours in a day, which means that you have to balance coordinating edits, promotion, and distribution with the actual task of producing the content. For digital publications today, there’s a lot more to content production than just writing a couple hundred words and loading them into WordPress. Once a post is published, it has to be distributed across channels like Facebook, YouTube, and Twitter.
A well-structured editorial calendar reduces communication overhead and allows your team to spend their time where it counts — actually writing.
Once an article is marked as “Complete,” it’s then moved from the production pipeline into a social media view.
Once published, articles are handed off to the social media manager through this view. Each story record details what should be published per social channel for every article.
By doing this, Singularity Hub can maintain a single editorial calendar to organize content production across WordPress, Medium, and YouTube, as well as social media distribution.
3. Collaborate remotely with your editorial calendar
Today, teams running an online content publication are often remote or enlist remote freelancers to help out with content production.
At QuickBooks Resource Center, QuickBooks’ online publication for small business owners, in-house editors work with freelance writers and SEO strategists to produce content on topics like managing cash flow, tracking inventory, and preparing payroll.
Their Airtable editorial calendar database is designed to keep everyone involved in content production on the same page — across various offices and time zones. One of the biggest challenges of managing a remote team is simply resource allocation. When you can’t look over at a teammate sitting at the desk next to you, it’s hard to tell when someone has too much on their plate.
To get around this, they have a Writer Workload view that shows who’s working on what at any given point, along with the status of each article. That makes it easy to assign new articles and redistribute existing ones based on writer capacity.
4. Interface with clients through your content calendar
For marketing and digital agencies, the organizational challenge of an editorial calendar is centralizing content production across multiple clients in a single place.
Similar to the Content Marketing pipeline template above, Animalz uses a kanban view to keep track of the status of articles in their pipeline.
Each of these articles, however, is linked to a separate Plan Periods view, which shows the number of pieces that need to be produced for each client every month.
Animalz bills clients on a recurring subscription basis. The Plan Periods table shows the intersection of each client’s plan with articles in production.
Animalz also uses its Airtable database as a CRM. Each article links to a record in a separate Customers table that shows how many articles per month are allotted to the customer, the monthly recurring revenue, and the customer contact data.
5. Strategize content concepts
Keeping up a high tempo of content production is crucial to growing traffic and building organic reach. But that’s only part of the equation. You also have to nail down the topics your audience actually cares about.
Embracing a data-driven approach to content, digital agency Purple Rock Scissors created a content counting database, which tallies up all the hypothetical content concepts pulled from doing user research.
As director of content strategy at Purple Rock Scissors Tricia D’Antin says, “The goal is to inform content strategy through data, rather than pre-existing assumptions, opinions, and beliefs about content.”
The main Content Concepts table lists various potential concepts that could exist on a business’ website.
Each content concept is then connected through linked records to alternate tables including use cases, business goals, page traffic, and more.
That makes it easy to tally up which concepts rank the highest for the specific work that Purple Rock Scissors undertakes for clients. It creates a starting point for the agency to craft a content strategy — whether they’re trying to drive higher search traffic to a client website, or redesign a site to better match use cases for specific customer personas.
The templates above aren’t meant to show you exactly how you should run your editorial calendar or your content production pipeline—instead, think of them as a set of building blocks to help you get started. The way that you structure your editorial calendar will differ based on various factors, like the size of your team, your audience, and your business goals.
Ultimately, you want to structure your editorial calendar according to the needs of your team — but that doesn’t mean you have to start from scratch. Take a look at what other people have already done, and use that to create an editorial calendar of your own.
You can find even more templates for content production over in our template gallery.