IB9JB0 Marketing & Strategy Analytics Term One, 2023-2024
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit
IB9JB0
Marketing & Strategy Analytics
Term One, 2023-2024
[100%] [Individual Assignment]
[3,000] words:
This is a strict limit not a guideline: any piece submitted with more words than the limit will result in the excess not being marked
Question 1 (50 points):
Imagine you are part of the marketing team for a restaurant called ‘TastyBites.’ TastyBites is eager to expand its customer base by attracting new customers from a variety of platforms, including Facebook, TikTok, Instagram, Google, and X. Given the competitive nature of the restaurant industry and the desire to make the most of this opportunity, the restaurant’s
management is considering two distinct approaches for this expansion:
1. Voucher-Inclusive Advertising: In this approach, TastyBites will run advertising campaigns on various platforms that promote the restaurant and provide vouchers to new customers who engage with the ads. These vouchers may include discounts, free items, or other
incentives to encourage participation.
2. Standard Advertising: The alternative approach focuses on standard advertising without including vouchers. TastyBites will run ad campaigns on the selected platforms to attract new customers, but these promotions will not offer any vouchers.
A. Do consumers in the Voucher-Inclusive Advertising approach generate more profit (compared to the Standard Advertising approach)? (Explain) (15 points)
B. How should platforms be ranked for future Voucher-Inclusive Advertising approach (based on the profit from the first order of the new customers)? (15 points)
To assist in the evaluation (for parts A and B), you have access to campaign results data from the different platforms, containing information about the acquired customers
(‘TastyBites_A.csv’). Using the ‘TastyBites_A.csv’ dataset, run a linear model that helps you address the CEO’s questions in parts A and B.
Variable Name |
Description |
id |
ID of the customers |
basket_size |
number of items in the first order |
basket_value |
profit realized from the first order (excluding the voucher amount) |
target |
= 1 if the customer was in the Voucher-Inclusive Advertising approach and = 0 otherwise |
platform |
the platform that the customers saw the ad: = 1: ‘ Facebook’ = 2: ‘TikTok’ = 3: ‘ Instagram’ = 4: ‘Google’ = 5: ‘X’ |
device |
the device type of the customers |
voucher_value |
value of the voucher |
time_engagement |
time of daywhen the customers engaged with the ad |
In addition to answering the questions raised by the CEO, you conducted additional analysis to investigate:
C. Did the Voucher-Inclusive Advertising approach generate more long-term profit than the Standard Advertising approach? (Explain) (10 points).
To investigate the question posed in part C, you calculated a new variable representing the expected long-term profitability of each customer (variable ‘LTP’). All this data is accessible from the ‘TastyBites_B.csv’ dataset.
Finally, for parts A and B, or C, discuss:
D. If you had the opportunity to collect more data, what would be the three most important variables/information you would want to know from the customers? (Explain; 10 points).
Notes that you should consider in your answer:
• Include your R code and its respective results in your solution.
• Make sure you clearly explain, justify, and detail all the assumptions and steps in
your solution. These might include data cleaning (e.g., dropping variable(s), observation(s), changing type of variable(s), etc.) or any other assumptions or steps.
• Carefully and completely interpret your results (including all your coefficients).
• Critically evaluate the implications (based on all your results) for TastyBites. Make sure that you use specific and concrete examples in your solution.
• The only part NOT counted in your word limit is your output from the RStudio’s
console. Everything else (e.g., your code, tables, and words in your figures) counts.
• Your answer (including arguments, discussions, recommendations, etc.) must be realistic, coherent, and logical.
Question 2 (25 points):
Imagine you are the driving force behind an Electric Vehicle (EV) manufacturing company. You have initiated a survey to gain deeper insights into consumer preferences and their willingness to pay for specific EV features.
In this pursuit, you have access to the 'Taste_EV.csv'dataset, which contains the following variables:
Variable Name |
Description |
ID |
participant ID |
seats |
number of the seats in the EV |
SUV |
categorized as ‘Yes’ for SUV and ‘ No’ otherwise |
acceleration |
0-60 mph in seconds |
price |
price of the EV |
warranty |
warranty duration (in years) |
speed_US |
topspeed of the EV in km/h |
T_speed_UK |
topspeed of the EV in mph |
Based on the structure and the information in the dataset (i.e., ‘Taste_EV.csv’ file), your task is as follows:
A. Find the correlation between ‘T_speed_UK’ and ‘ price’ and interpret the results. Find and interpret the correlation between ‘T_speed_UK’ and ‘speed_US’ (5 points).
B. Suggest a tree-based model that allows you to understand what EV features affect the consumers’ willingness to pay (i.e., ‘price’). Apply your suggested method (using R) and explain your results (15 points).
C. Evaluate the model’s performance developed in B (note that you are not required to split your dataset into train and test; 5 points).
Notes that you should consider in your answer:
• Include your R code and its respective results in your solution.
• Make sure you clearly explain, justify, and detail all the assumptions and steps in your solution. These might include data cleaning (e.g., dropping variable(s), observation(s), changing type of variable(s), etc.) or any other assumptions or steps.
• Carefully and completely interpret your results.
• Critically evaluate the implications (based on all your results). Make sure that you use specific and concrete examples in your solution.
• The only part NOT counted in your word limit is your output from the RStudio’s console. Everything else (e.g., your code, tables, and words in your figures) counts.
Question 3 (25 points):
Suppose you are the digital marketing manager for ane-commerce website. You have a
dataset with information about your customers’ website visits, including the number of
pages visited, time spent on the site, the product categories they viewed, and more (see the table below). Your goal is to:
A. Identify (and target) different customer segments into meaningful clusters in which individuals within a cluster are similar but different from those individuals in other clusters. After clustering, discuss and provide a marketing strategy for each resulting cluster to maximize the effectiveness of your marketing efforts (15 points) .
To this end, you put together a dataset (i.e., ‘FashionVisitorsInsights.csv’) including the following list of variables:
Variable Name |
Description |
|
ID |
ID of the customer |
|
age |
age of the customer |
|
page_visit |
average number of pages visited during a visit |
|
male |
indicating whether the customer is male (= ‘yes’) or other (= ‘no’) |
|
device |
preferred device for browsing (1 for mobile and 0 for desktop) |
|
referral |
the number of other customers that the focal customer referred |
|
product_cat |
average number of product categories visited during a visit |
|
time_spent |
average time spent (in seconds) on the website during a visit |
B. If you were to perform separate clustering for males and others, would you expect the clustering results to be significantly different or similar? Justify your answer based on the dataset (10 points).
Notes that you should consider in your answer:
• Based on the structure and the information in the dataset, apply your suggested method using R. Include your R code and its respective results in your solution.
• Make sure you clearly explain, justify, and detail all the assumptions and steps in your solution. These might include data cleaning (e.g., dropping variable(s), observation(s), changing type of variable(s), etc.), your decision (and justification why!) on the number of clusters, or any other assumptions or steps.
• Carefully and completely interpret your results. Your answer should cover but not be limited to explaining why the final solution is appropriate, describing the
characteristics of the clusters, and discussing managerial implications.
• Critically evaluate the implications (based on your results). Make sure that you use specific and concrete examples in your solution.
• The only part NOT counted in your word limit is your output from the RStudio’s
console. Everything else (e.g., your code, tables, and words in your figures) counts.
SUBMISSION DEADLINE: 12:00 (UK time) Thursday 4th January 2024
|
Word Count Policy and Formatting(found in your Masters Student Handbook Section 6.2c) The only part NOT counted in your word limit is your output from the RStudio’s console. Everything else (e.g., your code, tables, and words in your figures) counts. Guidelines for Online Submission(found in your Masters Student Handbook Section 6.2e) |
The submission deadline is precise and uploading of the document must be completed before 20.00 (UK time) on the submission date. Any document submitted even seconds later than 20.00 precisely will be penalised for late submission in line with WBS policy. Please consult your student handbook on my.wbs for more detailed information.
The online assignment submission system will only accept documents in portable documents format (PDF) files. Please note that we will not accept PDF files of scanned documents. You should create your assignment in your chosen package (for example, Word), then convert it straight to PDF before uploading. Please place your student ID number, NOT YOUR NAME, on the front of your submission as all submissions are marked anonymously.
All the scripts should also have the following paragraph included on the front page:
PLEASE ENSURE YOU KEEP A SECURITY COPY OF YOUR ASSESSMENT
Your Academic Writing and Avoiding Plagiarism Module on my.wbs has lots of useful information on structuring assignments, academic style and demonstrating critical engagement.
Please ensure that any work submitted by you for assessment has been correctly referenced as WBS expects all students to demonstrate the highest standards of academic integrity at all times and treats all cases of poor academic practice and suspected plagiarism very seriously. You can find information on these matters on my.wbs, in your student handbook and on the University's library webpageshere.
The University's Regulation 11 clarifies that '…'cheating' means an attempt to benefit oneself or another by deceit or fraud. This includes reproducing one's own work…' It is important to note that it is not permissible to re-use work which has already been submitted by you for credit either at WBS or at another institution (unless you have been explicitly told that you can do so). This is considered self-plagiarism and could result in significant mark reductions.
Upon submission of assignments, students will be asked to agree to one of the following declarations:
Individual work submissions:
By agreeing to these declarations (when the message pops upon submission) you are acknowledging that you have understood the rules about plagiarism and self-plagiarism and have taken all possible steps to ensure that your work complies with the requirements of WBS and the University.
You should only indicate your agreement with the relevant statement, once you have satisfied yourself that you have fully understood its implications. If you are in any doubt, you must consult with the Module
Organiser or Named Internal Examiner of the relevant module, because, once you have indicated your agreement, it will not be possible to later claim that you were unaware of these requirements in the event that your work is subsequently found to be problematic in respect to suspected plagiarism or self - plagiarism.
2024-01-09