📥 Export Viewtracker Data Center/Server Data

There are three ways to export the data collected by Viewtracker: via the built-in CSV export, REST API, or SQL.

Exports will adhere to Confluence's permission settings. This means that any content a user does not have access to within Confluence will be marked as RESTRICTED in the export.

If you are looking for instructions on how to export Viewtracker configuration information, please see How to create a Viewtracker Support ZIP.

For information on importing, please go to Import Data.

CSV Export

You can create a CSV of the numbers from the current filter or the selected date range in the built-in Viewtracker reports. The metrics depend on which report you are accessing. We are listing all the options you have in each report below.

Global Report

Global Content Report

You can export the Views, Edits and Creations via the “More” option in the report menu.

⚙ → Analytics Cockpit → Global Content Report → Export → Views/Edits/Creations

Attachments Report

⚙ → Analytics Cockpit → Menu “Attachments” → Export → choose individual or aggregated views

Individual views:

This exported CSV file will include every single attachment view with the following information:

View ID
Attachment ID
Attachment Name
View Date
View UNIX Date
Username
Full Name
Content ID
Content Title
Content Type
Space Key
Space Name

Aggregated views:

This exported CSV will include the aggregated view events as displayed in the Attachment Report and will include the following information:

Attachment Name
Space Name
Views

Search Report

⚙ → Analytics Cockpit → Menu “Search” → Export → choose individual or aggregated searches

Individual searches:

This exported CSV file of the search report will include every single search event with the following information:

Search ID
Search Term
Search date (& time)
Search UNIX Date
Username
Full name (if privacy setting allows it)
Number of results

Aggregated search terms:

This exported CSV will include the aggregated searches (as displayed in the Search Report) and will include the following information:

Search Term
Number of Results
Number of Searches

Space Report

Space → Space Tools → Analytics Cockpit → Content → Export → Views/Edits/Creations

Content Report

Access the page you want the information for. On the relevant part of the Content Report, select “Export” and decide on which metrics to export.

The CSV export of the views contains the following data:

Visit ID: ID of the view
Username: Name of the user who viewed the content. "Anonymous" if Extended Privacy Mode is enabled
Full Name: Full name of the user. "Anonymous" if Extended Privacy Mode is enabled
Content ID: ID of the viewed page or blog post
Content Title: Title of the page or blog post
Content Type: Type of the viewed content: page or blog post
Source: Source of the view: desktop, mobile, Confluence app, Linchpin or JSM
Space Key: The space key of the space the content is located in
Space Name: Full name of the space
Visit Date: Date of the view
UNIX Date: Date and time of the view as UNIX timestamp

Content & Usage Report

Content & Usage Spaces Report

You can export numbers of the Content Usage Report as a CSV file.

All numbers in the export refer to the selected filter and date range (last 30 days by default).

Here’s how to export:

main table: tap the “Export” button next to the date range and confirm the amount of data.
“All metrics” summary: tap the “Export” button in the overlay.
“Viewers”: tap the “Export” button in the overlay.
“Contributors”: tap the “Export” button in the overlay.
“Engaged users”: tap the “Export” button in the overlay.

The CSV contains the aggregated data from the report, including the following:

main table: Space Name, Space Key, Views, Viewers, Edits, Contributors, Engaged Users, Last Viewed, Last Viewed Formatted, Last Modified, Modified Date Formatted.
“all metrics” summary: Number of spaces, Views, Viewers, Contributors, Engaged Users, New content, Edits, Deleted content, Comments, Likes (on content), Likes (on comments), Watches.
“Viewers”: Name, Last Viewed, Times Viewed.
“Contributors”: Name, Last Edited, Times Edited.

Content & Usage Content Report

You can export numbers of the Content Usage Report as a CSV file.

All numbers in the export refer to the selected filter and date range (last 30 days by default).

Here’s how to export:

main table: tap the “Export” button next to the date range and confirm the amount of data.
“All metrics” summary: tap the “Export” button in the overlay.
“Viewers”: tap the “Export” button in the overlay.
“Contributors”: tap the “Export” button in the overlay.
“Engaged users”: tap the “Export” button in the overlay.

The CSV contains the aggregated data from the report, including the following:

main table: Content Id, Content Type, Title, Space Key, Views, Viewers, Edits, Contributors, Engaged Users, Last Viewed, Last Viewed Formatted, Last Modified, Modified Date Formatted.
“all metrics” summary: Number of content, Views, Viewers, Contributors, Engaged Users, New content, Edits, Deleted content, Comments, Likes (on content), Likes (on comments), Watches.
“Viewers”: Name, Last Viewed, Times Viewed.
“Contributors”: Name, Last Edited, Times Edited.

Content & Usage Users Report

You can export the numbers of the report as a CSV file.

All numbers in the export refer to the selected filter and date range (last 30 days by default).

Export the main table

Tap the “Export” button next to the date range.
Confirm the amount of data.

The CSV contains the aggregated data from the report, including the following:

Full Name, Views Total, Creates Total, Edits Total, Comments Total, Likes Total, Watches Total

Export the detailed user interactions (views, creations, edits, comments)

Tap the three dots in the “Views”, “Creations”, “Edits”, “Comments”, “Likes”, or “Watches” column next to a specific user.
In the overlay, tap the “Export” button.
Confirm the amount of data.

The CSV contains the individual views, creations, edits, comments, likes and watches. It consists of "Content Title" and "Date and Time".

API

An advanced option is the Viewtracker - REST Reporting API. This is especially interesting when integrating Viewtracker with other applications.

SQL

Utilize the table of tracked data inside the Confluence database via SQL.
To learn about the Viewtracker table, please refer to Viewtracker Data Structure.