Marketing Analytics in Tableau
Maarten Van den Broeck
Senior Content Developer at DataCamp
CAC = Customer Acquisition Cost
The amount of money a company needs to spend, on average, to acquire a new customer
$CAC = \frac{\text{Total paid marketing spend}} {\text{Total number of new customers}}$
B2C (Business to Consumer)
B2B (Business to Business)
Marketing Spend ~ 10% of Revenue
Some industries spend above average, others below
Industries > 10% on average:
Industries < 10% on average:
Email and organic
Overhead for paid channels
Overhead consists of costs required to launch marketing outside of the cost to run the ad itself
This includes employees who write and manage content
For most businesses, overhead costs are very small compared to the cost of running ads
LTV: measure of average customer's worth in terms of revenue
CAC: measure of cost to acquire a customer
If LTV = CAC...
$\frac{LTV}{CAC} = 1$
Average cost to acquire a customer = average revenue a customer is worth
If average customer lifetime value is 1,000 USD and customer acquisition cost is 250 USD...
$\frac{LTV}{CAC} = 4$
This tells us that every dollar we invest in acquiring a customer yields 4 USD over that customer's lifetime
Marketing Analytics in Tableau