topic Re: Clickstream Data Analysis in SAS Enterprise Guide

Clickstream Data Analysis

sewa_bal_gmail_com — Fri, 03 Feb 2017 08:31:45 GMT

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.

Re: Clickstream Data Analysis

Kurt_Bremser — Fri, 03 Feb 2017 09:25:58 GMT

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.

Re: Clickstream Data Analysis

sewa_bal_gmail_com — Fri, 03 Feb 2017 09:31:49 GMT

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.

Re: Clickstream Data Analysis

Kurt_Bremser — Fri, 03 Feb 2017 09:33:14 GMT

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

Re: Clickstream Data Analysis

sewa_bal_gmail_com — Fri, 03 Feb 2017 09:50:35 GMT

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.

Re: Clickstream Data Analysis

ChrisHemedinger — Fri, 03 Feb 2017 12:47:13 GMT

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