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

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.

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

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.