Using this spreadsheet, https://docs.google.com/spreadsheets/d/1M80LDEqemHQyPtBliqzPTEzj7gZ0CW5_-w1Ls2fVcVM/edit?usp=sharing. Complete the below task. Thanks Customer Data Suppose that in order to gain
Fantastic news! We've Found the answer you've been seeking!
Question:
Using this spreadsheet,
https://docs.google.com/spreadsheets/d/1M80LDEqemHQyPtBliqzPTEzj7gZ0CW5_-w1Ls2fVcVM/edit?usp=sharing. Complete the below task. Thanks
Transcribed Image Text:
Customer Data Suppose that in order to gain customer insights and develop a data-driven marketing strategy, a major retailer had recently conducted a large-scale customer survey on spending habits and integrated the survey results with internal customer transaction data. You will mine this data for insights that can be translated into actionable and defensible marketing recommendations. You will first analyze the data at three different levels: transaction, customer, and segment. Then, you will use your segmentation analysis to create what-if scenarios enabling you to forecast the expected results of different marketing actions. These forecasts will lead to a data-driven recommendation regarding which, if either, of two marketing campaigns would be expected to yield a higher return on investment. Background The survey was administered online throughout June 2020 and invitations were sent to 10,000 customers who provided an e-mail address when signing up for the store's membership card. As an incentive, customers who completed the survey were offered the chance to win one of five $500 gift cards from the retailer. The response rate was approximately 15%. The survey included two questions that are pertinent to this analysis. First, consumers were asked to recall the total amount of money they had spent at the retailer's store during the previous month. Second, consumers were asked to recall the total amount of money they had spent in the category overall during the previous month, including at stores of competing retailers. Survey results were validated by comparing customers' self-reported spending to their actual transaction data where the customer's membership card was scanned. Cases in which self- reported monthly spend differed from actual monthly spend by more than 5% were eliminated from the dataset. Records with missing or erroneous data in either the survey results or the transaction data were also removed from the dataset during the coding and cleaning process. This resulted in usable survey data from 1,057 customers. The dataset you have been provided contains information regarding 12,145 transactions made by these 1,057 customers during a five-year period (the retailer's fiscal year begins July 1 and ends June 30 of each year). Survey results were appended to this data and are indicated by the prefix "S_" in the variable name. Below is a description of each variable in the dataset, together with the range of valid values in parentheses: TransID: Unique identification number for each transaction (AA00AA00-ZZ99ZZ99) PurchDate: Date of purchase (1-Jul-2015 through 30-Jun-2020) PurchAmount: Purchase amount [in USD] CardID: Unique identification number for each customer membership card (00000000- 99999999) CardDate: Date the customer membership card application was processed (1-Jul-2015 through 31-May-2020) S_Date: Date the survey was completed (1-Jun-2020 through 30-Jun-2020) S_RetSpend: Customers' self-reported spend with the retailer during May 2020 [in USD] 1 Customer Data Suppose that in order to gain customer insights and develop a data-driven marketing strategy, a major retailer had recently conducted a large-scale customer survey on spending habits and integrated the survey results with internal customer transaction data. You will mine this data for insights that can be translated into actionable and defensible marketing recommendations. You will first analyze the data at three different levels: transaction, customer, and segment. Then, you will use your segmentation analysis to create what-if scenarios enabling you to forecast the expected results of different marketing actions. These forecasts will lead to a data-driven recommendation regarding which, if either, of two marketing campaigns would be expected to yield a higher return on investment. Background The survey was administered online throughout June 2020 and invitations were sent to 10,000 customers who provided an e-mail address when signing up for the store's membership card. As an incentive, customers who completed the survey were offered the chance to win one of five $500 gift cards from the retailer. The response rate was approximately 15%. The survey included two questions that are pertinent to this analysis. First, consumers were asked to recall the total amount of money they had spent at the retailer's store during the previous month. Second, consumers were asked to recall the total amount of money they had spent in the category overall during the previous month, including at stores of competing retailers. Survey results were validated by comparing customers' self-reported spending to their actual transaction data where the customer's membership card was scanned. Cases in which self- reported monthly spend differed from actual monthly spend by more than 5% were eliminated from the dataset. Records with missing or erroneous data in either the survey results or the transaction data were also removed from the dataset during the coding and cleaning process. This resulted in usable survey data from 1,057 customers. The dataset you have been provided contains information regarding 12,145 transactions made by these 1,057 customers during a five-year period (the retailer's fiscal year begins July 1 and ends June 30 of each year). Survey results were appended to this data and are indicated by the prefix "S_" in the variable name. Below is a description of each variable in the dataset, together with the range of valid values in parentheses: TransID: Unique identification number for each transaction (AA00AA00-ZZ99ZZ99) PurchDate: Date of purchase (1-Jul-2015 through 30-Jun-2020) PurchAmount: Purchase amount [in USD] CardID: Unique identification number for each customer membership card (00000000- 99999999) CardDate: Date the customer membership card application was processed (1-Jul-2015 through 31-May-2020) S_Date: Date the survey was completed (1-Jun-2020 through 30-Jun-2020) S_RetSpend: Customers' self-reported spend with the retailer during May 2020 [in USD] 1
Expert Answer:
Related Book For
Posted Date:
Students also viewed these finance questions
-
Subject : Strategic Management in a Global Environment Safaricom: Innovative Telecom Solutions to Empower Kenyans As the largest mobile provider in Kenya, Safaricom has touched the lives of Kenyans...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Under special case ll in the Routh Hurwitz, we replace the zero row with* Coefficients of the derivative of the auxiliary equation Coefficients of the auxiliary equation Arbitrary small numbers Roots...
-
Bienvenu Enterprises reported cost of goods sold for 2019 of $1,400,000 and retained earnings of $5,200,000 at December 31, 2019. Bienvenu later discovered that its ending inventories at December 31,...
-
Multinational corporations face stiff competition in the carbonated drink category (also known as soda or pop, depending on where you live). Data were collected on the 2015 U.S. market share of...
-
In a contract dispute between a US company and a Canadian company, the contract itself referred to provisions of the Uniform Commercial Code. Do these references alone preempt the contract from being...
-
The Newburg Flyers operate a major sports franchise from a building in downtown Newburg. The building was built in 1940 at a cost of $5,000,000 and is fully depreciated so that it is shown on the...
-
Scenario 1: Joey is a 15 year old who is ready to work, but his parents want him to have more responsibility with money first. His parents have already set up checking and savings accounts for him at...
-
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $ 8,000 Accounts receivable 20,000 Inventory 36,000...
-
Antidifferentiate using the table of integrals. You may need to transform the integrand first. COS (2) dr =
-
A sample of 100 steel-belted radial tires yields a mean life of 35,000 miles with a sample standard deviation of 4,000 miles. Construct a 90 % confidence interval for the mean life of steel-belted...
-
Since Uber officially launched online taxi reservation in San Francisco in October 2010, many ride-hailing companies have emerged in China, such as Didi Chuxing (hereafter Didi), Kuaidi, Yidao...
-
A poll is conducted to predict whether new municipal bonds should be issued. Assume that 230 out of 500 interviewees voted for issuance of the new bonds. How precise is this prediction? Construct a...
-
Suppose a sample of 500 companies listed on the NYSE is found to contain 327 companies paying dividends that have increased over the last year. Construct a 95 % confidence interval for the mean...
-
Suppose there is a sample of 30 items drawn from a normal population. Find the probability that the sample variance exceeds 36.6869.
-
Maendeleo Ltd. is a manufacturing company operating through a number of branches in Kenya. The following information relates to Maendeleo Ltd.s operations for the year ending 31 December 2020. Sh 000...
-
Digital Fruit is financed solely by common stock and has outstanding 25 million shares with a market price of $10 a share. It now announces that it intends to issue $160 million of debt and to use...
-
Consider again the bet in Example 21.3. Suppose the bet is S $106.184 if the price is above $106.184, and $106.184 S if the price is below $106.184. What is the value of this bet to each party? Why?
-
You own one 45-strike call with 180 days to expiration. Compute and graph the 1-day holding period profit if you delta- and gamma-hedge this position using a 40-strike call with 180 days to...
-
Suppose the S&P 500 futures price is 1000, = 30%, r = 5%, = 5%, T = 1, and n = 3. a. What are the prices of European calls and puts for K = $1000? Why do you find the prices to be equal? b. What...
-
There is another possible explanation for purchased goodwill appearing in a sole proprietor's statement of financial position. What do you think it might be?
-
Why do the assets need to be revalued in these cases? The business has not been sold.
-
The shown partners have always shared profits and losses in the ratio: Holt 4; Stott 2: Young 1. From 1 January the assets were to be revalued as the profit sharing ratios are to be altered soon. The...
Study smarter with the SolutionInn App