Clickstream Data Analysis

[sewa_bal_gmail_com]

I am very new to online data analysis. We alredy have a data like session id, cust id, hostname, time spend url in sec,product code, and other important columns

Could you please guide me how we can explore the online data to understand visitors behivour and at which page vistitor exit or purache and manay more parameters.

[Kurt_Bremser]

You need to start at the source. Have the web server configured to write the clickstream log (in the apache httpd.conf configuration file, one only has to uncomment the proper directive).

Once you have that log, I can provide a code example for reading and analysing it.

[sewa_bal_gmail_com]

Thanks for a reply , We alredy have a clean data on cloud, but i need help how to explore data to understand customer behaviour and at what point visitor leave the page and manay more question...

We have sas va and sas eg software.

[Kurt_Bremser]

Then post a thorough description of your data, and some examples (data step!)

[sewa_bal_gmail_com]

Please see below data description

1 milltion rows generated each date. we have also set of columns as well
custid datetime URL prod_code Event
1 100 www.zxc.com A page view
1 101 www.zxc2.com A Add to card
1 105 www.zxc3.com B purchase
1 107 www.zxc4.com B purachse.

[ChrisHemedinger]

Here is a simple paper on the topic.  And this whitepaper on the general approach that shows more sophisticated tools at work.