Engagement Rate Calculator Worksheet
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.
Analytics & ReportingPDF + CSV5 sectionsfree, no paywall
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.
Still choosing the tool you will run this in? Compare two side by side, or read how each profile is built in our review methodology.
What's inside
2 of 5 sections shown; the remaining 3 come with the free download.
What is an engagement rate calculator?
An engagement rate calculator is a worksheet that turns a post's raw counts into a percentage. You enter likes, comments, saves and shares, choose a base of reach, views or followers, then divide, so the answer describes how many of the people who saw the post did something about it.
Creators need it the moment a brand asks for a rate, because one post can honestly be 3% or 9% depending on the base used. Doing the sum yourself, with the formula written down beside it, lets you quote a number and explain exactly how you reached it.
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.
| Platform | Engagements counted | Recommended base | Formula | Strong rate |
|---|---|---|---|---|
| Likes + comments + saves + shares | Reach | (Engagements / Reach) x 100 | > 4% | |
| TikTok | Likes + comments + shares | Views | (Engagements / Views) x 100 | > 5% |
3 more sections and the PDF + CSV are behind the free download.
Tools that help with this
The template does the thinking; these are the products creators run it in. The full software directory has the rest.
Iconosquare
Iconosquare is a social media analytics platform with performance tracking, scheduled reports, hashtag analysis, and competitive benchmarking.
$0/mo
Modash
Modash is an influencer marketing platform for finding creators, analyzing audience data, and tracking campaigns across Instagram, TikTok, and YouTube.
$199/mo
Klear
Klear is an influencer marketing platform that helps brands discover creators, manage sponsorship relationships, run campaigns, and measure results across Instagram, TikTok, YouTube, and more.
~$25,000/yr
Categories to browse: Creator Analytics, Creator CRM & Sponsorship.
Frequently asked questions
What is an engagement rate calculator?
It is a worksheet that divides a post's total engagements by a chosen base and converts the result to a percentage. The value of it is consistency: the same formula, the same base and the same engagement types on every post you measure.
What is the engagement rate formula?
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.