Marketing Content Calendar Template for Small Business

You download an editorial calendar template in January, fill it in for three weeks, and by March the file has stalled at row 14. One rush job was all it took to push marketing to the bottom of the day. The columns were fine. What was missing was the plan above them, which decides what to publish and why, and the routine below them, which keeps the sheet current when the week falls apart.

An editorial plan template for a small business only holds up with all three pieces, and you’ll find all of them here. The plan fits on one page with 7 fields. The calendar has 10 columns you can copy into Google Sheets or Excel, no sign-up required. The routine takes 20 minutes a week.

Our worked example is a window and door company with €1.2 million in revenue and two people handling marketing, a case built for this article. Content pillars and a single metric are the basic decisions of small-business content marketing, so we’ll treat them as already made.

An editorial plan and an editorial calendar are two different things

The editorial plan is the document that sets your content pillars, formats, channels, frequency, voice and owners, and so decides what you publish and why. The editorial calendar is the working file that puts those decisions on specific dates, one row per piece. You revisit the plan every quarter and the calendar every week.

The distinction matters in big organizations too. The University of Georgia’s marketing and communications office merged its editorial calendar with its content calendar, put the media communications and strategic marketing teams at the same table, reworked its production and channel distribution workflows, and adopted Asana to coordinate the work. Gleason and Trevor report broader coverage and a more efficient team.¹ A small business has two people instead of two teams, and the mechanism stays the same. You settle the message first, then assign dates and channels.

	Editorial plan	Editorial calendar
What’s in it	Goal, pillars, channels, formats, frequency, roles, voice	Dates, titles, channels, assignees, statuses
Who fills it in	Business owner and marketing lead	Whoever coordinates production
How often it’s updated	Every quarter	Every week
Typical format	A one-page document	A spreadsheet with one row per piece
Typical mistake	Writing it and never opening it again	Filling it in before the pillars are decided
Small-business example	”We talk about materials, installation and renovation projects"	"The PVC vs. aluminum article goes live on January 12”

Here’s the practical rule. Without a plan, the calendar fills up with posts that exist to cover Tuesday; without a calendar, the plan stays a PDF in a shared folder.

What a one-page editorial plan template needs to include

A small business’s content marketing plan fits on a single side of paper, and that works in your favor. If answering “why are we publishing this?” means opening twenty slides, nobody will ever do it.

Writing it down also puts you in a minority. In 2018 Content Marketing Institute data on North America, cited by Iryna Diachuk, 37% of respondents had a documented content marketing strategy, 38% had an undocumented one, and 19% planned to have one within 12 months.² Those figures are old and come from a different market, so read them as an order of magnitude. In the same report, 72% of respondents named strategy as a success factor, while measurement stopped at 36%.²

Here are the 7 fields, filled in for the window and door company.

Field	What it’s for	Filled-in example
Goal and single metric	Gives you the test for saying yes or no to an idea	Qualified quote requests per month
3 content pillars	Limit the topics	Materials, installation and job sites, renovation case studies
Active and excluded channels	State where you won’t show up, and why	Blog, newsletter, LinkedIn. TikTok excluded because people planning a renovation don’t go there to find a window installer
Formats by channel	Save you from reinventing the format every time	Blog article, short newsletter copy, LinkedIn post and carousel
Sustainable frequency	Commits only the hours you actually have	1 article every two weeks, 4 spin-offs
Who does what	Splits the work between in-house staff, outside help and pay-as-you-go resources	Freelancer for drafts, marketing lead for spin-offs, business owner for technical review
Voice	Makes copy from different hands recognizable	Technical, concrete, calm. No superlatives, shouted discounts or catalog photos

The field people skip most easily is excluded channels. Fill it in anyway. Next time someone says “we should really be on TikTok,” the answer is already written down, with the reason next to it.

The 10-column content calendar template

Copy this header into the first row of your sheet. To break it into columns, paste it in and use “Split text to columns” with the semicolon as the separator.

Date;Title and link;Pillar;Customer stage;Channel and format;Type;Assigned to;Status;Spin-offs;30-day metric

Each column has a specific moment when it gets filled in, which keeps you from staring at a sheet full of empty cells.

Column	What it’s for	When to fill it in
Date	Sets the publish date, a promise you intend to keep	Planning
Title and link	Says what the piece covers and, once it’s live, where to find it	Planning, link after publishing
Pillar	Keeps the balance of topics in check	Planning
Customer stage	Says whether the reader is discovering, evaluating or deciding	Planning
Channel and format	Says where it runs and in what form	Planning
Type	Sales, technical or relationship	Planning
Assigned to	Puts one name on each row	Planning
Status	Shows where the work stands	Production
Spin-offs	Lists the pieces that come out of this content	Production
30-day metric	Says which number to check after publishing	Planning, value at 30 days

