Why a content calendar starts with the mix, not with the posts
Most social media calendars begin life as a list of ideas. Someone has a good thought for a Reel, a product needs a push, a sale is coming, and the weeks fill up. Four weeks later the feed looks busy and oddly one-sided: a wall of product shots and discount codes with the occasional tutorial squeezed in. Nobody decided that. It simply happened, one reasonable post at a time.
A content calendar is the table that says what will be published, on which platform, in which format and when. Planning it well is less about creativity than about arithmetic. Before you discuss a single caption, you can ask a much cheaper question: how many posts does each theme get, and is that what we agreed? This free lesson shows how to answer it in a spreadsheet with four small formulas, and why the answer is worth more when it is expressed in posts than in percentages.
The example company is Thistledown Yarn Co., a fictional online shop for yarn and knitting kits with a social team of a few people. All names, plans and numbers on this page are invented for learning, and the target shares are illustrative, not recommendations for your account. The data are the same sixteen calendar lines you work with in the interactive lab above.
Content pillars in plain words
Content pillars are the three to six themes an account returns to again and again. They are a promise to the audience about what they will find, and a promise to the team about what it has to produce. A pillar is broader than a topic and narrower than "everything about our brand". If you cannot sort a post into exactly one pillar, the pillars are either too vague or overlapping.
Thistledown Yarn Co. works with five pillars. Each one has a job:
- Tutorials: stitches, techniques and fixes. They are the reason people follow a yarn shop at all, and the posts that get saved.
- Product: yarns, kits, colourways and tools. They show what can be bought without pushing a price.
- Community: finished projects of customers, the maker of the month, knit-alongs. They show that real people use the products.
- Behind the scenes: dye days, packing orders, the studio. They make a small company recognisable.
- Promotion: sales, vouchers, last calls. They sell directly, and they wear an audience out fastest.
A target mix gives every pillar a share of the calendar. The team at Thistledown agreed on 35 % Tutorials, 20 % Product, 20 % Community, 15 % Behind the scenes and 10 % Promotion for this quarter. There is no universally right mix. A shop in launch mode will plan more Product, a service business may not need Behind the scenes at all. What matters is that the mix is written down, because only a written target can be compared with a draft.
Three numbers that turn a list into a mix
A calendar is a list of lines. To see the mix you need three numbers per pillar, each built on the one before:
- Planned posts: how many posts of the draft belong to the pillar. This is a conditional sum.
- Share of plan: planned posts of the pillar ÷ all posts of the plan. This makes plans of different sizes comparable.
- Gap in posts: planned posts − target posts, where target posts = target share × all posts. This tells you what to change.
The third number is the one that leads to action. "Product is ten percentage points over target" starts a discussion. "Product has four posts too many and Tutorials four too few" ends it: swap four lines.
A fully worked example: the June draft of Thistledown Yarn Co.
The draft for June 2026 has sixteen lines. Each line is a small series of posts: the same platform, format and pillar in one week, with the number of posts in the last column. Planning in lines instead of single posts keeps the table short, and it is the reason you will add a column rather than count rows.
| Week | Platform | Format | Content pillar | Posts |
|---|---|---|---|---|
| W1 | Reel | Tutorials | 3 | |
| W1 | Carousel | Product | 4 | |
| W1 | TikTok | Video | Tutorials | 2 |
| W1 | Pin | Product | 3 | |
| W2 | Reel | Community | 2 | |
| W2 | Story | Promotion | 4 | |
| W2 | TikTok | Video | Behind the scenes | 2 |
| W2 | YouTube | Long video | Tutorials | 1 |
| W3 | Carousel | Product | 3 | |
| W3 | Reel | Tutorials | 2 | |
| W3 | TikTok | Video | Community | 2 |
| W3 | Pin | Product | 2 | |
| W4 | Story | Promotion | 4 | |
| W4 | Reel | Behind the scenes | 2 | |
| W4 | YouTube | Long video | Tutorials | 2 |
| W4 | Post | Community | 2 | |
| All lines | 40 | |||
The sixteen lines hold 40 posts. Read down the pillar column and try to judge the mix by eye. It is hard, because the lines have different sizes: four Story posts on one line weigh more than one long video on another. That is exactly the kind of judgement a formula does better.
Step 1: add up the posts per pillar with SUMIF
In the lab, the calendar sits in columns A to E, rows 4 to 19, and a small summary table lists the five pillars in G4:G8. The first formula goes into I4:
=SUMIF($D$4:$D$19,G4,$E$4:$E$19)
SUMIF takes three arguments. The first is the range to test, here the pillar column D. The second is the criterion, here the pillar name in G4. The third is the range to add, here the Posts column E. The function walks down D4:D19, and whenever a cell equals "Tutorials" it adds the number in the same row of column E. For Tutorials it finds five lines with 3, 2, 1, 2 and 2 posts and returns 10.
The dollar signs matter as soon as you copy the formula down to I8. $D$4:$D$19 and $E$4:$E$19 are absolute references: they stay where they are. G4 has no dollar signs, so it becomes G5, G6, G7 and G8 and picks up the next pillar each time. Without the dollar signs the ranges would slide down one row per copy, and the last pillars would silently lose the first lines of the calendar. The results: Tutorials 10, Product 12, Community 6, Behind the scenes 4, Promotion 8.
Step 2: turn posts into a share of the plan
The share of plan is the pillar's posts divided by all posts: =I4/SUM($E$4:$E$19), formatted as a percentage. For Tutorials that is 10 ÷ 40 = 25 %. Product reaches 12 ÷ 40 = 30 %, Community 15 %, Behind the scenes 10 % and Promotion 20 %. The five shares add up to 100 %, a quick check that no line was missed and no pillar name was mistyped.
Why bother with shares when you already have counts? Because next month's plan may have 52 posts and last quarter's had 118. Shares let you compare plans of any size with one target.
Step 3: target posts and the gap
The target share becomes a number of posts when you multiply it by the size of the plan: =H4*SUM($E$4:$E$19). With 40 posts, 35 % Tutorials means 14 posts, 20 % Product means 8, and so on. The gap is then a plain subtraction, =I4-K4: planned minus target.
| Content pillar | Target share | Planned posts | Share of plan | Target posts | Gap (posts) |
|---|---|---|---|---|---|
| Tutorials | 35 % | 10 | 25 % | 14 | −4 |
| Product | 20 % | 12 | 30 % | 8 | +4 |
| Community | 20 % | 6 | 15 % | 8 | −2 |
| Behind the scenes | 15 % | 4 | 10 % | 6 | −2 |
| Promotion | 10 % | 8 | 20 % | 4 | +4 |
| Total | 100 % | 40 | 100 % | 40 | 0 |
The picture is clear. Product and Promotion are over-planned by four posts each, Tutorials are four short, Community and Behind the scenes two short each. A feed that was meant to teach first and sell second has been drafted the other way round: half of the June plan (20 of 40 posts) is Product or Promotion, where the target says 30 %.
How to read the result, and what to do with it
A gap table is a to-do list. Read it with these rules of thumb:
- The gaps always sum to zero. You cannot fix an over-planned pillar without deciding which under-planned pillar receives the slots. Here the eight surplus posts in Product and Promotion go to Tutorials (4), Community (2) and Behind the scenes (2).
- Swap inside the same platform and format first. Turning one Product carousel into a Tutorials carousel changes the mix without changing the workload. Turning Stories into long videos would repair the mix and wreck the week.
- Small gaps are noise. With 40 posts, one post is 2.5 percentage points. Do not rework a plan for a gap of one.
- A gap can be intended. If June contains a launch, more Product is a decision. Write the reason next to the number so that the gap is not "fixed" by someone else.
After the swap the plan matches the target, and the team can argue about ideas inside each pillar instead of about the balance between them.
Where the mix sits in the planning chain
The mix is only the first link. A calendar also needs a rhythm per platform, an honest estimate of hours per post, a view of who has time, and dates that leave room for approvals. Each of those steps multiplies the mix you start with: if the mix is wrong, you will carefully schedule, produce and approve the wrong posts. That is why this check comes before everything else.
Step by step in the spreadsheet
- List the calendar with one line per series and a Posts column. Use exactly one spelling per pillar name.
- Next to it, list each pillar once and type its target share. Check that the shares add up to 100 %.
- In I4 type
=SUMIF($D$4:$D$19,G4,$E$4:$E$19)and copy it down to I8. - In J4 type
=I4/SUM($E$4:$E$19), format it as a percentage and copy it down. - In K4 type
=H4*SUM($E$4:$E$19)and copy it down. - In L4 type
=I4-K4and copy it down. Positive means over-planned. - Select the pillars with the target share and the share of plan and insert a clustered column chart.
- Swap lines until every gap is within one post, or note why a gap is intended.
Common mistakes and how to spot them
- Counting lines instead of posts. COUNTIF returns 5, 4, 3, 2 and 2 for the five pillars and a mix that looks far closer to the target than it is.
- Forgetting the dollar signs. The first row is right, the rows below lose data. If the pillar counts do not add up to the total, check the references first.
- Dividing by the number of lines. COUNT(E4:E19) is 16, SUM(E4:E19) is 40. Shares must use the sum.
- Reading gaps in percentage points only. Ten points sound abstract. Four posts can be swapped this afternoon.
- Treating the target as a law. The target is last quarter's best guess. Lesson 13 of this course checks it against results per production hour.
- Too many pillars. With eight pillars and 40 posts, the average target is five posts, so a single moved post already looks like a large gap. Three to six pillars are easier to steer.
How to choose target shares in the first place
If you have never set a target mix, start from what the account is for and what the audience has rewarded so far. Give the largest share to the pillar that gives followers a reason to stay, a clear but limited share to the pillar that sells, and split the rest. Then run it for a quarter and look back. A target mix is a hypothesis that you correct with your own results, not a formula copied from another brand.
Be careful with promises, including the ones you make to yourself. A balanced mix does not guarantee reach, followers or sales, and platforms change how they distribute content. What a mix check does guarantee is modest and useful: the calendar you produce is the calendar you meant to produce.
Quick reference: functions and tools in this lesson
| Function or tool | What it does | Example from this lesson |
|---|---|---|
SUMIF(range, criterion, sum_range) | Adds the cells of sum_range whose partner in range matches the criterion | =SUMIF($D$4:$D$19,G4,$E$4:$E$19) |
SUM(range) | Adds all numbers in a range | =SUM($E$4:$E$19) gives 40 |
$ (absolute reference) | Keeps a column, a row or both fixed when a formula is copied | $D$4:$D$19 stays, G4 moves |
| F4 key (Cmd+T on a Mac) | Cycles a reference through the four $ variants while you type | D4 → $D$4 → D$4 → $D4 |
| Percent format | Shows 0.25 as 25 % | Share of plan in column J |
| Clustered column chart | Compares two series category by category | Target share next to share of plan |
What you will build in the rest of this course
The remaining nineteen labs follow the planning chain from the diagram, always with a new data set from the same fictional yarn shop.
Lessons 2 to 5 build the skeleton: a weekly cadence per platform and the consistency with which it was kept, production hours per post by stage, the available hours of each person in the team, and the date arithmetic of a calendar with weekdays, ISO weeks and gaps between posts.
Lessons 6 to 10 deal with what bends a plan: approval lead times counted backwards in working days, the hours saved by batching, repurposing ratios for hero pieces, campaign overlays on top of the always-on calendar, and the weekly comparison of demand hours with capacity.
Lessons 11 to 15 go deeper: a pipeline tracker by status, the content buffer measured in runway days, rebalancing pillars from results per production hour, reading your own weekday and time-slot data with a healthy distrust of averages, and a linear forecast of the hours a bigger calendar would need.
Lessons 16 to 20 close the loop: the cost of the calendar in-house and with freelance quotes, a what-if grid of cadence against hours per post, quality checks for double bookings and missing assets, a review of on-time delivery and a final quarterly dashboard with a flag and a combo chart. A 20-question exam and a certificate follow.
Summary
A content calendar should be checked for its mix before anyone polishes a single post. List the plan line by line with a Posts column, add up the posts per pillar with SUMIF, divide by the total for the share of plan, and subtract the target posts to get a gap you can act on. In the June draft of the fictional Thistledown Yarn Co., that takes four formulas and shows that Product and Promotion hold eight posts that the team had promised to Tutorials, Community and Behind the scenes.
Try it in the lab above: every formula is checked as you type, and the chart at the end shows the target next to the plan. All companies, people and numbers are fictional.
Frequently asked questions
What are content pillars in social media?
Content pillars are the three to six recurring themes of an account, for example tutorials, product, community, behind the scenes and promotion. Every post belongs to exactly one pillar, which makes it possible to plan and check the balance of a calendar.
How do I calculate the content mix of a calendar in Excel?
Add up the posts per pillar with SUMIF, for example =SUMIF($D$4:$D$19,G4,$E$4:$E$19), and divide each result by the total number of posts, =I4/SUM($E$4:$E$19). Format the result as a percentage to get the share of each pillar.
What is a good content pillar mix?
There is no universal mix. A common starting point gives the largest share to useful or entertaining content and a limited share to direct promotion, then adjusts after a quarter based on the account's own results. The shares in this lesson are illustrative figures of a fictional company.
Why use SUMIF instead of COUNTIF for a content calendar?
COUNTIF counts lines. If a calendar line can stand for several posts, such as four Stories in one week, counting lines understates large series. SUMIF adds the Posts column and gives the real number of posts per pillar.
Why should the gap be measured in posts and not in percent?
A gap in posts tells you directly how many calendar lines to swap. A gap of ten percentage points in a plan of 40 posts is four posts, which is a concrete change the team can make the same day.
How often should I review the target mix?
Check each draft calendar against the target before production starts, and review the target itself about once a quarter using your own results, such as saves and shares per production hour. Change it by a few posts at a time rather than removing a pillar.
Keep going: Social Media Content Calendar Planning: Content Pillars, Weekly Cadence, Production Capacity, Approval Lead Times, Batching, Repurposing & Campaign Overlays
This free lab is lesson 1 of 20. Unlock the other 19 hands-on labs, the final exam and your certificate for a one-time $9.90.
- Weekly Cadence per Platform: Planned Slots, Posts Actually Published and a Consistency Rate
- Production Hours: Hours per Post by Stage, Weekly Hours per Format and Where the Time Really Goes
- Team Capacity: Available Production Hours per Person, Utilisation and Headroom
- Dates in the Calendar: Weekdays, ISO Week Numbers, Gaps Between Posts and Posts per Week
- Approval Lead Times: Work Backwards from the Publish Date to the Draft Deadline and the Production Start
- Batch Planning: Setup Time, Sessions Needed and the Hours Saved by Producing in Batches
- Repurposing Ratios: Derivative Pieces per Hero, Total Hours and the Cost in Hours per Published Piece
- Campaign Overlays: Lay Launches and Sales on Top of the Always-On Calendar and Keep the Share in Check
- Weekly Load Against Capacity: Demand Hours, Headroom, Utilisation and the Weeks That Do Not Fit
- Pipeline Status: Count What Is Due Soon by Status, Add the Hours Left and Find the Items at Risk
- Content Buffer: Runway Days per Format, the Date the Queue Runs Dry and the Posts Needed for a Target Buffer
- Rebalancing the Mix: Rank Posts, Average Results per Pillar and Results per Production Hour
- Choosing Slots: Average Reach by Weekday and Time Slot, an Index and the Spread Behind the Average
- Forecasting Production Hours: Hours per Post, the Slope per Extra Post and a Linear Forecast for a Bigger Calendar
- The Cost of the Calendar: In-House Cost per Post, Monthly Cost per Format and the Freelance Comparison
- What-If Grid: Cadence × Hours per Post, a Heat Map of Utilisation and the Maximum Cadence That Fits
- Calendar Quality Checks: Slot Keys, Double Bookings, Caption Limits and Ready-to-Schedule Flags
- Plan Versus Reality: Days Late, Missed Posts, Fill Rate, On-Time Rate and the Average Delay
- Final Project: A Quarterly Calendar Dashboard with Posts, Hours, Utilisation, Campaign Share, Flags and a Combo Chart