Guide · Strategy
A social media content calendar: plan a whole month in one hour
Quick answer
The short answer
You can plan a month in one hour if you keep to the right order: first collect the occasions coming up in the next four weeks, then assign a format to each one, and only then fill the remaining gaps with everyday ideas. Our free content calendar template, with all ten columns and a sample month already filled in, is further down this page.
Download the content calendar template
Free spreadsheet template, in German, columns explained below, with a sample month, instructions and an idea bank. No email required, works in Excel and Google Sheets.
Why most content calendars die after two weeks
Almost every content calendar looks solid for the first two weeks. After that it usually breaks down for the same three reasons: too many channels at once, no footage for the topics that were planned, and nobody clearly responsible for getting it done. In our own sample of 55 Berlin business profiles on Instagram, the median was 0.66 posts per week, roughly one post every ten days, and nine of those 55 profiles hadn't posted anything in over 30 days. That's not an outlier, that's what happens when a plan only exists in someone's head instead of on a sheet. For a deeper look at what a workable posting rhythm looks like, see How often should you post on social media?, and for the bigger picture, the social media strategy hub.
What actually causes the collapse tends to show up in the same conversations again and again. A flower shop on Bergmannstraße sets up a whole quarter's plan in January, with topics for Easter, for Mother's Day, for the spring season. Three weeks in, the first photo is missing, because nobody on site thought to grab their phone during a delivery. A missing shot turns into a skipped week, and a skipped week turns into a calendar nobody opens anymore. The problem is rarely the idea itself, it's the gap between planning and actually doing it: a plan that assumes material which doesn't exist yet breaks down exactly where it was needed most.
The one-hour plan in five steps
One hour is enough for a whole month if you work through it in five steps instead of improvising as you go. The order matters more than any single step, because each one builds on the last.
- Collect occasions: holidays, delivery dates, promotions, trade fairs, anything already happening in the next four weeks.
- Find topics in everyday work: a piece you made, a technique, a question customers actually ask, not something invented at a desk.
- Match a format to each topic: reels for motion, stories for closeness, carousels for step by step, text posts for a factual point.
- Check the material: does the photo or video already exist, or does it need a shoot before the post can go live?
- Assign ownership: who writes it, who films it, who publishes it, written into the sheet, not just discussed out loud.
In practice, none of these five steps takes longer than ten to fifteen minutes if you work through them back to back instead of squeezing in other tasks in between. The first step, collecting occasions, usually takes the longest, because it needs the widest view of the business. The steps after that go faster, since they build on what's already settled. Doing the whole hour in one sitting, rather than spreading it across several days, tends to produce a more coherent calendar, because the topics line up better against each other when the whole month is in front of you at once.
What each column of the template is for
The template has ten columns on the sheet called „Redaktionsplan“ (content calendar), plus a sheet called „Anleitung“ (instructions) with the five steps above, and a sheet called „Ideenspeicher“ (idea bank) for anything that comes up spontaneously and doesn't have a slot in the month yet. The overview below shows what each column is for, with an example from a carpentry workshop in Weißensee, Berlin, taken straight from the template.
| Column(s) | What it's for | Example from the template |
|---|---|---|
| Week & date | Places the post in the week, so you can see at a glance how full each week is | Week 38 · Sep 22, 2026 |
| Channel | Decides where the post runs, since Instagram, LinkedIn and Facebook work on different rhythms | |
| Format | Determines how it gets filmed or written, before the shoot or the writing even starts | Reel |
| Topic/hook | The actual content, plus the opening line that earns a few more seconds of attention | How a table goes from raw log to delivery |
| Goal | States what the post is working toward, reach, trust or inquiries, since no single post can do all three at once | Trust |
| Material | Shows whether the footage already exists or a shoot is needed before the date gets close | Shoot needed |
| Status & owner | Tracks where the post stands and who owns it, from idea through to published | Idea · team |
| Note | Space for anything that would otherwise get lost, a shoot location, an open question, a deadline | Needs about half a shoot day |
The „Ideenspeicher“ sheet works as a catch basin: if an idea comes up between two appointments and doesn't have a fixed slot in the month yet, it goes there instead of getting lost. You can see what footage for ideas like that actually looks like on our social media content page, in the references section.
The idea bank sheet has its own columns: idea, format, channel, material and priority. That makes it quick to decide, during the weekly check-in, which of the collected ideas moves into the calendar next, without having to re-sort the whole list. An idea with high priority and material already on hand moves up first, one without material waits until the next shoot is due.
One shoot, four weeks of material
The „Material“ column is usually where a plan falls apart, because between an idea and a finished post there's a shoot that nobody scheduled. A single brand film shoot day, by contrast, delivers more than one film: from that same day you get reels, stories and stills that last for several weeks, instead of reaching for a phone every single time a post is due. That works because Öykü and Nils are on set and in the edit themselves, with no handover to another agency in between. One team for film and feed, not separate suppliers for shooting and social.
Many social media packages, by contrast, are priced by posts per month and add video on top as an extra allowance, say four posts a month with up to two of them reels (source: pricing page of a Berlin-based social media provider, August 2026). In practice that often means a moving feed image rather than a real shoot, because an extra camera day simply isn't part of the package. For your calendar, that usually means the „Material“ column keeps landing on „shoot needed“, because the shoot has to be booked separately. With us, the shoot is part of the monthly retainer. For how long the individual clips coming out of it should run, see How long should a video be on Instagram, TikTok and LinkedIn?.
In practice that looks like the carpentry example above: half a shoot day for a time-lapse reel doesn't just deliver that one video. The week after, a story carries the individual working steps in short clips, the week after that a carousel gets cut from the best stills, and whatever's left over goes into the idea bank for the following month. One shoot day, four weeks of different material, instead of four separate phone-out moments that rarely all happen anyway in a normal working week.
The calendar only works with a weekly check-in
A template alone doesn't keep a month running, the habit behind it does. That's why the instructions sheet in our template carries one simple piece of advice: take 15 minutes a week to update the calendar and prepare the week ahead. Nothing spectacular happens in those 15 minutes, and that's exactly the point: the „Status“ column gets updated, from idea through planned and produced to published, open items in the „Note“ column get ticked off or added to, and new ideas from the idea bank move into the calendar once material for them exists. Keep that 15-minute habit up and you'll notice gaps before they turn into a 30-day pause, the exact gap we saw missing in nine of the 55 profiles in our sample.
When to hand the plan over
A content calendar is work no matter how good the template is, new topics every week, new occasions every month. If that one hour keeps slipping, or the „Material“ column keeps staying empty, that's the moment to hand the plan over instead of trying to rescue it. Our social media content service covers planning, shooting and publishing for a fixed monthly fee, and covers campaign management for social media ads too if you need it. For the rough scale of what a service like that costs, see What does a social media agency cost per month?.
The same logic applies to paid ads as to the organic calendar: a strong reel from a regular shoot often works as an ad too, just with a tighter cut for the opening seconds. If you know when a promotion or a new season starts, you can tie that same row in the calendar directly to a campaign, instead of treating ads as separate from the rest of your content. The media budget always runs 1:1 through your own ad account, with no markup on top.
The relationship starts with an initial project, the first content batch and the first shared idea of what your films should look like, before the ongoing retainer begins. After that there's a one-month minimum term, then it's cancelable monthly, with no setup fee. All of that gets discussed in the first call, 45 minutes, free, and afterward scope and price are written into the offer, not added later on. And you'll always be talking to Öykü and Nils, not a rotating account team. See everything we offer on the services page, or book the first call on the contact page.
What's included in the price is written into the offer too: the team, equipment, music from licensed libraries, color grading, sound mixing and the agreed formats, plus two rounds of revisions on the first content batch. The finished exports then belong to you without restriction: usage rights with no time limit, for your website, social media, ads and presentations, you get every export. The raw footage itself stays with us, available on request under a separate offer, much like the „Material“ column in the template shows at the end of each week what's been delivered and what's still open.
Download the content calendar template
The template from this article, in German, with a content calendar, instructions and idea bank, free and no email required.
FAQ
Frequently asked
How far in advance should you plan a content calendar?
Four weeks is a good window, long enough to schedule shoots, short enough to still react to what's actually happening. The idea bank in the template catches anything that reaches further out than that.
What tools do you need for a content calendar?
A spreadsheet is enough to start with, our template works in Excel and in Google Sheets. Dedicated planning software only pays off once several people are working on the same calendar at the same time.
How many times a week should you post?
That depends on the channel and doesn't have one right answer, in our own sample the median on Instagram was 0.66 posts per week. For a fuller breakdown of what a sensible rhythm looks like per channel, see How often should you post on social media?.
What if we don't have any ideas for the month?
Then start the calendar with occasions, not topics: what's happening in the business over the next four weeks anyway? A delivery date, a new hire, a piece that's just been finished, most topics come out of that on their own.
Does every single post have to be in the calendar?
No, spontaneous posts stay allowed and useful, the calendar is a structure, not a straitjacket. What it prevents is a gap of several weeks with no post at all, exactly what we saw in nine of the 55 profiles in our sample.
Can the agency take over our content calendar for us?
Yes, that's exactly what our social media content service does, planning, shooting and publishing for a fixed monthly fee. You can talk through the starting point in the first call.
The matching service
The plan is done, who's going to run it?
We handle planning, shooting and publishing for a fixed monthly fee, as an ongoing retainer with a one-month minimum term. Here's how social media works with us.
Read on
Also relevant

Author
By Nils Grinbergs
Co-founder & Managing Director
Updated on 27 August 2026
