Retail Channel Performance Analysis
I have some real time sales and revenue data for a retailer for each day across customer type, state and channel. Sample data shared below:
Sales
| Date | Region | State | Customer Type | Sales | Channel |
|---|---|---|---|---|---|
| 1/1/2015 | South East | Florida | Employed | 100 | Kiosk |
| 1/2/2015 | South East | Georgia | Non-Employed | 200 | Dotcom |
| 1/3/2015 | South East | Florida | Employed | 300 | Dotcom |
| 1/4/2015 | South West | Arizona | Non-Employed | 400 | Kiosk |
| 1/5/2015 | South West | Georgia | Employed | 500 | Dotcom |
| 1/7/2015 | South West | Texas | Non-Employed | 0 | Kiosk |
Revenue
| Date | Region | State | Customer Type | Revenue | Channel |
|---|---|---|---|---|---|
| 1/1/2015 | South East | Florida | Employed | 10056 | Kiosk |
| 1/2/2015 | South East | Georgia | Non-Employed | 5263 | Dotcom |
| 1/3/2015 | South East | Florida | Employed | 0 | Dotcom |
| 1/4/2015 | South West | Arizona | Non-Employed | 216 | Kiosk |
| 1/5/2015 | South West | Georgia | Employed | 23037 | Dotcom |
| 1/7/2015 | South West | Texas | Non-Employed | 7743 | Kiosk |
I am stuck at finding performance of channels (Dotcom/Kisok) at the state and regional level. Should I consider only revenue or both sales and revenue? If both, how should I measure the performance? Could someone suggest any ideas or techniques? (I am new to Stackoverflow, please let me know if any other information is required).
Topic data-science-model data-analysis excel python machine-learning
Category Data Science