Most social reports answer "how did the posts do?" and stop there. An ROI audit answers a different question: which of last month's posts did anything the business can count? You can run it in 10 minutes with last month's top 10 posts, your analytics export and a link tracker.
TLDR: Pull your 10 best posts by engagement, give each one a business outcome (click, lead, sale, booking, reply from a buyer), and mark it keep, fix or drop. Anything with no outcome is a vanity metric, however big the number looks.
Mydrop data, September 2026: across accounts connected to Mydrop, which manages 55,000+ posts, the median engagement rate per post was 3.1% on Instagram, 3.0% on TikTok and 1.1% on Facebook. The middle half of Instagram posts ran between 1.1% and 6.7%, so a 2% post is normal and a 7% post is a good day. Method and full tables in the Mydrop social media benchmarks.
Minutes 0 to 3: list the 10 posts and the one outcome each was meant to cause
Open your analytics and sort last month's posts by engagement. Copy the top 10 into a sheet with five columns: post, format, engagement rate, intended outcome, actual outcome.
The "intended outcome" column is where most teams stall. A post has to have been meant to do something: send people to a page, collect an email, start a DM, put a product in front of buyers. If you cannot fill the cell, the post was entertainment. That is fine, but it should not appear in an ROI report.
Use the platform's own benchmark to sort strong from average. In Mydrop's data a 2% Instagram post is normal and 7% is a good day, so do not celebrate a 2.4% post that earned nothing.
Minutes 3 to 6: match each post to a click, a lead or a sale
Now fill "actual outcome". You need one number per post that lives outside the social app:
- Clicks from a tagged link (UTM parameters on every link, one campaign name per post group).
- Leads or sign-ups in your form tool or CRM, filtered by that same campaign tag.
- Sales or bookings where the buyer was asked "how did you hear about us?" or used a post-specific code.
- Buyer replies in comments or DMs, counted by hand.
Do not chase perfect attribution. Dark social and word of mouth will always leak. You are looking for a ranking, not an accounting statement.
Minutes 6 to 8: sort the posts into a three-bucket table
Use this table to turn the sheet into decisions.
| Bucket | What it looks like | What you do |
|---|---|---|
| Keep and repeat | Engagement at or above your median and a counted outcome | Write two more posts on the same angle this month |
| Fix the bridge | High engagement, no outcome | The post worked, the path did not. Add a link, a clear call to action or a pinned comment |
| Drop or demote | Low engagement and no outcome | Stop making this format or topic unless it serves brand, not revenue |
The middle bucket is the most valuable. A post that people loved but did not act on is a conversion problem, which is cheaper to fix than a reach problem.
Minutes 8 to 10: write one sentence for your boss, not a slide
End with a single sentence per bucket. For example: "Four of ten top posts produced tracked leads, three produced engagement only, three can be dropped." That sentence is the report. Attach the sheet if someone asks.
Then change one thing for next month's calendar. Not five. If "fix the bridge" had three posts, the one change is adding a tracked link and a clear next step to every post in that bucket.
What counts as vanity and what does not
A metric is vanity when nobody would change a decision because of it. Follower count, likes and impressions are vanity on their own. Saves, shares, replies from real prospects, tracked clicks and DMs about a product are not, because each one is a step toward a purchase.
Reach is not useless. It tells you whether the audience saw the post at all. But reach only earns a place in the ROI conversation when the next column, outcome, is filled.
Make the audit a monthly 10 minutes
Doing this once teaches you something. Doing it monthly shows trends. Keep one sheet with a tab per month and compare the share of top posts with a counted outcome. If it goes from 3 of 10 to 5 of 10, your content is getting closer to your sales path.
Mydrop helps with the two slow parts. Analytics pulls native metrics from each connected profile into one view and exports white-label PDF reports, so the top-10 list takes a minute. In the calendar you can add a note to each high performer saying which outcome it caused, so next month's planning starts from facts instead of memory. See social media reports and the performance dashboard.
Send the first audit before the end of the week
Pick last month, not this one. Pull the top 10, fill the five columns, and write the three bucket sentences. If you want a deeper plan for proving results to leadership, read Prove Social Media ROI to Your Boss in 30 Days next. For several brands in one sheet, use the multi-brand scorecard.
Google review
Trustpilot review
Product Hunt comment
