Engagement rate calculator
The three engagement rates that mean different things — by reach, by impressions, by follower — side by side, so you stop comparing numbers that were never comparable.
The preview below is the real file, just shortened. Several other resources here are free and need no account.
Preview
Post,Followers,Reach,Impressions,Likes,Comments,Shares,Saves,Total engagements,ER by follower %,ER by reach %,ER by impressions %
Example post,10000,4200,5600,310,24,18,41,=SUM(E2:H2),=I2/B2*100,=I2/C2*100,=I2/D2*100
,,,,,,,,=SUM(E3:H3),=I3/B3*100,=I3/C3*100,=I3/D3*100
,,,,,,,,=SUM(E4:H4),=I4/B4*100,=I4/C4*100,=I4/D4*100
,,,,,,,,,,,
NOTE,"ER by follower is the vanity one — it falls as you grow even when performance improves.",,,,,,,,,,
NOTE,"ER by reach is the honest one for organic: what share of the people who saw it did something.",,,,,,,,,,
NOTE,"Always say which one you used. A 'good' rate is meaningless without the denominator.",,,,,,,,,,Shortened for the page. The download is the complete file with every specification filled in and dated.
