Ecommerce shopping case study- Linear Regression

Problem statement:

You just got some contract work with an E commerce company based in New York City that sells clothing online but they also have in-store style and clothing advice sessions. Customers come in to the store, have sessions/meetings with a personal stylist, then they can go home and order either on a mobile app or website for the clothes they want.
The company is trying to decide whether to focus their efforts on their mobile app experience or their website. They've hired you on contract to help them.  

Information about the given Data:

RangeIndex: 500 entries, 0 to 499
Data columns (total 8 columns):
Email                   
Address                 
Avatar                 
Avg. Session Length     
Time on App             
Time on Website         
Length of Membership    
Yearly Amount Spent     

Approach:


  • I have first documented my initial thoughts and analysis. 
  • I will be updating the post as I do further reading on:
 a.Topics like online shopping behaviour, conversion funnel,  shopping trends etc.
 b.What factors to consider and how to ask the right      
    questions.

Initial thoughts:
  • Sells clothing online 
  • Company based in New York
  • In-store style and clothing advice sessions. 
  • Go home and order either on a mobile app or website for the clothes they want.


Focus efforts on mobile app experience or their website?
Need to inquire further about the objective: Focus efforts to do what?

My initial questions:

-Are we looking at New York specific data? Store is based in New York . Where are the styling stores located?
- Is the given data reflective of the customers that visited the store and then shopped on the website/app? or is it the information about overall customer database? If so, can we obtain the subset? 
-Have we identified / tracked :

  • Place specific user habits? 
  • How many users are logging in first and then visiting the store? How many are logging in after visiting the store?
- Is there an in store buying option? 
-Time period between visit and purchase/ second visit and purchase?
-Demographic details of users buying on app and website?

Which of these questions are relevant to our problem?

Data Analysis:
I would like to see what factors have a correlation with website and app design based on the given data. This is to understand:

  • Possible consequences if we make changes to their design, both positive and negative 
  • Identify parameters of interest for increasing efforts.








#All are positive; app has lesser engagement time. Why? Is there a correlation between design and engagement? Need more info of user behaviour on app and website. How does improving app and web design contribute to engagement time? And how does engagement relate to sales on each medium. How does it affect the purchase pattern?





# Looks like app time and website time vary linearly. Outliers noted. Interesting to investigate
#As time on app increases, the time difference  between  app and website decreases .Need to investigate if this higher engagement time  relate to sales?





Comments