Business Data Tracking Template.xlsx

	A	B	C	D	E	F	G	H	I
1	Date	Leads	Purchase Count	Revenue	Ad Spend	Other Costs	Cost Per Lead	Net Profit/Loss

2	September 1	40	2	₦50,000.00	₦2,000.00	₦5,000.00	₦50.00	₦43,000.00
3	September 2	30	1	₦25,000.00	₦2,000.00	₦0.00	₦66.67	₦23,000.00
4	September 3	40	1	₦25,000.00	₦2,000.00	₦0.00	₦50.00	₦23,000.00
5	September 4	20	4	₦100,000.00	₦2,000.00	₦0.00	₦100.00	₦98,000.00
6	September 5	20	2	₦50,000.00	₦2,000.00	₦0.00	₦100.00	₦48,000.00
7	September 6	15	1	₦25,000.00	₦2,000.00	₦0.00	₦133.33	₦23,000.00
8	September 7	10	1	₦25,000.00	₦2,000.00	₦0.00	₦200.00	₦23,000.00
9	September 8	5	4	₦100,000.00	₦2,000.00	₦0.00	₦400.00	₦98,000.00
10	September 9	30	2	₦50,000.00	₦2,000.00	₦0.00	₦66.67	₦48,000.00
11	September 10	40	1	₦25,000.00	₦3,000.00	₦0.00	₦75.00	₦22,000.00
12	September 11	20	1	₦25,000.00	₦0.00	₦0.00	₦0.00	₦25,000.00
13	September 12	20	4	₦100,000.00	₦0.00	₦0.00	₦0.00	₦100,000.00
14	September 13	15	2	₦50,000.00	₦0.00	₦0.00	₦0.00	₦50,000.00
15	September 14	10	1	₦25,000.00	₦0.00	₦0.00	₦0.00	₦25,000.00
16	September 15	5	1	₦25,000.00	₦3,000.00	₦0.00	₦600.00	₦22,000.00
17	September 16	30	4	₦100,000.00	₦3,000.00	₦6,000.00	₦100.00	₦91,000.00
18	September 17	40	2	₦50,000.00	₦3,000.00	₦0.00	₦75.00	₦47,000.00
19	September 18	20	1	₦25,000.00	₦3,000.00	₦0.00	₦150.00	₦22,000.00
20	September 19	20	1	₦25,000.00	₦4,000.00	₦0.00	₦200.00	₦21,000.00
21	September 20	15	4	₦100,000.00	₦4,000.00	₦0.00	₦266.67	₦96,000.00
22	September 21	10	2	₦50,000.00	₦4,000.00	₦0.00	₦400.00	₦46,000.00
23	September 22	5	1	₦25,000.00	₦4,000.00	₦0.00	₦800.00	₦21,000.00
24	September 23	30	1	₦25,000.00	₦4,000.00	₦0.00	₦133.33	₦21,000.00
25	September 24	40	4	₦100,000.00	₦4,000.00	₦0.00	₦100.00	₦96,000.00
26	September 25	20	2	₦50,000.00	₦2,000.00	₦0.00	₦100.00	₦48,000.00
27	September 26	20	1	₦25,000.00	₦2,000.00	₦0.00	₦100.00	₦23,000.00
28	September 27	15	1	₦25,000.00	₦2,000.00	₦0.00	₦133.33	₦23,000.00
29	September 28	10	4	₦100,000.00	₦2,000.00	₦0.00	₦200.00	₦98,000.00
30	September 29	5	2	₦50,000.00	₦2,000.00	₦0.00	₦400.00	₦48,000.00
31	September 30	34	1	₦25,000.00	₦2,000.00	₦0.00	₦58.82	₦23,000.00	Conversion rate
32		634	59	₦1,475,000.00	₦69,000.00	₦11,000.00	₦108.83	₦1,395,000.00	9.31%
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