Icon

01_​Clickstream_​Analysis

Clickstream Analysis
Data Preprocessing for Visualization Bin age andcalculate sessionbeginning time andtime spent on page. This workflow preprocesses and visualizes clickstream data:- Data Preprocessing- Data Preprocessing for Visualization- VisualizationSee the Description View for more details 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 categories Color Manager Purchase in session Purchases, clicksand weekday Separate sessions Customer age Read, join andformat data Transition probabilitycalculation Click sequences 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 Joiner Data Preprocessing for Visualization Bin age andcalculate sessionbeginning time andtime spent on page. This workflow preprocesses and visualizes clickstream data:- Data Preprocessing- Data Preprocessing for Visualization- VisualizationSee the Description View for more details 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 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 Joiner

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Anna
Created at: 2017-06-13
On NodePit since: 2019-07-12
Last update: 2024-11-17
Created with KNIME version: v4.5.0
Tags: ETLdata aggregationdata cleaningvisualizationJavaScriptcomposite viewinteractive viewweb page analyticsweb log filee-commerce analyticsclickstream analysisclick sequenceconversion rateweb analyticsgzPracticing Data Science

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!