Using last view date in automation

[melanie_boehmer]

Hi 

I am trying to set up an automation rule, where pages are labeled if they have not been viewed for 2 years or more. Is this possible? Maybe there is a way to include this as a smart.value? Does anyone have any experience with this?

[Barbara Szczesniak]

@melanie_boehmer Not sure how this might interact with automation, but you should be able to query the database to retrieve all pages where the last_view_date is before 2 years ago. See https://support.atlassian.com/confluence/kb/how-can-i-find-which-spaces-have-been-recently-viewed-or-their-content-modified/ I don't know if you could use SQL to add the label you want to the pages.

Also, since you are on Premium, you can use insights on spaces to examine the Content in a space and sort by the Last viewed column (see https://support.atlassian.com/confluence-cloud/docs/view-insights-on-spaces/ ). It looks like you can export this list as CSV also. 

[melanie_boehmer]

Hi, thanks for the suggestions. Our use case would be that we could tag pages that haven't been viewed in a while with a lable like "to-be-archived" automatically and then at a team meeting we could agree upon archiving the tagged pages and filter them easily without having to go into analytics. Maybe this would be worth suggesting to Atlassian as a feature, since the data and basic functionality is already in place. 

[Evgenii]

Hi, @melanie_boehmer 

I'm afraid it's not possible to retrieve information about when a page was last viewed. This data isn't available through Confluence Automation smart values or the REST API.

However, you can get the date when the page was last edited using this smart value:

{{page.dateLastUpdated}}

https://support.atlassian.com/cloud-automation/docs/smart-values-in-confluence-automation/#Content-properties--pages-and-blogs

This might help you identify outdated pages based on their last update date.

[melanie_boehmer]

Hi

I have actually already created a rule for tagging pages that have not been updated for a year, but it would have been useful to also tag pages no one ever looks at and archive them. 

Thank you for the suggestions though.