$253
Costo promedio por VIP
Inversión en pauta / VIPs obtenidos
$862
Ticket promedio por VIP
Ingresos / VIPs obtenidos
2.7x
ROI neto promedio
Ingreso neto / Inversión pauta
19.0%
Concentración Top 3
✅ Distribución saludable
Insights automáticos
Analizando patrones...
Costo por VIP por ciudad
Concentración de VIPs por ciudad
Matriz eficiencia: % Conversión vs ROAS
Eficiencia de Abejas
| Vendedor | Leads | Ventas | % Cierre | Comisión |
|---|---|---|---|---|
| ADRIANA | 45 | 12 | 26.7% | $23,720 |
| ALDO | 59 | 17 | 28.8% | $11,364 |
| ALEX | 36 | 13 | 36.1% | $6,709 |
| AMY | 39 | 17 | 43.6% | $9,044 |
| ANAYELI | 34 | 12 | 35.3% | $6,099 |
| BILLU | 39 | 11 | 28.2% | $6,279 |
| BRAULIO | 23 | 9 | 39.1% | $3,219 |
| CLAUDIA | 38 | 15 | 39.5% | $7,749 |
| AMGU | 0 | 11 | — | $4,690 |
| EDSON | 26 | 11 | 42.3% | $8,120 |
| ELI | 43 | 10 | 23.3% | $9,810 |
| FELIPE | 43 | 7 | 16.3% | $4,999 |
| GUADALUPE | 85 | 24 | 28.2% | $18,074 |
| ISAAC | 11 | 8 | 72.7% | $9,564 |
| IVAN | 30 | 13 | 43.3% | $6,219 |
| JACQUI | 21 | 16 | 76.2% | $5,779 |
| JAIRO | 38 | 9 | 23.7% | $5,289 |
| LUIS | 48 | 8 | 16.7% | $17,049 |
| LUPITA | 64 | 17 | 26.6% | $13,909 |
| MAGDA | 30 | 18 | 60.0% | $8,174 |
| MARIANA | 55 | 10 | 18.2% | $7,599 |
| PABLO | 16 | 3 | 18.8% | $19,810 |
| PAO | 0 | 0 | — | $43,870 |
| SAMU | 43 | 12 | 27.9% | $10,370 |
| SEBAS | 41 | 12 | 29.3% | $7,189 |
| VERO | 109 | 34 | 31.2% | $30,070 |
| VICKY | 92 | 17 | 18.5% | $17,624 |
| TEIBY | 4 | 0 | 0.0% | $500 |
| ZAID | 39 | 13 | 33.3% | $10,425 |
| ANGELICA | 33 | 9 | 27.3% | $8,115 |
| ELIZABETH | 36 | 10 | 27.8% | $8,765 |
| EMPRESA | 0 | 16 | — | $6,480 |
| RENE | 0 | 1 | — | $530 |
KPIs que deberías medir — roadmap de datos
Tiempo entre eventos por ciudad
Cuántos días pasan entre visitas a la misma ciudad. Detecta ciudades sin presencia reciente.
Prioridad Media
Asistencia por perfil demográfico
Segmentar registros por edad/género/origen para optimizar el pitch. Requiere enriquecer el Sheet.
Prioridad Alta
Tasa de conversión de seguimientos
% de presenciales que terminan en seguimiento 3m/6m/1a. Hoy solo ves el conteo, no la tasa.
Prioridad Alta
Rendimiento AM vs PM por ciudad
Las sesiones de mañana vs tarde convierten diferente. El Sheet tiene horario; no se está analizando.
Prioridad Media
Ticket promedio por vendedor
No solo cuánto vende cada abeja sino a qué precio promedio cierra.
Prioridad Media
Costo de adquisición de cliente (CAC)
CAC = Inversión total / Clientes nuevos. Requiere separar inversión por evento individualmente.
Prioridad Alta
LTV estimado del VIP
Valor de vida del cliente. Necesita histórico de recompras o upgrades.
Prioridad Baja (futuro)
Penetración de mercado por ciudad
VIPs obtenidos vs población objetivo estimada de la ciudad.
Prioridad Media
Tabla completa de eficiencia por ciudad
CSV| Ciudad | Región | Eventos | VIPs | % Conv. | Ticket prom. | Costo/VIP | ROI neto | Breakeven | Share VIPs |
|---|---|---|---|---|---|---|---|---|---|
| Querétaro | México | 7 | 472.0 | 4.5% | $4,122 | $1,841 | 0.7x | 335.7 |
5.5%
|
| Cdmx | México | 5 | 623.0 | 5.5% | $2,788 | $718 | 2.0x | 300.2 |
7.3%
|
| Guadalajara | México | 5 | 533.0 | 5.7% | $3,256 | $760 | 2.7x | 197.4 |
6.2%
|
| Monterrey | México | 2 | 352.0 | 8.1% | $2,855 | $643 | 2.4x | 159.2 |
4.1%
|
| Toluca | México | 1 | 162.0 | 6.8% | $2,796 | $580 | 2.8x | 67.6 |
1.9%
|
| Puebla | México | 1 | 185.0 | 8.2% | $2,115 | $456 | 2.8x | 72.8 |
2.2%
|
| Morelia | México | 1 | 143.0 | 6.4% | $2,401 | $652 | 2.0x | 66.1 |
1.7%
|
| Leon | México | 1 | 175.0 | 7.3% | $1,869 | $630 | 1.5x | 88.1 |
2.0%
|
| Aguascalientes | México | 1 | 159.0 | 9.6% | $1,284 | $595 | 0.5x | 122.5 |
1.9%
|
| Houston | USA | 2 | 304.0 | 17.0% | $350 | $73 | 3.1x | 104.6 |
3.6%
|
| Dallas | USA | 2 | 302.0 | 10.1% | $332 | $74 | 2.8x | 114.0 |
3.5%
|
| Newark | USA | 3 | 328.0 | 10.4% | $294 | $80 | 1.8x | 170.6 |
3.8%
|
| Los Ángeles | USA | 1 | 213.0 | 12.8% | $432 | $60 | 5.6x | 48.8 |
2.5%
|
| Miami | USA | 4 | 203.0 | 6.0% | $452 | $136 | 1.8x | 92.1 |
2.4%
|
| Chicago | USA | 3 | 319.0 | 11.2% | $278 | $65 | 2.8x | 111.1 |
3.7%
|
| Phoenix | USA | 2 | 257.0 | 12.6% | $329 | $86 | 2.2x | 111.8 |
3.0%
|
| Tampa | USA | 4 | 170.0 | 6.8% | $475 | $192 | 1.0x | 100.6 |
2.0%
|
| Orlando | USA | 4 | 228.0 | 6.2% | $347 | $159 | 0.7x | 160.1 |
2.7%
|
| Austin | USA | 2 | 232.0 | 11.8% | $330 | $92 | 2.1x | 95.6 |
2.7%
|
| San Diego | USA | 2 | 257.0 | 14.0% | $293 | $87 | 1.6x | 133.0 |
3.0%
|
| San José | LATAM | 2 | 284.0 | 16.6% | $248 | $75 | 1.8x | 132.8 |
3.3%
|
| Las Vegas | USA | 2 | 220.0 | 11.4% | $300 | $91 | 1.3x | 133.8 |
2.6%
|
| Atlanta | USA | 1 | 171.0 | 13.2% | $373 | $60 | 4.4x | 50.0 |
2.0%
|
| Denver | USA | 1 | 103.0 | 10.6% | $568 | $104 | 3.7x | 33.7 |
1.2%
|
| Los Angeles | USA | 1 | 246.0 | 16.2% | $224 | $51 | 2.2x | 123.7 |
2.9%
|
| San Antonio | USA | 2 | 214.0 | 10.2% | $252 | $102 | 1.0x | 129.9 |
2.5%
|
| Fresno | USA | 1 | 119.0 | 11.0% | $369 | $94 | 2.4x | 45.9 |
1.4%
|
| Washington | USA | 1 | 118.0 | 15.9% | $309 | $69 | 2.4x | 53.7 |
1.4%
|
| Boston | USA | 1 | 81.0 | 5.7% | $394 | $109 | 1.8x | 41.1 |
0.9%
|
| Sacramento | USA | 1 | 144.0 | 22.0% | $212 | $60 | 1.8x | 72.7 |
1.7%
|
| San Francisco | USA | 1 | 150.0 | 18.7% | $184 | $75 | 0.7x | 108.1 |
1.8%
|
| Filadeldia | USA | 1 | 113.0 | 12.9% | $197 | $77 | 0.9x | 72.9 |
1.3%
|
| Bogotá | LATAM | 2 | 253.0 | 4.5% | — | $26 | 18.8x | — |
3.0%
|
| Republica Dominicana | LATAM | 2 | 331.0 | 4.0% | — | $76 | — | — |
3.9%
|
| Medellín | LATAM | 1 | 180.0 | 4.2% | — | $31 | 9.6x | — |
2.1%
|
| Lima | LATAM | 2 | 204.0 | 3.6% | — | $23 | 2.1x | — |
2.4%
|