Booking service increases revenue
through optimization of advertising costs

3
91

Objective

Thousands of customers use this service to book flights and hotels every day. Some of them generate more revenue and make bookings more often, some seldom make purchases, others do not place orders at all. The main business objective was to break the paying audience down by their buying characteristics, then identify the most valuable customers and develop different strategies to boost sales in each segment.

Solution

OWOX recommended that they perform RFM and LTV analysis based on the CRM data in Google BigQuery.

CRM data was first processed in Google BigQuery to determine R (recency), F (frequency), M (monetary) value and LTV segment ID for each user. During the RFM analysis users of each segment were divided into three different groups (1 — the most valuable users, 3 — the least valuable users), which resulted in 27 different groups. In LTV analysis users were divided into five segments (1 — being customers who bring in the most revenue, 5 — being customers who bring in the least revenue).

The second step was to upload the data from Google BigQuery to Google Analytics. The following algorithm was applied:

  1. Use Google BigQuery Reports Add-on to export data from Google BigQuery to Google Sheets.
  2. Create user scope dimensions in Google Analytics.
  3. Create data sets in the User Data Import section in Google Analytics.
  4. Use Data Import and Google Sheets Data Upload Add-on to import data into Google Analytics.

The third step was to create and visualize reports in Google Sheets, using the BigQuery Reports Add-on.

The final step was to analyze reports to determine which sources & mediums return the most valuable customers.

Results

  1. Determined which traffic sources bring in the most valuable customers.
  2. Optimized costs.
  3. Increased the average order value and ROI.

You might also like

    Trusted by

    Online Tours

    Professional Team!

    We are grateful for the efficient cooperation with OWOX. Particularly I would like to acknowledge their active involvement during the implementation process and while configuring the analytics platform for our needs: setting up Google Tag Manager, enabling the latest Google Analytics functions for our account, integration with Google BigQuery. Now we can better understand customers acquisition, behaviour and ways to improve ROI and revenue with OWOX Business Intelligence tools.