The Analytics dashboard provides valuable metrics. You can use the exported data to create reports to share with editors and authors to evaluate the success of their content. You can use filters to create different data sets for various members of your organization. These filters ensure you extract only the data you are currently seeing in the user interface.
The CSV export displays a maximum of 1,000 rows of data, in order to optimize export generation.
In this article:
Types of Exportable Data
You can download CSV data from the different tabs. Learn more. There are different types of exportable data based on the Analytics tabs.
News
In the News tab, the CSV download offers two options.
Columns in the News Table CSV Export
This option exports performance data for each individual news post. Each row on the export corresponds to an individual post.
| Column Name | Metric Type | Definition |
| branch id | String | The ID of the branch containing the data. |
| branch name | String | The name of the branch containing the data. |
| branch slug | String | The internal identifier of the branch containing the data. Usually an abbreviated version of the App or Intranet name. |
| channel id | String | The ID of the news channel containing the data. |
| content name | String | The name of the news channel where the news post is published. |
| comments | Numeric | The number of comments the content has. |
| postLikes | Numeric | The number of likes the post has. |
| commentLikes | Numeric | The number of likes the comments on the post have. |
| newPosts | Numeric | The number of news posts published within the selected time interval. This includes published and republished posts. |
| notification email | Boolean | Indicates if the news post triggered a notification email. |
| notification push | Boolean | Indicates if the news post triggered a push notification. |
| post channel id | String | The ID of the news channel where the news post is published. |
| post creation date | Timestamp | Indicates when the post was created. |
| post id | String | The ID of the news post containing the data. |
| post published date | Timestamp | Indicates when the post was last published. |
| post title | String | The title of the news post. |
| public | Boolean | Indicates if the news post is publicly available. |
| registered visitors | Numeric | The number of unique signed-in users who viewed the post. |
| registered visits | Numeric | The number of total signed-in user visits for the post. |
| shares | Numeric | The number of times the news post was shared. |
| space id | String | The ID of the space where the news post was published. |
| space name | String | The name of the Space where the news post was published. |
| unregistered visitor | Numeric | The number of unique users visiting any public content. Only available, if the feature public area tracking is activated. |
| unregistered visits | Numeric | The number of total visits for the news post that are not from signed in users. Only relevant for public content. |
Columns in the News Timeseries CSV Export
This option exports news activity metrics grouped by a specific time unit per row. Depending on the span of your time interval, the exported data is grouped by one of the following:
- Month: for longer time periods
- Day: for shorter time periods
| Column Name | Metric Type | Definition |
| comments | Numeric | The number of comments that the news post has. |
| day | Numeric | The day of the month for which the data is aggregated. The value can vary from 1 to 31. |
| likes | Numeric | The number of likes that the new post had. |
| month | Numeric | The number for which the data is aggregated. The values can vary from 1 (January) to 12 (December). |
| newPosts | Numeric | The number of news posts published in the selected time interval. This includes published and republished posts. |
| registered visitors | Numeric | The number of unique signed-in users who viewed the post. |
| registered visits | Numeric | The number of total signed-in visits for the post. |
| shares | Numeric | The number of times the news post was shared. |
| unregistered visitors | Numeric | The number of unique users visiting any public content. Only available when the public area tracking feature is activated. |
| unregistered visits | Numeric | Number of total visits for the news post that are not from signed-in users. Only relevant for public content. |
| year | Numeric | The year for which the data is aggregated. |
Pages
In the Pages tab, the CSV download offers two options.
Columns in the Pages Timeseries CSV Export
| Column Name | Metric Type | Definition |
| date | Timestamp | The date and time, in ISO 8601 format. |
| views | Numeric | The number of page views. |
| visitors | Numeric | The number of unique users who visited a page. |
Columns in the Pages Table CSV Export
This option exports performance data for each individual page. Each row on the export corresponds to an individual page.
| Column Name | Metric Type | Definition |
| page id | String | The ID of the page. |
| branch id | String | The ID of the branch containing the data. |
| space id | Numeric | The ID of the space where the page was published. |
| views | Numeric | The number of page views. |
| unique visitors | Numeric | The number of distinct users who visited the page. |
| avg. time on page | Numeric | The average time users spent on the page in seconds. |
| clicks | Numeric | The number of times users clicked on the page. |
| page title | String | The title of the page. |
| bounce rate | Numeric | The percentage of sessions where visitors exited the page within three seconds. |
| space name | String | The name of the space in which the page belongs. |
Individual Pages
For each individual page in the Pages tab, the CSV download offers two options.
Columns in the Metric Development Over Time CSV Export
| Column Name | Metric Type | Definition |
| year | Numeric | The year for which the data is aggregated. |
| month | Numeric | The month for which the data is aggregated. The values can vary from 1 (January) to 12 (December). |
| day | Numeric | The day of the month for which the data is aggregated. The value can vary from 1 to 31. |
| hour | Numeric | The hour for which the data is aggregated. The values can vary from 0 to 23. |
| views | Numeric | The number of page views. |
| unique visitors | Numeric | The number of unique users who visited a page. |
| clicks | Numeric | The number of times users clicked on the page. |
Columns in the Breakdown by User Group CSV Export
| Column Name | Metric Type | Definition |
| user group | String | The user group ID number. |
| group name | String | The name of the user group. |
| amount of views | Numeric | The number of page views by the specific group. |
Columns in the Breakdown by Clicks CSV Export
| Column Name | Metric Type | Definition |
| link | String | The full link of the clicked element. |
| name of element | String | The name of the widget or document. |
| amount of clicks | Numeric | The number of times users clicked on the element. |
Content
In the Content tab, you can export all of the content found in the table.
Columns in the Content CSV Export
| Column Name | Metric Type | Definition |
| content id | String | The unique identifier for the content. |
| content type | String | The type of content for which the data was collected. |
| registered visitors | Numeric | The number of unique signed-in users visiting the content. |
| registered visits | Numeric | The number of total signed-in visits for the content. |
| space id | String | The ID of the space where the news post was published. |
| space name | String | The name of the Space where the content was published. |
| unregistered visitors | Numeric | The number of unique users visiting any public content. Only available when the public area tracking feature is activated. |
| unregistered visits | Numeric | The number of total visits for the news post that are not from signed-in. Only relevant for public content. |
Users
In the User tab, you can export user activity metrics grouped by time unit, per row.
Columns in the User CSV Export
Depending on the span of your time interval, the exported data is grouped by one of the following:
- Month: for longer time periods
- Day: for shorter time periods
| Column Name | Metric Type | Definition |
| active users | Numeric | The number of users who have signed in at least once in the defined time period. |
| day | Numeric | The day of the month for which the data is aggregated. The values can vary from 1 to 31. |
| engaged users | Numeric | The number of users who have commented, liked, or shared content t in the defined time period. |
| month | Numeric | The month for which the data is aggregated. The values can vary from 1 (January) to 12 (December). |
| registered visits | Numeric | The number of total signed-in user visits for the content. |
| total users | Numeric | The number of registered or pending users in your platform during the selected timeframe. |
| year | Numeric | The year for which the data is aggregated. |
Chat
In the Chat tab, you can export chat activity metrics grouped by time unit, per row.
Columns in the Chat CSV Export
Depending on the time span you have selected, the exported data is grouped by one of the following:
- Month: for longer time periods
- Day: for shorter time periods
| Column Name | Metric Type | Definition |
| active chat users | Numeric | The number of users who have sent at least one chat message in the defined time period. |
| active direct conversations | Numeric | The number of one-to-one chats with at least one message exchanged in the defined time period. |
| active group conversations | Numeric | The number of group chats with at least one message exchanged in the defined time period. |
| day | Numeric | The day of the month for which the data is aggregated. The values can vary from 1 to 31. |
| month | Numeric | The month for which the data is aggregated. The values can vary from 1 (January) to 12 (December). |
| total users | Numeric | The number of registered or pending users in your platform during the selected timeframe. |
| year | Numeric | The year for which the data is aggregated. |
Search
In the Search tab, you can export all of the content found in the table, plus a comparison to the number of searches from the previous period.
Columns in the Chat CSV Export
| Column Name | Metric Type | Definition |
| current count | Numeric | The number of searches performed by users within the timeframe. |
| previous count | Numeric | The number of searches performed by users within the previous comparable timeframe. |
| search term | String | The word or phrase that users searched for within the timeframe. |
| unique users | Numeric | The number of unique users who performed searches during the timeframe. |
In the Email tab, you can export all Email metrics displayed on the page.
Downloads are limited to a maximum of 365 days.
Columns in the Email CSV Export
This option exports performance data for each individual email. Each row on the export corresponds to an individual email.
- Month: for longer time periods
- Day: for shorter time periods
| Column Name | Metric Type | Definition |
| email id | String | The ID of the email. |
| email title | String | The internal title of the email. |
| total sent | Numeric | The total number of recipients emailed. |
| total bounced | Numeric | The number of new contacts for whom the email bounced. |
| total delivered | Numeric | The total number of emails delivered. |
| total opens | Numeric | The total number of times the email was opened, including repeated and unique opens. |
| unique opens | Numeric | The number of times the email was opened for the first time by a specific recipient. |
| percent opens | Numeric | The percentage of delivered emails opened. |
| total clicks | Numeric | The total number of times a link in the email was clicked, including repeated and unique clicks. |
| unique clicks | String | The number of times a link was clicked for the first time by a specific recipient. |
| percent clicks | Numeric | The percentage of openers who clicked a link. |
| sent date | String | The date the email was sent. |
| sent time | String | The time the email was sent. |
| locales | String | The languages the email was sent in. |
| subject line | String | The subject line, as defined in the fallback language. |
| preview text | String | The preview text, as defined in the fallback language. |
| sender name | String | The name of the sender. |
| sender address | String | The email address of the sender. |
| folder name | String | The name of the folder in which the email was created. |
| space name | String | The name of the space in which the email is located. |
| campaign name | String | The name of the campaign to which the email was assigned. |
| desktop opens | Numeric | The total number of opens on desktop. |
| mobile opens | Numeric | The total number of opens on mobile devices. |
| tablet opens | Numeric | The total number of opens on tablets. |
| desktop clicks | Numeric | The total number of clicks on desktop. |
| mobile clicks | Numeric | The total number of clicks on mobile devices. |
| tablet clicks | Numeric | The total number of clicks on tablets. |
| percent read | Numeric | The total percentage of openers who read the email for more than 8 seconds. (Only available if read times are activated.) |
| percent skimmed | Numeric | The total percentage of openers who read the email for 3–8 seconds. (Only available if read times are activated.) |
| percent glanced | Numeric | The total percentage of openers who read the email for less than 2 seconds. (Only available if read times are activated.) |
Comments
0 comments
Article is closed for comments.