How can I see the last viewed page of a specific section within a visit or visitor? | Community
Skip to main content
D
DebbyNPL
Level 3
August 31, 2022
Solved

How can I see the last viewed page of a specific section within a visit or visitor?

  • August 31, 2022
  • 3 replies
  • 1728 views

I want to see the last viewed page of a specific section. 

 

For example,

the last product page that a visitor viewed (the yellow one)

or what product page will make people jump out of the product-related pages but go to other pages?  (The yellow one and the green one)

 

Hope I expressed my question clearly.

 

    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 leocwlau

    Data Warehouse is just another way to export data from Adobe Analytics. I use Data Warehouse for smaller scale of selected data while Data Feed is only for the full set of clickstream raw data.

    In Data Feed, each row is a hit so you can sequence page views easily to get your result. For Data Warehouse, you need to include visitor id, visit number, clicks to page and page to have the sequence of page for your reporting. 

    3 replies

    leocwlau
    Community Advisor and Adobe Champion
    leocwlauCommunity Advisor and Adobe Champion
    Community Advisor and Adobe Champion
    September 1, 2022

    A very interesting question. Tried different ways to construct a segment to get this but no luck. The last resort is getting data using Data Warehouse or Data Feed but that will be away from the AA Workspace. Wondering if other Analytics Champions and Community Advisors have any ideas to do this within Workspace.

    D
    DebbyNPLAuthor
    Level 3
    September 2, 2022

    Hi Leo

     

    Thanks for your reply, I also tried to build some consequential segments but failed.

    I think I can get the point of how to use Data Feed to get the result. but Could you please introduce more about your idea of using the Data Warehouse to solve this problem? I'm very interested in it. 

     

    BR

    Debby

    leocwlau
    Community Advisor and Adobe Champion
    leocwlauCommunity Advisor and Adobe ChampionAccepted solution
    Community Advisor and Adobe Champion
    September 8, 2022

    Data Warehouse is just another way to export data from Adobe Analytics. I use Data Warehouse for smaller scale of selected data while Data Feed is only for the full set of clickstream raw data.

    In Data Feed, each row is a hit so you can sequence page views easily to get your result. For Data Warehouse, you need to include visitor id, visit number, clicks to page and page to have the sequence of page for your reporting. 

    ChetanyaJain-1
    Community Advisor
    ChetanyaJain-1Community Advisor
    Community Advisor
    September 6, 2022

    Hi @debbynpl 

    • How are you capturing the events and sending them to AEP? Can you please share more details on the web events schema? 
    • Do you want to know this in AEP Segments, Queries, or CJA?

     

    Regards,

    Chetanya 

    ChetanyaJain-1
    Community Advisor
    ChetanyaJain-1Community Advisor
    Community Advisor
    September 6, 2022

    Did you look at this for additional samples & ideas - https://experienceleague.adobe.com/docs/experience-platform/query/sample-queries/adobe-analytics.html?lang=en ?

    Terms & ConditionsAccessibility statement

    Loading footer...