Free template kit
Free social media strategy template: 10 files, audit to report
This social media strategy template kit is for social media managers, small marketing teams and agencies: 10 editable files that take you from the first account review to the monthly report. Each file is broken down below.
- Audit what you already run
Engagement, publishing, audience and top posts for each profile, set against last year, with a SWOT grid to finish.
- Strategy document in Word
Goals, scope, timeline and milestones, laid out as a client proposal. In-house? Cut the fees and it's your strategy.
- Budget and monthly report
Paid social spend by campaign and month, plus a 13-slide PowerPoint report with charts you update in Excel.
- The weekly working files
Editorial calendar, Facebook and Instagram post logs, hashtag days, image sizes and a software checklist. The unglamorous bits.
Get the 10 templates
Your templates are ready
Your download button is right here. Open the audit workbook first; the other files build on it.
Download 10 Social Media TemplatesA copy is on its way to your inbox too.
What's inside
Ten templates, one social media strategy
The ZIP holds 10 editable files: 8 Excel workbooks, 1 Word document and 1 PowerPoint deck. Here's what each one contains and the decision it helps you make. (The two post logs are small, so they're covered together.)
All 10 open in Excel, Word and PowerPoint. Working in Google Drive? Upload them and each one opens as a Google Sheet, Google Doc or Slides deck.
Social media audit workbook
Six tabs. A Summary totals engagement, referral traffic, new followers and impressions across social. Twitter (now X), Facebook, Instagram and LinkedIn each get a tab with year-on-year columns, your 5 best posts and a SWOT grid (strengths, weaknesses, opportunities, threats) that shows what to fix first.
Proposal that doubles as the strategy document
Word. Overview, goals, timeline, scope of work (posting, content curation, hashtag monitoring for social listening, reporting), milestones, terms and a payment schedule. It's written for agencies pitching a client; in-house teams can drop the fees and proof-of-work sections and keep the rest for sign-off.
Paid social budget tracker
Every campaign gets a row with its annual budget, then actual spend month by month. Formulas show each one's share of the total, spend to date and what's left, so an overspend shows up while there's still time to fix it.
Editorial calendar and content bank
A monthly grid with a theme row per network for each day (that's where you decide what each channel talks about), plus a key for holidays, contests and launches. Behind it sit a content repository with content types and expiry dates, and three network post logs. The Twitter log even counts characters.
Facebook and Instagram post logs
Two small workbooks. Facebook gets four posting slots a day for a week, plus a monthly Live schedule. The Instagram log adds a link-in-bio column, a tab to collect inspiration for social posts and a Publishing DRI column: the one person directly responsible for each post.
13-slide monthly report
PowerPoint. Total traffic, engagements by channel, website visits from social and follower growth, then conversions and leads by channel with conversion rate, which is where you see which networks earn their budget. Five slides cover top posts and landing pages, and the charts edit in Excel.
Hashtag holiday list
The date, the day and its hashtag, month by month: #CMAD for Community Manager Appreciation Day in January, #SMDay for Social Media Day on 30 June and dozens more. Pick the few that suit your brand. Most are US observances, so add the dates your own audience keeps (Eid, say, or Swedish Midsummer).
Image size reference
A tab per network with recommended dimensions, aspect ratios, file size limits and file types. Treat it as a checklist, not gospel: specs change often, and the Google+ tab covers a network that has since closed. Confirm current sizes before anyone designs.
Software RFP checklist
An RFP (request for proposal) sheet for choosing social media management software: publishing, the shared inbox, reporting and team permissions. Mark each question need-to-have or nice-to-have, add your own, and send the same sheet to every vendor so the answers line up.
How to use it
Build your social media strategy with the templates
Work through the files in this order. Each step feeds the next, and skipping the first one means guessing at every number after it.
Review the accounts you already run
Export 12 months of numbers from each platform's social media analytics and fill one tab per network (there's room for 3 profiles each). Take the year-on-year columns seriously; a drop only shows when you compare. Leave the SWOT until the last tab is done, because the same weakness often turns up on every network.
- 12 months of data per profile
- Your 5 best posts, linked
- SWOT last
Turn the findings into goals
Pick 2 or 3 targets tied to business goals your leadership already tracks, such as leads or online sales, and write them into the proposal's goals and milestones sections. Each needs a baseline, a target and a date. 'Grow engagement' won't survive a budget meeting. '1,800 Instagram sessions a month by June' will.
- A baseline for every goal
- One owner each
- A date you'd defend
Put numbers on paid social
List each campaign in the paid social sheet with its annual budget and type in actual spend at the end of every month. We'd add rows for tools, production and creator fees too. A budget that only counts ad spend makes social look cheaper than it is, and stakeholders notice at renewal time.
- One row per campaign
- Actual spend only
- Tools and production included
Plan the month, then the posts
Build a content calendar a month at a time, themes first and posts second. Park ideas in the content repository, then move finished posts into the logs with a time, an owner and a campaign name (that column saves you a separate campaign template). Check image sizes against each platform's current spec before anything goes to design.
- Themes before posts
- Every post has an owner
- Sizes checked before design
Report monthly, review every quarter
Report weekly or monthly, but always on the same slides, refreshing the charts in Excel. Say why the top posts worked, not just that they did, and add a final slide for decisions and next month's tests. Then revisit the strategy in a quarterly review, when 3 reports show a trend rather than a blip.
- Same slides every time
- Decisions on the last slide
- A review every quarter
Guide
From social media audit to monthly report
The files give you structure; the judgement calls are still yours. These notes cover the ones teams get stuck on.
Writing up the strategy
Your strategy should answer four questions: what you want social to achieve, for whom, on which channels, and how you'll know it's working. The proposal file has a home for each. Write the overview last (it's far easier once the rest exists) and keep goals to one page. A section that won't fit on one screen is usually two decisions sharing a heading.
How to run a social media audit
Judge each of your social accounts on four things: consistent branding (bio, link, style), real engagement, steady publishing and an audience that matches your buyers. The workbook also asks whether passwords are centralised. Don't skip that row; losing the only login to a page is a miserable way to start. For a quick competitor analysis, make a list of two or three rivals per network, duplicate a tab for each and fill in what's public. It all feeds your SWOT.
Setting measurable social media goals
Decide which metrics matter before you pick targets. Key performance indicators (KPIs) tell you whether a goal is on track, and one per goal is plenty. Say Instagram sends 1,200 website sessions a month today: aiming for 1,800 by the end of Q2 is a 50% lift you can plan content and spend around. Track five more measures and the report fills with numbers nobody acts on.
Choosing the right social media platforms
To choose the right mix, start where your buyers already spend time, then check what you can feed every week. DataReportal's Digital 2025 Global Overview Report found that about 73% of internet users aged 16 and over use social media to research brands and products. HubSpot's 2026 State of Marketing report found 70% of marketers use Instagram and 69.6% use Facebook. Popular isn't automatically right, though: if you sell to businesses, LinkedIn may reach your audience better, and in the UAE, check WhatsApp and Snapchat before ruling them out.
Read moreBuilding the paid social budget
Paid social is now nearly as common as organic: HubSpot's 2026 State of Marketing report puts brands using organic social content at 40.3% and those using paid social content at 39.4%. Budget for both. As an example, AED 6,000 a month across two social campaigns (AED 4,000 acquisition, AED 2,000 retargeting) is AED 72,000 a year, and that's before a single photo shoot or creator fee.
Read moreContent themes, cadence and approvals
Decide your themes before your posts. The calendar's daily theme rows work well as content pillars, a handful of recurring subjects every post maps back to. Set a cadence you can keep in a bad month, not a good one. Then agree the workflow: who drafts, who approves, who presses publish. There's a reason the Instagram log has a DRI column. 'The team' never posts anything.
Community management in two languages
Replies belong in the strategy. Set a response-time target your social media team can actually hit (for example, within 4 working hours), write saved replies for the questions you get every week, and decide who handles complaints. Selling in the UAE or Sweden often means replying in Arabic or Swedish too, so keep both versions of each saved reply side by side and have a native speaker approve them once.
Social media report template: what to show
Lead with business numbers. In the deck, move the conversions and leads slide to the front, then traffic from social, then engagement and follower growth, with top posts and landing pages as evidence. Measure performance against your goals; last month's likes are a footnote. Show the path from post to visit to lead, even when the numbers are small, and end with what changes next month.
A filled-in strategy example
An example with made-up numbers: a skincare brand selling online in the UAE and Sweden. Audit: Instagram drives most engagement; the Facebook page hasn't posted since spring. Goals: Instagram sessions from 1,200 to 1,800 a month by the end of Q2, and 60 leads a month from social by June. Platforms: Instagram and TikTok, plus WhatsApp for questions. Cadence: 4 feed posts a week and daily Stories. Campaigns: one social media campaign a quarter, Ramadan the biggest. Budget: AED 6,000 a month on paid social. No follower target, you'll notice. Followers belong in the report.
What good looks like, and the usual mistakes
A good strategy is short enough that a busy director can repeat its goals from memory. Every goal has a baseline, a date and one owner, the budget covers production as well as ads, and the report ties back to the goals. The usual mistakes run the other way: no baseline, five platforms at half strength, reports full of likes and no decisions. Two are specific to this kit: clear the sample rows first (they're placeholders, old dates included) and check image sizes before you trust them.
Adapting it for B2B, B2C, small teams and agencies
B2B teams should weight the review towards LinkedIn and lead quality, and expect a long gap between post and deal. B2C brands care more about reach, saves and sales, so Instagram and TikTok take a bigger share of the calendar. A one-person team can get by with the audit workbook, one post log and the report. Agencies get the most from the proposal and RFP checklist.
Read moreWork with us
Help with your social media marketing
Templates get you organised. If you'd rather hand over part of your social marketing, Adnika runs social for brands in the UAE and Sweden.
- 01
Strategy and channel management
We'll run the audit with you, agree goals and baselines, then manage the channels week to week with one clear monthly report.
- 02
Content production
Content creation built around your themes and sized for each platform, so the calendar never has empty days.
- 03
Community management
Comments and messages answered within an agreed response time, with clear rules for when a complaint goes to a person.
- 04
Paid social campaign management
Targeting, creative testing and budget pacing for paid social, planned against the budget you set rather than a guess.
FAQ
Frequently asked questions
Quick answers on the kit itself and on strategy basics.
Start with what's already working. Look at your best posts, pick 3 or 4 content themes your audience cares about, and match each to the formats each platform rewards. Set a posting rhythm you can keep and plan a month at a time. Content that resonates earns more of next month's mix.
In eight parts: audit findings, goals with baselines, audience, platforms, content themes, budget, community management and reporting, topped with a one-page summary showing how social supports the wider marketing strategy. Choose your platforms once you understand your target audience, never before. The audit workbook, proposal, paid social sheet and report deck cover those parts between them.
Here, if you mean planning templates: this kit has 10, covering everything from account review to the monthly report. If you meant post graphics, design tools such as Canva carry those. Plan first, though. A beautiful post with no goal behind it is decoration.
It's an informal daily engagement habit rather than an official rule, and versions differ. A common one: each day, leave 5 thoughtful comments on other people's posts, reply to 5 stories, and post or share 5 times. Others use 5 minutes per task. Keep the habit of showing up; don't obsess over the numbers.
It's a content-mix ratio: for every 6 posts, 4 share relevant content from other people, 1 is your own original piece and 1 is promotional. It's usually credited to Tippingpoint Labs and was popularised by Joe Pulizzi of the Content Marketing Institute. Treat it as a starting point, then let your own numbers adjust it.
Strategy decides what social is for: goals, audience, platforms and how you'll judge success. A plan turns that into campaigns with budgets, owners and dates, and a content calendar sits underneath with the actual posts. Looking for a social media plan template? The proposal and paid social sheet cover that layer.
Revisit it every quarter and rewrite it once a year. The monthly report shows what to tweak in between, like the posting mix or budget split, while goals and platforms get a fixed review date so they don't drift. Update sooner after a big change, such as a new market or a launch.
No. The core is three files: the audit workbook, the proposal and the report deck. Add the paid social sheet if you run ads, the calendar and post logs if you publish most days, and the RFP checklist only when you're picking a tool. The hashtag list and image sizes are references.
Fill in the form at the top of this page (first name, last name, email, company, phone and country) and a download button appears straight away. You get one ZIP with 8 Excel workbooks, 1 Word document and 1 PowerPoint deck.
Yes. The proposal is written as a client pitch, with scope, milestones, proof of work, terms and a payment schedule, and the RFP checklist lets you choose software with a client rather than for them. Fill in your own details in the placeholders and clear the sample rows first.
No questions match — try another search.
More free templates
Free templates for the rest of your marketing
Need the posting calendar on its own, or a full marketing plan? Each one below has its own page, so you can see exactly what's inside before you download it.
TemplateSocial Media Content Calendar
An Excel calendar for planning posts on X (Twitter), Facebook, LinkedIn, Instagram and Pinterest, with a monthly planner, a posting schedule and a content library.Get the free template
TemplateContent Mapping Template
A 15-page crash course on content mapping and a Word template with three persona profiles and a content map for each lifecycle stage.Get the free template
TemplateMarketing Plan Template
A Word marketing plan template with a SWOT table, target market and personas, a marketing mix section, a budget table and a channel plan.Get the free template
TemplateSales Plan Template
A Word sales plan template covering mission, team, target market, tools, positioning, prospecting, action plan, goals and budget.Get the free template
Free download
Get all 10 templates in one free ZIP
One form, 10 editable files. Start on the first workbook this week and you'll have a baseline to plan from before the month is out. The rest can wait.