ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAK
1
2
3
4
5
Copyright 2021 DESelect bv.
6
https://deselect.com
7
INSTRUCTIONS
8
This is a public spreadsheet to help customers and partners determine the business case for improved audience management based on a better segmentation solution.
9
Numbers are based on various intakes with SFMC customers and partners and backed up with references.
10
Your numbers may vary - Feel free to copy this sheet and adjust as needed.
11
References can be found at the bottom.
12
13
Time Saving Calculation
14
In TotalPer FTEHow long does it take?
15
ResourcesFTEs
(Full Time Equivalent)
% Time Spent on Data Mgt in SFMC (1)Saved hours / weekSaved hours / daySaved hours / weekSaved hours / monthSaved days / monthSaved days / yearSaved hours / daySaved hours / weekSaved hours / monthSaved days / monthSaved days / yearTo get to the moon (days)To cross the Atlantics by boatRoad trip across all UE countriesGrow TomatosMotorcycle trip accross the Americas
16
Central Marketing Automation Team750%1962819684010512604.028.0120.015.0180.0371650140
17
Decentral Marketing Teams3020%33648336144018021601.611.248.06.072.0
18
Total3753276532228028534202.114.461.67.792.4
19
20
Efficiency Gain Calculation
21
22
ENTERPRISE: Decentral marketing teams supported by central team of specialists
23
ResourcesFTEs
(Full Time Equivalent)
% Time Spent on Data Mgt in SFMC (1)Avg. Annual FTE Cost (2)Annual Cost Data Mgt in SFMCTime Saving with DESelect (3)Estimated Annual Efficiency Gain
24
Central Marketing Automation Team750%$84,435.40$295,523.9050%$147,761.95
25
Decentral Marketing Teams3020%$75,975.20$455,851.2050%$227,925.60
26
Total37$751,375.10$375,687.55=> This is the added value provided by efficient audience management
27
28
29
LARGE CORPORATE: Marketing team supported by specialists
30
ResourcesFTEs
(Full Time Equivalent)
% Time Spent on Data Mgt in SFMC (1)Avg. Annual FTE Cost (2)Annual Cost Data Mgt in SFMCTime Saving with DESelect (3)Estimated Annual Efficiency Gain
31
Marketing Automation Specialists250%$84,435.40$84,435.4050%$42,217.70
32
Marketers1520%$75,975.20$227,925.6050%$113,962.80
33
Total17$312,361.00$156,180.50=> This is the added value provided by efficient audience management
34
35
36
CORPORATE: Marketing team including specialist
37
ResourcesFTEs
(Full Time Equivalent)
% Time Spent on Data Mgt in SFMC (1)Avg. Annual FTE Cost (2)Annual Cost Data Mgt in SFMCTime Saving with DESelect (3)Estimated Annual Efficiency Gain
38
Marketing Automation Specialists140%$84,435.40$33,774.1650%$16,887.08
39
Marketers340%$75,975.20$91,170.2450%$45,585.12
40
Total4$124,944.40$62,472.20=> This is the added value provided by efficient audience management
41
42
43
(1) "Data Management": Creating data extensions, queries, automations, working with FTP, briefing technical resources what query to write (comm. overhead),...
On average, we find that teams managing SFMC spend 40% of their time on data management. When you have a specialized central team, it's possible to reduce this number for the supported colleagues, but of course it would increase for the central team.
44
(2) Salaries taken from Glassdoor:
- Marketer
- Marketing Automation Specialist (resources in central teams are usually more senior and specialized)
Take these salaries, then multiply with 1.25-1.4 (source) in the case of US.
For EU salaries plus additional costs, factor in 60-90K€ for marketing resources.
To calculate the annual cost of contractors, take day rate and multiply with 180 (days).
45
(3) With the right enablement, a team can save 50% of time spent on audience management. See these success stories:
- Cambridge University Press: Over 50% time saved on data management and no more SQL queries in 1 month.
- Practising Law Institute (PLI): Canceled all investments in SQL training and reached full user adoption in 1 month.
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