Two columns need explaining, because generic templates leave them out.

Customer stage. An experimental B2B study shows that content judged relevant to the stage of the buying journey a customer is in generates more engagement with the company and its content. The same authors point out that no sequence is universally correct and that preferences vary from person to person.³ That means two things for you. Fill in this column on every row, and work out the right sequence from how your own customers react.

Type. A LinkedIn study followed a new, steadily growing B2B services firm for 106 weeks, sorting its posts into three categories (sales, technical, social). Sales posts and website visits grew the follower count, social posts raised engagement, and followers and website visits both had a positive effect on revenue.⁴ Each type pulls a different lever. If this column reads “sales” eight times in a row, you already know what to fix.

Here are six rows from the window and door company’s first quarter.

Date	Title	Pillar	Stage	Channel and format	Type	Assigned to	Status	Spin-offs	30-day metric
Jan 12	PVC or aluminum near the sea	Materials	Evaluation	Blog, article	Technical	Freelancer	Published	Newsletter, 2 posts, carousel	Visits to the quote page
Jan 14	Three questions to ask before replacing your windows	Materials	Discovery	LinkedIn, post	Technical	In-house marketing	Published	Spin-off of Jan 12	New followers
Jan 21	What we learned on a third-floor job	Case studies	Discovery	LinkedIn, post	Relationship	In-house marketing	Approved	None	Comments and shares
Jan 26	Replacing the windows in a house people are living in	Installation	Evaluation	Blog, article	Technical	Freelancer	In review	Newsletter, 2 posts, carousel	Visits to the quote page
Feb 4	Before and after a renovation	Case studies	Evaluation	LinkedIn, carousel	Relationship	In-house marketing	Draft	Spin-off of Jan 26	Clicks to the website
Feb 9	What an installation quote covers	Installation	Decision	Blog, article	Sales	Freelancer	Idea	To be decided	Quote requests

The columns to leave out

A 19-field calendar looks more professional than a 10-field one. But every Friday, somebody has to fill it in. One test applies to any column you’re tempted to add. Would this data change a decision in the weekly meeting? If not, it stays out.

By that standard, a team of 1-3 people can drop the following.

• Hashtags and full post copy, which belong in the draft.
• Exact publishing time, until you have your own data to choose one.
• Budget per row, which lives in the annual budget.
• Positioning and competitor analysis, which happen upstream.

That last one matters most. In an action research project on a company website, interviews with the CEO and employees and a study of competitor sites first fed a SWOT analysis, and the editorial calendar and choice of distribution channels came out of that.⁵ So analysis sits above the calendar, in the plan. By the time it reaches the sheet, it has already become a decision.

In a guide to social media content calendars, Mills describes the end result as a cohesive, organized and collaborative calendar that saves time and energy and keeps the content mix balanced.⁶ Every extra column chips away at those three adjectives, because a sheet nobody wants to open soon stops being collaborative.

How many pieces can you fit in the calendar?

As many as your team’s real hours allow: multiply those hours by the weeks in the quarter and divide by the hours each piece takes. Run that number before you write the first date, because capacity comes before ambition.

Let’s do the math for the window and door company. The marketing lead has 6 free hours a week, so 12 every two weeks. One article, counting the freelancer briefing and the review, takes 6. Four spin-offs take an hour each. That’s 10 hours, with 2 left as a buffer for surprises. Over 12 weeks you get 6 articles and 24 spin-offs, or 30 rows. If the buffer disappears twice in a row mid-quarter, cut a spin-off and leave the article alone.

This is where the Spin-offs column pays for itself. One long article gives you a newsletter, two posts, a carousel and, if you have job-site footage, a short video. With a single piece made from scratch, you cover two weeks of channels.

You’ve already made the process decisions: pillars, hours, customer stage. Now Claude or ChatGPT can speed up the drafting of the rows. Paste in your one-page plan and use this prompt.

You’re the editorial lead at a small business. I’m pasting our one-page editorial plan below. We have [6] hours a week, an article takes [6] hours and a spin-off takes [1] hour. Propose a calendar for the next 12 weeks as a table with these columns, in this order: Date, Title and link, Pillar, Customer stage, Channel and format, Type, Assigned to, Status, Spin-offs, 30-day metric. Stay within the hours limit, balance the pillars and cover the discovery, evaluation and decision stages. Don’t make up facts about the company. If a topic needs technical information you don’t have, write “check with the owner” next to the title.

