Call · 30 min
MarketingMattia Esposito10 November 202613 min read

Social media content calendar. A sheet where every post has a reason, a date and a number to check seven days later.

A content calendar of dates and topics alone says what to post and never whether it worked. Here is the Excel template with four weeks of examples, the disclosure label and seven-day metrics.

In brief

A social media content calendar decides in advance, for every post, the platform, format, goal, topic, hook and call to action. Seven days later the same row gets the figures, and the following month is planned on those.

Each format works towards a different goal. Instagram says Feed, Stories, Explore and Reels each have their own algorithm. In a Buffer study of 2.1 million posts, accounts posting 3-5 times a week grew followers more than twice as fast as those posting once or twice.

A paid post has to be declared. In Italy the IAP Digital Chart wants the label as the first piece of information in the post, even when the person posting is an employee or a paid studio.

The Excel template can be downloaded below, with the worked example also as a PDF, with no email required.

Written by: Mattia Esposito, AI and marketing consultant, founder of Itria AI. From Puglia, based in Turin since 2023, he works remotely in Italy and abroad. LinkedIn profile.

The content calendar Excel template, to download

An Excel file with three sheets: the blank calendar to fill in, the same calendar with four weeks of examples and the disclosure rules in four countries. Totals calculate themselves: posts per month, hours, cost and engagement on reach. It also opens in Google Sheets and LibreOffice.

Example of a four-week social media content calendar for a made-up company, with platform, format, goal, hook and disclosure label
FileContentsLink
Excelto fill in, in Italian

The blank calendar with drop-down lists, the four-week example, the disclosure sheet.

piano-editoriale-social-modello.xlsx

PDFto read, in Italian

The worked example, to print or send to the person writing the posts.

piano-editoriale-social-esempio.pdf

ColumnWhat you enterIn the example
Date

The publishing date. One row per post.

Tuesday 12 January

Platform

Where the post goes out, from the drop-down list.

LinkedIn

Size

Photo post, carousel, reel, story, video, document, text only.

Photo post

Goal

Awareness, consideration or request: get seen, get understood, prompt a step.

Consideration

Topic

One of the three or four subjects you come back to every week.

Projects

Hook

The first line, the one read before deciding whether to stop.

«A six-square-metre bathroom asked us for 41 colour tests.»

Call to action

The step you ask of the reader: save, comment, write.

Write to us for the sample folder

Paid or in partnership

Whether there is a payment, a gifted product or a working relationship.

No

Disclosure label

The label to put first, when needed.

Not needed

Hours

Writing, photo or video, posting, reading the figures.

1.5

7-day metrics

Impressions, reach, engagement, saves, sends, clicks. The engagement-to-reach ratio calculates itself.

written on 19 January

What I repeat or change

One sentence: the decision that post leaves for next month.

after the metrics

At 14 I opened @artartism, an Instagram page of paintings, all in English. It reached 55,000 followers with 680 posts, one a day. In one month it got 10 million views, with zero euros spent on advertising. There was no written plan. There was an hour a day, always the same one.

In that hour I looked for posts that had done well, then poems, music and quotes to sit alongside them. I posted, replied, and at the end looked at the figures. I described it like this on 8 September: «I measured engagement and thought it through.» That habit became the last columns of this sheet. The full post.

Years later I lined up the data from those posts, comparing each with others from the same month, because the page kept growing in the meantime. The result is in the box. The rule I drew from it I still use: «A line alongside doubles the picture.» That’s why the hook has its own column in the sheet. The six principles, with the figures.

What I measured on @artartism

The total. 632,288 organic likes in seven months. The yardstick: a post with only the painting and the artist counts as 1x, and every other post is compared with those of the same month.

A line next to the image. Without a line, 1,000 likes; with a line underneath, a quote or what I saw in it, 2,300. In other words 2.3x.

A sentence of my own. A description taken from Wikipedia did 1.5x. What I felt, written in a hurry, 2.5x.

What concerns the reader. Marcus Aurelius on death, 12,000 likes. Woody Allen joking about existentialism, 903. Same subject, taken seriously or made fun of.

The work that moves nothing. 13 hashtags or 52, credits, tagged locations, an invitation to follow the page repeated three times: 1x.

