Tabellab

Content Pillars: Count the Posts per Pillar, Turn Them into a Mix and Compare the Plan with the Target

Lesson 1 of 20Lab

All lessons
  1. Content Pillars: Count the Posts per Pillar, Turn Them into a Mix and Compare the Plan with the TargetLabFree
  2. Weekly Cadence per Platform: Planned Slots, Posts Actually Published and a Consistency RateLab Locked
  3. Production Hours: Hours per Post by Stage, Weekly Hours per Format and Where the Time Really GoesLab Locked
  4. Team Capacity: Available Production Hours per Person, Utilisation and HeadroomLab Locked
  5. Dates in the Calendar: Weekdays, ISO Week Numbers, Gaps Between Posts and Posts per WeekLab Locked
  6. Approval Lead Times: Work Backwards from the Publish Date to the Draft Deadline and the Production StartLab Locked
  7. Batch Planning: Setup Time, Sessions Needed and the Hours Saved by Producing in BatchesLab Locked
  8. Repurposing Ratios: Derivative Pieces per Hero, Total Hours and the Cost in Hours per Published PieceLab Locked
  9. Campaign Overlays: Lay Launches and Sales on Top of the Always-On Calendar and Keep the Share in CheckLab Locked
  10. Weekly Load Against Capacity: Demand Hours, Headroom, Utilisation and the Weeks That Do Not FitLab Locked
  11. Pipeline Status: Count What Is Due Soon by Status, Add the Hours Left and Find the Items at RiskLab Locked
  12. Content Buffer: Runway Days per Format, the Date the Queue Runs Dry and the Posts Needed for a Target BufferLab Locked
  13. Rebalancing the Mix: Rank Posts, Average Results per Pillar and Results per Production HourLab Locked
  14. Choosing Slots: Average Reach by Weekday and Time Slot, an Index and the Spread Behind the AverageLab Locked
  15. Forecasting Production Hours: Hours per Post, the Slope per Extra Post and a Linear Forecast for a Bigger CalendarLab Locked
  16. The Cost of the Calendar: In-House Cost per Post, Monthly Cost per Format and the Freelance ComparisonLab Locked
  17. What-If Grid: Cadence × Hours per Post, a Heat Map of Utilisation and the Maximum Cadence That FitsLab Locked
  18. Calendar Quality Checks: Slot Keys, Double Bookings, Caption Limits and Ready-to-Schedule FlagsLab Locked
  19. Plan Versus Reality: Days Late, Missed Posts, Fill Rate, On-Time Rate and the Average DelayLab Locked
  20. Final Project: A Quarterly Calendar Dashboard with Posts, Hours, Utilisation, Campaign Share, Flags and a Combo ChartLab Locked

You are not signed in — the lab works, but your progress is not saved. Sign up

Lesson 1 of 20 is free. Unlock all 20 hands-on labs, the final exam and your certificate.

Buy course — $9.90
Loading the spreadsheet…

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.

Pillars describe content, not people. Decide what to publish from what your audience does with it (saves, replies, clicks, purchases) and never plan or target content by age, gender, origin or other protected characteristics.

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:

  1. Planned posts: how many posts of the draft belong to the pillar. This is a conditional sum.
  2. Share of plan: planned posts of the pillar ÷ all posts of the plan. This makes plans of different sizes comparable.
  3. 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.

WeekPlatformFormatContent pillarPosts
W1InstagramReelTutorials3
W1InstagramCarouselProduct4
W1TikTokVideoTutorials2
W1PinterestPinProduct3
W2InstagramReelCommunity2
W2InstagramStoryPromotion4
W2TikTokVideoBehind the scenes2
W2YouTubeLong videoTutorials1
W3InstagramCarouselProduct3
W3InstagramReelTutorials2
W3TikTokVideoCommunity2
W3PinterestPinProduct2
W4InstagramStoryPromotion4
W4InstagramReelBehind the scenes2
W4YouTubeLong videoTutorials2
W4FacebookPostCommunity2
All lines40

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.

Do not confuse SUMIF with COUNTIF. COUNTIF would count the lines (five for Tutorials, four for Product) and ignore how many posts each line holds. In a calendar planned line by line, the Posts column is the truth.

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 pillarTarget sharePlanned postsShare of planTarget postsGap (posts)
Tutorials35 %1025 %14−4
Product20 %1230 %8+4
Community20 %615 %8−2
Behind the scenes15 %410 %6−2
Promotion10 %820 %4+4
Total100 %40100 %400

