Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Dataset Used: ATTRIBUTED-DATA-STUDENT.xlsx' . Data Description: Major retailer has secured data on the purchase paths of its new and returning customers. The client is interested

Dataset Used: ATTRIBUTED-DATA-STUDENT.xlsx' .

Data Description: Major retailer has secured data on the purchase paths of its new and returning customers. The client is interested in understanding more about the effectiveness of individual marketing channels wants to analyze attribution data to inform marketing investment decisions. The retailer is aware of different attribution models and wants to examine the variability in decision outcomes due to the model utilized recognizing that some models are superior. Purpose: Understand how to utilize attribution data to interpret how each marketing channel supports the conversion funnel and how to subsequently make marketing investment decisions.

Deliverable: A power-point presentation that addresses the retailer's decision problem. Instead of an "executive summary," prepare a "Dashboard" with key insights that logically points to decision options.

Specific SPSS/Excel Procedures Used: Descriptives, Examine, Transform, Split-File, Pivot tables, Lookup Tables, If commands, etc. Key issues to be included in the analysis as follows. You may include additional analysis to develop a more insightful DASHBOARD. Interpret each analysis you include.

1. Develop descriptive data about patterns in the data such as: (a) marketing channels commonly used by new/returning customers, (b) average order revenue by new/returning customers, and (c) purchase path lengths by new/returning customers.

2. Compare the orders and revenue generated by different marketing channels under different attribution models (i.e., First Click, Last Click, Position, and Time Decay). The weights for different models are in the "LOOK_UP" tab. Evaluate channels also by computing revenue/order.

3. Marketing investment by channel is provided in the "INVESTMENT" tab. Using these investments as "costs," what is the return for each channel based on revenue generated.

4. Estimate purchase latency for new and returning customers. What metric would be appropriate for representing latency in the DASHBOARD

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Cost Accounting

Authors: William Lanen, Shannon Anderson, Michael Maher

5th edition

978-1259728877, 1259728870, 978-1259565403

More Books

Students also viewed these Mathematics questions

Question

9-1 Describe the performance appraisal process.

Answered: 1 week ago

Question

9-4 List steps to take in the appraisal interview.

Answered: 1 week ago