Expand my Community achievements bar.

SOLVED

How to pull data on a per visit level?

Avatar

Level 1

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?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

....

View solution in original post

6 Replies

Avatar

Community Advisor

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

Level 1

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?

Avatar

Community Advisor

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

Level 1

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

Correct answer by
Community Advisor

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

....

Avatar

Level 5

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