$194
Costo promedio por VIP
Inversión en pauta / VIPs obtenidos
$953
Ticket promedio por VIP
Ingresos / VIPs obtenidos
3.67x
ROI neto promedio
Ingreso neto / Inversión pauta
19.7%
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 |
|---|---|---|---|---|---|---|---|---|---|
| Cdmx | México | 12 | 2674.0 | 6.8% | $2,942 | $640 | 2.3x | 1311.0 |
8.6%
|
| Querétaro | México | 12 | 1540.0 | 5.8% | $3,739 | $780 | 2.6x | 705.1 |
4.9%
|
| Guadalajara | México | 11 | 1821.0 | 7.2% | $2,843 | $603 | 2.6x | 820.8 |
5.8%
|
| Monterrey | México | 8 | 1663.0 | 6.9% | $2,952 | $724 | 2.0x | 852.7 |
5.3%
|
| Morelia | México | 5 | 1316.0 | 8.6% | $2,672 | $437 | 4.2x | 403.2 |
4.2%
|
| Chihuahua | México | 4 | 1408.0 | 10.9% | $2,416 | $462 | 3.5x | 451.6 |
4.5%
|
| Cd Juarez | México | 2 | 819.0 | 11.6% | $3,334 | $489 | 4.5x | 273.5 |
2.6%
|
| Tijuana | México | 1 | 1054.0 | 13.0% | $1,977 | $223 | 6.7x | 258.4 |
3.4%
|
| Hermosillo | México | 3 | 688.0 | 8.2% | $2,958 | $963 | 1.2x | 411.2 |
2.2%
|
| Leon | México | 3 | 1001.0 | 9.7% | $1,962 | $335 | 3.8x | 349.4 |
3.2%
|
| Mérida | México | 2 | 634.0 | 8.0% | $2,656 | $444 | 3.5x | 263.7 |
2.0%
|
| Aguascalientes | México | 3 | 786.0 | 9.2% | $1,904 | $397 | 2.5x | 367.6 |
2.5%
|
| San Luis Potosí | México | 2 | 591.0 | 7.5% | $2,494 | $406 | 3.5x | 255.5 |
1.9%
|
| Puebla | México | 2 | 637.0 | 12.6% | $1,939 | $147 | 10.2x | 144.4 |
2.0%
|
| Cancún | México | 1 | 721.0 | 9.7% | $1,384 | $264 | 2.3x | 407.4 |
2.3%
|
| Toluca | México | 2 | 472.0 | 9.6% | $1,794 | $220 | 4.7x | 199.9 |
1.5%
|
| Vallarta | México | 1 | 390.0 | 22.4% | $1,815 | $111 | 12.1x | 102.4 |
1.2%
|
| Pachuca | México | 1 | 229.0 | 7.6% | $2,050 | $37 | 41.7x | 58.2 |
0.7%
|
| Dallas | USA | 4 | 721.0 | 9.7% | $344 | $72 | 3.1x | 248.2 |
2.3%
|
| Houston | USA | 4 | 689.0 | 10.2% | $322 | $80 | 2.6x | 251.6 |
2.2%
|
| Chicago | USA | 5 | 961.0 | 12.1% | $218 | $61 | 2.0x | 416.5 |
3.1%
|
| Los Angeles | USA | 3 | 704.0 | 11.6% | $282 | $66 | 2.5x | 290.4 |
2.3%
|
| Newark | USA | 4 | 636.0 | 10.6% | $288 | $69 | 2.4x | 270.0 |
2.0%
|
| Tampa | USA | 6 | 489.0 | 8.4% | $372 | $124 | 1.4x | 253.5 |
1.6%
|
| Miami | USA | 6 | 442.0 | 6.4% | $401 | $145 | 1.2x | 241.9 |
1.4%
|
| San Diego | USA | 4 | 584.0 | 10.7% | $286 | $93 | 1.4x | 310.4 |
1.9%
|
| Atlanta | USA | 3 | 582.0 | 12.8% | $272 | $80 | 1.8x | 271.6 |
1.9%
|
| Phoenix | USA | 3 | 571.0 | 12.3% | $273 | $71 | 2.2x | 238.0 |
1.8%
|
| Austin | USA | 4 | 486.0 | 10.0% | $294 | $97 | 1.6x | 238.2 |
1.6%
|
| Seattle | USA | 2 | 415.0 | 12.1% | $315 | $76 | 2.6x | 155.1 |
1.3%
|
| Portland | USA | 2 | 397.0 | 14.5% | $271 | $104 | 1.1x | 222.4 |
1.3%
|
| Baltimore | USA | 2 | 326.0 | 11.3% | $310 | $102 | 1.4x | 179.5 |
1.0%
|
| Orlando | USA | 5 | 366.0 | 6.7% | $270 | $143 | 0.4x | 294.3 |
1.2%
|
| Los Ángeles | USA | 1 | 213.0 | 12.8% | $432 | $60 | 5.6x | 48.8 |
0.7%
|
| Sacramento | USA | 2 | 279.0 | 14.4% | $277 | $70 | 2.2x | 123.0 |
0.9%
|
| San José | LATAM | 2 | 284.0 | 16.6% | $248 | $75 | 1.8x | 132.8 |
0.9%
|
| San Antonio | USA | 3 | 289.0 | 8.7% | $240 | $110 | 0.6x | 214.9 |
0.9%
|
| Las Vegas | USA | 2 | 220.0 | 11.4% | $300 | $91 | 1.3x | 133.8 |
0.7%
|
| San Jose | USA | 1 | 262.0 | 12.6% | $243 | $71 | 1.9x | 115.6 |
0.8%
|
| Vancouver | Canadá | 1 | 178.0 | 8.5% | $356 | $106 | 2.9x | 24.8 |
0.6%
|
| Denver | USA | 1 | 103.0 | 10.6% | $568 | $104 | 3.7x | 33.7 |
0.3%
|
| Charlotte | USA | 1 | 151.0 | 9.3% | $376 | $109 | 2.0x | 64.1 |
0.5%
|
| Salt Lake City | USA | 1 | 226.0 | 10.9% | $209 | $44 | 2.9x | 88.8 |
0.7%
|
| Fresno | USA | 1 | 119.0 | 11.0% | $369 | $94 | 2.4x | 45.9 |
0.4%
|
| Fremont | USA | 1 | 129.0 | 9.3% | $319 | $93 | 1.9x | 57.1 |
0.4%
|
| Toronto | Canadá | 1 | 236.0 | 9.1% | $166 | $50 | 1.5x | 132.2 |
0.8%
|
| Washington | USA | 1 | 118.0 | 15.9% | $309 | $69 | 2.4x | 53.7 |
0.4%
|
| Boston | USA | 1 | 81.0 | 5.7% | $394 | $109 | 1.8x | 41.1 |
0.3%
|
| San Francisco | USA | 1 | 150.0 | 18.7% | $184 | $75 | 0.7x | 108.1 |
0.5%
|
| West Palm Beach | USA | 1 | 106.0 | 8.7% | $241 | $111 | 0.5x | 82.3 |
0.3%
|
| Albuquerque | USA | 1 | 105.0 | 12.7% | $228 | $113 | 0.4x | 86.3 |
0.3%
|
| Filadeldia | USA | 1 | 113.0 | 12.9% | $197 | $77 | 0.9x | 72.9 |
0.4%
|
| Jacksonville | USA | 1 | 71.0 | 6.4% | $291 | $221 | — | 83.5 |
0.2%
|
| Bogotá | LATAM | 2 | 253.0 | 4.5% | — | $26 | 18.8x | — |
0.8%
|
| Republica Dominicana | LATAM | 2 | 331.0 | 4.0% | — | $76 | — | — |
1.1%
|
| Medellín | LATAM | 1 | 180.0 | 4.2% | — | $31 | 9.6x | — |
0.6%
|
| Lima | LATAM | 2 | 204.0 | 3.6% | — | $23 | 2.1x | — |
0.7%
|