Sample social media scorecard.xlsx

	A	B	C	D	E	F	G	H	J	K	L	M	N	O
1	2023 Targets								2.86
2	2023 Targets								JAN		2.98	FEB		2.75
3	PAGE		WEIGHT	1 Poor Brand Health	Unsatisfactory Health	3 Satisfactory Health	4 Good Brand Health	5 Excellent Brand Health	Result	Score	Weighted Score	Result	Score	Weighted Score
4	Brand 1	Page Followers	5%	< 200 (< 5)	201 - 900 (6 - 30)	901 - 1,200 (31 - 90)	1,201 - 1,900 (91 - 150	≥ 1,901(≥ 150)	172,266	4	0.20	173,237	4	0.20
5		Impressions	20%	< 500,000 (<5,000)	500,001 - 1,500,000 (5,001 - 15,000)	1,500,001 - 2,000,000 (15,001 - 35,000)	2,000,001 - 2,750,000 (35,001 - 50,000)	≥ 2,750,001 (≥ 50,001)	27,357	4	0.80	19,760	4	0.80
6		Engagement	25%	< 90,000 (<20)	90,001 - 120,000 (21 - 1,000)	120,001 - 165,000 (1,001 - 1,750)	165,001 - 210,000 (1,751 - 2,250)	≥ 210,001 (≥ 2,251)	1,666	3	0.75	2,821	5	1.25
7		Link Clicks	25%	< 2,500 (< 5)	< 2,501 - 4,000 (6 - 20)	4,001 - 5,800 (21 - 60)	5,801 - 7,600 (61 - 90)	≥ 7,601 (≥ 91)	57	3	0.75	29	3	0.75
8		Leads	25%	< 1	2 - 5	6 - 10	11- 20	≥ 21	27	2	0.50	19	1	0.25
9											3.00			3.25
10	Brand 2	Page Followers	5%	< 200 (< 5)	201 - 900 (6 - 30)	901 - 1,200 (31 - 90)	1,201 - 1,900 (91 - 150	≥ 1,901(≥ 150)	30,388	3	0.15	30,397	3	0.15
11		Impressions	20%	< 500,000 (<500)	500,001 - 1,500,000 (501 - 1,500)	1,500,001 - 2,000,000 (1,501 - 3,000)	2,000,001 - 2,750,000 (3,001 - 4,500)	≥ 2,750,000 (≥ 4,501)	1,420	4	0.80	791	3	0.60
12		Engagement	25%	< 90,000 (<5)	90,001 - 120,000 (6 - 100)	120,001 - 165,000 (101 - 750)	165,001 - 210,000 (751 - 1,250)	≥ 210,001 (≥ 1,251)	162	3	0.75	83	2	0.50
13		Link Clicks	25%	< 2,500 (<1)	< 2,501 - 4,000 (1 - 3)	4,001 - 5,800 (4 - 10)	5,801 - 7,600 (10 - 30)	≥ 7,601 (≥ 30)	3	2	0.50	3	2	0.50
14		Leads	25%	< 1	2 - 5	6 - 10	10 - 25	≥ 26	9	3	0.75	4	2	0.50
15											2.95			2.25
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