Skip to content



Gathering customer dataBuilding and managing databases for CRM

To effectively use your gathered data for CRM you will need to be able to:
• Examine the database and make pre-campaign counts of records that fit segments and other criteria
• Specify each segment that is to be mailed, drawing from a selection of database fields. There may be a large number of such segments. There will then be a number of different messages or content versions, one of which will be applicable to each target:
A grid or hierarchy structure will be needed to organise this
It will need to be output in a form that will help sales staff to recruit the newsletter advertisers
• Extract campaign lists, with all the required database fields for each record, and send them to the email and mobile marketing system. Alternatively, the records may be sent to a direct mail house for a postal mailing. The database record should be automatically flagged whenever a record is extracted
• Specify the fulfilment rules – for example, if the recipient clicks on a particular link, they are automatically flagged with a specific interest code, or receive a specified next email
• Add other campaign information, such as costs and a return on investment calculation
• Handle customers who are newly acquired during a campaign, for example, fresh website registrants, or those enrolling for an event
• Feed research survey data (if not anonymous) from online questionnaires into the CRM database

Analysing the data and producing reports to steer strategy

At different times, three types of report will be needed: real-time reporting of campaigns, regular standard reports, and the ability to produce special reports. Standard report formats should be set up in advance by your CRM system supplier. These should enable your marketing users to carry out data analysis using an on-screen query builder that accesses the customer database. The system should allow the marketer to build up a report format from a menu of options. This should include the ability to receive cross-tabulated and matrix reports pulling on fields from the customer database.

You may want reports on:
• Database size, database growth, and proportion of records with key fields completed, shown as totals and by year-to-date, month-on-month, and year-on-year
• Views of the data at global level, by country of residence, region of residence, segment, or by other criteria
• Reports on data completeness – the number of records with valid values in high priority fields against your targets. Examples include enquiry contact method, enquiry campaign code, segment definition fields, interests, planned date of visit, and planned duration of visit
• Cross tabulation of interests versus segments
• Contact methods – the proportion of customer enquiries received via each channel
• Campaign response – the number of customer enquiries received in response to specific campaigns
• Actual bookings – the number and/or percentage of customer enquiries with valid values in key fields such as actual visit duration and actual visit date. This data may be available in your sales system
• Retail data – the volume, cost and types of products sold via your e-commerce system and merchandise shop, and dates
• Data quality:
Quality of address data against official national postal address files
Quality of customer profile data against business rules and/or lookup tables associated with each database field
• Generic requirements for standard reports may include:
• The option to present reports in a graphical or tabular view
• Automatic generation on preset dates or to preset time periods
• Easy viewing by marketing staff and senior management
• Automatic emailing to a defined list of users of links to the reports, at specified intervals

If yours is a large business, you may be asked to pass key data live to the company’s main executive dashboard. A dashboard is a real-time graphic display for managers of performance against main key Performance Indicators (KPIs) drawn from multiple databases across the organisation. The CRM database will be one of the most important contributors to the dashboard
Marketing staff will also need the ability to compile reports on an ad hoc basis to meet specific needs. These would draw on a selection of available key fields in the database, defined in advance with the database supplier.

You should discuss with the supplier the cost advantages of such a facility, and the processing and presentation facilities you might need, compared with paying for such reports as the need arises.

etourismfrontiers E-Tourism Frontiers Resources
Staying ahead of the game in the dynamic world of e-tourism can be a real challenge, especially for those of us in emerging markets. E-Tourism Frontiers aims to provide tourism and ICT professionals with the resources and guidance they need to succeed online. The material in this section is a general overview of the topics covered and resources provided in our training courses.

To gain full understanding and make maximum use of these resources, join on of our training seminars, which provide attendees with intensive hands training in online sales, marketing and management skills for both destinations and tourism companies. Our trainers are experienced professionals with extensive experience working in online tourism around the world, including first hand experience of working in emerging markets. We use live demonstrations of working websites and technologies and will give you the skills, resources and support to begin making changes to your business and use the web to improve your organization and business. For full information on our training seminars please see our training section.

The following is a basic overview of the topics that we cover, complete with more information and advice on each area:
What Does Social Media mean for Tourism?.
Online Travel Trends.
Social Networking and Travel.
Travel Social Networks.
New Technologies for Tourism.
Tourism eMarketing.
Destination Management.
Customer Relations Management (CRM).
Gathering Customer Data.
Email Marketing.
Website Design & Management.
Search Engine Optimization (SEO).
Web Content.
Content Management Systems.
Online Advertising.

E-Tourism Frontiers is a global programme to develop online tourism in emerging markets around the world.
Our aim is to open the developing world’s tourism trade to the world of online travel distribution and marketing- a sector in which the region has been left far behind- with very little inventory available to the online travel shopper. This situation threatens the sustainability and diversity of Tourism and the communities and environment that it supports.
We hold pro-active business driven conference events and training seminars featuring leading online tourism companies, experts and trainers- as well as regional road-shows targeting the travel trade, destination managers and National and regional tourism offices in all emerging markets, including the Middle East, Asia, Latin America, Eastern Europe and Scandinavia.

The success of our events speaks for itself and is changing the way both the public and private sector do business, manage their resources and market themselves globally, and creating new business relationships with leading international players and technology providers. We work with a range of major international sponsors to be sure that these events are of the highest international standards, as well as accessible and affordable to the complete spectrum of tourism players, including Small to Medium Enterprise (SMEs), Community and Eco-Tourism projects.
Our sponsor partners to date have included major global brands includingMicrosoft, VISA, Safaricom, Vodacom and Coca-Cola and many more together with regional tourism and ICT authorities. Our events have been attended and opened by Ministers and Vice Presidents- and attended by a diverse range of tourism players, from Multinational CEOs to University tourism students.

This article is quoted from E-TOURISM FRONTIERS.

The article is uploaded by Majbritt Magnussen, administrator on ‘Views On Tourism’. Please join the online Views On Tourism network and discussion group in order to achieve personal goals as well as encourage a sustainable tourism development in Bangladesh and South Asia. Read more about this group and how to become a member here.

Be Sociable, Share!

Posted in Africa, Americas, Asia, Asia Pacific, BRIC, Caribbean, Central America, Customer opinions, East Asia, Education and qualification, Europe, IT, Market knowledge, Middle East, N11, North Africa, North America, Northeast Asia, Oceania, Performance and management, Sale and marketing, South America, South Asia, Sub Saharan.

Tagged with , , , , , .

0 Responses

Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.

Some HTML is OK

or, reply to this post via trackback.