đź“Ą Export Viewtracker Data Center/Server Data
There are three ways to export the data Viewtracker collected. Either via built-in CSV export, REST API or SQL.
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.