CLICK HERE for FULL Delta Airlines Marketing Campaign Post Pandemic Codes

This project is fully coded in R.The number of domestic flights taken in the United States have decreased significantly in the past year due to a pandemic. 2020 has not been kind to airlines, as they are facing severe financial damage, averaging a $84.3 billion loss this year alone. This study analyzes Delta airlines and how different applied marketing campaign strategies can impact future ticket revenue. We will select 800 individuals for both the e-mail marketing campaign and website marketing campaign, ultimately dividing them evenly into a treatment group and control group (400 subjects in each group). These individuals either purchased a Delta airlines ticket within the past year, or are currently looking for flights online. We will also compare the conversion rate of these two channels and figure out whether one is more successful than the other. The results revealed that the coupon marketing strategy will conclusively increase customer conversion rates. The conversion rate of one channel will be higher than the other and we should use this strategy to attract more customers and increase ticket sales. The analysis results associated with the research questions and two scenarios are provided in the report.

As travel restrictions and quarantine orders were implemented, the demand for air travel has significantly declined over the past year. The number of domestic flights taken in the United States has notably decreased due to COVID-19. Airline industries are facing severe financial damage, averaging a $84.3 billion loss this year alone. With various protocols and blueprints to recovery, there is a compelling need for a sustainable approach to push for safety, cooperation, and normalcy so that the aviation industry can get back on track.

The aviation industry is essential for global business, generating substantial economic growth, providing countless jobs, and ultimately facilitating international trade and tourism. In this study, we will focus on Delta airlines, a major airline of the United States and a legacy carrier. The rise of challenges in the face of crisis is nothing new to Delta and the broader travel sector, as it has overcome past pandemics, recessions, and other devastating events. There have been some diverse attempts at engaging past and new air travel customers, but these campaigning efforts have yet to have any significant effect on turnout. By October 2020, 43 commercial airlines had gone bankrupt and this list still continues to grow. It is in the best interest of Delta airlines to launch successful marketing campaigns in order to increase ticket revenue after the impact of Covid-19.

The first research question is about if e-mail advertising can effectively achieve the airline’s goal which is to improve the conversion rate on airline tickets. For this research question, my null hypothesis is that the conversion rate of coupons delivered by email is almost the same as the conversion rate of PSA delivered by email. And the alternative hypothesis is that the conversion rate of coupons delivered by email is higher than that of PSA delivered by email.

The second research question is about if website advertising can effectively improve the conversion rate on airline tickets. For this research question, my null hypothesis is that the conversion rate of coupon advertising on websites is almost the same as the conversion rate of PSA on websites. And the alternative hypothesis is that the conversion rate of coupon advertising on websites is higher than the conversion rate of PSA on websites.

The third research question is about if the conversion efficiency of the two advertising methods is the same. For this research question, my null hypothesis is that the conversion rate of coupon advertising delivered by email is almost the same as the conversion rate of coupon advertising on websites. And the alternative hypothesis is that the conversion rate of coupon advertising delivered by email is not the same as the conversion rate of coupon advertising on websites.

Air transport represents a critical share of GDP and is closely linked to the activities of many other economic sectors. It not only relates to airports and aircraft manufacturing but also to tourism and other business events. However, the dramatic drop in demand for air transport due to the COVID-19 pandemic is threatening the viability of many firms in the air transport sector, especially the airline industry. To be specific, the change in the behavior of passengers following the COVID-19 crisis and travel restrictions have caused a significant decrease in demand for airline services. Countless jobs, international trades, and other substantial global or domestic business events facilitated by the airline industry are at stake.

As the airline industry is a key enabler of many economic activities, there is an urgent need for airline companies to get back on track and financially recover as soon as possible. Our study utilized a data analytics approach to gain a better understanding of passengers’ behaviors and called for a focused program to study on the passengers’ data. Then we analyzed the data we collected and make strategic plans for airline companies to minimize the detrimental cost and increase revenue after the pandemic. We chose Delta Air Lines, a leader in domestic and international travel based in Atlanta, U.S. as our object of study. The study focused on how different applied marketing strategies can impact ticket revenue.

The findings of this study will contribute to the benefit of the whole airline industry considering that efficient and successful marketing campaigns can help airline companies to make up for a loss after the direct impact of COVID-19. The outcome of this study will directly benefit Delta airlines. It can also be used as a forward guidance for many other airline companies to follow, leading to a speedy recovery from the pandemic.

