I would like to pull data based on a per visit level. For example, each row in the table will log the information on when the user arrive the site, from what page, what did he do during this visit to the check out page. Is it possible to do so?
For now, I can set the granuality to be one hour, but as far as I understood, the results are some how aggregated by a per hour basis. If a user check in a couple of times within this hour, the results are aggregated. Is this correct? How can I get down to the per visit level?
The ideas is that I can see this user's visit number and the corresponding URLs he viewed at what time during this visit. If I understand correctly, The URLs returned for a particular visit number is not ordered sequentially in the excel table. Then I cannot infer the URL path correctly. If I set the granularity to be 1 hour, then time stamps for all the URLs associated with one visit number will be the same. It does not help me to find out the order of URLs.
Anyway I can solve this using the data warehouse? Or how can I access the raw data to do so?
Then, how can you also get the time stamps in the report? So that each row shows this visit happens at 10:30, 11th, Nov, next visit happens at 10:45. When I leave the granularity to be *None*, the time information is lost. Any way to add this in the report?