Sandaya has experienced a rapid growth over the past seven years. The increase of campsites and visitors caused an increase in the vast amount of data. Managing all this data became a real challenge as was the ability for marketers and analysts to have quick and clear insights.
The information was stored in several different applications. In order to analyse these data, it had to be moved from different sources (some of them on-premise) into a spreadsheet and from there back to an analysing tool. This took days. Also, the tools Sandaya worked with were not suitable for the travel business, which made it hard to have the exact insights they wanted.
Sandaya was looking for an automated and easy-to-use dashboard that would provide insight into trends of their campsite portfolio. They needed to swiftly sort, filter and compare data by their specified travel characteristics such as arrival date, country origin, type of accommodation, region, campsite and other types of dimensions and metrics. They also needed the solution to be cloud-based to save on internal infrastructure maintenance costs and make it easier for them to upscale at a fast tempo.
Crystalloids created a custom solution for Sandaya, based on InsightOS - the easy-to-use application built with Google App Engine and Google BigQuery, which helps travel companies use data to improve their revenue. InsightOS makes it possible to easily store, analyse and process the data, and has a function to save certain views, graphs or tables and share them with colleagues.
Within the travel industry, the difference between the moment of arrival and the time of booking are two separate time units. Therefore, two different kinds of InsightOS viewer applications were created - the arrival and the booking viewer.
The Arrival Viewer
The InsightOS arrival viewer provides the view of the arrival date of their customers. It is easy to link all Sandaya’s different data sets such as customer, media and sales to the moment of arrival. Via facet navigation it is easy to select future or past arrival dates. The resulting answers are presented in a clear graph or table format, making it possible for marketers and analysts to have more complete insights in their customers' behaviour.
The Booking Viewer
The InsightOS booking viewer allows Sandaya to link different kinds of datasets such as destination, customer, sales and media channel to the date when customer makes a booking. A calendar element allows to select one or multiple booking dates which is handy when comparing past and present periods. The InsightOS platform also allows to save the selection for future retrieval.