Desktop productivity for business analysts and programmers

Clickstream Data Analysis

Reply
Contributor
Posts: 65

Clickstream Data Analysis

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.

Esteemed Advisor
Posts: 6,646

Re: Clickstream Data Analysis

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Contributor
Posts: 65

Re: Clickstream Data Analysis

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.

 

Esteemed Advisor
Posts: 6,646

Re: Clickstream Data Analysis

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Contributor
Posts: 65

Re: Clickstream Data Analysis

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.

Community Manager
Posts: 2,693

Re: Clickstream Data Analysis

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

 

 

Ask a Question
Discussion stats
  • 5 replies
  • 154 views
  • 0 likes
  • 3 in conversation