Social media audit template: a 7-section TikTok and Instagram audit from one Claude prompt

Updated

A social media audit template should measure every post against your own median, not your follower count. This one is a single Claude prompt connected to Virlo that returns a 7-section TikTok and Instagram audit: outlier sweep, hook audit, format and length, competitor benchmark, trend opportunities, an impact/effort/confidence fix matrix and a 30/60/90-day roadmap, plus a PDF, an .xlsx fix tracker and a content calendar.

  • The 7 sections a TikTok and Instagram audit needs, as a checklist
  • The full audit prompt, word for word, ready to paste into Claude
  • A worked example on WHOOP: outliers, a cross-app gap and 3 scored fixes
TikTokInstagram

What should a social media audit template include?

A social media audit template should include 7 sections, each measured against your own account's median views on that platform. Paid audits often hand back follower counts; this template reads your videos from the last year and compares them with your own baseline, your competitors and what's winning in your category now.

The 7-section social media audit checklist
#SectionWhat it answers
1Outlier sweepEach platform's median, then every video at 3 times its median or more
2Hook auditYour hook types against your median, plus 10 trending hooks you aren't using
3Format and lengthWhat you post most vs what pulls the most views, per platform; videos that hit on one app and died on the other
4Competitor benchmarkEach competitor's median, top 3 outliers, and the hooks and formats they win with that you don't use
5Trend opportunities3 live formats that fit your brand, with the recipe and an example each
6Impact/Effort/Confidence matrixEvery fix scored 1 to 5 and sorted by (impact x confidence) / effort
730/60/90-day roadmapWhat to post each month, and how many

Agencies quote $2,500 to $5,000 for a social media audit (Webtonic, 2026) and 2 to 4 weeks to deliver one (Giraffe Social Media, Volume Nine). This template runs in a few minutes. For the outlier logic behind section 1, see outlier videos.

How do you measure posts fairly in a social media audit?

Measure each post against that account's own median views on that platform, never against follower count. A video at 3 times your median is an outlier worth studying; raw views mostly reflect account size.

Audit rules built into the template
RuleWhy
Compare every video only to its own account's median on that platformFollowers don't predict views; your median does
Skip posts with no views when working out a medianThey drag the baseline down
Take hooks from the hook field, never the captionThe caption is often not what's said or shown first
Treat length and hashtags as differences, not proven causesA pattern in a small set can be chance
Never invent a numberIf it isn't in the results, the report says so

The same own-median rule powers Virlo's Outliers and the TikTok analytics and Instagram analytics views.

How do you set up Claude to run a social media audit?

Set up Claude for the audit in about 5 minutes: connect it to Virlo's database of 23.3M viral videos and switch on file creation so it can hand you the PDF and the tracker.

  1. Create your Virlo account. Start your 7-day free trial.
  2. Add the connector. In claude.ai open Customize, then Connectors, then Add custom connector. Name it Virlo, paste the URL below and sign in. In a new chat, click + then Connectors and turn Virlo on. Full walkthrough: Virlo for Claude.
  3. Turn on file creation. In Settings, then Capabilities, switch on "Code execution and file creation".
Connector URL
https://dev.virlo.ai/api/mcp/mcp
Claude settings: Add custom connector named Virlo with the URL https://dev.virlo.ai/api/mcp/mcp

In Claude Code, run this, then type /mcp and sign in:

Claude Code
claude mcp add --transport http virlo https://dev.virlo.ai/api/mcp/mcp

What is the social media audit prompt?

The social media audit prompt below is the whole template. Fill in the brackets (your brand, handles, niche, hook category and 3 competitors) and leave everything else as it is.

Social media audit prompt
Using Virlo: run a full TikTok + Instagram audit on [BRAND]
and give it to me as a report.

