How to Do a Social Media Audit (+ Free Template)

A social media audit is worth the time when it ends in decisions: which accounts to keep, what to make more of, and what to drop. This is the process, a downloadable spreadsheet template, how often to run it, and what AI can honestly do with your numbers.

A social media audit is a structured review of every social account your brand runs: what exists, how each account is set up, how it performed over a fixed period, and how it compares with competitors. It should end in decisions about which accounts stay, what you’ll make more of and what you’ll stop making, and what the team is responsible for next quarter.

Plenty of audits never get that far. Someone exports a few months of Instagram, pastes the charts into a deck, and presents it, and the next quarter’s plan doesn’t change.

The deliverable is a list of actions, each with an owner and a date, backed by a scorecard that uses the same metrics and dates on every platform. This guide covers the steps, a downloadable spreadsheet template, how often to repeat the work, and where automation and AI help.

Before you start: set the scope

Make two decisions before anyone opens an export.

Pick one period and use it on every platform. The last full quarter is what most teams use. A full year fits an annual review. Instagram for Q3, TikTok for “the last 90 days,” and LinkedIn for the year will not hold up on one slide. Write the start and end dates at the top of the doc.

Then write what’s in and what’s out. Organic only, or paid too? Brand accounts only, or regional pages, product accounts, and executive accounts as well? Competitors, or just your own house? Put the answer at the top, next to the dates. Otherwise the kickoff becomes a debate about whether the UK Facebook page counts.

Get access before the metrics. You need admin or analyst access to every account’s native analytics, and to the ad accounts if paid is in scope. A missing login discovered on day two delays every step after it.

How to do a social media audit in 9 steps

1. Inventory every account

Search each platform for the brand name, the product names, and the misspellings people actually type. You will usually find more than the brand guidelines admit: a forgotten regional page, a campaign handle still pointing at a dead landing page, an account a former employee created on a work email, sometimes an impostor.

For each account, record the platform, handle, and URL, the owner (a named person, not “marketing”), the purpose (brand, support, product, region, or campaign), the status (active, dormant, or to be closed), and the last post date.

Dormant accounts get skipped because they feel awkward to raise. An account that hasn’t posted in a year tells anyone who lands on it that nobody’s home. Give it a purpose and a posting plan, or archive it and point people to a profile you use.

2. Check profile consistency

Open each active profile the way a stranger would, on a phone. The admin view hides the stale cover and the link that 404s.

Check these:

  • Display name and handle match the brand, or follow a pattern you can explain (@brand, @brandsupport, @brand_uk)
  • Profile photo and cover are current, and they look like the same brand on every platform
  • Bio says what the account is for, in the positioning you use now
  • Link goes to a live page. UTM parameters are how you’ll know whether the profile sends anyone
  • Contact details, category, and location are right
  • Pinned or featured posts aren’t a campaign you already ended, or a product you no longer sell

This step looks cosmetic, but it’s where most of the same-day fixes are, such as a bio that still says “coming soon.”

3. Pull performance metrics per platform

Same metrics, same dates, every account. Platforms don’t count things the same way, so a bigger number on TikTok does not mean TikTok had the better quarter. Meta, for example, has moved Facebook and Instagram reporting from impressions to views. A year-over-year comparison that ignores that is two different metrics sharing a label.

Keep the list short. These cover most audits:

Metric What it tells you
Followers and net follower growth Audience size and momentum
Posts published Output, so you can read every other number in context
Reach or views How many people saw your content
Engagements Likes, comments, shares, saves, and replies combined
Engagement rate Engagements relative to reach or views, which makes accounts of different sizes comparable
Video views and watch time Whether people actually watch your video
Link clicks or profile visits Whether attention turns into action

Write down the engagement rate formula. There are several in common use, and they don’t return the same number. If one person divides by followers and another by reach, the “best account” on the slide is an argument about a denominator. For a fuller list of metrics worth tracking, see our guide to social media metrics for 2026.

4. Find your top and bottom content

Account totals show how the period went. Individual posts show why.

Rank by a rate (engagement rate, or views relative to followers) rather than raw counts. Otherwise one post that got lucky becomes the whole story. Pull the top 10 and the bottom 10.

Then open the posts themselves, because the patterns don’t show up in a sorted sheet. Classify each post by format (short video, carousel, single image, Stories, long-form) and topic (product, education, behind the scenes, community, news). Next, check the creative execution: the hook in the first seconds, the caption, the on-screen text, and the length. Note collaborations against posts you made alone. Note the day and time, and whether you were early or late to whatever else was circulating that week.

Compare a post with what’s normal for that account and that format. Your best-ever Reel is a bad yardstick for a Tuesday carousel. The post everyone remembers for its view count is another poor benchmark if its saves and comments were low, so check its rate before you rebuild the calendar around it. In Measure Studio, post benchmarking does this automatically. It sets a normal range at 20% either side of your median for each post type and flags posts that land above or below it.

The bottom 10 matters as much as the top. If a format keeps landing there, move that production time to formats that already work.

5. Benchmark against competitors

Your own trend can’t tell you if you’re slow. Pick three to five accounts that compete for the same audience. Direct competitors, or aspirational brands a step ahead of you, if someone on the team actually compares you to them. Leave out names that are only on an old competitive-set slide or that sell in markets you don’t.

You only see public data: follower counts, posting frequency, the formats they use, and public engagement such as likes, comments, and views. Their reach and audience data stay private. The public data is still enough to see whether they post more or less often than you, which formats and topics get engagement, where they’re active and you aren’t (and the reverse), and which of their posts beat their own typical performance.

Doing this by hand is a lot of scrolling and copying. Measure Studio’s competitor tracking pulls public accounts into the same dashboards and benchmarks as your own, including public Instagram, TikTok, YouTube, and LinkedIn company accounts. It’s part of the Enterprise plan.

6. Review audience and demographics

Check who you are actually reaching. Age, gender, location, and language, where the platform shows them.

Put that next to the audience you say you want. A mismatch should change the plan. If your customers are mostly in the US and 40% of your Instagram audience is somewhere else, the reach number in the scorecard is flattering you.

Platforms diverge, even when the monthly report treats “our audience” as one group. Often a single platform reaches people the others miss. That is a reason to keep a small account that looks inefficient on a follower chart.

7. Separate paid from organic

If you boost posts or run ads, split paid from organic before you conclude anything. A post with $5,000 behind it isn’t comparable to one that earned its reach.

For each platform, record organic and paid reach separately. Note how much of total reach came from paid, which organic posts were boosted and whether the boost paid off, and the cost per result (cost per click, per lead, or per view, depending on the objective).

If paid is doing most of the work, decide whether organic is underperforming or under-resourced. Compare posting volume with spend, choose the explanation the numbers support, and assign someone to act on it. For more on reading the two together, see organic vs. paid social media and our guide to paid social analytics.

8. Set goals and KPIs

Give each account one primary goal that matches its purpose, then one or two KPIs that measure it. Track more than that and the extra numbers tend to go unmanaged.

Account goal KPIs to track
Awareness Reach or views, net follower growth
Engagement and community Engagement rate, comments, shares, saves
Traffic Link clicks, profile visits, click-through rate
Conversion Sign-ups, leads, or purchases attributed through UTMs or pixels
Support Response time, resolved conversations

Set the target from your own baseline. Industry averages can commit you to a number the account has never reached. “Lift Reels engagement rate from 3.1% to 3.6% by end of Q1” is a goal you can manage. “Go viral” isn’t.

If you can’t name the baseline, finish the scorecard before you set the target.

9. Report the findings

Keep the report short enough that the people who make decisions will read it:

  1. Summary. Three to five findings, written as sentences.
  2. Scorecard. One table across all platforms.
  3. What’s working. Top content and the pattern behind it.
  4. What isn’t. Bottom content, dormant accounts, audiences that don’t match who you sell to.
  5. Competitive context. Where you lead and where you trail.
  6. Actions. What to start, stop, and continue. An owner and a date on each.

Put a sentence under every number saying what it means. Our guide to social media reports covers what a strong report includes and how to build one without starting from a blank spreadsheet.

Free social media audit template

