Engagement Rate Calculator

	A	B	C	D	E	F	G	H	I
1	Post Title	Post Date	Likes	Comments	Shares	Saves	Total Engagement	Followers	Engagement Rate
2	Example	11/25/2024	25	10	3	2	40	100	0.4
3	Example	11/24/2024	50	5	10	15	80	100	0.8
4
5	Template		0	0	0	0	0	0	#DIV/0!
6
7
8	Author's Note
9	To use this template, copy and paste the template line to replicate the formula. Or you can erase the examples and get started there! Plug in your engagement metrics and your followers, and it will calculate your engagement rate! You can create mulitple sheets to track overall engagement, daily engagement, individual posts, and more.
10	We recommend duplicating this page and starting your tracking on the next Sheet, which already has the examples, the template, and the graph. That way the basic template is always on hand!
11	To use the graph, simply calculate the engagement rate on your posts: it should udpate automatically. To change the graph style, clip the three buttons in the top right corner and click the drop down Graph Style menu. There might be an option that's better for you, but this simple line graph should be all you need.
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100