ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Profitability Questionnaire
3
4
Profitability Analysis for Google Ads Spend - 1/1/2024 through 1/31/2024
5
6
Orders by ChannelRevenue by Channel
7
ChannelOrders%ChannelRevenue%
8
Web Orders 105 70%Web Revenue$63,639 70%
9
Phone Orders 32 30%Phone Revenue$19,092 30%
10
Total 137 100%Total Revenue$82,730 100%
11
12
Key Performance IndicatorsKey Performance Indicators
13
KPITotal $Total %KPITotal $Total %
14
Revenue$82,730 100%Gross Revenue$16,650 20%
15
Ad Spend$10,942 -Total Fixed Costs$3,000 4%
16
Return on Ad Spend$71,788 656%Net Profit$13,650 16%
17
Cost of Goods Sold$55,138 67%True ROI125%
18
19
Top 5 Most Profitable Ad GroupsTop 5 Least Profitable Ad Groups
20
Ad GroupGross Rev% of ProfitAd GroupGross Rev% of Profit
21
Socially Relevant Beehives
 $ 5,615 41%Blazers $ (660)-5%
22
Jackets $ 2,287 17%Shorts $ (14)0%
23
Chinos $ 2,261 17% $ - 0%
24
Pants $ 2,153 16% $ - 0%
25
Jeans $ 517 4% $ - 0%
26
27
Customer Lifetime ProfitabilityCustomer Lifetime Profitability
28
Based on 1.5 Lifetime Purchases
Based on 1.5 Lifetime Purchases
29
KPITotal $Total %KPITotal $Total %
30
Revenue$124,095 100%Gross Revenue$30,446 25%
31
Ad Spend$10,942 -Total Fixed Costs$3,000 4%
32
Return on Ad Spend$113,153 1034%Net Profit$27,446 33%
33
Cost of Goods Sold$82,707 67%True ROI251%
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