The full delivery-to-response journey for 10,091 conversations. Two big drops: Read → Rated (81.5% loss) and Contacted → Read (33.8% loss). The read-to-response gap is the biggest opportunity.
| Country | Contacted | Reached | Read | Rated | Read → Response | NPS |
|---|---|---|---|---|---|---|
| 🇲🇽 Mexico | 1,273 | 1,158 (91.0%) | 846 (66.5%) | 243 | 28.7% | 51.0 |
| 🇵🇪 Peru | 5,506 | 4,871 (88.5%) | 3,865 (70.2%) | 713 | 18.4% | 44.7 |
| 🇬🇹 Guatemala | 3,312 | 2,849 (86.0%) | 1,967 (59.4%) | 278 | 14.1% | 21.2 |
| LATAM Total | 10,091 | 8,878 (88.0%) | 6,678 (66.2%) | 1,234 | 18.5% | 40.7 |
| Model | Responses | Promoters | Passives | Detractors | NPS |
|---|---|---|---|---|---|
| RONIN 250 | 84 | 60 | 15 | 9 | 60.7 |
| Apache RTR 200 | 54 | 31 | 9 | 14 | 31.5 |
| Apache RTR 160 | 36 | 25 | 4 | 7 | 50.0 |
| STRYKER 125 | 23 | 16 | 3 | 4 | 52.2 |
| Apache RR 310 | 21 | 13 | 5 | 3 | 47.6 |
| HLX 150 | 10 | 7 | 2 | 1 | 60.0 |
dealer_id but not dealer_name. The city field is 100% null. Dealer master mapping and geo-tagging are open action items to enable dealer scorecards.
| Model | Responses | Promoters | Passives | Detractors | NPS |
|---|---|---|---|---|---|
| RAIDER | 169 | 97 | 34 | 38 | 34.9 |
| KING DELUXE LNG | 124 | 83 | 19 | 22 | 49.2 |
| KING DURAMAX LPG | 95 | 55 | 23 | 17 | 40.0 |
| RAIDER FI | 78 | 47 | 15 | 16 | 39.7 |
| Apache RTR 200 | 42 | 26 | 4 | 12 | 33.3 |
| KING DURAMAX CNG | 34 | 22 | 6 | 6 | 47.1 |
| KING DURAMAX PETROL | 32 | 29 | 3 | 0 | 90.6 |
| Apache RTR 160 | 23 | 17 | 2 | 4 | 56.5 |
| NTORQ 125 | 23 | 18 | 2 | 3 | 65.2 |
| Apache RTR 180 | 22 | 14 | 4 | 4 | 45.5 |
| KING DELUXE PETROL | 18 | 11 | 3 | 4 | 38.9 |
| RONIN 225 | 17 | 11 | 5 | 1 | 58.8 |
| Apache RR 310 | 16 | 8 | 5 | 3 | 31.2 |
| City | Responses | Promoters | Passives | Detractors | NPS |
|---|---|---|---|---|---|
| SAN JUAN DE LURIGANCHO | 69 | 39 | 18 | 12 | 39.1 |
| VENTANILLA | 34 | 27 | 4 | 3 | 70.6 |
| SAN MARTIN DE PORRES | 32 | 22 | 4 | 6 | 50.0 |
| ATE | 30 | 17 | 8 | 5 | 40.0 |
| COMAS | 30 | 15 | 4 | 11 | 13.3 |
| CHORRILLOS | 29 | 20 | 2 | 7 | 44.8 |
| CALLAO | 28 | 13 | 7 | 8 | 17.9 |
| SAN JUAN DE MIRAFLORES | 28 | 14 | 8 | 6 | 28.6 |
| VILLA MARIA DEL TRIUNFO | 28 | 23 | 3 | 2 | 75.0 |
| CARABAYLLO | 19 | 9 | 3 | 7 | 10.5 |
| VILLA EL SALVADOR | 18 | 5 | 8 | 5 | 0.0 |
| LIMA | 16 | 11 | 3 | 2 | 56.2 |
| SANTA ANITA | 16 | 13 | 1 | 2 | 68.8 |
| LOS OLIVOS | 14 | 9 | 3 | 2 | 50.0 |
| PACHACAMAC | 12 | 8 | 2 | 2 | 50.0 |
dealer_id and dealer_name are 100% null across all Peru rows. Enforcing DMS dealer-id mapping is the #1 data-quality action for Peru.
| Model | Responses | Promoters | Passives | Detractors | NPS |
|---|---|---|---|---|---|
| RAIDER 125 | 86 | 50 | 12 | 24 | 30.2 |
| Apache RTR 200 | 78 | 35 | 10 | 33 | 2.6 |
| Apache RTR 160 | 66 | 35 | 12 | 19 | 24.2 |
| RONIN 225 | 14 | 8 | 1 | 5 | 21.4 |
| Apache RTR 180 | 12 | 5 | 3 | 4 | 8.3 |
| Dealer | Responses | Promoters | Passives | Detractors | NPS |
|---|---|---|---|---|---|
| KING SAN JOSE PINULA | 13 | 10 | 2 | 1 | 69.2 |
| TVS EL CASTAÑO | 18 | 13 | 3 | 2 | 61.1 |
| ESCUINTLA | 17 | 13 | 1 | 3 | 58.8 |
| TVS RETALHULEU | 7 | 4 | 1 | 2 | 28.6 |
| TVS JALAPA | 9 | 5 | 1 | 3 | 22.2 |
| 6TA AV ZONA 9 | 31 | 16 | 4 | 11 | 16.1 |
| CENTRAL YURRITA | 125 | 58 | 22 | 45 | 10.4 |
| TVS AMATITLAN | 13 | 5 | 4 | 4 | 7.7 |
| TVS QUETZALTENANGO | 12 | 6 | 0 | 6 | 0.0 |
| TVS CALLE MARTI | 22 | 7 | 3 | 12 | -22.7 |
Four testable hypotheses for the 81.5% read-to-drop gap. Guatemala 14.1% is the worst starting point for experiments.
Median lag from service to outreach is 89 days. Customers don't remember the service well enough to answer — they open, don't recall, and close the message.
Peru has the highest read rate but only 18.4% response. Guatemala 59% read but 14% respond. Local Spanish nuances may make the bot feel foreign and impersonal.
Nothing compels the customer to spend 30 seconds answering. No incentive, no "help us improve", no visible dealer-name — reads like a generic corporate ping.
If the opening message doesn't state "reply with 1 number 0-10", customers may not realise what's expected and skip.
Test 3 variants in Guatemala (lowest R2R at 14.1%): (a) current, (b) "Your feedback in 10 seconds — reply 0-10", (c) "Help <dealer_name> serve you better — 1 number 0-10". Target: +5 pp read-to-response in 30 days.
NPS score + one open-text "why". Drop anything else. Long conversation flows kill mobile engagement.
NPS -22.7 on 22 responses — the only sub-zero major dealer in LATAM. Dealer audit + coaching intervention.
Event-driven DMS webhook: service closure → Day-3 NPS trigger. Recall is fresh, answers are honest, response rates rise. Owner: Prem Prakash D.
Persist raw transcript, LLM summary and L1/L2/L3 themes for every conversation. Without "why" data, we cannot diagnose the read-to-drop cause.
Map dealer_id + dealer_name in Peru DMS; map dealer_name and city in Mexico DMS. Back-fill 90 days of history so dealer-level NPS scorecards can be produced weekly in Power BI.
972 undelivered + 241 sent-only = 12.0% never reached device. Validate customer number quality in DMS, audit opt-out lists, verify WhatsApp Business template approvals.