How can I extract a sample of visitor level data for download? I want to do clickstream analysis

[eric_roberts]

Hi:

I am new to SiteCatalyst. I typically work with off line data to build statistical models;however, now I will need to learn how to extract a sample of visitor level data (Web log/ clickstream) from SiteCatalyst or Discover so that I can conduct some web mining on some of the unique visitor paths.

I have not been able to find any tutorials or help documentation in this area.

Thanks

[Hyder_Ziaee · Accepted solution]

Hi Eric,

I believe this question belongs to the Adobe Analytics section.

Have you had a chance to look into Clickstream Datafeeds. We provide all collected data in the form of compressed, TSV files that you can store on your end and use for analysis. for your question, you need to three things to being wiith.

1. How to configure Datafeeds: https://marketing.adobe.com/resources/help/en_US/sc/clickstream/datafeeds_configure.html
2. What does each column represent: https://marketing.adobe.com/resources/help/en_US/sc/clickstream/datafeeds_reference.html
3. How to extract visitor level data: https://marketing.adobe.com/resources/help/en_US/sc/clickstream/datafeeds_visid.html

Hope this helps.

Edit: Look for the columns page_event and post_page_event. The lookup for the columns here.

-Hyder