How to pull data on a per visit level?

Avatar

Avatar

DataOx

Avatar

DataOx

DataOx

11-09-2017

Hi,

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?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

AlexisCazes

MVP

Avatar

AlexisCazes

MVP

AlexisCazes
MVP

13-09-2017

I think what you are trying to do is see raw data, like for visitor X and visit_num Y see all hits send.

Data Warehouse return aggregated raw data, where Data Feed returns hit based raw data, which can be used in a Data base to mine your data.

I think you should be able to do that using Data Feed

You should be able to get all raw data that Adobe Analytics receive and then process it in the output you need. i.e : calculating metrics

Columns and how to identify unique visitors

Here are some columns you might be interested

date_time

cust_hit_time_gmt

hit_time_gmt

hit_source

Visitors columns

post_visid_type

post_cust_visid

post_visid_high

post_visid_low

mcvisid

Visit columns

new_visit

visit_num

visit_page_num

visit_ref_domain

visit_ref_type

visit_referrer

visit_start_page_url

visit_start_pagename

visit_start_time_gmt

Other

exclude_hit

duplicate_hit

duplicate_events

duplicate_purchase

page_url

post_page_url

event_list

post_event_list

first_hit_page_url

first_hit_time_gmt

post_evarX where X is the number of the eVar

....

Answers (5)

Answers (5)

Avatar

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

485

Correct Answer

250

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

485

Correct Answer

250
ursboller
MVP

11-09-2017

you can still use "hour" as granularity, but then a single visit may occur several times (depending how long it takes.

other options:

- use your custom "prop" for the time granularity (if you have setup one

- examine data feed (raw data of the analytic calls)

Avatar

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

485

Correct Answer

250

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

485

Correct Answer

250
ursboller
MVP

11-09-2017

just an idea: leave granularity at "none" and break down by "visitor ID" and "visit number". this should result in a (big?) list as follow:

- visitor 1 - visit 1 -....

- visitor 1 - visit 2 -....

- visitor 2 - visit 1 -....

Avatar

Avatar

rameshk28785

Avatar

rameshk28785

rameshk28785

13-09-2017

I guess you can able to run this data using data warehouse. It should work.

Avatar

Avatar

DataOx

Avatar

DataOx

DataOx

13-09-2017

I want to design the data extract in this way:

UserID, Visit number, URLs, time stamp

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?

Avatar

Avatar

DataOx

Avatar

DataOx

DataOx

11-09-2017

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?