Airline Loyalty Program Project: Was the Campaign worth it?

Objectives

1. What impact did the campaign have on booked flights during summer 2018?
2. Was the campaign adoption more successful for certain demographics of loyalty members?
3. Develop a detailed page of top 20 loyal customers based on their lifetime value

Insights

• What impact did the campaign have on booked flights during summer 2018?

The campaign had a negative effect on booked flights during summer 2018 because cancellation of loyalty program increased after the campaign.

• Was the campaign adoption more successful for certain demographics of loyalty members?

No, the campaign was not successful for certain demographics of loyalty members as the above screenshots show that loyalty program cancellation increased after campaign in Ontario, British Columbia, Quebec.

• Develop a detailed page of top 20 loyal customers based on their lifetime value

The above show that Customer with loyalty number 615459 has the highest lifetime value. He is male, stays in H2Y 4R4, Montreal, Quebec, Canada. He is married and holds a Bachelor degree and Star loyalty card.