logo

360 Private Travel: Database Performance Optimization & Mobile App

Query times reduced from 20 seconds to milliseconds
360 Private Travel

360 Private Travel is a luxury travel company offering the very best in personal service with a passion for quality.

After impressive growth, its tech stack was no longer fit for purpose:

  • Database queries were taking anywhere from 2 to 20 seconds to complete
  • Data quality was poor
  • Third party data sources could not be integrated
  • Content updates required developer intervention, creating bottlenecks
  • Agents lacked visual tools to present itineraries to clients
  • Business insights were difficult to extract from data

The net result was that 360 Private Travel's 523 agents could not access the wealth of information the business had gathered over the years and was slowed down in their day-to-day work.

Performance comparison chart showing query times improvement

Our Approach

Database Infrastructure & AI-Powered Search

We introduced a modern Google Cloud managed Postgres database that could:

  • Easily handle current workloads
  • Scale to handle future workloads

It is available via API, which allows various parts of the business to interact with it, ensuring proper permission handling and a single source of truth throughout the business.

Google Cloud Postgres database and API integration architecture

We introduced a lightning fast free-text search powered by ElasticSearch and ChatGPT. It allows agents to look for things like "family friendly resorts in the Maldives" and get every relevant piece of information available in the business - including a list of the resorts, the key contacts at the resorts, customer and staff reviews, write-ups from colleagues that have visited, past itineraries and even relevant sections of the company-wide chat history. The search functionality delivers results in just 200ms, making 8,032 documents instantly accessible to travel agents.

Mobile & Web Application

We released a mobile application within 4 weeks of project launch which allowed agents to access this wealth of information in structured or unstructured search. The app was simultaneously deployed to both Android and Apple app stores, ensuring all agents had immediate access regardless of their device preference. New features have been released on a daily basis since launch. The same codebase powers a web-app so that features are immediately available for desktop use as well.

Mobile app screenshots showing iOS and Android interfaces

Content Management System Integration

To eliminate bottlenecks in content updates, we integrated Strapi headless CMS with both web and mobile applications. This empowered head office staff to independently create and manage complex destination information and property details without technical assistance. Content updates now appear instantly across all platforms, achieving a 90% reduction in developer involvement for content updates and a 72% faster publishing time.

Strapi CMS interface showing content management

Interactive Map Creation Tool

We built and integrated a custom Google Maps solution that allows agents to create and edit interactive travel maps during client consultations. Leveraging Google Maps API, Places API, and custom styling, the system enables quick creation of visually appealing itineraries with flights, destinations, and points of interest. This achieved a 95% reduction in map creation time, from minutes to seconds.

Custom map creation interface showing interactive travel itinerary

External Data Integration

We incorporated 6 external data sources to give agents an even more complete picture of what is available throughout the world to incorporate into their clients' luxury holidays. The database optimization achieved an 84% reduction in average query time, transforming query performance from 2-20 seconds down to milliseconds.

Business Intelligence & Analytics

We created a comprehensive suite of Looker reports that provide real-time insights across the entire business. These dashboards track sales performance, member statistics, booking trends, flight request analytics, conversion rates, agent productivity, and revenue forecasting. The automated reporting system saves countless hours previously spent on manual data compilation and gives leadership immediate visibility into key business metrics, enabling data-driven decision making at every level.

Looker dashboard screenshots showing sales metrics and booking analytics

The Power of Integration

By seamlessly connecting multiple data sources and creating a unified platform, we've transformed how 360 Private Travel's agents access and utilize information. This integrated approach has significantly reduced query times, empowered agents with self-service tools, and improved the overall customer experience while giving leadership unprecedented visibility into business performance.


The Impact

  • 84% reduction in average query time
  • 8,032 documents made accessible with 200ms search
  • 6 external data sources integrated
  • 4 weeks to Android + iOS app launch
  • 90% reduction in developer involvement for content updates
  • 72% faster content publishing time
  • 95% reduction in map creation time
  • Hundreds of hours saved monthly on manual reporting

360 Private Travel remains one of our biggest and closest clients. Our partnership continues to evolve with ongoing work and regular feature additions, ensuring their platform stays at the cutting edge of luxury travel technology.

""The team are great, they are smart and really personable, they pick up concepts really quickly (which saves SO much time) and have a huge depth in tech ability and know how.

The quality of all the work seen to date is of a high standard, I am loving this partnership and looking forward to collaborating on more in the year to come.

I am certain that working with Wakeflow will mean we have a platform for growth for the long term!""

Katie Robertson
Digital Product & Technology Director
phonebooth

Let's fix your tech problem

If you tell us about it, we can fix it

Go on, get in the booth