Template_Table

	A	B	C	D	E	F	G	H	J
1
2	No		Indikator	Bobot ( % )	Target	Capaian	Perhitungan	Skors
3	1	Awwareness - 25%	Reach	10%	50.000	40000		8,0%	Bulan
4			Followers Growth	5%	2.000	2200		5,5%	1
5			Profile Visit	5%	5.000	4300		4,3%	2
6			Brand Mentioan	5%	100	90		4,5%	3
7	2	Consideration - 25%	Engagement Rate	10%	6%	3%		5,0%	4
8			Story View & Interaksi	5%	15.000	15.000		5,0%	5
9			DM Masuk	5%	200	75		1,9%	6
10			Wa Masuk / klik link	5%	1000	500		2,5%	7
11	3	Conversion - 35%	Closing Rate	15%	25%	23%		13,8%	8
12			Cost per Lead	5%	20.000	18000		5,6%	9
13			Cost per Acquisition	5%	100.000	135000		3,7%	10
14			Waktu Konfersi	5%	3	6		2,5%	11
15			Average Order Value	5%	3.500.000	3800000		5,4%	12
16	4	Loyality - 15%	UGC / Testimoni	5%	50	38		3,8%
17			Referal	5%	25	20		4,0%
18			Repeat Order / Servise	5%	25	10		2,0%
19								77,5%
20		Iterpretasi
21		> 90%	Sangat baik
22		70% - 90%	Baik. tapi masih ada ruang perbaikan
23		50 - 70%	perlu perbaikan besar
24		< 50%	strategi marketing tidak efektif
25
26	No		Indikator	Bobot ( % )	Target	Capaian	Perhitungan	Skors
27	1	Traffic & Leads - 35%	Jumlah Lead Baru	15%
28			Sumber Leads ( Channel Efektif )	10%
29			Lead Quality ( Sesuai target budget & Minat )	10%
30	2	Konversi - 40%	Respon Speed	10%
31			Closing Rate	15%
32			Follow up Rate	10%
33			Deal Time	5%
34	3	Revenue & Nilai tranaksi - 25%	Average Order Value ( AOV )	10%
35			Revenue Harian/mingguan	10%
36			Repeat order / referal & Servise	5%
37
38		Interpretasi Cepat
39		> 85%	Strategi selling sangat efektif, Pertahankan & Scale Up
40		70% - 84%	Masih sehat tapi ada 1 - 2 indikator yang perlu ditingkatkan
41		< 70%	perlu evaluasi besar, fokus ke indikator dengan bobot tertinggi ( Closing Rate, Leads baru & Revenue )
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