Social media content calendar: what it is and what it’s for

A social media content calendar is the document that sets what to post, where, in what format, with what goal and how to measure it, for a defined period. Its dated part is the editorial calendar. In Italian it is called piano editoriale, and that’s how Italian templates are searched for.

Its job is to make social media work for the company. According to Eurostat, in 2025 59% of Italian enterprises with at least 10 employees used at least one social network, against an EU average of 64%. Being there is common. Knowing which post brought in an enquiry is much rarer.

The calendar starts from the monthly goal and three or four topics, chosen according to how you want to be remembered. For the topics, the work on brand positioning comes before the calendar.

How to build a social media content calendar, row by row

It takes five steps: monthly goal, topics, frequency, one row per post, seven-day metrics. The first three are decided once a month. Rows are written a week ahead, so there is time for photos, videos and approvals.

Write the monthly goal with a number and the name of the buyer: «20 sample requests from architecture practices» can be checked at the end of the month, «more visibility» can’t. The figures that follow a goal like that are indicators, and the KPI glossary explains how to choose a few.

The cycle of one row of the content calendar: goal, topic and format, hook, posting, seven-day metrics, and the decision that feeds back into next month’s goal The goalawareness, request Topic and formatwhere and how The hookthe first line The postwith the label Seven daysthe metrics what I repeat and what I change: next month’s calendar starts here
Every row of the sheet goes through this cycle. The «What I repeat or change» column is where the calendar learns.

Then frequency: how many rows a week you can fill, counting the hours. Finally the hook, which decides almost everything: examples taken apart one by one are on the page about hooks and headlines. For founders’ personal posts, see the guide to LinkedIn personal branding.

Which format for which goal

On Instagram each part of the app has its own algorithm, so the same content performs differently depending on the format. Adam Mosseri, head of Instagram, wrote it in 2023: Feed is for keeping up with friends and interests, Stories for getting closer to people, Explore and Reels for discovering new things, with Reels giving more room to entertainment.

In the sheet that means: reels go on awareness rows, stories on request rows aimed at people who already follow you. Buffer notes that stories don’t usually reach people who don’t follow the account. In the example, on LinkedIn, photo posts and documents sit on consideration rows.

Format sizes change often: check them in the platform’s guide on the day you shoot the video. In the sheet the format’s name is enough.

Content calendar example: four weeks for a made-up company

The example is Fornace Vetrani, a made-up name: a kiln producing handmade ceramics and tiles and selling them to architecture practices in Italy and abroad. Monthly goal: 20 requests for the sample folder. Twelve posts in four weeks, three a week, on LinkedIn, Instagram and Facebook.

DateHookWhere and goal
12 Jan

A six-square-metre bathroom asked us for 41 colour tests.

LinkedIn, consideration

14 Jan

Thirty seconds of glaze, twelve hours in the kiln.

Reel, awareness

16 Jan

Five things to ask before using ceramics outdoors.

Carousel, consideration

19 Jan

How well a glaze stands up to frost: the test we run on every batch.

LinkedIn document, consideration

21 Jan

Gloss or matt, for a kitchen?

Story with poll, request

23 Jan

The floor that decided everything else in the house.

Reel by a paid studio, awareness, with label

26 Jan

My grandfather fired with wood. We measure the kiln every ten minutes.

LinkedIn, awareness

28 Jan

The same blue on four different clays.

Carousel, consideration

30 Jan

Ten samples at your home, to decide in real light.

Facebook ad, request

2 Feb

What German architects ask that Italians never do.

Sales rep’s profile, consideration, with label

4 Feb

Why no tile comes out the same as the next.

Reel, awareness

6 Feb

The week’s three questions, with the answers.

Stories, request

The mix is deliberate: five consideration posts, four awareness, three request. The sheet counts them itself, so at the end of the month you can see whether the calendar actually asked for anything. The example’s metrics are blank: the company doesn’t exist, and figures are only written in when they are real.

Three rows out of twelve need a label: the reel by the paid studio, the ad, and the sales rep’s post on his own profile. On company page posts it is already clear who is speaking. On the ad the platform adds the label. To see how competitors write their ads, open Meta’s Ad Library.

