I want to perform cluster analysis on the data of a website. The data is mainly visitor history(97000 rows) and has following variables:
a)User Device Category b) Traffic Marketing Channel c) Traffic Source d) Marketing Campaign e) Website Landing Page f) User Session Duration g) User Goal Completion
Apart from session duration and goal completion rest of the data is categorical. In particular traffic source,campaign,landing page etc have 100's of levels each.
Also I believe the goal completion is sparse as most of the time it is 0.
Would it be a good idea to:
bin the session duration to categories. eg. 1000 seconds to 3000 sec.is one category and so on
if a level of categorical variable is not too frequent then just write "others"
combine certain levels if they have similar characteristic.
Could someone give me tips on how to handle the categorical data, which package in R can handle mixed data type and what would be a good way to interpret the results.
I am fairly new to data analysis and need all the help I can get. Thanks a lot in advance!