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?
Solved! Go to Solution.
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
....
Views
Replies
Total Likes
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 -....
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?
Views
Replies
Total Likes
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)
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?
Views
Replies
Total Likes
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
....
Views
Replies
Total Likes
I guess you can able to run this data using data warehouse. It should work.
Views
Replies
Total Likes