Editorial Calendar Template

Run a publication’s pipeline from pitch to print with writer assignments, deadlines and per-word fees.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Marketing

Tables

Articles, Writers

Fields

22

Views

grid, calendar, kanban, form

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Articles

14 fields · 6 sample rows

  • All articles (Grid)
  • Publishing calendar (Calendar)
  • Pipeline (Kanban)
  • Pitch a story (Form)
HeadlineTextSectionSingle selectWriterLink to another tableEditorTextStatusSingle selectDraft DueDatePublish DateDateWord CountNumberRate per WordRollupFeeFormulaDays to Draft DueFormulaDraft LinkURLFeatured ImageAttachmentNotesLong text
Inside India’s EV battery boomFeaturesAparna IyerSiddharth RaoDrafting23 Nov 202630 Nov 20262,500₹4.00₹10,0004
Why remote work is here to stayOpinionJames WhitfieldSiddharth RaoEditing17 Nov 202622 Nov 20261,200₹6.00₹7,200https://docs.example.com/remote-work
Review: the new Pixel phoneReviewsKunal ShahMaria LopezScheduled13 Nov 202620 Nov 20261,600₹0.00₹0
How to file ITR without a CAHow-toAparna IyerMaria LopezPublished4 Nov 202612 Nov 20261,800₹4.00₹7,200
In conversation with a Michelin chefInterviewsJames WhitfieldMaria LopezAssigned29 Nov 20269 Dec 20262,000₹6.00₹12,00010
Monsoon travel: 8 hidden gemsFeaturesPitched₹0Needs photographer.
Field details
Headline · Text
Section · Single select
News, Features, Opinion, How-to, Reviews, Interviews
Writer · Link to another table
Links to Writers
Editor · Text
Status · Single select
Pitched, Assigned, Drafting, Editing, Scheduled, Published, Killed
Draft Due · Date
Publish Date · Date
Word Count · Number
Rate per Word · Rollup
max of Rate per Word via Writer
Fee · Formula
ROUND({Word Count} * {Rate per Word}, 0)
Days to Draft Due · Formula
IF(AND({Draft Due}, OR({Status} = 'Assigned', {Status} = 'Drafting')), DATETIME_DIFF({Draft Due}, TODAY(), 'days'), BLANK())
Draft Link · URL
Featured Image · Attachment
Notes · Long text

Form view “Pitch a story” asks for: Headline, Section, Notes.

Writers

8 fields · 4 sample rows

  • Writers (Grid)
NameTextEmailEmailBeatMultiple selectTypeSingle selectRate per WordCurrencyArticlesLink to another tableArticle CountCountTotal FeesRollup
Aparna Iyer[email protected]Tech, FinanceFreelance₹4.00Inside India’s EV battery boom, How to file ITR without a CA2₹17,200
James Whitfield[email protected]Business, FoodContributor₹6.00Why remote work is here to stay, In conversation with a Michelin chef2₹19,200
Kunal Shah[email protected]TechStaff₹0.00Review: the new Pixel phone1₹0
Leila Haddad[email protected]Travel, LifestyleFreelance₹5.000₹0
Field details
Name · Text
Email · Email
Beat · Multiple select
Tech, Business, Lifestyle, Travel, Food, Finance
Type · Single select
Staff, Freelance, Contributor
Rate per Word · Currency
INR
Articles · Link to another table
Links to Articles
Article Count · Count
Total Fees · Rollup
sum of Fee via Articles

Editorial Calendar Template: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates