---
title: "Social Media Audit Template (Free Sheet) and How to Use It"
description: "Free social media audit template: a sheet to paste into Google Sheets or Excel, six scored checks per account and a 60-minute plan to fix the lowest first."
url: "https://postnext.io/guides/social-media-audit"
language: "en-GB"
---

# Social media audit template and how to use it

Free social media audit template: a sheet to paste into Google Sheets or Excel, six scored checks per account and a 60-minute plan to fix the lowest first.

Human version: [https://postnext.io/guides/social-media-audit](https://postnext.io/guides/social-media-audit)

Score every account in 60 minutes and know which fix comes first.

[Start your 7-day free trial](https://postnext.io/signup?plan=free&source=guides-hero)

**Your checklist**8 steps · 60 minutes

0 of 8 done

1. List every account you own
2. Score the profile
3. Read the bio as a stranger
4. Tap every link on your phone
5. Count the posts of the last 30 days
6. Find the top 3 posts on each account
7. Measure your reply time
8. Pick 3 fixes and give each a date

**You finish with**

A score out of 12 for every account and 3 fixes with a date in your calendar.

**Have ready**

- The login for every social account you run
- A spreadsheet or a notes file
- Your phone, to test each link

To do a social media audit, list every account you run and score each one on six checks: profile, bio, link, posts a week, top posts and reply time. Give each check 0, 1 or 2 points. Fix the check with the lowest score first. Then audit again in 90 days.

## The audit, check by check

1. 1
   **List every account you own**
   Write one row for each network, handle and the person who has the login. Add old accounts you stopped using. People still find them in search.
   Your spreadsheet or notes file 10 min
   **Done when:** One row per account, old accounts included.
2. 2
   **Score the profile**
   Open each profile as a visitor sees it. Check the photo, the name, the category and the contact details. Score 0, 1 or 2 with the rules in the next section.
   Each network: your profile, in a private browser window5 min
   **Done when:** Every row has a profile score.
3. 3
   **Read the bio as a stranger**
   A stranger must see what you do, who it is for and what to tap, in 3 seconds. If your [bio](https://postnext.io/learn/how-to-write-a-social-media-bio) only says your brand name, score it 0.
   Each network: your profile5 min
   **Done when:** Every row has a bio score and a note.
4. 4
   **Tap every link on your phone**
   Most people tap your link on a phone. Check that it opens, loads fast and goes to the page your bio promises.
   Your phone: each profile > the link5 min
   **Done when:** Every link opens the right page on a phone.
5. 5
   **Count the posts of the last 30 days**
   Divide the number of posts by 4 to get posts a week. Compare it with the number you planned.
   PostNext: Calendar > Published, or the grid on each profile 10 min
   **Done when:** Every row has a posts-a-week number.
6. 6
   **Find the top 3 posts on each account**
   Sort the posts by comments, then by likes. Write one line on what the top 3 share: a format, a topic or a time.
   PostNext: Analytics, or the network's own insights for older posts 10 min
   **Done when:** Every row has 3 top posts and one line on why they worked.
7. 7
   **Measure your reply time**
   Open the last 10 comments and questions. Note how long the oldest one waited for an answer.
   PostNext: Comment inbox (Instagram), or each network's app5 min
   **Done when:** Every row has a reply time in hours or days.
8. 8
   **Pick 3 fixes and give each a date**
   Add the six scores. Take the lowest checks across all accounts and plan one fix for each this week.
   PostNext: Calendar 10 min
   **Done when:** 3 fixes with a date and a name next to each.

## Scoring rules for each check

| Check | 0 points | 1 point | 2 points |
| --- | --- | --- | --- |
| Profile | No photo, or an old name | Photo and name, but no category or contact | Photo, name, category and contact all correct |
| Bio | Only your brand name | Says what you do, not for whom | What you do, for whom and what to tap |
| Link | No link, or it is broken | Works, but opens your homepage | Opens the page your bio promises |
| Posts a week | No post in 30 days | Less than your plan | Your planned number, every week |
| Top 3 posts | You do not know them | You know them | You know why they worked and made more like them |
| Reply time | More than 3 days, or no replies | 1 to 3 days | The same day |

Score each account alone. A strong Instagram account does not lift a TikTok account nobody posts on.

## The audit sheet

**Social media audit**

```
Audit date: [today]   Next audit: [date in 90 days]

Account: [network] @[handle]   Login held by: [name]
Profile (0-2): [ ]   Note: [what is wrong]
Bio (0-2): [ ]   Note: [what is missing]
Link (0-2): [ ]   Opens: [page]
Posts a week (0-2): [ ]   Last 30 days: [number] posts
Top 3 posts (0-2): [ ]   1. [post] 2. [post] 3. [post]   Why: [one line]
Reply time (0-2): [ ]   Oldest wait: [hours or days]
Total: [ ] of 12

Fix first: [lowest check]   By: [date]   Who: [name]
```

Copy the account block once for each account. Keep the sheet. In 90 days you score the same checks and compare.

## Audit template for Google Sheets or Excel

Copy the sheet and paste it into cell A1 of a new Google Sheet or Excel file. Each value lands in its own column, and the Total column adds up the six scores for you. Delete the rows of networks you do not use.

**Social media audit template (spreadsheet)**

```
Network	Handle	Profile (0-2)	Bio (0-2)	Link (0-2)	Posts a week (0-2)	Top posts (0-2)	Reply time (0-2)	Total (of 12)	Fix first
Instagram	@							=SUM(C2:H2)	
TikTok	@							=SUM(C3:H3)	
LinkedIn	@							=SUM(C4:H4)	
X	@							=SUM(C5:H5)	
Threads	@							=SUM(C6:H6)	
Bluesky	@							=SUM(C7:H7)	
YouTube	@							=SUM(C8:H8)
```

Score each check 0, 1 or 2 with the rules above. Write the check with the lowest score in **Fix first**.

## What each total means

| Total | What it means | Fix first |
| --- | --- | --- |
| 0 to 4 | The account works against you | Profile, bio and link. Or close the account and send people to the one you use |
| 5 to 8 | People can find you, but posts are rare or replies are slow | Posts a week and reply time |
| 9 to 10 | The basics work | Top posts: make more posts like your best 3 |
| 11 to 12 | A healthy account | Keep the rhythm and audit again in 90 days |

**Fix order when scores tie**

Fix the link first, then the bio, the profile, the reply time, the posts a week and the top posts. A broken link loses the people who already want to act.

## A 60-minute order of work

| Minutes | Task | You finish with |
| --- | --- | --- |
| 0 to 10 | List every account and its login | One row per account |
| 10 to 25 | Profile, bio and link on each account | Three scores per row |
| 25 to 45 | Posts of the last 30 days and the top 3 | Two more scores per row |
| 45 to 50 | Reply time | The last score per row |
| 50 to 60 | Totals and 3 fixes | 3 fixes with a date in your calendar |

Run more than 5 accounts? Audit the accounts that bring customers first, and the rest next week.

## Fixes to copy

- Bio Candles, ceramics and linen, made by the sea. We ship to the EU and the UK. New pieces every Friday. Shop below.
- Old account We moved. Our new posts are at @marea.home. See you there.
- Late reply Sorry for the slow answer. Yes, the candle comes in a bigger size. The link is in our bio.
- Posting rule3 posts a week: Monday a product, Wednesday the studio, Friday a customer photo.

[**Instagram bio generator***Free. Writes bio lines from what you sell and who it is for.*](https://postnext.io/tools/instagram-bio-generator) [**Engagement rate calculator***Free. Compare accounts with one rate from likes, comments and followers.*](https://postnext.io/tools/engagement-rate-calculator)

## Fixes in PostNext

- Low posts a week: set posting times for each channel in **Channels > Settings > Posting Times**, then add posts with **Next Available**.
- Slow replies: answer Instagram comments in the **Comment inbox**. It shows comments from the 25 most recent posts on each account.
- Top posts unknown: open **[Analytics](https://postnext.io/features/analytics)** each week. It shows likes and comments per post for X, Instagram, TikTok and LinkedIn.
- One message for several networks: write one draft, pick the channels, and change the text for each channel in the same draft.

Analytics shows the posts published since you connected the channel. For older posts, use the network's own insights. On Instagram, Insights needs a Business or Creator account.

## Mistakes to avoid

**Do**

- Score every account with the same six checks
- Test links on a phone, not a laptop
- Write why the top 3 posts worked
- Put each fix in the calendar with a name
- Audit again in 90 days

**Avoid**

- Counting followers as the only score
- Fixing ten things at once
- Keeping accounts nobody posts on
- Auditing from memory instead of the profile

Updated 19 November 2026 by the PostNext team

[Next guide · 8 steps · 40 minutes **Write posts with AI**A brand profile to complete, prompts to copy and a checklist for every AI draft.](https://postnext.io/guides/how-to-write-social-media-posts-with-ai)

## Common questions

**What is a social media audit?**

A check of every account you run against the same list: profile, bio, link, posts a week, top posts and reply time. The score tells you what to fix first. [What is a content audit?](https://postnext.io/learn/what-is-a-content-audit)

**How often should I do a social media audit?**

Every 90 days. Do one more after a big change, such as a new name, a new website or a new product.

**Can PostNext do the audit for me?**

No. PostNext does not score profiles. It shows two of the checks in one place: your published posts in the calendar, and likes and comments per post in Analytics.

**Why does PostNext Analytics not show my older posts?**

History starts when you connect a channel. PostNext does not import older posts. For posts from before that day, use the network's own insights.

**Which networks have numbers in PostNext Analytics?**

Likes and comments per post for X, Instagram, TikTok and LinkedIn. Followers for X, Instagram, Threads and TikTok. You pick the last 7, 30 or 90 days. Bluesky and YouTube have no numbers yet.

**Can I export the numbers for my audit?**

On paid plans, Analytics exports CSV and PDF files and can send reports by email.

**Should I close an account I no longer use?**

If you cannot post there every week, post one last message that names the account you use. Then close it or leave it with that message at the top.

## Do this week's posts in one sitting

Connect your channels, write each post once and PostNext publishes it at the time you pick.

[Start your 7-day free trial](https://postnext.io/signup?plan=free&source=guides-guide-close)

The trial asks for a card. Cancel before it ends and you pay nothing.
