STORES Magazine - June 2008 - (Page 70)

NUTS AND BOLTS / SUPPLY CHAIN Directory Assistance Call-routing system has Radiator Express hitting on all cylinders BY LEN LEWIS t may not be the sexiest thing in retailing, but the selling of car and truck radiators is proving to be one of the most recessionproof businesses in the country. I “It’s not one of those parts that you can wait to have repaired,” says Mike Carvalho, chief technology officer of Radiator Express. With customer service now a key differentiator in sales and marketing, however, even the best economic conditions and escalating demand won’t make up for a phone system that allows customer orders to fall through the cracks. This was the scenario facing the Benicia, Calif.-based franchisor, which has been successfully serving the radiator and auto parts market for nearly 25 years. The company’s rapid growth in sales resulted in an expanding network, which now consists of 220 franchisees across the country. But growth also put a severe strain on call data capacity. “Basically, we distribute products from 70 STORES / JUNE 2008 Routing solution Qwest, the company’s carrier, The closer a call is to a border between suggested that Radiator Express infranchises, the more scrutiny it receives, vestigate a solution offered by with the system asking more questions so AdGeo, a St. Louis-based company that the call can be routed properly. specializing in call routing, tracking continued to exand reporting and data mining systems. It pand. As recently as did, and the switch to AdGeo was fully January 2007, “we integrated in June 2007. were doing our own “There were some issues to work phone systems in through, such as misconfigurations on house using a prodthe initial set-up which impacted routuct provided to us ing of some calls,” Carvalho says. “But by MCI,” Carvalho the AdGeo team did everything they says. But area codes could to make the switchover as painless and ZIP codes don’t as possible. It was basically a matter of necessarily corredeveloping standard operating proceWWW.STORES.ORG the manufacturers to our customers, who are made up of automotive body shops, parts stores and dealerships,” Carvalho says. “They are the ones that order through our toll-free numbers, and we can usually deliver to them within two hours.” While the company has a growing retail component generated through its website and online auctions, the bulk of Radiator Express’s sales come via the telephone. “When calls come into our toll-free lines they are routed to franchisees,” Carvalho says. The territories and boundaries of each franchisee are determined by ZIP code. This system became one of the company’s biggest challenges as its network spond neatly to one another. “The result was that in large metro areas like Chicago we had franchisees whose borders came together or overlapped and who sometimes shared area codes,” he says. Consequently, the number of calls going to the incorrect franchisee was increasing. “The problem was simply a lack of accuracy,” says Brian McNichols, network manager for Radiator Express. At that point, the company was receiving about 11,000 calls per day through its main toll-free number and about 75 secondary lines (the secondary numbers align with advertisements for ROI tracking purposes). Identifying incoming calls by area code and prefix “was about as granular as we could get,” McNichols says. “The downside was that the same area code and prefix combination could exist in two different ZIP codes with different franchisees. We basically had to default one way or another.” Radiator Express then created “exception tables” that would automatically route calls when a specific number came up. “The problem was with our large wholesale customers,” McNichols says. “Every time they added a new telephone number or moved or changed a number, it became an exception. The situation became even more complex with the addition of new franchises. http://WWW.STORES.ORG

Table of Contents for the Digital Edition of STORES Magazine - June 2008

STORES Magazine - June 2008
Contents
Executive Editor's Page
President's Page
Tesco Tests Carbon Labels
What Shoppers Think
10 Things You May Have Missed
Numbers Worth Counting
Full Price/Markdown
Retail People
Cover Story: Boom - or Bust
Green Retailing
Concept2Watch
Online Marketing
Building Traffic
Water Management
Branding
Digital Marketing
Loyalty Programs
Special Report: Taking on Teens
Supply Chain - Robo Crop
Human Resources
Supply Chain - Directory Assistance
Loeb Retail Letter
ARTS Update
Point of View
NRF News
Retail Crossword
Retail Industry Calendar
Last Laugh

STORES Magazine - June 2008

