Social media audit template and how to use it

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

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 file10 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 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 profile10 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 posts10 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: Calendar10 min

    Done when: 3 fixes with a date and a name next to each.

Scoring rules for each check

Check0 points1 point2 points
ProfileNo photo, or an old namePhoto and name, but no category or contactPhoto, name, category and contact all correct
BioOnly your brand nameSays what you do, not for whomWhat you do, for whom and what to tap
LinkNo link, or it is brokenWorks, but opens your homepageOpens the page your bio promises
Posts a weekNo post in 30 daysLess than your planYour planned number, every week
Top 3 postsYou do not know themYou know themYou know why they worked and made more like them
Reply timeMore than 3 days, or no replies1 to 3 daysThe 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

TotalWhat it meansFix first
0 to 4The account works against youProfile, bio and link. Or close the account and send people to the one you use
5 to 8People can find you, but posts are rare or replies are slowPosts a week and reply time
9 to 10The basics workTop posts: make more posts like your best 3
11 to 12A healthy accountKeep the rhythm and audit again in 90 days

A 60-minute order of work

MinutesTaskYou finish with
0 to 10List every account and its loginOne row per account
10 to 25Profile, bio and link on each accountThree scores per row
25 to 45Posts of the last 30 days and the top 3Two more scores per row
45 to 50Reply timeThe last score per row
50 to 60Totals and 3 fixes3 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

  • BioCandles, ceramics and linen, made by the sea. We ship to the EU and the UK. New pieces every Friday. Shop below.
  • Old accountWe moved. Our new posts are at @marea.home. See you there.
  • Late replySorry 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 generatorFree. Writes bio lines from what you sell and who it is for.Engagement rate calculatorFree. Compare accounts with one rate from likes, comments and followers.

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 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  by the PostNext team

Next guide · 8 steps · 40 minutesWrite posts with AIA brand profile to complete, prompts to copy and a checklist for every AI draft.

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?

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.

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