BACKGROUND WeWashUSleep is a laundry-pickup service startup with 140 locations spread across two US regions. Recently, the company opened more stores in ten new cities.
BUSINESS OBJECTIVE: The company wants to find out which of the ten newly opened stores will get the best return on marketing investment (ROMI) if more money is spent on marketing that store.
VARIABLES;
The dataset consists of the following variables;
- Store ID: A designated number to represent each store.
- City: The city in which a specific store is located.
- State: The state in which a specific store is located.
- Sales Region: The stores are in either US Region 1 or US Region 2.
- New Expansion: Whether a store is old or new, denoted by ‘Old’ or ‘New’.
- Marketing Spend: Amount of money spent on marketing the stores.
- Revenue: The revenue generated from each store.
- ROMI: This is the return on marketing investment and was calculated using the Tableau calculated field.
Click here for the full insights and to interact with the story https://public.tableau.com/views/StorePerformanceAnalysis_16769138498090/StorePerformanceAnalysis?:language=en-GB&:display_count=n&:origin=viz_share_link