http://www.nxtbook.com/nxtbooks/nrf/STORES2019_tuesday
http://www.nxtbook.com/nxtbooks/nrf/STORES2019_monday
http://www.nxtbook.com/nxtbooks/nrf/STORES2019_sunday
http://www.nxtbook.com/nxtbooks/nrf/STORES2019_preview
http://www.nxtbook.com/nxtbooks/nrf/STORES_bigshowdaily20180116
http://www.nxtbook.com/nxtbooks/nrf/STORES_bigshowdaily20180115
http://www.nxtbook.com/nxtbooks/nrf/STORES_bigshowdaily20180114
http://www.nxtbook.com/nxtbooks/nrf/STORES2018_preview
http://www.nxtbook.com/nxtbooks/nrfe/STORES0415
http://www.nxtbook.com/nxtbooks/nrfe/STORES0315
http://www.nxtbook.com/nxtbooks/nrfe/STORES0215
http://www.nxtbook.com/nxtbooks/nrfe/STORES0115
http://www.nxtbook.com/nxtbooks/nrfe/STORES1214
http://www.nxtbook.com/nxtbooks/nrfe/STORES1114
http://www.nxtbook.com/nxtbooks/nrfe/STORES1014
http://www.nxtbook.com/nxtbooks/nrfe/STORES0914
http://www.nxtbook.com/nxtbooks/nrfe/STORES0814
http://www.nxtbook.com/nxtbooks/nrfe/STORES0714
http://www.nxtbook.com/nxtbooks/nrfe/STORES0614
http://www.nxtbook.com/nxtbooks/nrfe/STORES0514
http://www.nxtbook.com/nxtbooks/nrfe/STORES_sourcebook2014
http://www.nxtbook.com/nxtbooks/nrfe/STORES0414
http://www.nxtbook.com/nxtbooks/nrfe/STORES0314
http://www.nxtbook.com/nxtbooks/nrfe/STORES0214
http://www.nxtbook.com/nxtbooks/nrfe/STORES0114
http://www.nxtbook.com/nxtbooks/nrfe/STORES1213
http://www.nxtbook.com/nxtbooks/nrfe/STORES1113_buyersguide
http://www.nxtbook.com/nxtbooks/nrfe/STORES1113
http://www.nxtbook.com/nxtbooks/nrfe/STORES1013
http://www.nxtbook.com/nxtbooks/nrfe/STORES_mediakit2014
http://www.nxtbook.com/nxtbooks/nrfe/STORES0913
http://www.nxtbook.com/nxtbooks/nrfe/STORES0813
http://www.nxtbook.com/nxtbooks/nrfe/STORES0713
http://www.nxtbook.com/nxtbooks/nrfe/STORES0613
http://www.nxtbook.com/nxtbooks/nrfe/STORES0513
http://www.nxtbook.com/nxtbooks/nrfe/STORES0413
http://www.nxtbook.com/nxtbooks/nrfe/STORES0313
http://www.nxtbook.com/nxtbooks/nrfe/STORES0213
http://www.nxtbook.com/nxtbooks/nrfe/STORES2013_20130115
http://www.nxtbook.com/nxtbooks/nrfe/STORES2013_20130113
http://www.nxtbook.com/nxtbooks/nrfe/STORES2013_20130114
http://www.nxtbook.com/nxtbooks/nrfe/STORES2013_preview
http://www.nxtbook.com/nxtbooks/nrfe/STORES0113
http://www.nxtbook.com/nxtbooks/nrfe/STORES1212
http://www.nxtbook.com/nxtbooks/nrfe/STORES1112
http://www.nxtbook.com/nxtbooks/nrfe/STORES1012
http://www.nxtbook.com/nxtbooks/nrfe/STORES_mediakit2013
http://www.nxtbook.com/nxtbooks/nrfe/STORES0912
http://www.nxtbook.com/nxtbooks/nrfe/STORES0812
http://www.nxtbook.com/nxtbooks/nrfe/STORES0712
http://www.nxtbook.com/nxtbooks/nrfe/STORES0612
http://www.nxtbook.com/nxtbooks/nrfe/STORES0512
http://www.nxtbook.com/nxtbooks/nrfe/STORES0412
http://www.nxtbook.com/nxtbooks/nrfe/STORES0312
http://www.nxtbook.com/nxtbooks/nrfe/STORES0212
http://www.nxtbook.com/nxtbooks/nrfe/STORES2012_preview
http://www.nxtbook.com/nxtbooks/nrfe/STORES0112
http://www.nxtbook.com/nxtbooks/nrfe/STORES1211
http://www.nxtbook.com/nxtbooks/nrfe/STORES1111
http://www.nxtbook.com/nxtbooks/nrfe/STORES1011
http://www.nxtbook.com/nxtbooks/nrfe/STORES_mediakit2012
http://www.nxtbook.com/nxtbooks/nrfe/STORES0911
http://www.nxtbook.com/nxtbooks/nrfe/STORES0811
http://www.nxtbook.com/nxtbooks/nrfe/STORES0711
http://www.nxtbook.com/nxtbooks/nrfe/STORES0611
http://www.nxtbook.com/nxtbooks/nrfe/STORES0511
http://www.nxtbook.com/nxtbooks/nrfe/STORES0411
http://www.nxtbook.com/nxtbooks/nrfe/STORES0311_v2
http://www.nxtbook.com/nxtbooks/nrfe/STORES0311
http://www.nxtbook.com/nxtbooks/nrfe/STORES0211
http://www.nxtbook.com/nxtbooks/nrfe/STORES0111
http://www.nxtbook.com/nxtbooks/nrfe/stores1210
http://www.nxtbook.com/nxtbooks/nrfe/stores_mediakit2011
http://www.nxtbook.com/nxtbooks/nrfe/stores1110
http://www.nxtbook.com/nxtbooks/nrfe/stores1010
http://www.nxtbook.com/nxtbooks/nrfe/stores0910
http://www.nxtbook.com/nxtbooks/nrfe/stores0810
http://www.nxtbook.com/nxtbooks/nrfe/stores0710
http://www.nxtbook.com/nxtbooks/nrfe/stores0610
http://www.nxtbook.com/nxtbooks/nrfe/stores0510
http://www.nxtbook.com/nxtbooks/nrfe/stores0410
http://www.nxtbook.com/nxtbooks/nrfe/stores0310
http://www.nxtbook.com/nxtbooks/nrfe/stores0210
http://www.nxtbook.com/nxtbooks/nrfe/store_bigshow2010_post
http://www.nxtbook.com/nxtbooks/nrfe/stores_bigshow_20100112
http://www.nxtbook.com/nxtbooks/nrfe/stores_bigshow_20100111
http://www.nxtbook.com/nxtbooks/nrfe/stores_bigshow_20100110
http://www.nxtbook.com/nxtbooks/nrfe/stores0110
http://www.nxtbook.com/nxtbooks/nrfe/store_bigshowpreview2010
http://www.nxtbook.com/nxtbooks/nrfe/stores1209
http://www.nxtbook.com/nxtbooks/nrfe/stores1109
http://www.nxtbook.com/nxtbooks/nrfe/stores1009
http://www.nxtbook.com/nxtbooks/nrfe/stores0909
http://www.nxtbook.com/nxtbooks/nrfe/stores0809
http://www.nxtbook.com/nxtbooks/nrfe/stores0709
http://www.nxtbook.com/nxtbooks/nrfe/stores0609
http://www.nxtbook.com/nxtbooks/nrfe/stores0509
http://www.nxtbook.com/nxtbooks/nrfe/stores0409
http://www.nxtbook.com/nxtbooks/nrfe/stores0309
http://www.nxtbook.com/nxtbooks/nrfe/stores0209
http://www.nxtbook.com/nxtbooks/nrfe/stores0109
http://www.nxtbook.com/nxtbooks/nrfe/stores1208
http://www.nxtbook.com/nxtbooks/nrfe/stores1108
http://www.nxtbook.com/nxtbooks/nrfe/stores1008
http://www.nxtbook.com/nxtbooks/nrfe/stores0908
http://www.nxtbook.com/nxtbooks/nrfe/stores0808
http://www.nxtbook.com/nxtbooks/nrfe/stores0708
http://www.nxtbook.com/nxtbooks/nrfe/stores0608
http://www.nxtbook.com/nxtbooks/nrfe/stores0508
http://www.nxtbook.com/nxtbooks/nrfe/stores0408
http://www.nxtbook.com/nxtbooks/nrfe/stores0308
http://www.nxtbook.com/nxtbooks/nrfe/stores0208
http://www.nxtbook.com/nxtbooks/nrfe/stores-globalretail08
http://www.nxtbook.com/nxtbooks/nrfe/stores0108
http://www.nxtbook.com/nxtbooks/nrfe/stores1207
http://www.nxtbook.com/nxtbooks/nrfe/stores1107
http://www.nxtbook.com/nxtbooks/nrfe/stores1007
http://www.nxtbook.com/nxtbooks/nrfe/stores0907
http://www.nxtbook.com/nxtbooks/nrfe/stores0807
http://www.nxtbook.com/nxtbooks/nrfe/stores0707
http://www.nxtbook.com/nxtbooks/nrfe/stores0607
http://www.nxtbook.com/nxtbooks/nrfe/stores0507
http://www.nxtbook.com/nxtbooks/nrfe/stores0407
http://www.nxtbook.com/nxtbooks/nrfe/stores0307
http://www.nxtbook.com/nxtbooks/nrfe/stores0207
http://www.nxtbook.com/nxtbooks/nrfe/stores-globalretail07
http://www.nxtbook.com/nxtbooks/nrfe/stores0107
http://www.nxtbook.com/nxtbooks/nrfe/stores1206
http://www.nxtbook.com/nxtbooks/nrfe/stores1106
http://www.nxtbook.com/nxtbooks/nrfe/stores1006
http://www.nxtbook.com/nxtbooks/nrfe/stores0906
http://www.nxtbook.com/nxtbooks/nrfe/stores0806
http://www.nxtbook.com/nxtbooks/nrfe/stores0706
http://www.nxtbook.com/nxtbooks/nrfe/stores0606
http://www.nxtbook.com/nxtbooks/nrfe/stores0506
http://www.nxtbook.com/nxtbooks/nrfe/stores0406
http://www.nxtbook.com/nxtbooks/nrfe/stores0306
http://www.nxtbook.com/nxtbooks/nrfe/stores0206
http://www.nxtbook.com/nxtbooks/nrfe/stores0106-globalretail
http://www.nxtbook.com/nxtbooks/nrfe/stores0106
http://www.nxtbook.com/nxtbooks/nrfe/stores1205
http://www.nxtbook.com/nxtbooks/nrfe/stores1105
http://www.nxtbookMEDIA.com