Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Last viewed spaces and pages within last year

Paulina Schneider February 9, 2024

Hi, we are trying to analyze which spaces and pages have been viewed within the last year (in order to export those) as the Server instance will be shut off soon. We tried some SQL commands but they only return the last 60 days. Is there a limitation on this data? Is there another way?

1 answer

0 votes
Aron Gombas _Midori_
Community Champion
February 9, 2024

@Paulina Schneider Which app have you used to collect the "last viewed" information? There are few apps that offer this functionality, and the answer depends on the actual app being used.

If it is Better Content Archiving, I can help with the precise answer.

Paulina Schneider February 9, 2024

We used a SQL query on the database. We also tried view tracker but it only retrieves new data after installation. Which apps can we try?

Mattia _Communardo_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 9, 2024

Hello @Paulina Schneider 

To analyze which content has been viewed, an app or the Confluence built-in Analytics must have been active so that the views are tracked and stored in the database. 

The Viewtracker app is only able to import the built-in Analytics data to provide analysis from before Viewtracker itself was installed.

Maybe you had one of the other apps installed 60 days ago, that is providing you the views data? 

Aron Gombas _Midori_
Community Champion
February 9, 2024

Well, our Better Content Archiving tracks page views, but obviously only from that point of time when it was installed. And it will true for any other third party app.

If page views were not collected by any app, then I'm afraid there is no data to query anywhere.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events