Campaign Performance - Renewal & Resurrection

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	P
1	Year	Month	Campaign	Funnel	Segment	Voucher	Channel	Total Spend	Voucher Redeem	Gross Revenue	Nett Revenue	Avg. Return on Spend	Avg. Cost per Conversion	Avg. Conversion Rate

2	Total							Rp0	0	Rp0	Rp0	0	Rp0	0.00%
3	2022	December Total						Rp0	145	Rp14,500,000	Rp14,500,000	0	Rp0	0.39%	note: kupon tidak boleh sama walaupun berada di bulan yang berbeda
4	2023	January	Angpau	Renewal	Gerai	ANGPAU12C	Email	Rp0	18	Rp1,800,000	Rp1,800,000	0	Rp0	1.60%
5						ANGPAU12E Total		Rp0	43	Rp4,300,000	Rp4,300,000	0	Rp0.0	12.68%
6						ANGPAU12F	Facebook Ads	Rp220,969	3	Rp300,000	Rp79,031	0	Rp73,656	0.17%
7						ANGPAU12G	Web Push	Rp0	0	Rp0	Rp0	0	Rp0	0.00%
8					Regular Bikom	ANGPAU12A	Email	Rp0	42	Rp4,200,000	Rp4,200,000	0	Rp0	0.20%
9						ANGPAU12B	Web Push	Rp0	9	Rp900,000	Rp900,000	0	Rp0	0.09%
10						ANGPAU12D	Facebook Ads	Rp254,495	4	Rp400,000	Rp145,505	1	Rp63,624	0.05%
11				Resurrection	Gerai	ANGPAU5	Web Push	Rp0	0	Rp0	Rp0	0	Rp0	0.00%
12						ANGPAU500	Email	Rp0	18	Rp1,800,000	Rp1,800,000	0	Rp0	0.62%
13						ANGPAU500FB	Facebook Ads	Rp223,166	1	Rp100,000	-Rp123,166	-1	Rp223,166	0.02%
14						ANGPAU500WA	WhatsApp	Rp0	70	Rp7,000,000	Rp7,000,000	0	Rp0	8.01%
15					Regular Bikom	ANGPAU1	Web Push	Rp0	1	Rp100,000	Rp100,000	0	Rp0	0.00%
16						ANGPAU100	Email	Rp0	346	Rp34,600,000	Rp34,600,000	0	Rp0	0.14%
17						ANGPAU100FB	Facebook Ads	Rp241,708	8	Rp800,000	Rp558,292	2	Rp30,214	0.03%
18						ANGPAU23	Email	Rp0	2	Rp200,000	Rp200,000	0	Rp0	2.56%
19			Angpau Total					Rp940,338	565	Rp56,500,000	Rp55,559,662	0	Rp26,044	1.75%
20			Rubrik Total					Rp0	91	Rp8,940,000	Rp8,940,000	0	Rp0	0.03%
21		February Total						Rp0	760	Rp78,850,000	Rp78,850,000	0	Rp0	0.33%
22		March Total						Rp0	728	Rp74,025,000	Rp74,025,000	0	Rp0	0.49%
23		April Total						Rp0	671	Rp74,380,000	Rp74,380,000	0	Rp0	0.03%
24		May Total						Rp0	477	Rp51,750,000	Rp51,750,000	0	Rp0	0.02%
25		June Total						Rp0	243	Rp29,861,000	Rp29,861,000	0	Rp0	0.00%
26	2023	July Total						Rp0	0	Rp0	Rp0	0	Rp0	0.00%
27	Grand Total							Rp940,338	3,680	Rp388,806,000	Rp387,865,662	0	Rp402	0.08%
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