How to build a social media content plan

Opening a page is easy; keeping it going month after month is hard. Once the enthusiasm of the first week wears off, the question “what shall I post today?” appears and the page goes quiet. What solves this is not inspiration but a system. In this guide we build a content plan from scratch: starting from your goal and audience, choosing content pillars and their balance, setting up a monthly calendar in Google Sheets, collecting an ideas bank, preparing a week’s content in one day, turning one topic into several formats, scheduling posts in advance and reviewing results once a month. If your page is not set up yet, start with the article on social media for small businesses, which covers the profile and first posts. The names, businesses and figures in the examples are hypothetical.

Start with your goal and audience

A content plan answers two questions: “Why am I posting?” and “Who am I posting for?” Without those answers, the plan turns into a collection of random posts.

Make the goal measurable

“More customers” is not a goal; it is a wish. Write it down in specific, measurable terms: for example, “over the next three months, increase the number of order messages that come in through the page” or “take sign-ups for our learning centre’s trial lesson steadily every month”. The article on SMART goals explains in detail how to word a goal clearly.

Each goal calls for its own kind of content:

• Awareness: useful, shareable posts and short videos;
• Trust: behind the scenes, the team, customer stories;
• Enquiries and orders: clear announcements, Q&A, how to place an order;
• Keeping regular customers: news, tips, seasonal offers.

Describe your audience

Do not write “everyone”. Put one or two typical customers down on paper: who they are, where they live, what problem they have, when they look at their phone and what words they use.

For example, Sevara owns a small flower shop in Namangan. She has two main customers. The first is a young man urgently looking for a bouquet for a holiday or a birthday; the second is a family ordering decorations for a wedding or an event well in advance. The first needs quick information: what is available today and how to order. The second needs trust: examples of past work, the process, customer feedback. These two portraits shape Sevara’s entire plan.

Content pillars: categories and their balance

A content pillar (a regular category) is a type of post that recurs on your page. With pillars in place, you no longer start from zero each time: instead of “what shall I write?”, you ask “what will this week’s useful post be about?”

Five core pillars for a small business or organisation:

1. Useful. Advice that solves a customer’s problem: how to keep flowers fresh for longer, how to practise maths with a child at home, how to wash clothes properly. People save and share these posts.
2. Behind the scenes. The work process, preparation, the team, the workplace. Seeing you helps people trust you.
3. Customer story. A customer’s experience, result or feedback, only with their consent.
4. Q&A. Answers to questions you are asked often. One good answer saves dozens of private messages.
5. Announcement. A new product, a change in opening hours, an event, the start of enrolment.

Plan the balance

The most common mistake is posting nothing but announcements and “buy now” messages. A page like that gives people no reason to stay subscribed. So decide on the balance between pillars in advance.

A hypothetical example: Sevara plans around 12 posts a month and splits them like this: 4 useful, 3 behind the scenes, 2 customer stories, 2 Q&A and 1–2 announcements. This is not a universal rule, just a starting point. If your goal is awareness, the number of useful posts goes up; in the month you launch a new service, it is natural to have a few more announcements. What matters is choosing the balance deliberately and adjusting it at the end of the month based on results.

Come up with a template for each pillar: for example, Q&A posts could always open with the line “You asked:”, while customer stories follow a “before, process, result” structure.

The monthly content calendar: building the table

A plan needs to be written down. The handiest tool is an ordinary spreadsheet: Google Sheets is free, opens on your phone and can be edited together with your team.

Table columns

Create a new spreadsheet and type the following headers into the first row:

• Date: the day the post goes out (and the time, if needed);
• Platform: Telegram, Instagram or both;
• Pillar: which of the five pillars;
• Topic: what the post is about, in one sentence;
• Format: text, photo, carousel, short video, story, poll;
• Text: the finished text or a link to the document containing it;
• Visual: whether the photo or video is ready and where it is stored;
• Owner: who prepares it;
• Status: Idea, In progress, Ready, Scheduled, Published.

A few useful settings:

1. Freeze the first row: View → Freeze → 1 row. The headers stay visible as you scroll down.
2. Create a drop-down list for the “Pillar”, “Format” and “Status” columns: select the column and choose Data → Data validation → Dropdown. Everyone then uses the same words, and filtering later becomes easy.
3. Colour-code the statuses: Format → Conditional formatting. For example, “Published” in green and “Idea” in grey.
4. Share the spreadsheet with colleagues using the Share button.

A sample two-week plan

Below is a hypothetical two-week plan for Sevara’s flower shop. The days and topics are for illustration only.

Notice that all five pillars appear over the two weeks, while there is only one announcement. Rows still marked “Idea” immediately show which posts are falling behind.

The ideas bank: never run out of topics

An ideas bank is a separate sheet in your spreadsheet or a note on your phone where you jot down every topic as soon as it occurs to you. When it is time to draw up the monthly plan, you pick from a ready-made list rather than a blank page.

Where ideas come from

• Customer questions. Every question asked in Telegram or Instagram messages, by phone or in the shop is a ready-made Q&A post. Write down all the questions you get for a week and the list fills up quickly.
• Moments at work. A new delivery, a tricky order, something unexpected: material for a behind-the-scenes post.
• Customer feedback. Thank-you messages and results become customer stories, with the customer’s consent.
• Seasonal dates. Holidays and events that come round every year.

A list of seasonal dates

Once, at the start of the year, list the general dates and write down an idea that suits your business for each one. Examples of general dates in Uzbekistan:

• New Year: 1 January;
• International Women’s Day: 8 March;
• Navruz: 21 March;
• Day of Remembrance and Honour: 9 May;
• the season of school leaving ceremonies and summer holidays;
• Independence Day: 1 September;
• Knowledge Day and the start of the school year: 2 September;
• Teachers’ and Mentors’ Day: 1 October;
• Ramadan Eid and Eid al-Adha: their dates change every year, so check the official announcement each time.

