Analyst at Fresh Direct

For this assignment, you will demonstrate your developing understanding of analytics that might be used within a marketing analytics function. Remember: each of the frameworks that you are learning in this course is just one lens in an organization. That means you will also need to think about how this data lives at the intersection of the marketing department and the finance department.

Below, imagine you are an analyst at Fresh Direct and as a result of your terrific work in the past, both the Chief Financial Officer (CFO) and Chief Operating Officer (COO) of the organization need you to help them with separate, but related projects. Each person has asked you to author a one-page memo (two memos, so two pages total) to answer the question they have using your new skills with customer segmentation. You will also need to submit a third brief response (300 words) to the CEO.

In addition to what will be covered in the live session, please review this material as well (Links to an external site.). lynda.com/Business-Skills-tutorials/Customer-Segmentation/379411-2.html

FreshDirect is an online-only grocery home delivery service. Begin this assignment by reading this brief outline of the services and background provided by FreshDirect. This presentation also contains some important information about how FreshDirect classifies its loyal customers that might be helpful for this assignment.

• FreshDirect Background Information

Then, consider this dataset. For this assignment, you are given a complete set of data with descriptions (a true luxury!). After you have reviewed this data, consider the questions from the CFO and COO. Recall that you will need to submit a one-page memo to each. A third question from the CEO follows. 

• FreshDirect Data Set and Descriptions

1. Question from CFO: Our sales are down and we need to make more money! I am willing to invest in marketing campaigns with a couple of targeted customer populations, but am not sure how many customer segments and/or which customer segments I should select to provide the best chance at increasing our sales. Which customer segments should we select and why?
2. Question from the COO: We have a limited number of deliveries that we can make each day and I would like to understand where we should be focusing our efforts by better understanding our customers. For example, if there are certain areas in our delivery zone where a lot of our customers are located, perhaps we could come up with new delivery techniques to increase our capacity for deliveries in those zones without a lot of investment. Can you help me better understand how our customers are segmented geographically so that we can better utilize our delivery infrastructure?
3. Finally, the CEO has heard that you are doing some great work and would like a summary of the analytics you are putting together for the CFO and COO.  Please provide in 300 words a brief summary of your analysis and key findings for the CEO.

Assessment

This assignment is assessed based on your ability to describe the analytics that are used to understand the customer journey and sales funnel. This includes considering and justifying how your market segmentation should be considered and how marketing effectiveness can be assessed. You will also be assessed based on the clarity and brevity of your work. You should submit three memos that are appropriately written for the audience and that demonstrate your ability to communicate about analytics to others inside of the organization. Lastly, remember that this is not a frameworks course; though you are welcome to practice analytical techniques on this data, you are not required to as part of this assignment and you will not need to in order to answer the questions above. 

Submission

Remember that you need to submit three memos as part of this assignment - (1) memo for the CFO, (1) memo for the COO, and (1) memo for the CEO. You should submit these assignments as a single file but please be sure to clearly note to which question you are responding. You should also submit your Excel workpapers that contain your technical analysis for reference.

Rubric

APANPS5100 Assignment 2 RubricAPANPS5100 Assignment 2 RubricCriteriaRatingsPtsThis criterion is linked to a Learning OutcomeCFO Memo40.0 to >35.0 ptsExcellent (A)There is a clear and concise overview of an innovative and potentially impactful recommendation. Informative, creative and correct customer segmentation analysis findings used to support recommendation. Assumptions and projections are appropriately detailed and clearly contextualized. They are both creative and logical.35.0 to >25.0 ptsGood (B)There is a clear and concise overview of a recommendation. Correct customer segmentation analysis findings used to support recommendation. Assumptions and projections are appropriately detailed and clearly contextualized. They are both creative and logical.25.0 to >10.0 ptsFair (C)There is an overview of a recommendation. Customer segmentation analysis findings used to support recommendation. Assumptions and projections are overly detailed but clearly contextualized.10.0 to >0 ptsPoor (D-F)Limited or no recommendation. Customer segmentation analysis findings incorrect or unrelated to recommendation. Assumptions and projections are not detailed or described.40.0 pts
This criterion is linked to a Learning OutcomeCOO Memo40.0 to >35.0 ptsExcellent (A)There is a clear and concise overview of an innovative and potentially impactful recommendation. Informative, creative and correct customer segmentation analysis findings used to support recommendation. Assumptions and projections are appropriately detailed and clearly contextualized. They are both creative and logical.35.0 to >25.0 ptsGood (B)There is a clear and concise overview of a recommendation. Correct customer segmentation analysis findings used to support recommendation. Assumptions and projections are appropriately detailed and clearly contextualized. They are both creative and logical.25.0 to >10.0 ptsFair (C)There is an overview of a recommendation. Customer segmentation analysis findings used to support recommendation. Assumptions and projections are overly detailed but clearly contextualized.10.0 to >0 ptsPoor (D-F)Limited or no recommendation. Customer segmentation analysis findings incorrect or not related to recommendation. Assumptions and projections are not detailed or described.40.0 pts
This criterion is linked to a Learning OutcomeCEO Memo20.0 to >18.0 ptsExcellent (A)There is a clear and concise overview of an innovative and potentially impactful recommendation. Summary of customer segmentation analysis clear and contextualized. Summary of assumptions and projections is appropriately detailed and clearly contextualized.18.0 to >13.0 ptsGood (B)There is a clear and concise overview of recommendations. Summary of customer segmentation analysis provided. Summary of assumptions and projections is detailed and contextualized.13.0 to >5.0 ptsFair (C)There is an overview of recommendations. Summary of customer segmentation analysis provided. Summary of assumptions and projections is insufficiently or overly detailed but contextualized.5.0 to >0 ptsPoor (D-F)Limited description of recommendation provided. Summary of customer segmentation analysis not provided. Summary of assumptions and projections is not detailed or contextualized.20.0 pts
Total Points: 100.0