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'

Gasto Total en Marketing

SELECT CONCAT('$', ROUND(SUM(Marketing_Spend), 2)) AS Gasto_Total FROM 'customer_acquisition_cost_dataset.csv';

Número Total de Nuevos Clientes

SELECT SUM(New_Customers) AS Total_de_Nuevos_Clientes FROM 'customer_acquisition_cost_dataset.csv';

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 the app to see this chart

Press the run button in the top right corner

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 the app to see this chart

Press the run button in the top right corner

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 the app to see this chart

Press the run button in the top right corner

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 the app to see this chart

Press the run button in the top right corner

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 the app to see this chart

Press the run button in the top right corner

Conclusiones