1. The population of Interest: This study intends to focus on Delta Airlines and how different applied marketing strategies can impact ticket revenue. To improve airline ticket conversion rates, we need to focus on Delta’s past customers including both frequent and one-time ticket purchasers, as well as potential customers that have recently looked for flight tickets online.

In order to test the conversion rate of email, our population of interest is going to be the company’s past customers (both frequent and one-time flyers) because we have access to their email from the purchase history. As for the website conversion, our main target is potential customers who visit flight-ticket booking websites. We intend to narrow down the potential customer pool by filtering flight-ticket booking websites and posting discounts and deals on these sites.

 

2. Sample Selection: Since we want to compare the difference between two marketing channels, we will set up two groups. The first group will be for treatment while the other is for control. For the treatment group, we will distribute the same amount of coupons on the website, and for the control group, we will email our past customers with the same number of coupons.

In this study and in our email selection, we will only include customers who purchased Delta airline tickets within one year. Individuals who recently searched for information on ticket-booking websites have more interest in buying tickets. Taking this into consideration, it’s important for us to evaluate the best group to choose for a higher success rate.

In order to answer whether the conversion rate on coupon advertising and other PSA advertising is the same or not, we will also have control and treatment groups. Individuals who received coupon advertising are in the treatment group, while individuals receiving PSA advertising are in the control group. We will make sure that the two channels have the same number of treatment and control groups to ensure the validity of the test result. During this selection, we will use random sampling to randomize the PSA ads distribution.

3. Sample Size: According to our research problems, we have determined the population of interest and the sample selection. We also have to determine the sample size for these three types of research. The appropriate sample size is usually determined by three important criteria: the level of precision, the level of confidence or risk, and the degree of variability in the attributes being measured (Miaoulis & Michener, 1976). And we find from Glenn’s sample size table 1(Israel, 1992) that the sample is 400 when the population size is greater than 100,000 when we assume the level of precision is 5%, the level of confidence is 95%, and the degree of variability is 50% since this would provide the maximum sample size. Therefore, for each test group and control group in these comparative experiments, we decide to use 400 as our sample size and randomly select them from the research results. The statistical power could also be calculated according to pwr.t.test function. As the following results show, the statistical power will be 80.65%, 99.99%, and 100% if we assume the effect size is 0.2, 0.5, and 0.8.

4. Operational Procedures:
First, we randomly select 800 users for the email channel research and 800 users for the website channel research according to our sample size calculation.

Second, we will send emails and upload coupons when users browse the official Delta website to subjects in the email channel research and website channel research respectively. For the email channel experiment, we will randomly send emails to 800 users based on their previously submitted contact information. We will collect data pertaining to whether they were interested in the coupon given to them and monitor their decision in buying a ticket using the promotional link sent to them via email in 10 days. This is long enough for users to notice the email and much less than the interval between purchases of average people. For the website channel experiment, we will randomly display a coupon advertisement on ticket-booking web pages to 800 users when they browse these websites. We will also measure if they choose to buy a ticket on these websites in 10 days after coming across the advertisement.

Third, for each experiment, it would be very important to know the extent to which conversions can be attributed to the advertising campaign. Therefore, we have to provide evidence that the coupon does make a difference. We do so by randomly dividing these 800 users to form a control group and a test group, with 400 subjects in each group. For the email channel experiment, users in the control group will be sent a public service announcement (PSA) email, such as emails about wildfire prevention or global warming instead of an advertisement coupon email. As for the website channel experiment, users in the control group will also be shown the PSA instead of the advertisement in the exact same size and position on the page. By randomly selecting which user is in the control group and which user is exposed, we can then measure the difference of how impactful the coupons are. For these two studies, we will complete these operations within half a year instead of a shorter period of time. This is to prevent other confounding factors such as seasonal demand fluctuations or holidays from affecting the final research results.

Finally, for the third research question which compares the conversion rate of these two channels, we will use the results of the previous two experiments. Therefore, we don’t need to conduct extra operations.

5. Brief Schedule:

Phase I: Developing research questions and literature review (Plan on 1 week) In this phase we will find a managerial dilemma that is critical for our company and formulate the related research questions and hypotheses. After determining the research questions, we will also read articles in this field to understand the prevailing theories and previous results of similar researches.

Phase II: Research strategy design (Plan on 2 week) In this phase we should determine important experimental factors (such as the population of interest, sample size, and sample selection method) and operational procedures. This phase is actually very hard, and it can take a long time.

