Back to the engagement interpretation guide
Instagram engagement comparison worksheet
Keep the method consistent. Record two post samples, understand what changed and choose one next action.
Use your browser’s Print command to print this worksheet or save it as a PDF, or copy the prompts into your own document. This worksheet does not collect or save entries. All examples are illustrative.
Rate (%) = ((likes + comments) ÷ posts) ÷ follower snapshot × 100
This worksheet matches our Instagram calculator’s likes-and-comments method. It excludes saves and shares. It is not a reach or view rate, an authenticity score, or a measure of sales.
01Set the comparison rules
- Use comparable periods, formats and observation ages.
- Include posts with zero likes or comments. Mark missing observations “unavailable”; do not silently turn them into zero.
- Use the same follower-snapshot convention in both periods. A present-day count for old posts is a retrospective proxy, not a verified historical count.
02Record the two samples
Keep a post-level ledger in your own records: post reference, published date, collection date, likes and comments. Record excluded posts and the reason. Use whole counts; post and follower totals must be greater than zero.
Period A · Reference
Period B · Comparison
03Calculate, then compare
Enter each sample separately in the Instagram engagement calculator. Copy the results below.
| Measure | A | B |
|---|---|---|
| Total likes + comments | _______ | _______ |
| Interactions per post | _______ | _______ |
| Follower snapshot | _______ | _______ |
| Engagement rate (%) | _______ | _______ |
If A’s rate is zero, relative percentage change is undefined. Report the percentage-point difference and absolute counts instead. Do not compare unlike denominators or different sets of interactions.
Worked example · More interactions, lower rate
| Measure | A | B |
|---|---|---|
| Likes / comments | 900 / 100 | 1,080 / 120 |
| Posts / followers | 10 / 2,000 | 10 / 3,000 |
| Interactions per post | 100 | 120 |
| Rate | 5.00% | 4.00% |
Interactions per post rose 20%; followers rose 50%. The rate fell 1 percentage point, or 20% relative to A.
The denominator grew faster. This alone does not show that the content got worse. Check the sample, audience and useful outcomes before deciding what to change.
04Choose one useful next action
Record uncertainty and missing data. A small sample or one before/after comparison does not establish what caused the change. There is no universal “good” rate in this worksheet.