Clickstream Sales Analysis - Online shopping

Focusing on Sales by Month, Clothing Type, and Display Page

Dataset - ML datasets from UCI (Univ of CA at Irvine)

Dataset for online store sales for pregnant woman clothing is gatehered from https://archive-beta.ics.uci.edu/ml/datasets with selected filters on clustering and regression. Details of the dataset:
https://archive.ics.uci.edu/ml/datasets/clickstream+data+for+online+shopping

Citation Request: If you use this dataset, please cite:
Łapczyński M., Białowąs S. (2013) Discovering Patterns of Users' Behaviour in an E-shop - Comparison of Consumer Buying Behaviours in Poland and Other European Countries, “Studia Ekonomiczne”, nr 151, “La société de l'information : perspective européenne et globale : les usages et les risques d'Internet pour les citoyens et les consommateurs”, p. 144-153

Data Set Information:
The dataset contains information on clickstream from online store offering clothing for pregnant women. Data are from five months of 2008 and include, among others, product category, location of the photo on the page, country of origin of the IP address and product price in US dollars.

Attribute Information:
The dataset contains 14 variables described in a separate file (See 'Data set description')

Let's Explore

Get to know Metadata

Exploring possibilities

Data Cleanup

Plots to uncover the plots in data

Conclusion

Further Review

Submission

Get to know Metadata

Data description “e-shop clothing 2008”

Variables:

1. YEAR (2008)

2. MONTH -> from April (4) to August (8)

3. DAY -> day number of the month

4. ORDER -> sequence of clicks during one session

5. COUNTRY -> variable indicating the country of origin of the IP address with the
   following categories:
   1-Australia
   2-Austria
   3-Belgium
   4-British Virgin Islands
   5-Cayman Islands
   6-Christmas Island
   7-Croatia
   8-Cyprus
   9-Czech Republic
   10-Denmark
   11-Estonia
   12-unidentified
   13-Faroe Islands
   14-Finland
   15-France
   16-Germany
   17-Greece
   18-Hungary
   19-Iceland
   20-India
   21-Ireland
   22-Italy
   23-Latvia
   24-Lithuania
   25-Luxembourg
   26-Mexico
   27-Netherlands
   28-Norway
   29-Poland
   30-Portugal
   31-Romania
   32-Russia
   33-San Marino
   34-Slovakia
   35-Slovenia
   36-Spain
   37-Sweden
   38-Switzerland
   39-Ukraine
   40-United Arab Emirates
   41-United Kingdom
   42-USA
   43-biz (.biz)
   44-com (.com)
   45-int (.int)
   46-net (.net)
   47-org (*.org)

6. SESSION ID -> variable indicating session id (short record)

7. PAGE 1 (MAIN CATEGORY) -> concerns the main product category:
   1-trousers
   2-skirts
   3-blouses
   4-sale

8. PAGE 2 (CLOTHING MODEL) -> contains information about the code for each product
   (217 products)

9. COLOUR -> colour of product
   1-beige
   2-black
   3-blue
   4-brown
   5-burgundy
   6-gray
   7-green
   8-navy blue
   9-of many colors
   10-olive
   11-pink
   12-red
   13-violet
   14-white

10. LOCATION -> photo location on the page, the screen has been divided into six parts:
    1-top left
    2-top in the middle
    3-top right
    4-bottom left
    5-bottom in the middle
    6-bottom right

11. MODEL PHOTOGRAPHY -> variable with two categories:
    1-en face
    2-profile

12. PRICE -> price in US dollars

13. PRICE 2 -> variable informing whether the price of a particular product is higher than
    the average price for the entire product category
    1-yes
    2-no

14. PAGE -> page number within the e-store website (from 1 to 5)