Treat the draft as raw material. You’ll change at least one title in two after talking to the people on site, and that’s when your calendar stops looking like every other window installer’s.

The 20-minute routine that keeps the file alive

For a team of 1-3 people, an up-to-date file beats a pretty one. So maintenance gets a fixed slot, same day, same length. The sheet is one part of how you plan your weekly marketing activities.

The Friday round has three parts.

1. First 5 minutes, archive. Everything that went out moves to “Published,” with the link in the second column.
2. Next 5 minutes, reschedule. Anything that slipped gets a new date. If a row slips a second time, delete it or drop its priority.
3. Last 10 minutes, fill in. Complete week +2, giving every row an assignee and a status.

Filling in week +2 is the detail that holds everything together. You always have two weeks already assigned, so a rush job can wreck your Friday round without stopping what goes out.

Once a month, add a 45-minute review, and this is where the last column comes in. Enter the 30-day value for each piece and read the sheet by pillar, type and stage. Look past the likes to the numbers further down the line too. In the LinkedIn study cited above, followers and website visits were the factors tied to revenue.⁴

Research on the online channel of a luxury fashion accessories maker linked Facebook posts to transactions. Informational posts about standard features were associated with higher sales and more returns, posts about customizable features with a drop in both.⁷ That sector is a long way from custom windows and doors, and these are statistical associations. What carries over is the method: judging a piece of content on commercial numbers, including the awkward ones.

A prompt speeds up this analysis too. Export the sheet as a CSV, attach it to a conversation with Claude or ChatGPT and write this.

I’m attaching our editorial calendar with the 30-day values. Our single metric is [qualified quote requests]. Group the results by pillar, type and customer stage. Flag any group with fewer than 3 pieces, because the data there is too thin to decide on. Then propose 3 changes for next month, each tied to the calendar row it’s based on. If a data point is missing, flag it and don’t estimate it.

The quarterly review goes back to the one-page plan. If you use marketing OKRs, that’s the moment to line up your single metric with the quarter’s goal.

Approval statuses when you work with an outside partner

The classic bottleneck goes like this. The freelancer delivers the draft on Wednesday, the owner reads it ten days later between site visits, and the publish date slips without anyone deciding it should. The Status column shows where the work has stopped, as long as each status has exactly one person responsible.

Status	Who holds the row	What has to happen to move on
Idea	Marketing lead	Title, pillar and stage filled in
Draft	Freelancer or pay-as-you-go tool	Copy delivered by the internal deadline
In review	Business owner	Technical corrections made within 48 hours
Approved	Marketing lead	Images and spin-offs ready
Scheduled	Marketing lead	Content loaded on the channel
Published	Marketing lead	Link added to the sheet

Set the draft deadline at least 5 business days before the publish date, and limit the owner’s review to what only the owner knows: prices, commercial promises and technical accuracy. Commas are the marketing lead’s call.

The University of Georgia case shows that part of the result came from reworking the workflows, alongside adopting the tool.¹ That’s why it pays to settle the statuses first. As long as you’re running a few dozen rows a quarter, the sheet is enough. Once you add more outside collaborators and more approvals, the choice shifts to the best project management tools, and the statuses move over unchanged.

The same setup holds even if production leaves your hands entirely. Whether drafts come from a collaborator, a managed service like those from Marketing Hackers or a pay-as-you-go tool, the owner always checks the same point in the sheet.

Your first hour with the template

It takes 60 minutes to go from an empty file to a calendar you can use.

1. Spend 20 minutes filling in the one-page plan, with its 7 fields.
2. Spend 5 minutes calculating capacity from next quarter’s real hours.
3. Spend 5 minutes pasting the headers into your sheet.
4. Spend 20 minutes writing the first 6 rows, using the draft prompt.
5. Spend 10 minutes putting the Friday round and the monthly review on your calendar.

Booking those slots is the step everyone skips, and it’s the one that decides whether the file is still open in March.

Sources

Footnotes

1. Integrated editorial planning at the University of Georgia. doi.org ↩ ↩²

2. CONTENT MARKETING MODEL FOR EFFECTIVE WEB CONTENT MANAGEMENT. snku.krok.edu.ua ↩ ↩²

3. Digital content marketing on social media along the B2B customer journey: The effect of timely content delivery on customer engagement. doi.org ↩

4. Managing the content of LinkedIn posts: Influence on B2B customer engagement and sales?. sciencedirect.com ↩ ↩²

5. The Process Of Improving The Case Company’s Website Content Performance. theseus.fi ↩

6. Creating an effective social media content calendar. doi.org ↩

7. Linking Firm-Generated Social Media Content to Sales and Returns. doi.org ↩