Project Description

Data merging and email list management system

This luxury hotel group, with several properties around the world, needed a solution that would take the data gathered from all the guest activity, whether it is a hotel stay, a day on the golf course or a meal at one of their restaurants, and combine it for use in generating targeted email marketing lists.

With two different systems used internally for hotel bookings and a variety of different systems used for activities, restaurant reservations and more, in formats as varied as Fox Pro, MS SQL and CSV exports, merging and deduping all this data was an arduous task. The system we developed in FileMaker Pro combines all this data weekly in a process that takes several hours.

Working with Linear Blue has been a real pleasure and an interesting experience, their technical capabilities and speed of design has been a real eye opener, especially for a non technical person such as myself. Their enthusiasm to produce effective, intuitive and easy to use solutions enabled us to work seamlessly and efficiently with the new solution! – Project Lead, Luxury Hotel Group

The combined data is then available for the marketing department to perform some sophisticated demographic and behavioural targeting to produce lists to send highly customised email to. These lists are deduped once more and integrated with their email marketing provider’s system; with the kind of VIP clients this hotel group has, emailing them multiple times is unacceptable.