Most ecommerce founders publish on LinkedIn for a quarter, look at follower count, and call that a review. That's not a review. That's a glance.
A quarterly content audit is different. It's a structured 90-day post-mortem on every post you've published — what topics earned reach, what formats earned saves, what hooks earned profile views, what content actually moved DMs into pipeline. It takes us about three hours per client. It cuts post volume by 30% on average and lifts inbound DM rate by 40-60% because we stop writing the posts that drain the calendar.
This is the audit we run for every EcomGhosts client at the end of every quarter. Steal it.
Why Quarterly, Not Weekly
Weekly post reviews lie to you. One viral post inflates the week. One algorithm dip tanks the week. Sample size is too small to draw any conclusion that survives the next post.
Quarterly is the smallest window where patterns become visible. A quarter is roughly 60 posts for a 5x/week founder. That's enough to see which pillars are pulling weight and which are dead.
It's also the smallest window where business outcomes — DMs, calls, closed pipeline — become statistically meaningful. A great post in week 3 might generate a call that closes in week 11. If you only review the post in week 3, you mark it as "low engagement" and stop writing about that topic. The audit catches the lag.
The 7-Column Audit Spreadsheet
Open a spreadsheet. Columns:
- Date posted
- Pillar (use the 3-5 pillars you defined for the quarter)
- Format (text, carousel, video, image, repost)
- Hook type (contrarian, framework, observational, story, news, list)
- Impressions
- Engagement rate (likes + comments + reposts ÷ impressions)
- Profile views attributed (LinkedIn analytics shows this per post)
Add three more columns the audit week:
- DMs received in 7 days post-publish
- Calls booked attributable to this post or pillar
- Verdict (kill / keep / scale)
The first 7 columns are populated as you publish. The last 3 are populated during the audit week. Don't try to populate columns 8-10 in real-time. You'll bias them.
Step 1: Pillar Performance Analysis
Sort by pillar. Calculate average impressions, average engagement rate, total DMs, and total calls booked per pillar.
You're looking for the gap between vanity engagement and pipeline engagement.
Real client example from a Q1 2026 audit. Five pillars across 62 posts:
- Pillar A (founder story): avg 18K impressions, 4.2% engagement, 2 DMs, 0 calls
- Pillar B (operator framework): avg 9K impressions, 2.8% engagement, 11 DMs, 4 calls
- Pillar C (industry commentary): avg 24K impressions, 5.1% engagement, 3 DMs, 1 call
- Pillar D (client case studies): avg 7K impressions, 2.1% engagement, 9 DMs, 5 calls
- Pillar E (controversial takes): avg 31K impressions, 6.4% engagement, 1 DM, 0 calls
The reach winners (C and E) generated almost zero pipeline. The "underperforming" pillars (B and D) generated 20 DMs and 9 calls — every closed-won client that quarter came from posts in those pillars.
Verdict: cut pillar A entirely, reduce E to once a month for distribution, double down on B and D.
Step 2: Format Performance Analysis
Same exercise, sorted by format. We typically see one of three patterns:
Pattern 1: Text dominates. Founder writes well, formats well, hooks well. Carousels add production cost without adding reach or DMs. Audit verdict: kill carousels, save 4 hours a week.
Pattern 2: Carousels carry saves. Text drives reach, carousels drive saves. Saves correlate with DMs 30 days later. Verdict: keep both, target 70/30 split.
Pattern 3: Video underperforms text. Founder is camera-uncomfortable, video posts get 40% of text reach. Verdict: kill video, redirect production time to writing.
The audit ends the format debate. You stop writing carousels because some LinkedIn guru told you to. You write what your data tells you to.
Step 3: Hook Type Analysis
This is the most actionable part of the audit.
Tag every post by hook type. Six common types:
- Contrarian (most people think X, here's why they're wrong)
- Framework (here's the 5-step system)
- Observational (after reviewing 50K listings, I noticed)
- Story (a year ago, I almost shut this down)
- News (Amazon just announced X, here's what it means)
- List (7 things I'd tell a $1M Amazon brand)
Calculate avg impressions, avg engagement rate, and DM rate per hook type.
In our last 12 audits, observational hooks won DM rate in 9 of 12 cases. They under-index on impressions but over-index on the right kind of impressions — operators reading and DMing, not casual scrollers liking.
Contrarian hooks won impressions but lost DMs more than any other format. Reach without pipeline.
Verdict pattern: shift hook mix toward observational and framework, reduce contrarian to once every 2 weeks for distribution.
Step 4: Time-of-Day and Day-of-Week Analysis
LinkedIn's first-hour velocity window means posting time matters more than most founders think.
Pull average impressions by time slot and day of week. Look for clusters. Most ecommerce founders we audit have a clear winning slot — usually Tuesday-Thursday between 7am and 9am ET — and one or two dead slots they should stop posting in.
We had one client posting Friday at 3pm because that's when she finished her week. Friday 3pm posts averaged 4K impressions vs her Tuesday 8am average of 22K. The audit moved her Friday post to Monday 8am. Quarterly impressions went up 38% with no change in content.
Step 5: The DM Audit
Pull every DM you received the quarter. Categorize:
- Cold pitches (kill)
- Networking (keep, no pipeline weight)
- Founder questions (medium pipeline weight)
- Founders asking about your service or pricing (high pipeline weight)
Then trace each high-weight DM back to a post. Which post triggered it? Which pillar? Which hook?
This is where the magic shows up. The post that triggered the DM is rarely the highest-engagement post that week. It's usually a quieter post in pillar B or D — a framework reveal, a client case study, an operational observation — that pulled the right reader without the algorithm rewarding it heavily.
Tag those posts as "pipeline winners." They get scaled next quarter.
Step 6: Profile View Analysis
LinkedIn shows profile views attributed to specific posts. This is criminally underused.
A post with 8K impressions and 220 profile views is a different kind of post than one with 30K impressions and 50 profile views. The first is doing positioning work — it's pushing readers into your profile, your About, your featured links. The second is doing distribution work — it's getting reach but not curiosity.
Profile views are a 30-day leading indicator of DMs. A post that triggers profile views today triggers DMs three weeks later, after the reader has read your About, scrolled your featured posts, and decided to reach out.
Sort by profile-views-per-1000-impressions. The top 20% of posts by this metric are your authority builders. Scale them.
Step 7: The Kill List
By now you've identified:
- 1-2 pillars to cut entirely
- 1 format to deprioritize
- 1-2 hook types to reduce
- 2-3 dead time slots to abandon
Add it up. For most founders we audit, the kill list removes 30-40% of their post volume without removing reach or pipeline. That time goes back into deeper posts in the winning pillars, more comment engagement, and more DM follow-through.
Step 8: The Scale List
The opposite list. Pillars, formats, and hooks that punched above their weight on pipeline metrics.
For every item on the scale list, write down:
- 5 fresh angles for next quarter
- 2 case studies you can tell
- 1 framework you can codify
You walk out of the audit with a 30-post content calendar already half-drafted. No blank-page Sundays for the next quarter.
How Long Does This Take
About three hours if you've been tagging posts as you publish. About six if you have to retroactively tag a quarter of posts.
Do it once a quarter, every quarter. Skip it and your content drifts back to whatever you find easy to write rather than what your audience actually responds to.
FAQ
Q: I post 2x/week, not 5x. Is the audit still useful? At 2x/week you have ~25 posts per quarter. That's the lower bound for pillar-level analysis. Hook type and time-of-day analysis still work. Pillar analysis becomes directional, not statistical.
Q: What if I don't have access to historical DM data? Start tracking now. The audit becomes more valuable each quarter because the data set compounds.
Q: Can I do this monthly instead? Monthly is too small a sample for pillar conclusions. We do a 30-minute monthly check-in and a full 3-hour quarterly audit. The monthly check-in catches obvious problems; the quarterly audit catches patterns.
The Audit Is the System
Most LinkedIn content fails not because the writer can't write, but because no one ever stops to ask which posts are working. The quarterly audit is the only structural mechanism that forces that question.
Your content gets sharper every 90 days. Your time investment drops. Your pipeline rate climbs. Compounding.
If you want a team that runs this audit for you alongside the writing, book a call — we audit every client's content quarterly as part of the engagement.