My accounts: TikTok [TIKTOK HANDLE], Instagram [INSTAGRAM HANDLE].
My niche: [NICHE, e.g. "protein snacks" or "budgeting app"].
Hook category: [ONE OF: fitness, food_beverage, beauty, fashion,
tech, finance, health_wellness, lifestyle, education, other].
My 3 competitors: [COMPETITOR 1], [COMPETITOR 2], [COMPETITOR 3]
(TikTok or Instagram handles, say which).

PULL THE DATA
1. Run lookup_creator on each of my accounts (platform tiktok,
   then instagram) with include "videos,outliers", max_videos 100,
   trend_analysis true and data_intelligence true. Context: "which
   hooks, formats and lengths drive this brand's most-viewed
   videos". The hook, format and visual fields land a few minutes
   after the lookup, so read the saved run with get_satellite_run
   once it says ready.
2. Run lookup_creator on each competitor with include
   "videos,outliers" and max_videos 50.
3. Run get_trending_hooks with category [HOOK CATEGORY], days 14,
   sort weighted_score, limit 30.
4. Run get_content_trends with examples 3 and limit 20. Keep only
   the formats that fit [BRAND].

RULES
- Compare every video only to that account's own median views on
  that platform, never to its follower count.
- Skip posts with no views when you work out a median.
- Take hooks from the hook field, never from the caption.
- Length and hashtags are differences, not proven causes. Say so.
- Never invent a number. If it isn't in the results, say so.

WRITE THE AUDIT IN 7 SECTIONS
1. Outlier sweep: each platform's median, then every video at 3 times
   its median or more, biggest first (link, views, multiple, date,
   hook).
2. Hook audit: my hook types against my median, then the 10 hooks
   from step 3 I'm not using yet, word for word, with links.
3. Format and length: what I post most against what pulls the
   most views, per platform. Flag any video that hit on one app
   and died on the other.
4. Competitor benchmark: each competitor's median and top 3
   outliers, and the hooks and formats they win with that I never
   use.
5. Trend opportunities: the 3 formats from step 4 that fit
   [BRAND], with the recipe and one example video each.
6. Impact/Effort/Confidence matrix: every fix you found, scored
   1-5 on each, sorted by (impact x confidence) / effort.
   Confidence = how many videos back it: 1-2 low, 3-5 medium,
   6+ high.
7. 30/60/90-day content roadmap built from the top fixes: what to
   post each month and how many.

THEN MAKE 3 FILES
- A PDF report of the 7 sections, with the 3 fixes that matter
  most on page 1.
- An .xlsx tracker, one row per fix: section, fix, impact, effort,
  confidence, score, video links, status. Sorted by score.
- The roadmap as a one-page content calendar.

It takes a few minutes while the hook and format fields land, then the report comes back section by section. For more prompts in the same style, see the best Claude prompts for social media.

What does a finished social media audit look like?

Here is the template run on WHOOP, the fitness band and app, with every count pulled live on 17 November 2026 across 53 TikToks and 53 Reels from the past year. WHOOP's TikTok median is 23.5K views and its Instagram median is 171.6K.

Section 1 outlier sweep for WHOOP: TikTok median 23.5K, Instagram median 171.6K; outliers at 32.8M, 76.3M, 642.4K and 94.8K views
WHOOP outlier sweep (section 1)
VideoPlatformViewsTimes its median
"5 high-impact habits you'll actually do" (hands only, 8 seconds)TikTok32.8M1,396x
Ronaldo's heart rate at the goalInstagram76.3M445x
Van der Poel on recoveryInstagram642.4K3.7x
Niall Horan's new bandTikTok94.8K4.0x

Section 3 caught a gap between the apps: the Ronaldo heart-rate moment did 76.3M on Instagram and 224.6K as a TikTok. On TikTok, question captions ran at 0.63x the median and videos of 15 seconds or less at 1.20x (a difference, not a proven cause).

Section 3 for WHOOP: the same Ronaldo heart-rate moment at 76.3M views on Instagram and 224.6K on TikTok; question captions 0.63x median, TikToks of 15s or less 1.20x

How do you prioritise fixes after a social media audit?

