Can a Travel Agency Know Why it Doesn’t Get Confirmed Requests?

Let’s find out using a travel agency dataset

Omar Mohy El Din
3 min readOct 17, 2020

It is quite frustrating for a travel agency to find that only 33% of the total client's requests are getting confirmed, based on the sales communication.

Let’s ask some questions using the data we have and try to help them!

1. What are the top nationalities that get confirmed requests or makes requests in general?

Here we can see the top 10 nationalities that are the country of origin of clients who make travel requests and their confirmations.

We can see that clients from the United States make requests the most while around only 35% of total requests are confirmed.

Clients from Egypt and Australia do not make many requests however, nearly 50% of requests are confirmed.

Clients from Brazil and India do not usually confirm their requests.

2. Do people like to travel in groups or alone and does it affect client confirmation?

Below we can see that most people like to travel in groups.

And here below we can see the confirmed requests given that they are travelling alone (value 0 in below) or in groups (value 1 in below).

We can see that when travelling alone it is more likely to confirm your request than travelling in groups.

3. Does price affect clients' confirmation?

Here we can see a heat map of the relation between prices and confirmed requests.

A very negligible negative relation between confirmed cases and prices, which could imply given this dataset no relation is found between them. This is actually counter-intuitive.

4. Does the duration of stay affect the client’s confirmation?

Here we can see the duration of stay that clients like to book and their number of confirmed cases.

We can see that most people like to book for a travel duration for one week or two weeks. However, only half of them confirm their requests in both durations.

Clients that book for three weeks are more likely to confirm their requests.

Clients that book for more than three weeks do not confirm their requests at all.

Conclusion

In this article, we took a look at what could affect clients confirmation for their booking requests, according to a travel agency data.

  1. The sales and marketing team should target clients from Egypt and Australia and increase their reputation as these clients are with most proportions of confirmed requests.
  2. It is more likely to confirm when travel alone than in groups, so the sales and marketing team should target them more to increase their requests.
  3. Prices don’t show an effect on the client’s confirmation. But, since most of the prices in the data were missing I couldn’t find a direct relation. So actually, there could be one.
  4. The sales and marketing team should make more discounts and offers for any trip duration that is around three weeks, as it is likely to get a confirmed request but it needs to encourage more clients first to book for that period.

Can You Help this Travel Agency with More Questions and Insights?

To see more about this analysis, see the link to my Github available here.

--

--