Download the social media audit template (.xlsx). It opens in Excel and imports into Google Sheets. The workbook has one tab for each template below, and the filled rows are examples to show what goes in each column. Replace them with yours.

Account inventory

The full list of accounts from step 1, with an owner and a decision for each. It also records the result of the profile check in step 2.

  • Platform, Handle, URL: where the account lives
  • Owner: a named person, not a team
  • Purpose: brand, support, product, region, or campaign
  • Status: active, dormant, or to be closed
  • Last post: the date of the most recent post
  • Bio and link up to date?: the result of the profile check
  • Action: what happens next, such as updating the link or archiving the account

Performance scorecard

One row per account, with the same metrics over the same period from step 3. This is the table that goes into the report.

  • Platform: the account
  • Followers (end), Net growth: audience size at the end of the period, and the change during it
  • Posts: how many posts went out
  • Reach or views, Engagements, Engagement rate: calculate engagement rate with the same formula for every account
  • Link clicks: whether attention turned into action
  • Paid share of reach: the percentage of reach that came from paid, from step 7
  • Change vs. last period: the change from the previous scorecard

Content review

The top 10 and bottom 10 posts from step 4, ranked by a rate rather than raw counts.

  • Rank: Top 1 to 10 and Bottom 1 to 10
  • Platform, Post link: where to find the post
  • Format: short video, carousel, single image, Stories, or long-form
  • Topic or pillar: product, education, behind the scenes, community, or news
  • Engagement rate: the same formula as the scorecard
  • vs. account normal: above, within, or below what’s typical for that account and format
  • Why it worked (or didn’t): what you see in the creative, such as the hook, caption, or length

Competitor benchmark

Three to five competitors next to your own brand, using the public data from step 5.

  • Account, Platform: the brand and the network
  • Followers, Posts per week: audience size and output
  • Avg. engagements per post: public engagement, such as likes, comments, and views, averaged per post
  • Top format: the format that gets them the most engagement
  • Notable campaign or partner: campaigns and collaborations worth noting

Goals and actions

The findings turned into work, with an owner and a date on each, from steps 8 and 9.

  • Account, Finding: what the audit showed
  • Action: the change you’ll make
  • Owner: the person responsible
  • KPI, Baseline, Target: the measure, where it stands now, and where it should be
  • Due: the date you’ll check it

How often should you do a social media audit?

A monthly pass is a scorecard. A quarterly pass should change what you post. The full nine steps run once or twice a year:

Cadence Scope Purpose
Monthly Performance scorecard only Catch problems early; this is regular reporting, not a full audit
Quarterly Scorecard, content review, competitors Adjust content mix and targets
Once or twice a year Full audit, all nine steps Reset strategy, clean up accounts, set annual goals

Run the full audit again when something big changes, such as a rebrand, a new market, a new team or agency, a merger, or a sudden drop in performance you can’t explain from the content you posted.

How to speed up a social media audit with automation and AI

Most of an audit’s hours go into collecting the data: logging into each platform, exporting, lining up the dates, and reconciling metric names, such as one network’s “views” and whatever the next network calls the same idea. That is the part to automate, and automating it is what makes a quarterly cadence realistic.

An analytics tool that connects the accounts gives you one place, one date picker, and metric definitions that don’t shift halfway through the sheet. Social media analytics tools vary a lot in how far they go. Check that yours covers every platform you run, keeps paid and organic separate, and lets you export post-level data. Without the export, you’re back to copying rows by hand.

Scheduled exports and saved report templates are how the monthly scorecard shows up without someone remembering to pull it. The quarterly audit should start from data you already have. In Measure Studio, connected accounts share one dashboard and one date range, and Scheduled Exports email the dashboard or post-level data to your team weekly or monthly.

If posts are already scored against that account’s normal range, finding the top and bottom content in step 4 takes minutes instead of an afternoon of sorting.

Can ChatGPT do a social media audit?

Partly. It depends on what the model can see.

