Análisis de costo de adquisición de clientes
El Costo de Adquisición de Clientes (CAC) es una métrica crítica para las empresas que buscan medir la eficacia y rentabilidad de sus esfuerzos de marketing. Esta métrica refleja el gasto promedio que una empresa realiza para conseguir un nuevo cliente. El análisis del CAC permite a las empresas poder optimizar sus estrategias de marketing y distribuir sus recursos de manera más eficiente.
Análisis
Conjunto de datos
SELECT * FROM 'customer_acquisition_cost_dataset.csv'
Run to view results
Gasto Total en Marketing
SELECT CONCAT('$', ROUND(SUM(Marketing_Spend), 2)) AS Gasto_Total
FROM 'customer_acquisition_cost_dataset.csv';
Run to view results
Número Total de Nuevos Clientes
SELECT SUM(New_Customers) AS Total_de_Nuevos_Clientes
FROM 'customer_acquisition_cost_dataset.csv';
Run to view results
Gasto por Canal de Marketing
SELECT Marketing_Channel, ROUND(SUM(Marketing_Spend), 2) AS Gasto_Total_en_Marketing_Por_Canal
FROM 'customer_acquisition_cost_dataset.csv'
GROUP BY Marketing_Channel
ORDER BY Gasto_Total_en_Marketing_Por_Canal DESC;
Run to view results
Run to view results
Número de Nuevos Clientes por Canal de Marketing
SELECT Marketing_Channel, COUNT(New_Customers) AS Nuevos_Clientes_por_Canal_de_Marketing
FROM 'customer_acquisition_cost_dataset.csv'
GROUP BY Marketing_Channel
ORDER BY Nuevos_Clientes_por_Canal_de_Marketing DESC;
Run to view results
Run to view results
Costo de Adquisición de Cliente (CAC) por Canal de Marketing
SELECT Marketing_Channel,
ROUND((SUM(Marketing_Spend) / SUM(New_Customers)), 2) as CAC
FROM 'customer_acquisition_cost_dataset.csv'
GROUP BY Marketing_Channel
ORDER BY CAC DESC;
Run to view results
Run to view results
Ratio de Conversión (Nuevos Clientes / Gasto en Marketing) por Canal de Marketing
SELECT Marketing_Channel, ROUND((SUM(New_Customers) / SUM(Marketing_Spend)) * 100, 2) as Ratio
FROM 'customer_acquisition_cost_dataset.csv'
GROUP BY Marketing_Channel
ORDER BY Ratio DESC;
Run to view results
Run to view results
Punto de Equilibrio (Gasto en Marketing / CAC)
SELECT Marketing_Channel,
SUM(New_Customers) AS Nuevos_Clientes,
SUM(Marketing_Spend) / (SUM(Marketing_Spend) / SUM(New_Customers)) AS Punto_de_Equilibrio
FROM 'customer_acquisition_cost_dataset.csv'
GROUP BY Marketing_Channel;
Run to view results
Run to view results