How to pull data on a per visit level? | Community
Skip to main content
D
DataOx
September 11, 2017
Solved

How to pull data on a per visit level?

  • September 11, 2017
  • 6 replies
  • 4456 views

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?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Alexis_Cazes_

    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

    ....

    6 replies

    Urs_Boller
    Community Advisor
    Urs_BollerCommunity Advisor
    Community Advisor
    September 11, 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 -....

      D
      DataOxAuthor
      September 11, 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?

      Urs_Boller
      Community Advisor
      Urs_BollerCommunity Advisor
      Community Advisor
      September 11, 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)

        D
        DataOxAuthor
        September 13, 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?

        Alexis_Cazes_
        Alexis_Cazes_Accepted solution
        Level 10
        September 13, 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

        ....

        R
        RameshAnalytics
        Level 4
        September 13, 2017

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

        Terms & ConditionsAccessibility statement

        Loading footer...