Content pillar mix: target vs June planTarget shareShare of June plan0 %10 %20 %30 %40 %35 %25 %Tutorialsgap −4 posts20 %30 %Productgap +4 posts20 %15 %Communitygap −2 posts15 %10 %Behind the scenesgap −2 posts10 %20 %Promotiongap +4 posts
Figure 1. Target share and share of the June plan per content pillar at Thistledown Yarn Co. (fictional). The plan has 40 posts; the gap below each pair is planned posts minus target posts.

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 %.

Gap in posts: planned minus targetTutorials−4Product+4Community−2Behind the scenes−2Promotion+4under-plannedover-planned
Figure 2. Gap in posts per pillar. The gaps add up to zero: every post too many in one pillar is a post missing in another.

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

From pillars to a calendar that fitsPillarswhat we talk aboutCadenceslots per weekHours per postdemand in hoursCapacityhours the team hasCalendardates and ownersThis lesson checks the first box: does the draft match the agreed mix?Approval lead timesBatchingRepurposingCampaign overlaysAdjusters: they move dates, cut hours per post or add posts on top of the base plan
Figure 3. The planning chain of this course. The pillar mix comes first, because every later step multiplies whatever mix you start with.

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

  1. List the calendar with one line per series and a Posts column. Use exactly one spelling per pillar name.
  2. Next to it, list each pillar once and type its target share. Check that the shares add up to 100 %.
  3. In I4 type =SUMIF($D$4:$D$19,G4,$E$4:$E$19) and copy it down to I8.
  4. In J4 type =I4/SUM($E$4:$E$19), format it as a percentage and copy it down.
  5. In K4 type =H4*SUM($E$4:$E$19) and copy it down.
  6. In L4 type =I4-K4 and copy it down. Positive means over-planned.
  7. Select the pillars with the target share and the share of plan and insert a clustered column chart.
  8. Swap lines until every gap is within one post, or note why a gap is intended.
In a copy of your own calendar, type a wrong pillar name on purpose, for example "Tutorial" without the s, and watch the planned posts of that pillar drop while the total stays the same. A summary whose pillar counts no longer add up to the total is the fastest way to find spelling problems in a real calendar.

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 toolWhat it doesExample 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 typeD4 → $D$4 → D$4 → $D4
Percent formatShows 0.25 as 25 %Share of plan in column J
Clustered column chartCompares two series category by categoryTarget 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.

  1. Weekly Cadence per Platform: Planned Slots, Posts Actually Published and a Consistency Rate
  2. Production Hours: Hours per Post by Stage, Weekly Hours per Format and Where the Time Really Goes
  3. Team Capacity: Available Production Hours per Person, Utilisation and Headroom
  4. Dates in the Calendar: Weekdays, ISO Week Numbers, Gaps Between Posts and Posts per Week
  5. Approval Lead Times: Work Backwards from the Publish Date to the Draft Deadline and the Production Start
  6. Batch Planning: Setup Time, Sessions Needed and the Hours Saved by Producing in Batches
  7. Repurposing Ratios: Derivative Pieces per Hero, Total Hours and the Cost in Hours per Published Piece
  8. Campaign Overlays: Lay Launches and Sales on Top of the Always-On Calendar and Keep the Share in Check
  9. Weekly Load Against Capacity: Demand Hours, Headroom, Utilisation and the Weeks That Do Not Fit
  10. Pipeline Status: Count What Is Due Soon by Status, Add the Hours Left and Find the Items at Risk
  11. Content Buffer: Runway Days per Format, the Date the Queue Runs Dry and the Posts Needed for a Target Buffer
  12. Rebalancing the Mix: Rank Posts, Average Results per Pillar and Results per Production Hour
  13. Choosing Slots: Average Reach by Weekday and Time Slot, an Index and the Spread Behind the Average
  14. Forecasting Production Hours: Hours per Post, the Slope per Extra Post and a Linear Forecast for a Bigger Calendar
  15. The Cost of the Calendar: In-House Cost per Post, Monthly Cost per Format and the Freelance Comparison
  16. What-If Grid: Cadence × Hours per Post, a Heat Map of Utilisation and the Maximum Cadence That Fits
  17. Calendar Quality Checks: Slot Keys, Double Bookings, Caption Limits and Ready-to-Schedule Flags
  18. Plan Versus Reality: Days Late, Missed Posts, Fill Rate, On-Time Rate and the Average Delay
  19. Final Project: A Quarterly Calendar Dashboard with Posts, Hours, Utilisation, Campaign Share, Flags and a Combo Chart

Buy course — $9.90 See the full course