Prioritise audit fixes by (impact x confidence) / effort, with confidence set by how many videos back each fix: 1 to 2 is low, 3 to 5 medium, 6 or more high. The WHOOP sample produced these 3, scored as judgement calls on the real data above:

WHOOP sample fix matrix (section 6)
FixImpactEffortConfidenceBacked by
Turn "5 high-impact habits" into a weekly TikTok series523The 32.8M outlier plus 4 tutorial-promise TikToks at 1.44x the median
Re-cut athlete heart-rate moments for TikTok, number in frame 0433The 76.3M vs 224.6K pair
Swap question captions for how-to promises3126 question-caption TikToks at 0.63x vs 1.14x for the rest
Section 6 impact/effort/confidence matrix for WHOOP: weekly habits series (5/2/3), re-cut heart-rate moments for TikTok (4/3/3), swap question captions for how-to promises (3/1/2)
Sample 30/60/90-day roadmap from the WHOOP audit: 4 habit-list TikToks in month 1, athlete moments re-cut for TikTok in month 2, keep the 3 winners in month 3

Then open the tracker, sort by score and do the top 3 for 30 days. Run the same prompt again at day 30 and see which fixes moved your median. To dig into competitors beyond section 4, use the competitor content analysis or the Instagram competitor analysis.

Rather skip Claude? Look up your account, your competitors and your niche inside the Virlo web app.

How this resource was made

Source
Virlo: WHOOP's TikTok and Instagram videos from 17 November 2025 onwards (53 TikToks, 53 Reels), live view counts pulled 17 November 2026; each multiple is live views divided by the median of the same account on that platform. Audit pricing from Webtonic (2026) and SocialRails; turnaround from Giraffe Social Media and Volume Nine.
How this page is made
Written by the Virlo team from the original One-Prompt Social Media Audit resource. The prompt is unchanged.
Limitations
The WHOOP fix scores are judgement calls on real data, shown as a sample. Length and caption patterns are differences, not proven causes.
As of
(first published November 17, 2026)

Source: Virlo, Social media audit template: a 7-section TikTok and Instagram audit from one Claude prompt, November 2026, virlo.ai/resources/social-media-audit-template

Want the full list?

Run a 7-section TikTok and Instagram audit on your own account, measured against your own median. Virlo is social listening for TikTok and Instagram Reels: start a 7-day free trial at app.virlo.ai and see real videos from your niche before you pay.

Frequently asked questions

What is a social media audit?

A review of an account's posts to find what works, what doesn't and what to change. A useful one measures each post against the account's own median views and ends with a ranked list of fixes.

What should a social media audit template include?

An outlier sweep, a hook audit, format and length, a competitor benchmark, trend opportunities, a scored fix matrix and a 30/60/90-day roadmap.

How do you do a social media audit on TikTok and Instagram?

Pull your videos from the last year on each platform, work out each platform's median views, flag videos at 3x the median or more, then compare hooks, formats, competitors and trends. The prompt on this page does it in one run.

How much does a social media audit cost?

Agencies quote $2,500 to $5,000 (Webtonic, 2026), and some list $500 to $2,500 (SocialRails), usually with 2 to 4 weeks to deliver.

Why compare posts to your own median instead of followers?

Follower count doesn't predict views. Your median shows what's normal for your account, so a 3x video is a real outlier.

What is an impact/effort/confidence matrix?

Each fix is scored 1 to 5 on impact, effort and confidence, then sorted by (impact x confidence) / effort so the cheap, likely wins come first.

Can I audit my competitors too?

Yes. Section 4 pulls each competitor's median, top 3 outliers and the hooks and formats they win with that you don't use.

What files does the audit produce?

A PDF report with the 3 top fixes on page 1, an .xlsx fix tracker sorted by score, and a one-page 90-day content calendar.

How often should I run a social media audit?

Every 30 days: do the top 3 fixes, rerun the prompt and check which ones moved your median.

Run this on your own niche

Run a 7-section TikTok and Instagram audit on your own account, measured against your own median.

7-day free trial, easy to cancel.