You can also add a filter to remove articles that have already been published. The Grid will organize itself by writer, giving you a quick view of every article they've been assigned along with that article's status. To see what all of your writers are working on, group this Grid by the field “Writer.” Initially, it will be identical to the Master View.Īirtable Grids can be grouped by any of the variables. This is low-hanging fruit for Airtable.įrom your Master View, add a new Grid View. The problem is that once you're working with a handful of writers, it becomes hard to remember who is working on what and when each article is due. Keep Track of the Work on Each Writer's Plateĭeciding which articles to assign is one challenge, but deciding who to assign them to is another story. Formulas - Run calculations just like you would in Excel.Number - Track wordcount (if you pay writers per word).Currency - Track the budget for each post.Checkboxes - Create detailed checklists for each article.Attachments - Add images, docs and other relevant files.You can add an unlimited number of fields to any card. Collaborators will receive email notifications about the articles they're working on, similar to adding members to a Trello card. I suggest adding writers as collaborators as opposed to using a text or dropdown field. The writer field is made of Collaborators. The status field can contain predetermined selections that live in a dropdown menu. The Google Doc field is specifically designed to house URLs and the date field contains an actual calendar. The title and description fields, for example, are simple text fields. The Anatomy of an Airtable RecordĮach row in a grid can also be viewed as a card. As you get comfortable viewing the data in multiple ways, you can start creating dashboards to track tasks and simple automations that will save you a ton of time. The power of this flexibility becomes more obvious as we ask Airtable to do more and more. Kanban boards are familiar territory for anyone working in content, but it's just the beginning. Moving an article from “In Production” to “For Revision” will change the status on the Master View. The cards here are organized by the article's status and can be dragged into different columns. A description of what the article should be aboutīy toggling the view, you can visualize this same data on a kanban board.The data associated with each article is pretty straightforward: We'll call this the Master View-every base should have one view that is the source of truth from which other views pull data.Ĭlick "View larger version" to play around with this Base.
Each row of the spreadsheet is called a Record.You see the same data in a spreadsheet, a kanban board, a grid and a calendar. Within a Base, there are unlimited Views.You start with a Base-here's an example Editorial Calendar that I made.If you haven't used Airtable before, here's a brief overview. Or perhaps more accurately, Airtable is the platform to create that tool. I've used a number of different tools but until now, I've never come across a single tool to rule them all, a place to track the progress of every article and unlimited ways to view, analyze and track all those cats.Īirtable is that tool. To keep track of timelines and production schedules, many people rely on spreadsheets, Trello boards, task managers and project management tools. Distributing content through a network of internal and external channelsĪn editor's job isn't that different from herding cats.
Keyword research, often in conjunction with an SEO team.It's about much more than great writing.Ī great final product is the result of a lot of moving pieces, typically held together by an editor. The longer I work in content marketing, the more I realize that there are so many little things that make a great content program.
0 kommentar(er)
