Pens and Printers faces the challenge of optimizing its sales strategy by identifying the most effective communication methods to drive customer engagement and revenue. The analysis of sales data shows that the Email method is the most efficient, generating 53% of total revenue and engaging 50% of customers, while the Call method lags with only 17% revenue contribution. The Email + Call method has shown growth potential, with the highest revenue per customer (RPC) at $183.63. To address this, the company should prioritize Email marketing, reduce resources allocated to Call strategies, and regularly monitor the RPC metric to adjust strategies based on emerging trends.
Business Task Hi, Really hoping you could help me out with some analysis. This is quite short notice but I have a meeting with the executive team to update them on sales approaches for the new product line so I need this information as soon as possible.
We need to know:
How many customers were there for each approach? What does the spread of the revenue look like overall? And for each method? Was there any difference in revenue over time for each of the methods? Based on the data, which method would you recommend we continue to use? Some of these methods take more time from the team so they may not be the best for us to use if the results are similar. We don’t really know if there are other differences between the customers in each group, so anything you can tell us would be really helpful to give some context to what went well.
Written Report Your written report should include written text summaries and graphics of the following:
Describe validation and cleaning steps for every column in the data
Two different types of graphic showing single variables only At least one graphic showing two or more variables Description of your findings
How should the business monitor what they want to achieve? Estimate the initial value(s) for the metric based on the current data?
Presentation You will give an overview presentation to the sales rep who requested the work. The presentation should include: ● An overview of the project and business goals ● A summary of the work you undertook and how this addresses the problem ● Your key findings including the metric to monitor and current estimation ● Your recommendations to the business