DES Computer Services
Products & ServicesThe DES DifferenceCase HistoriesDES Client PortalSupportLinksJobsAbout DES Computer ServicesContact us

CASE HISTORIES

IT Solutions that Deliver Results - The DES Difference
Case Histories > Database Design & Development > Major HGV Manufacturer
CompanyMajor HGV Manufacturer
SummaryCRM - Marketing Database Development and Management
Background & Requirements
Major manufacturer of HGVs wanted to develop their relationship with their customer base by setting up a complex relational CRM database, requiring the following:
  • Details of numerous contacts at each address.
  • Detailed vehicle information to be stored against each address.
  • Marketing contact information recorded against every individual.
  • Responses to campaigns logged and acknowledged.
Relational database developed in Access.
Data from various sources combined and enhanced with PAF then deduplicated. Where more than one contact identified at a site, linked to one address record – 85,000 contacts at 50,000 sites with 40,000 vehicle delivery details.
Dealer assigned either by purchase history or by regional matching through active postcode lookup.
Targeted data files created through dynamic selection process.
Communications history maintained against each personal contact.
All responses to communications categorised, flagged, responded to appropriately (letter acknowledgement etc.) assigned Dealers notified of responses so could follow up.
Report suite written for client to assess on-going campaign analyses and database statistics.
Following delivery of a new truck, Customer Satisfaction questionnaires are mailed and non responders followed up by telephone. Responses are recorded and summarised for dealer follow up.
Regional events booked and monitored with Dealer notification of contact details of prospective and actual attendees.
Database used to coordinate sales lead generation and sales lead management as well as supporting regional events, product launches, open days etc
Contact Us



Home / Products & Services - The DES Difference - Case Histories - DES Client Portal - Support - Links - Jobs - About us - Contact us

DES Computer Services is part of the DES Media GroupDES Group
© 1989 - 2009, DES Computer Services Ltd