Clientes | Riesgo de abandono

¿Qué clientes ya dejaron de comprarte?

Un cliente está en riesgo cuando lleva más del doble de su intervalo normal sin comprar. Pega tus clientes y sale la lista para llamar esta semana.

Descargar en Excel Hoja «Clientes en riesgo», con prompts para adaptarlo con IA. Sin registro.

Un cliente por renglón: nombre, venta anual, días normales entre compras, días desde su última compra

C-001, 49000, 23, 17
C-002, 248000, 34, 122
C-003, 796000, 18, 22
C-004, 1036000, 32, 22
C-005, 980000, 13, 10
C-006, 548000, 18, 10
C-007, 143000, 11, 4
C-008, 791000, 20, 12
C-009, 559000, 22, 24
C-010, 446000, 19, 25
C-011, 119000, 18, 13
C-012, 498000, 41, 159
C-013, 1240000, 43, 133
C-014, 681000, 11, 7
C-015, 286000, 38, 25
C-016, 571000, 9, 6
C-017, 352000, 15, 11
C-018, 411000, 19, 17
C-019, 747000, 22, 31
C-020, 477000, 12, 13
C-021, 374000, 15, 14
C-022, 495000, 22, 8
C-023, 168000, 15, 7
C-024, 144000, 15, 11
C-025, 541000, 29, 22
C-026, 206000, 33, 71
C-027, 578000, 20, 6
C-028, 68000, 21, 17
C-029, 1023000, 21, 109
C-030, 320000, 17, 85
C-031, 1554000, 16, 8
C-032, 38000, 12, 10
C-033, 78000, 29, 19
C-034, 1230000, 20, 19
C-035, 403000, 20, 69
C-036, 460000, 23, 10
C-037, 392000, 27, 45
C-038, 405000, 43, 36
C-039, 568000, 18, 9
C-040, 142000, 17, 10
C-041, 303000, 23, 8
C-042, 1125000, 14, 22
C-043, 413000, 40, 64
C-044, 202000, 33, 39
C-045, 383000, 30, 43
C-046, 895000, 20, 19
C-047, 294000, 30, 45
C-048, 300000, 36, 37
C-049, 546000, 27, 43
C-050, 753000, 18, 13
C-051, 1319000, 9, 6
C-052, 314000, 34, 18
C-053, 481000, 18, 10
C-054, 897000, 14, 4
C-055, 64000, 33, 50
C-056, 401000, 25, 40
C-057, 534000, 10, 11
C-058, 328000, 20, 26
C-059, 165000, 18, 97
C-060, 598000, 34, 33
C-061, 1077000, 8, 3
C-062, 327000, 17, 12
C-063, 230000, 20, 6
C-064, 293000, 43, 22
C-065, 1431000, 12, 8
C-066, 1082000, 6, 4
C-067, 370000, 11, 5
C-068, 133000, 24, 36
C-069, 115000, 31, 39
C-070, 267000, 50, 28
C-071, 269000, 26, 10
C-072, 453000, 14, 8
C-073, 130000, 33, 41
C-074, 320000, 21, 5
C-075, 576000, 19, 22
C-076, 79000, 21, 14
C-077, 2801000, 40, 24
C-078, 600000, 13, 17
C-079, 574000, 13, 10
C-080, 112000, 20, 12
C-081, 143000, 20, 29
C-082, 894000, 14, 4
C-083, 796000, 14, 25
C-084, 40000, 25, 12
C-085, 1014000, 41, 19
C-086, 692000, 30, 53
C-087, 630000, 30, 135
C-088, 133000, 39, 56
C-089, 455000, 8, 4
C-090, 210000, 10, 2
C-091, 598000, 15, 66
C-092, 1886000, 12, 9
C-093, 643000, 13, 7
C-094, 902000, 22, 15
C-095, 274000, 11, 56
C-096, 145000, 17, 20
C-097, 367000, 8, 6
C-098, 922000, 13, 9
C-099, 1359000, 41, 9
C-100, 345000, 16, 14
C-101, 457000, 25, 8
C-102, 254000, 30, 33
C-103, 78000, 16, 12
C-104, 394000, 28, 7
C-105, 498000, 23, 14
C-106, 251000, 30, 12
C-107, 312000, 15, 15
C-108, 72000, 10, 32
C-109, 384000, 13, 17
C-110, 1263000, 16, 8
C-111, 357000, 27, 161
C-112, 623000, 19, 7
C-113, 544000, 17, 15
C-114, 185000, 19, 100
C-115, 441000, 36, 30
C-116, 175000, 16, 12
C-117, 5017000, 45, 57
C-118, 439000, 11, 7
C-119, 137000, 16, 56
C-120, 92000, 32, 50
C-121, 1394000, 27, 19
C-122, 634000, 14, 8
C-123, 521000, 20, 9
C-124, 107000, 15, 11
C-125, 220000, 32, 23
C-126, 123000, 28, 29
C-127, 979000, 15, 68
C-128, 228000, 26, 134
C-129, 2059000, 17, 11
C-130, 581000, 20, 35
C-131, 273000, 22, 16
C-132, 1216000, 16, 17
C-133, 55000, 26, 23
C-134, 173000, 26, 9
C-135, 254000, 26, 33
C-136, 952000, 36, 21
C-137, 959000, 18, 22
C-138, 502000, 10, 2
C-139, 74000, 16, 4
C-140, 227000, 23, 6
C-141, 135000, 21, 6
C-142, 1119000, 28, 16
C-143, 245000, 31, 105
C-144, 619000, 20, 72
C-145, 1932000, 20, 12
C-146, 341000, 13, 6
C-147, 683000, 35, 38
C-148, 258000, 18, 19
C-149, 380000, 12, 43
C-150, 379000, 12, 12
C-151, 369000, 17, 31
C-152, 388000, 46, 47
C-153, 256000, 31, 10
C-154, 1954000, 9, 6
C-155, 203000, 20, 12
C-156, 455000, 24, 27
C-157, 279000, 29, 27
C-158, 48000, 25, 29
C-159, 872000, 15, 5
C-160, 448000, 26, 40
C-161, 106000, 16, 11
C-162, 189000, 7, 8
C-163, 85000, 15, 14
C-164, 469000, 15, 7
C-165, 1476000, 34, 199
C-166, 1083000, 36, 156
C-167, 113000, 12, 16
C-168, 77000, 23, 127
C-169, 581000, 22, 8
C-170, 1643000, 10, 39
C-171, 378000, 8, 3
C-172, 927000, 20, 44
C-173, 103000, 22, 13
C-174, 326000, 16, 16
C-175, 535000, 6, 3
C-176, 248000, 21, 8
C-177, 293000, 16, 9
C-178, 664000, 13, 9
C-179, 205000, 18, 14
C-180, 147000, 12, 9
C-181, 701000, 28, 18
C-182, 446000, 21, 20
C-183, 146000, 16, 66
C-184, 528000, 24, 62
C-185, 216000, 21, 13
C-186, 635000, 10, 19
C-187, 354000, 20, 9
C-188, 276000, 17, 45
C-189, 178000, 9, 5
C-190, 428000, 15, 15
C-191, 342000, 26, 8
C-192, 1958000, 15, 10
C-193, 343000, 42, 64
C-194, 106000, 49, 219
C-195, 2296000, 18, 8
C-196, 57000, 28, 23
C-197, 1575000, 57, 48
C-198, 164000, 18, 6
C-199, 1243000, 13, 5
C-200, 301000, 17, 61
C-201, 580000, 11, 9
C-202, 365000, 11, 44
C-203, 322000, 23, 15
C-204, 568000, 17, 17
C-205, 199000, 24, 32
C-206, 546000, 27, 10
C-207, 134000, 14, 17
C-208, 184000, 19, 20
C-209, 224000, 18, 25
C-210, 324000, 15, 9
C-211, 1057000, 14, 10
C-212, 167000, 25, 64
C-213, 163000, 20, 11
C-214, 129000, 25, 30
C-215, 245000, 35, 28
C-216, 585000, 35, 14
C-217, 180000, 12, 10
C-218, 271000, 14, 6
C-219, 208000, 18, 5
C-220, 380000, 22, 9
C-221, 57000, 34, 24
C-222, 601000, 13, 10
C-223, 809000, 17, 11
C-224, 166000, 24, 56
C-225, 331000, 39, 77
C-226, 155000, 42, 16
C-227, 867000, 13, 11
C-228, 622000, 19, 15
C-229, 4783000, 14, 5
C-230, 292000, 32, 17
C-231, 160000, 26, 20
C-232, 229000, 18, 13
C-233, 114000, 15, 52
C-234, 426000, 24, 25
C-235, 467000, 34, 27
C-236, 813000, 14, 14
C-237, 510000, 18, 30
C-238, 244000, 22, 8
C-239, 1137000, 21, 25
C-240, 599000, 25, 88
C-241, 751000, 13, 6
C-242, 124000, 16, 11
C-243, 168000, 7, 4
C-244, 200000, 22, 8
C-245, 251000, 36, 39
C-246, 50000, 8, 4
C-247, 1055000, 15, 4
C-248, 296000, 33, 36
C-249, 769000, 20, 11
C-250, 720000, 8, 7
C-251, 1381000, 38, 30
C-252, 604000, 10, 6
C-253, 507000, 42, 24
C-254, 186000, 16, 39
C-255, 405000, 15, 8
C-256, 1763000, 21, 8
C-257, 75000, 21, 107
C-258, 193000, 28, 13
C-259, 468000, 27, 13
C-260, 1569000, 20, 15
C-261, 137000, 41, 15
C-262, 245000, 30, 14
C-263, 423000, 24, 13
C-264, 6046000, 22, 19
C-265, 170000, 20, 6
C-266, 323000, 20, 50
C-267, 727000, 29, 19
C-268, 198000, 27, 14
C-269, 528000, 21, 18
C-270, 543000, 35, 42
C-271, 271000, 18, 23
C-272, 515000, 26, 10
C-273, 1772000, 32, 46
C-274, 422000, 12, 9
C-275, 257000, 18, 25
C-276, 193000, 48, 19
C-277, 466000, 13, 8
C-278, 964000, 37, 24
C-279, 433000, 12, 4
C-280, 502000, 26, 123
C-281, 4117000, 12, 14
C-282, 191000, 15, 19
C-283, 144000, 17, 17
C-284, 487000, 16, 13
C-285, 313000, 35, 19
C-286, 637000, 32, 67
C-287, 1160000, 32, 11
C-288, 525000, 23, 8
C-289, 319000, 48, 22
C-290, 607000, 35, 27
C-291, 588000, 25, 14
C-292, 351000, 12, 13
C-293, 227000, 30, 95
C-294, 694000, 29, 31
C-295, 318000, 22, 39
C-296, 136000, 30, 33
C-297, 702000, 31, 18
C-298, 238000, 18, 9
C-299, 234000, 28, 35
C-300, 680000, 25, 7
C-301, 187000, 25, 11
C-302, 323000, 18, 5
C-303, 156000, 17, 11
C-304, 96000, 22, 41
C-305, 491000, 43, 24
C-306, 1528000, 67, 83
C-307, 172000, 17, 7
C-308, 1071000, 12, 6
C-309, 982000, 18, 9
C-310, 1456000, 14, 17
C-311, 144000, 17, 7
C-312, 209000, 26, 122
C-313, 1652000, 13, 67
C-314, 360000, 28, 44
C-315, 374000, 31, 22
C-316, 714000, 45, 81
C-317, 655000, 52, 45
C-318, 231000, 35, 21
C-319, 313000, 65, 83
C-320, 673000, 16, 8
C-321, 484000, 24, 61
C-322, 198000, 23, 109
C-323, 1200000, 26, 8
C-324, 818000, 35, 13
C-325, 287000, 18, 8
C-326, 233000, 49, 240
C-327, 875000, 40, 48
C-328, 44000, 25, 32
C-329, 421000, 27, 17
C-330, 225000, 13, 10
C-331, 209000, 6, 4
C-332, 848000, 20, 7
C-333, 506000, 25, 22
C-334, 5993000, 24, 11
C-335, 318000, 12, 12
C-336, 538000, 17, 9
C-337, 110000, 51, 179
C-338, 960000, 30, 25
C-339, 228000, 29, 15
C-340, 474000, 18, 6
C-341, 1247000, 31, 37
C-342, 1127000, 40, 33
C-343, 607000, 31, 25
C-344, 1233000, 17, 12
C-345, 263000, 24, 12
C-346, 170000, 14, 2
C-347, 100000, 18, 9
C-348, 645000, 28, 132
C-349, 2284000, 16, 51
C-350, 292000, 19, 39
C-351, 395000, 43, 206
C-352, 294000, 19, 13
C-353, 604000, 31, 47
C-354, 76000, 18, 8
C-355, 841000, 12, 8
C-356, 1029000, 21, 17
C-357, 212000, 18, 17
C-358, 158000, 8, 11
C-359, 177000, 12, 11
C-360, 639000, 17, 84
C-361, 1427000, 44, 74
C-362, 159000, 16, 4
C-363, 97000, 21, 21
C-364, 426000, 29, 41
C-365, 493000, 24, 12
C-366, 732000, 18, 12
C-367, 208000, 49, 33
C-368, 747000, 41, 16
C-369, 1037000, 6, 5
C-370, 89000, 34, 14
C-371, 295000, 28, 23
C-372, 667000, 34, 33
C-373, 764000, 22, 28
C-374, 233000, 32, 46
C-375, 67000, 55, 48
C-376, 189000, 49, 45
C-377, 106000, 51, 32
C-378, 237000, 36, 24
C-379, 955000, 33, 37
C-380, 214000, 34, 36
C-381, 407000, 12, 11
C-382, 127000, 65, 45
C-383, 869000, 24, 29
C-384, 214000, 25, 10
C-385, 147000, 22, 12
C-386, 2010000, 27, 21
C-387, 507000, 7, 9
C-388, 693000, 24, 9
C-389, 62000, 11, 4
C-390, 1348000, 13, 58
C-391, 1753000, 8, 8
C-392, 331000, 9, 10
C-393, 285000, 28, 45
C-394, 221000, 17, 64
C-395, 982000, 20, 7
C-396, 91000, 19, 12
C-397, 500000, 12, 67
C-398, 2242000, 15, 6
C-399, 421000, 11, 8
C-400, 2193000, 18, 9

En riesgo cuando pasan más de X veces su intervalo: 2.0 Perdido después de (días)

activos

para vigilar

en riesgo

perdidos

Descargar en Excel Hoja «Clientes en riesgo», con prompts para adaptarlo con IA. Sin registro.

La lista para esta semana

Ordenada por venta anual: primero a quien más te cuesta perder.

Qué hacer con la lista

Una llamada, no un correo

Que la haga quien lleva la cuenta y pregunte qué cambió: precio, servicio o un competidor.

Cada lunes, no cada trimestre

Si te enteras en el cierre, ya se fue.

Cruza con lo que cambiaste

Si subiste precio o cambiaste de ruta hace poco, revisa si esos clientes aparecen aquí.

Ejemplo simulado: distribuidora industrial, 400 clientes. Para vigilar: más de 1.5 veces su intervalo.