|
|
| |
National Pest Control Company Data Repository
|
| |
Problem:
|
| |
A prominent National Pest Control company desired to establish a cost effective nation wide database marketing capability. Previous attempts were unsuccessful, largely due to the fact that the company's transaction and customer data resided on multiple systems in multiple formats. Critical marketing initiatives requiring data were in jeopardy of failure.
|
|
|
| |
Solution:
|
| |
The services of Doner Direct were secured to resolve the problem. After analyzing various database-marketing vendors, Doner recommended The Electron Factory (TEF). The decision was based on TEF's demonstrated ability to quickly, accurately and costs effectively manage its client's databases.
|
|
| |
The first critical initiative was the re-pricing of the pest company's customer base. Historical data was required to solve this initiative.
|
|
| |
Within three weeks, TEF:- Met with key members of the marketing and operations departments to prioritize data issues.
- Loaded 150 million customer, service, and billing detail records.
- Generated cross tab and custom reports on the entire file to ensure data hygiene.
- Completed an in-depth pricing analysis within 10 days.
|
|
| |
Currently:
|
|
| |
TEF is contracted to provide data warehousing for all of the client's data. Monthly customer, billing, service, claims, leads and vendor files are forwarded to TEF for load, analysis and audit. Monthly audit and marketing reports are delivered within 72 hours of receipt of files.
|
|
| |
TEF produces mail and telemarketing files, ad hoc requests (extracts, reports), and response and operational reports for tracking trends, profitability and analysis.
|
|
| |
TEF maintains the client's Promotional History Database, and appends data from external sources as needed to enhance the customer file.
|
|
| |
Result:
|
| |
With the TEF provided solution, the client's critical marketing initiatives were completed. Additionally TEF was able to produce information necessary for a national regulatory agency. For the cost of one senior programmer, the client's information marketing needs will be met for the coming year.
|
|
|