Seven-day metrics: what each one counts

Seven days is the same window for every post, so one week’s figures compare fairly with the next. The names in the sheet are those of LinkedIn’s help on post analytics; Instagram and Facebook have similar ones, under their own names.

MetricWhat it counts (LinkedIn Help)What it’s for in the calendar
Impressions

The number of times the post appeared on screen. LinkedIn warns it’s an estimate.

Awareness

Reach

The distinct members and pages that saw the post; people who see it again aren’t counted twice.

The denominator

Reactions

The number of times someone reacted to the post.

The weakest signal

Comments

The number of times someone commented.

Consideration

Reposts

The number of times the post was reposted to someone else’s feed.

Out-of-network awareness

Saves

The number of times a member saved the post.

Perceived usefulness

Sends

The number of times the post was sent to someone on LinkedIn.

The signal closest to an enquiry

The sheet calculates engagement on reach, row by row and for the month. Read that ratio next to the previous month’s, never on its own and never across different platforms. Impressions tell you how far a post travelled; saves and sends tell you whether it was useful to someone, and for a business they count more.

How often a business should post on Instagram: what the data says

No platform gives an official number of posts per week, and the article in which Instagram explains its ranking doesn’t mention one. One data point comes from a social media tool vendor: in August 2025 Buffer analysed 2.1 million feed posts from 102,000 Instagram accounts, excluding stories.

In the study, accounts posting 3-5 times a week grew followers more than twice as fast as those posting once or twice, and reach per post rose by about 12%. Beyond five posts the gains continue but shrink. The study comes from a company that sells publishing tools, and should be read with that in mind.

The practical rule is the frequency you can keep up for four weeks without skipping. @artartism posted every day because the hour a day was always there. With an hour a week, two well-written posts beat five rushed ones.

Excel template, PDF or tool: which to use

Excel, or a Google Sheet, is the best format for a content calendar, because metrics are written next to posts and totals calculate themselves. The PDF is for showing the calendar to the people who approve it or produce the photos. This page’s template comes in both.

Scheduling tools have their own calendar, handy when there are many profiles. It holds the posts, rarely the reason they exist: keep the sheet with goal and «what I repeat» next to it.

How much a social media content calendar costs

There’s no official price list: the cost of a content calendar is the hours of the people who write it, produce it and read the figures. The Excel template has a column for each post’s hours and a field for the cost of an hour. The month’s total is the real cost, even when you do the work yourself.

In the kiln example the twelve posts come to an estimated 15.5 hours over four weeks. If you outsource it, ask whether copy, images and reading the metrics are included. Copy weighs most: that’s the work on the copy and sales materials page.

Sponsored content: the disclosure label in Italy, the EU, the UK and the US

In all four jurisdictions paid content has to be recognisable as advertising, and what changes is mainly how the label is written. In Italy the IAP Digital Chart, version of 30 October 2024, is clear on where the label goes: one of the permitted labels must appear as the first piece of information.

WhereWhat it asks forSource
Italy

«Pubblicità» or «advertising», or «adv» plus the brand, as the first piece of information or within the first three hashtags; on stories, above the image.

IAP, Digital Chart

Italy

For relevant influencers, from 500,000 followers or a million average monthly views: a label in the text or overlaid.

Agcom, resolution 197/25/CONS

Italy

Gifted product with no agreement: «prodotto inviato da» (product sent by) plus the brand.

IAP, Digital Chart

EU

Editorial content paid for by the company is always misleading if the payment isn’t made clear.

Directive 2005/29/EC, Annex I, point 11

EU

Platforms label ads and offer a feature to declare commercial content.

Regulation (EU) 2022/2065, Art. 26

United Kingdom

Ads must be recognisable; «#ad» is fine, «sponsored» is discouraged as ambiguous.

ASA, CAP Code section 2

United Kingdom

Owners, employees, partners and directors talking about the brand must disclose it.

ASA, influencer guidance

United States

The connection is disclosed in a way people can’t easily miss, even when an employee is posting; the company trains and monitors.

FTC, 16 CFR 255

The Agcom guidelines of 23 July 2025 apply only to relevant influencers, and an SME posting on its own page usually falls outside them. The Digital Chart, by contrast, applies to anyone posting paid content. In the UK the ASA writes about «sponsored»: «we advise against using this label to refer to advertising».

