0 ×

01_​Clickstream_​Analysis

Workflow

Clickstream Analysis
ETLdata aggregationdata cleaningvisualizationJavaScriptcomposite viewinteractive viewweb page analyticsweb log filee-commerce analyticsclickstream analysisclick sequencetargetingconversion rateweb analytics
Data Preprocessing for Visualization Bin age andcalculate sessionbeginning time andtime spent on page. Clickstream AnalysisData PreprocessingData Preprocessing for VisualizationVisualizationThe dataset we use for the clickstream analysis was originally provided by Hortonworks Inc.Similar datasets are available at: https://de.hortonworks.com/tutorial/visualize-website-clickstream-data/You can download the datasets used in this workflow from:https://github.com/hortonworks/fieldeng-modern-clickstream/tree/master/dataAfter executing the "00_Download_Dataset" workflow the datafiles can be accessed at"52_Clickstream_Analysis/_data". Execute the "00_Download_Dataset" before executing this workflow. Separate click sequences and calculatenumber of purchases and clicks on weekdays/weekends.Calculate transition probability between categories. Assign colors to categories Data Preprocessing- Access, join and format data- Calculate customer age- Separate individual sessions and calculate session duration- Add purchase yes/no to each session Visualization Calculate average session duration and number of sessions by category, weekday, time of the day, purchase, age and gender. Calculate how often different categories appear aslast or single categories and how long vistors stay onthe last page. Assign colors to categoriesColor Manager Purchase in session Purchases, clicksand weekday Separate sessions Customer age Read, join andformat data Transition probabilitycalculation Click sequences Joiner Count and timelast category Count singlecategory Last/singlecategory visits Age bin,weekday, hour Sessions by time,category and purchase Sessions by weekdayand category Sessions,gender and age Sessions and usersby age and gender Sessions by time ofthe day and purchase Click patterns andclicks/purchases correlation Data Preprocessing for Visualization Bin age andcalculate sessionbeginning time andtime spent on page. Clickstream AnalysisData PreprocessingData Preprocessing for VisualizationVisualizationThe dataset we use for the clickstream analysis was originally provided by Hortonworks Inc.Similar datasets are available at: https://de.hortonworks.com/tutorial/visualize-website-clickstream-data/You can download the datasets used in this workflow from:https://github.com/hortonworks/fieldeng-modern-clickstream/tree/master/dataAfter executing the "00_Download_Dataset" workflow the datafiles can be accessed at"52_Clickstream_Analysis/_data". Execute the "00_Download_Dataset" before executing this workflow. Separate click sequences and calculatenumber of purchases and clicks on weekdays/weekends.Calculate transition probability between categories. Assign colors to categories Data Preprocessing- Access, join and format data- Calculate customer age- Separate individual sessions and calculate session duration- Add purchase yes/no to each session Visualization Calculate average session duration and number of sessions by category, weekday, time of the day, purchase, age and gender. Calculate how often different categories appear aslast or single categories and how long vistors stay onthe last page. Assign colors to categoriesColor Manager Purchase in session Purchases, clicksand weekday Separate sessions Customer age Read, join andformat data Transition probabilitycalculation Click sequences Joiner Count and timelast category Count singlecategory Last/singlecategory visits Age bin,weekday, hour Sessions by time,category and purchase Sessions by weekdayand category Sessions,gender and age Sessions and usersby age and gender Sessions by time ofthe day and purchase Click patterns andclicks/purchases correlation

Download

Get this workflow from the following link: Download

Nodes

01_​Clickstream_​Analysis consists of the following 176 nodes(s):

Plugins

01_​Clickstream_​Analysis contains nodes provided by the following 9 plugin(s):