Phase III: Conducting the Study (Plan on 6 months) In this phase, we conduct experiments according to the planned procedures and record the data generated. We plan to conduct this project in a long period rather than a short one in order to avoid the impact of short-term abnormal fluctuations. At this stage, it is also easy to encounter technical problems or other operational problems such as data collection leading to delays in the schedule.

Phase IV: Data analysis (Plan on 2 weeks) In this phase, we will perform statistical analysis on the data obtained in the previous phase to determine whether the results meet the hypothesis we made earlier. In the process of analysis, the data we collected may be insufficient or it may be difficult to find a suitable statistical method for our analysis. These situations can also lead to delays.

Phase V: Writing the final research report (Plan on 1 week) In this phase, we will summarize the previous work and conclusions to complete a final research report. Enough time is also planned for revision and others’ feedback.

6. Data Collection and Data Security: There are two ways to collect our data in our study. As mentioned above, the email conversion rate will be collected from emails that we send out to our past customers. Website data will be collected from individuals who clicked a link from the official Delta website. Basically, rarely any detailed personal information will be needed in our data collection to conduct the study. Only the link conversion rate will be recorded in the research. In terms of charity advertising, we will also collect data for those who clicked from email and website.

In this study, we will not include any sensitive information about our customers and potential customers. Since the nature of our study only addresses conversion rates from two marketing channels, this study will not include customers’ names or their credit card information. In terms of website inclusion, our dataset will only store those who clicked our ads link, so there is no data exploitation to the website’s other users. In reference to our data, we will use numbers to identify each person who clicked the advertising link. All data collection and storage devices will be password protected and only limited members of the study team will have access to it. After we analyze our data, all the information will be secured, and we will not sell our data to other companies or individuals. This study will solely be considered as a suggestion for the company’s future marketing campaign.

Outcomes (Dependent Variables): The dependent variable for the first two experiments will be the conversion rate of each group. If a customer buys a ticket, the conversion condition will be 1 while the conversion rate will be 0 if the user doesn’t buy a ticket. The conversion rate of each group can be obtained by dividing the sum of the conversion conditions by the total number of users of this group. The dependent variable for the third research will be the conversion rate of each channel and it could be calculated based on previous research results.

Treatments (Independent Variables): For the email channel experiment, the independent variable will be whether a past customer is sent an email with a coupon or without a coupon. As for the website channel experiment, the independent variable will be whether a user will see the coupon or a PSA on the web page. Our main objective is to figure out if a coupon advertisement will affect the conversion rate of customers.

The variable will be true if the user receives the coupon email or sees the coupon on the web page. It will be false if the user receives an irrelevant email or sees a PSA on the official Delta website. For the third research question, the independent variable will be emailed for the email channel experiment and the website for the website channel experiment. We ultimately want to compare the conversion rate of these two channels.


STATISTICAL ANALYSIS PLAN:

For each one in the first two experiments, we need to compare whether the average conversion rate between the test group and the control group is the same. Since the variable conversion condition is 1 or 0, the mean value of the conversion condition is equal to the conversion rate. The two-sample t-test which allows us to compare the mean value of conversion condition (equals to the conversion rate) of two samples will be a suitable statistical method to analyze the first two questions.

For the third experiment, we need to compare if the average conversion rate between two different channels is the same. We could also use the two-sample t-test to figure out if the difference between the mean value of conversion condition (equals to the conversion rate) of email channel test group and that of the website channel group is a substantial difference or a result of sample selection.

Limitations and uncertainties: Given our research problem, we might have excluded other essential predictors from the study. Contributions to conversion rate is extremely broad but we only test the difference between two marketing channels. However, age, gender, education, income and so on also have an effect on the final conversion rate. Even within our sample group, varied attributions on each person might influence the results to a certain degree. For example, in our control group, website users may be on the younger side, having income levels that are average or below average. If this is the case, coupons and other promotional activities could be a lot more effective with this group.

Though random sample selection could alleviate this problem, the results might still include some bias. There is no certainty that a strong statistical result can guarantee the exact results of a real-world application. If we are able to collect more customer information from websites, such as gender or age, we could stratify our observed data based on these characteristics and test if these are relevant to the results of the study. Moreover, we do not specify the class, so we cannot conclude whether coupons on different classes will have an effect on the conversion rate. It is possible that people who normally choose a business class or first class might not be interested in using coupons.

If this is the case, we can choose to ignore how other marketing campaigns could have effects on this customer sector. However, it is impossible to know whether our potential customers would purchase an economy-class ticket or other-class ticket. If we want to test the effectiveness of other marketing methods, then we should only use past customers’ purchase information to test.