For a B2B company the most frequent case is an employee talking about products on LinkedIn. The British and American rules name it: the connection has to be stated, and the FTC expects the company to train the people posting. The sheet has a column for it.

Content calendar: the English-speaking world

In English the plan is searched for as a content calendar or social media calendar, and templates as content calendar template, in Excel or Google Sheets. The columns are the same; the labels change, written in English in the UK and US, with «#ad» up front.

For a foreign market, write one row per language: a hook rarely survives a word-for-word translation. If posts need to collect contacts, you need content to download, as on the page about lead magnets.

Questions and answers

What is a social media content calendar?

The document that sets, for a period, what to post on social media, where, in what format, with what goal and how to measure it. The dated part is called the editorial calendar; in Italian, piano editoriale.

A useful calendar has one row per post and, seven days later, that post’s figures on the same row.

How do you build a social media content calendar?

Start from a monthly goal with a number, choose three or four topics and a sustainable frequency, then write one row per post: platform, format, goal, topic, hook, call to action and disclosure if the post is paid. Seven days later you write in the metrics and decide what to repeat.

How much does a social media content calendar cost?

There’s no official price list. The real cost is hours: writing, preparing photos or video, posting and reading the figures. The Excel template multiplies the month’s hours by the cost of an hour, whether it’s yours or your supplier’s.

How often should you post on social media?

No platform gives an official number. In a study by Buffer, a social media tool vendor, of 2.1 million Instagram posts, accounts posting 3-5 times a week grew their followers more than twice as fast as those posting once or twice. What counts is the frequency you can keep up for weeks.

When do you have to label a post as advertising?

When the person posting has been paid, has received the product or works with the company they’re talking about. In Italy the IAP Digital Chart requires «pubblicità», «advertising» or «adv» plus the brand as the first piece of information; the Agcom guidelines apply to influencers with at least 500,000 followers or a million average monthly views.

Notes on sources

  1. Istituto dell’Autodisciplina Pubblicitaria, Digital Chart regulation, version approved on 30 October 2024: labels, position, stories, videos, gifted products. Read on 10 November 2026.
  2. Agcom, resolution 197/25/CONS of 23 July 2025, published on 5 August 2025, and Annex A, guidelines: the relevant-influencer threshold and the recognition label. Read on 10 November 2026.
  3. Directive 2005/29/EC, Annex I, point 11; Regulation (EU) 2022/2065, Article 26. Official texts read on 10 November 2026.
  4. ASA, Recognising ads: Social media and influencer marketing: CAP Code section 2, «#ad», «sponsored», owners and employees; source of the quotation. Read on 10 November 2026.
  5. Federal Trade Commission, 16 CFR Part 255, Guides Concerning Use of Endorsements and Testimonials in Advertising: §255.0(f), §255.1(d), §255.5 example 8. Current text read on 10 November 2026.
  6. Adam Mosseri, Instagram Ranking Explained, 31 May 2023. LinkedIn Help, Combined post analytics. Read on 10 November 2026.
  7. Buffer, How Often Should You Post on Instagram in 2026?, 13 August 2025: a study by a social media tool vendor, 2.1 million posts from 102,000 accounts. Read on 10 November 2026.
  8. Eurostat, isoc_cismt, enterprises with at least 10 employees using at least one social network, 2025: Italy 58.97%, EU 63.57%. Data updated 27 February 2026, read on 10 November 2026.
  9. The @artartism figures come from Mattia Esposito’s LinkedIn posts of 8 September and 25 September 2026.
·Who does it for you

The sheet takes an afternoon to fill in. The line that stops people scrolling has to be written first. Positioning is built starting from the market.

Mattia Esposito, who wrote this guide, also works with Itria on positioning: in-depth market analysis to find where competitors are exposed and take that ground. He did it on his own site first. In August, asked who had founded itria.io, ChatGPT couldn’t find him. From 11 October to 7 November 2026 itria.io pages appeared 13,803 times in Google and Bing results and 3,818 times in AI answers: Google’s AI Overviews and AI Mode, and Microsoft Copilot.