On its own, no. ChatGPT, Claude, and similar assistants have no access to your private analytics. Ask for Instagram reach last quarter and you’ll get either an honest “I don’t know” or, worse, a tidy set of numbers that look plausible and aren’t. Treat any figure it gives you without a data source as invented, and check it against your analytics before it goes into a report. Without data, a chatbot can still help with the paperwork around the audit: a checklist, a first pass at KPIs for a goal you’ve already chosen, a read on whether the bios match, a critique of competitor posts you paste in.

Give it a clean export and it can rank posts, spot patterns, and draft the summary. You still did the exporting, the date matching, and the work of reconciling metrics across platforms. Read the draft against the sheet. Check the arithmetic, and check that it understood the columns. A model that treats engagement rate and total engagements as the same field will write a confident paragraph about the wrong thing.

Connected to live analytics through MCP, most of the collecting goes away. The Model Context Protocol is “an open-source standard for connecting AI applications to external systems.” When an assistant is connected to your analytics through an MCP server, it queries real numbers. It can pull account stats for the audit period, search posts by format or topic, compare accounts side by side, and build report slides.

Measure Studio’s MCP server works this way: it connects Claude, ChatGPT, and other MCP clients to your workspace’s organic, paid, and competitor data. A connected assistant can handle prompts like:

  • “For Q3, give me followers, net growth, posts, views, and engagement rate for every account, in one table.”
  • “List our 10 best and 10 worst Instagram posts by engagement rate this quarter and tell me what the top ones have in common.”
  • “Compare our TikTok posting frequency and average engagement against the competitors we track.”
  • “Build a slide with the audience demographics for each account.”

If you’d rather stay in the app, Archer is the AI analyst built into Measure Studio. It answers the same kinds of questions against data that’s already classified and benchmarked, and it drafts recap decks.

An assistant can gather and summarize the evidence, but decisions such as closing an account, changing the content mix, or moving budget from paid to organic need a named owner who has checked that evidence against the data.

Frequently asked questions

What should a social media audit include?

An audit covers every account you run, whether the profiles are consistent, and the same performance metrics for every platform over one period. It also reviews your top and bottom content, competitors, audience, and paid versus organic results, then sets goals for the next period. The template above has tabs for the inventory, scorecard, content review, competitor benchmark, and goals.

How long does a social media audit take?

It depends on the number of accounts and where the data lives. A first audit done by hand across several platforms can take days. With the accounts connected to one analytics tool, the time goes into the content review, the competitor comparison, and the actions rather than into exports.

How much does a social media audit cost?

There’s no standard price. In-house, the cost is staff time, plus any analytics tool you use. Agencies and consultants usually quote a fixed project, and the number moves with scope: how many accounts and platforms, whether competitors and paid media are in, and whether they owe you a strategy recommendation or just the findings. Write the scope down before you ask for quotes, so every quote prices the same job.

Can ChatGPT do a social media audit?

Not on its own, because it can’t see your private analytics. With an export or an MCP connection to your analytics, it can do much of the analysis. See the section above for what each setup can handle.

What’s the difference between a social media audit and a social media report?

A report comes around on a schedule, usually monthly, and tracks performance against goals you already set. An audit is the less frequent step back. Are the accounts, the content, and the goals still the right ones? The audit sets the targets. After that, the report is how you tell whether you hit them.

Is there a free social media audit template?

Yes. Download the social media audit template (.xlsx). It opens in Excel and imports into Google Sheets, with tabs for the inventory, scorecard, content review, competitor benchmark, and goals and actions.

Running your next audit in Measure Studio

Measure Studio handles the data collection behind the scorecard, the content review, and the goals. Connect your accounts once, and every row of the scorecard comes from the same date range. Post benchmarks flag the posts that land above or below each account’s normal range, Targets track the goals from step 8 between audits, and the findings go out as a branded .pdf or .pptx deck. Archer and the MCP server are on every plan, so you can ask for the scorecard in plain language. Competitor tracking is on Enterprise.

To run it on last quarter’s numbers, start a 14-day free trial. No credit card required.

Put your social data to work

14-day trial · No credit card · Connect your accounts in minutes.

Control the cookies and tracking technologies used on this website. Opting out of advertising cookies is how you opt out of the "sale" or "sharing" of your personal information under U.S. state privacy laws. See our Privacy Policy for details.