PDA Database Developed to Synchronize Field Sales & Marketing TeamsOne 2 One Mobile Puts PDA Forms to Work in the Field
by Frank Yacano, Director of Business Development, SYWARE, Inc.
One of the keys to an effective sales effort is a well-coordinated flow of information between sales personnel in the field and the marketing department at headquarters. The field team needs the latest presentations and current information about products and pricing. Headquarters needs feedback from the field to ensure that its marketing programs are working effectively, and to make necessary adjustments. When the process is working smoothly, the prompt two-way flow of information leads to a steady increase in sales effectiveness and the ability to land new business. Unfortunately, the reality is often less satisfactory, with paper-based processes leading to inefficiencies and delays at both ends.
One to One Mobile (www.t-mobile.co.uk), one of the largest mobile phone companies in the UK, with over 8 million subscribers making more than 200 million calls each week, needed to face this issue head-on. To differentiate itself in a fiercely competitive marketplace where several major companies battle for market share, One to One turned to Zync Solutions (www.zync-solutions.com), a UK integrator and hosting provider. Zync worked with One to One to create a special application that automates the two-way flow of information between sales force PDA databases and the internal Intranet-based marketing database.
One to One's field sales staff now uses PDA databases to capture customer survey data, which is uploaded each night to a central database and published immediately on an Intranet web page for analysis by marketing management. The PDAs also store and display the company's complete 300-page sales presentation, which is updated automatically during the nightly synchronization. This means One 2 One now has field survey data available for analysis the same day - rather than weeks later - while the field sales force has up-to-date presentations and product information. In addition, by eliminating the costs related to distributing paper presentations and duplicate data entry work, the automated solution paid for itself after only three months of operation.
Visiting 6000 Outlets Monthly
During the day, consultants typically visit 10-15 stores, conducting presentations and gathering survey information. When they get home in the evening, they synchronize their PDA databases with a central marketing server - the only administrative task required using the new system. During synchronization, the field survey data is uploaded into a master database for analysis and reporting, while the latest presentation material is downloaded to the PDA. The synchronization can take place over a modem or wirelessly via the infrared port on a mobile phone.
Power Tool for PDA Database Development
"Visual CE allows us to create and modify forms faster than any other product," notes Ian Fisk, Managing Director, Zync Solutions. "It was also something we could use without getting a programmer involved." Fisk had considered using Visual Basic for building forms, but determined that the coding required would have taken too long and cost too much.
Database forms can be created and maintained either on the PDA device or on a desktop computer. This flexibility allows forms to be created and updated on a central office system and then automatically deployed to PDAs in the field during synchronization. "If One 2 One wants a question changed or a complete new form created, we can write it once and deploy it to all PDAs out there," adds Fisk.
Zync Solutions used Visual CE to create an eight-page form that allows salespeople to capture all field information of interest to marketing management, while using a variety of clever techniques to avoid unnecessary keying. On the initial page, the user can enter a store ID or customer name and Visual CE automatically fills in details such as the complete address, phone number, and contact name. The remaining pages allow the salesperson to record details about One 2 One products sold, utilization of shelf and window space, condition of displays, and other information that indicates the effectiveness of marketing campaigns. Drop down lists allows choices to be selected by point and click rather than losing time writing the answers.
Comprehensive Reporting with Current Data
Fisk also sees particular advantages in the new Visual CE Version 6.0. The latest version allows different forms to be associated with individual stores, since not all questions are applicable for each store. When the user enters the store address, Visual CE automatically presents the correct series of forms that is appropriate for that store. The latest version also validates information as it is entered, keeping track of details that could easily elude manual entry. For example, if percentages for estimated share of window space don't add up to a hundred, Visual CE displays a flag on the user's screen.
Zync evaluated three PDA devices before settling on the Vadem Clio. Requirements included a large screen for viewing presentations, as well as keyboard and touch screen input. A Windows CE platform was needed for the added database functionality compared to Palm products, along with the familiar Windows environment.
Streamlined Processes for Users and Developers
"Based on the results at One 2 One, quite a few companies have asked us to engage in similar outsourcing projects," Fisk adds. "Visual CE will make our task much easier as we pursue these new opportunities. The speed of the process is phenomenal - we can develop and deploy a new form in minutes."
Have a SMB Question?
Call a SYWARE implementation expert at 617-497-1300 or
click here to email us.