Engagement rate is the number brands judge you on, and most creators calculate it wrong. This worksheet gives you the right formula for each platform, a per-post calculator, and a benchmark column so you know whether your rate is actually strong.
What you get
The correct engagement-rate formula for each major platform
A per-post calculator that shows your true rate, not a vanity number
A benchmark column so you can judge whether your rate is competitive
Editable CSV for Google Sheets or Excel, plus a branded print-ready PDF
How to use this template
1
Choose the right base. Decide whether you're dividing by followers or by reach. Reach gives a fairer rate; followers is the figure brands often expect.
2
Add up total engagements. Sum likes, comments, shares, and saves for the post. Saves and shares matter more than likes, so always include them.
3
Run the calculation. Divide total engagements by your base and multiply by 100. Enter the post's numbers and the worksheet shows your rate.
4
Compare to the benchmark. Check your rate against the platform benchmark column to see whether a post over- or under-performed.
What's inside
Here's a preview. Unlock the free download to get all 3 sections (2 more below).
Formula reference by platform
Use the right base for each platform. Engagement-by-reach is the fairest measure; engagement-by-followers is what many brands still ask for.
If you can't remember which posts actually performed, you keep guessing. This tracker gives every piece of content one row — platform, format, the metric that matters, and a verdict — so your next content decision is based on evidence, not vibes.
Reporting across four platforms with four different dashboards is how creators stop checking their numbers entirely. This template flattens every channel into one comparable view so you can see what's working at a glance and write the recap in minutes.
You can't make content for an audience you can't describe. This template pulls your demographics, top locations, active hours, and recurring questions into one profile so every post is aimed at the people actually watching.
The standard formula is (total engagements / base) x 100, where engagements include likes, comments, saves, and shares. Divide by reach or views for the fairest rate, or by followers if a brand specifically asks for engagement-by-followers.
Should I calculate engagement rate by reach or by followers?
+
Reach (or views) is more accurate because it measures engagement against people who actually saw the post, not your whole follower list. Followers-based rate runs lower as your audience grows, so know which one a brand means before quoting it.
What counts as a good engagement rate?
+
It varies by platform and audience size, but roughly: above 4% on Instagram and YouTube and above 5% on TikTok is strong. The most useful benchmark is your own recent average, since that's what reveals over- and under-performers.