$142
Costo promedio por VIP
Inversión en pauta / VIPs obtenidos
$1,013
Ticket promedio por VIP
Ingresos / VIPs obtenidos
8.39x
ROI neto promedio
Ingreso neto / Inversión pauta
24.9%
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 |
|---|---|---|---|---|---|---|---|---|---|
| Guadalajara | México | 4 | 1288.0 | 8.0% | $2,672 | $538 | 2.8x | 559.7 |
10.3%
|
| Cdmx | México | 3 | 826.0 | 6.9% | $3,211 | $478 | 3.2x | 437.0 |
6.6%
|
| Monterrey | México | 4 | 1006.0 | 7.7% | $2,543 | $578 | 1.9x | 563.7 |
8.0%
|
| Querétaro | México | 3 | 710.0 | 7.4% | $2,976 | $231 | 8.0x | 267.5 |
5.7%
|
| Morelia | México | 2 | 717.0 | 12.4% | $2,300 | $212 | 8.3x | 166.9 |
5.7%
|
| Chihuahua | México | 2 | 706.0 | 10.8% | $2,307 | $338 | 4.8x | 214.7 |
5.6%
|
| Hermosillo | México | 1 | 373.0 | 9.3% | $2,330 | $381 | 3.1x | 184.7 |
3.0%
|
| Puebla | México | 1 | 452.0 | 16.2% | $1,867 | $20 | 78.8x | 67.4 |
3.6%
|
| San Luis Potosí | México | 1 | 317.0 | 10.5% | $2,517 | $80 | 24.0x | 74.1 |
2.5%
|
| Vallarta | México | 1 | 390.0 | 22.4% | $1,815 | $111 | 12.1x | 102.4 |
3.1%
|
| Leon | México | 1 | 470.0 | 14.8% | $1,390 | $40 | 28.3x | 88.6 |
3.8%
|
| Aguascalientes | México | 1 | 328.0 | 11.1% | $1,684 | $40 | 29.2x | 99.1 |
2.6%
|
| Pachuca | México | 1 | 229.0 | 7.6% | $2,050 | $37 | 41.7x | 58.2 |
1.8%
|
| Toluca | México | 1 | 310.0 | 12.2% | $1,271 | $32 | 22.6x | 133.5 |
2.5%
|
| Chicago | USA | 2 | 642.0 | 12.7% | $188 | $59 | 1.6x | 318.7 |
5.1%
|
| Baltimore | USA | 2 | 326.0 | 11.3% | $310 | $102 | 1.4x | 179.5 |
2.6%
|
| Atlanta | USA | 2 | 411.0 | 12.7% | $230 | $89 | 1.1x | 240.2 |
3.3%
|
| Newark | USA | 1 | 308.0 | 10.7% | $281 | $57 | 3.4x | 98.2 |
2.5%
|
| Seattle | USA | 1 | 215.0 | 11.9% | $318 | $47 | 5.0x | 55.5 |
1.7%
|
| Dallas | USA | 1 | 174.0 | 9.1% | $363 | $62 | 4.1x | 51.8 |
1.4%
|
| Charlotte | USA | 1 | 151.0 | 9.3% | $376 | $109 | 2.0x | 64.1 |
1.2%
|
| Portland | USA | 1 | 191.0 | 14.3% | $283 | $57 | 3.3x | 64.5 |
1.5%
|
| Tampa | USA | 1 | 139.0 | 9.9% | $387 | $90 | 2.6x | 55.5 |
1.1%
|
| Los Angeles | USA | 1 | 178.0 | 8.0% | $293 | $65 | 2.8x | 68.3 |
1.4%
|
| Salt Lake City | USA | 1 | 226.0 | 10.9% | $209 | $44 | 2.9x | 88.8 |
1.8%
|
| Sacramento | USA | 1 | 135.0 | 10.6% | $346 | $81 | 2.6x | 53.9 |
1.1%
|
| San Diego | USA | 1 | 113.0 | 6.8% | $403 | $117 | 1.8x | 54.3 |
0.9%
|
| Miami | USA | 1 | 104.0 | 6.7% | $406 | $149 | 1.1x | 61.8 |
0.8%
|
| Fremont | USA | 1 | 129.0 | 9.3% | $319 | $93 | 1.9x | 57.1 |
1.0%
|
| Toronto | Canadá | 1 | 236.0 | 9.1% | $166 | $50 | 1.5x | 132.2 |
1.9%
|
| Houston | USA | 1 | 160.0 | 7.3% | $214 | $75 | 1.4x | 83.7 |
1.3%
|
| Austin | USA | 1 | 78.0 | 6.4% | $346 | $115 | 1.4x | 41.3 |
0.6%
|
| West Palm Beach | USA | 1 | 106.0 | 8.7% | $241 | $111 | 0.5x | 82.3 |
0.8%
|
| Albuquerque | USA | 1 | 105.0 | 12.7% | $228 | $113 | 0.4x | 86.3 |
0.8%
|
| Jacksonville | USA | 1 | 71.0 | 6.4% | $291 | $221 | — | 83.5 |
0.6%
|
| Orlando | USA | 1 | 138.0 | 7.7% | $144 | $115 | — | 166.0 |
1.1%
|
| San Antonio | USA | 1 | 75.0 | 6.1% | $204 | $133 | — | 92.4 |
0.6%
|