Plan a seasonal post not for the day itself but one or two weeks ahead: for a flower shop, an advance-order announcement before 8 March; for a learning centre, tips on getting ready for the new school year at the end of August.

Batch creation and reusing content

A week of content in one day

Preparing a post from scratch every day takes a lot of time. Batch creation means doing similar tasks in one sitting. Set aside 2–3 hours once a week and prepare the whole week in that time.

A batch day looks like this:

1. Review the plan. Pick this week’s posts from the spreadsheet (15 minutes).
2. Write all the texts. Writing every text in one sitting is faster than writing them one by one. Keep them in Google Docs or directly in the spreadsheet.
3. Take the photos. Shoot everything at one time in good light, so the background, angle and style match. For practical tips on shooting with a phone, see the article on phone photography and video.
4. Record the videos and do a quick edit.
5. Schedule. Set the finished posts for the right days and change their status in the spreadsheet to “Scheduled”.

If something unexpectedly interesting happens, post it as a story; the main plan keeps running regardless.

Several formats from one topic

Do not use a good topic only once. A hypothetical example, the topic “Keeping a bouquet fresh at home”:

• Post (carousel): 5 tips, each on its own image;
• Story: a poll asking “How do you keep your flowers fresh?” plus one tip;
• Short video: Jamshid shows in 20 seconds how to cut a stem at an angle;
• Telegram post: the tips in text form, with contact details for orders;
• Q&A: a month later, answers to the questions followers have asked.

This way one round of preparation yields a week of content. Remember to adapt it to each platform: on Instagram the visual comes first, while on Telegram the text can be more detailed.

Scheduled posting

Once a post is ready, there is no need to wait for the right moment to publish it. Many platforms let you set a post to go out at a chosen time.

Telegram channel. Write the post as usual, then press and hold the send button (on a computer, right-click it) and choose “Schedule Message”. Set the date and time. Scheduled messages appear in a separate list inside the channel, where you can edit or delete them. For more on running a channel, see the article on starting a Telegram channel.

Instagram and Facebook. Professional accounts can use Meta Business Suite, where you prepare a post once and schedule it for Instagram and Facebook at the same time. The post creation window usually has a “Schedule” option, and the “Planner” section shows scheduled posts as a calendar. The interface changes from time to time, so the exact button name may differ.

What time should you post? There is no single right answer for everyone. Check when your own audience is active in the platform’s built-in statistics: an Instagram professional account’s insights show follower activity, and Telegram opens channel statistics for channels above a certain size. If you do not have statistics yet, try a few different times and record the results in your spreadsheet.

Remember to reply to comments and messages on the day a post goes out.

Review your results once a month

Once a month, set aside 30–40 minutes to review the previous month.

Add a few more columns to your spreadsheet: “Reach”, “Saves and shares”, “Comments and messages”. For each post, copy the figures from the platform’s built-in statistics. Then answer these questions:

1. Which three posts got the most reach and response? Which pillar and format were they?
2. Which posts got almost no response? Was it the topic, the format or the timing?
3. How much of the plan was carried out? If not all of it, what got in the way?
4. Did the page bring any real enquiries or orders? Ask new customers: “How did you hear about us?”
5. What will you do more of next month, and what less?

Do not draw big conclusions from a single month; look for patterns that repeat over two or three months. For example, Sevara saw three months in a row that Q&A posts brought in more messages, and adjusted her balance accordingly.

Common mistakes

• An oversized plan. Planning a post for every day and stopping in the second week. Start with what you can manage: even 2–3 posts a week give good results if they come out regularly.
• Nothing but announcements and sales. Without useful and behind-the-scenes posts, the page turns into a noticeboard.
• Statuses never updated. If everything in the spreadsheet stays at “Idea”, it tells you nothing about what is coming up.
• Ignoring the statistics. Repeating the same plan month after month without looking at results.
• Copying other people’s content. Do not use other people’s photos, videos or texts without permission, and always get consent for a customer’s photo or story.
• Remembering seasonal dates too late. Trying to prepare a holiday post on the holiday itself leads to rushed, poor-quality results.

Practical exercise and checklist

Over the course of a week, work through the following steps for your own page or a business you know well.

1. Goal. Write the page’s main goal in one sentence, specific and measurable.
2. Audience. Describe one or two typical customers in 3–4 sentences.
3. Pillars. Name the five pillars for your business and come up with a template for each.
4. Balance. Decide how many posts a month you will publish and how they split across pillars.
5. Spreadsheet. Create a nine-column calendar in Google Sheets and set up drop-down lists and colour rules.
6. Ideas bank. On a separate sheet, write down at least 20 ideas: customer questions, your work process, seasonal dates.
7. Two weeks. Fill in a two-week plan following the sample above.
8. Batch day. Choose a day, then prepare and schedule all of the first week’s posts.
9. Reuse. Turn one topic into at least three formats.
10. Review day. Block out time in your calendar for a review at the end of the month.

Checklist

• The goal is written down and measurable.
• The audience is described.
• Five pillars and their monthly balance are set.
• The calendar has all nine columns, and statuses are kept up to date.
• The ideas bank and the list of seasonal dates are ready.
• A weekly batch day is set aside.
• Posts are scheduled in advance, and you reply to comments on the day they go out.
• Once a month, results go into the spreadsheet and the plan is adjusted accordingly.

A content plan is not a rigid rule but a tool that makes the work easier: it replaces the daily worry of “what shall I post today?” with planning once a week.

If you would like to learn social media and marketing systematically with a teacher, take a look at our association’s free marketing programme and other training programmes. When you are ready, submit an application and our specialists will get in touch.