How to create an Adobe analytics report on the day a page was visited last | Community
Skip to main content
Jitty_Thomas1
Level 2
Dec 27, 2023 4:05 PM UTC
Solved

How to create an Adobe analytics report on the day a page was visited last

Hi team,

 

Can somebody help me in creating an analytics report for the day a page was last visited.

The expected dimension is page url and the time range is one year.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
RobertBlakeley
RobertBlakeleyAccepted solution
New Participant
Dec 28, 2023 4:11 PM UTC

I tested using a segment in the following configuration, where the calendar date was set for a year.

The segment I used finds the last page a visitor saw in the year.

However, this gives you the last time any given visitor saw a page. So visitor 1 could have seen page A as the last page on Jan 1 and visitor 2 could have seen the same last page on Dec 1.

We would need to find the last page across all visitors. I don't know if that can be done with segments. Perhaps someone else does?

 

 

View reply

5 replies

RobertBlakeley
RobertBlakeleyAccepted solution
New Participant
Dec 28, 2023 4:11 PM UTC

I tested using a segment in the following configuration, where the calendar date was set for a year.

The segment I used finds the last page a visitor saw in the year.

However, this gives you the last time any given visitor saw a page. So visitor 1 could have seen page A as the last page on Jan 1 and visitor 2 could have seen the same last page on Dec 1.

We would need to find the last page across all visitors. I don't know if that can be done with segments. Perhaps someone else does?

 

 

Translate
Jitty_Thomas1Author
Level 2
Jan 12, 2024 4:34 AM UTC

Hi @robertblakeley ,

 

Sorry for late reply,was occupied with couple of activities.

will try to implement the same.

Thanks for your reply

 

Translate
leocwlau
leocwlau
New Participant
Dec 28, 2023 6:49 AM UTC

This may sound easy if looking from a database point of view, just query the table group by page and select max(date) and return a table with two columns

 

page max date

 

However, date is a dimension in Adobe Analytics and we cannot perform any function on it, so your request is a bit complicated.

The closest thing that comes to my mind is having page, or page url dimension as you wanted, as the first level dimension, then breakdown by year, month of year, and day of month. Limit to show only one item of each level of breakdown and make sure to sort descending by dimension values of each breakdown as pointed out in the image. You will also need to set each breakdown to "breakdown by position", so the breakdown is always on the first item instead of following the value item. There is a lot of work to do to set up such as a report.

 

If you don't need it absolutely an AA dashboard but only getting the data, pulling out page (or page URL) using Data Warehouse with a "daily" granularity, then do the "group by, max date" operation in Excel or any other tool can give you a quicker and cleaner solution.

 

One last thing, please be reminded if a page got no visit in the reporting date range, it will not show up. So if you are looking for some dormant pages, those dead pages are missing from this last access report.

 

Translate
    Josh__Stephens
    Josh__Stephens
    New Participant
    Dec 27, 2023 10:54 PM UTC

    I believe you'd need to do some nested sequential segments.  There's a slide deck from a Summit Presentation that looks at something similar.  See the link below

    https://www.dropbox.com/s/fnxsr9s94k63rsk/RockstarTips2019_AudreySalerno.pdf?dl=0

     

    I thought there might be a way to use attribution with the page dimension.  But I don't see a way to do this off hand.

    Translate
    Josh__Stephens
    Josh__Stephens
    New Participant
    Dec 27, 2023 11:20 PM UTC

    Actually, you might try a Flow.  Here's an example from Demo Data Sandbox.

    Use the page you're interested in as the Ends With...  Use Day as the Pathing Dimension

    Be sure you're using a Visitor Scope, and Limit to Last Occurrence.

    Not necessarily the easiest, but might give you what you're looking for fairly easily.

     

     

     

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...