Aurora Analytics Metric Definitions
This article provides definitions for all the metrics available in Aurora Analytics. Aurora Analytics approximates user behavior and therefore these metrics exclude almost all nonhuman requests (Web crawlers, robots, RSS feeds, REST API calls). About how Community visit metrics are calculated When viewing visits metrics, you might see small variants in the reported numbers. This is expected when you compare visits metric for a period within a month versus a sum of months in that period. The main reasons for these differences include: Overlapping visits across months "Visits" are defined as the number of unique user sessions. A session is defined as a group of interactions one user takes within a given time frame. Sessions time out in the case of 30-minute inactivity. Assume someone browsed through a community during the last hour of a month (Month-1) and continued browsing through the first hour of next month (Month-2). In this scenario: When we measure visits for Month 1, this session is counted as 1 visit. When we measure visits for Month 2, this session is counted as 1 visit. So, when you sum up visits for Month 1 and Month 2, you see 2 total visits, whereas, if you measure visits over the 2-month period, this session is counted as a single visit. Algorithm approximation "Visits" and "visitors" metrics are an approximation algorithm in their calculations. As such, there might be a 1-2% variance in the calculations. Elastic search documentation mentions that sometimes the variance could be up to 6%. Aurora Analytics metrics and definitions Widget/Metrics Definition Page Views A page view is counted each time a browser requests a page regardless of the device type or whether the page is cached. Page Views approximate user behavior and therefore exclude non-human requests (web crawlers, bots, RSS feeds, REST API calls). Page Views (Trend graph) Page Views trend graph is a line graph that shows how the Page Views are trending for the selected time frame. Visits A visit is one or more page views over time by a uniquely identified visitor. A cookie set in the browser identifies visitors (anonymous or registered), so if a visitor has cookies turned off, each page view counts as a new visit. The visit counter increments as soon as the visitor views any community page; the visit ends after 30 minutes of inactivity. After the 30-minute timeout, the next page view counts as a new visit. The Mobile Visits metric is a subset of the Visits metric and includes requests from mobile web browsers only. Unique Visitors The number of unique visitors over the specified time interval. When a visitor (registered or anonymous) views a page, the application looks for a visitor cookie. If no cookie is found, a new cookie is created, and the visitor counts as a new unique visitor. If a visitor cookie is found, the Unique Visitor counter is not incremented. If cookies are cleared after a visit, the next visit sets a new cookie and counts a new unique visitor. Since cookies are browser dependent, so are unique visitors. Users who access the community from different browsers count as a unique visitor. The Mobile Unique Visitors metric is a subset of the Unique Visitors metric and includes visitors who used mobile web browsers only over the specified time interval. Page Views /Visit The average number of Page Views per Visit for the time frame selected. Visits vs. Unique Visitors The trend of the number of visits to the community site against the number of unique visitors for the selected time frame. Visits by User Type The number of visits made by anonymous users and signed-in users. Anonymous users also refer to community members who have not logged in. Learn more about Visits by User Type. Visit Referrals The number of community visits that originated from specific URL domains. This metric helps you understand how much traffic is coming in from different search engines, social networks, or links on your company website. Completed Registrations The number of member registrations completed during the selected time period (excludes partial/abandoned registrations). A registration is considered complete when the visitor finishes the sign-up flow and is given a unique user ID. If the visitor leaves the sign-up flow before being granted their unique user ID, the registration is considered to be abandoned, and the completed registration counter is not incremented. If the community uses Single Sign On (SSO), Khoros increments the completed registration count the first time it receives an authentication token that contains a unique User ID. Partial Registrations The number of user registrations abandoned during the selected time period. Completed and Partial Registrations The line graph shows how the completed and partial registrations are trending over the selected time frame. DAU/MAU DAU (Daily Active Users) is the number of unique members who engage with the community in a one-day window. MAU (Monthly Active Users) is the number of unique members who engage with the community over a month or 30-day window. The ratio of DAU to MAU is the proportion of monthly active members who engage with the community in a single day window. Member Time on Site The Member Time metric indicates the total number of minutes from first page request to last page request for each visit of all registered members in your community during the date range of the report. Member time does not capture the time of actions, such as likes, unless the member requests a new page after the action. Nor does it include the last 30 minutes after the last page request before the session times out. Member time is calculated from the time of the first page request, such that a session that started at 11:50pm on day 1 and ending at 12:15am on day 2 is counted as member time for day 1. New vs. Returning Members New members are members who have never visited the community and are visiting for the first time. Returning members are members who have visited the community before. This line graph shows the trend of new and returning members over the selected time frame. Note that this widget will show data for the last 30 days only, irrespective of the selected date range. Depending on the time range you choose in the dashboard settings, you may get partial data or no data. New vs. Returning Anonymous Users When a user views the community without signing in, the community looks for cookies saved on their device. If there is no cookie present, then the user is treated as a New Anonymous User. If cookies are present, then the user is treated as a Returning Anonymous User. Since members can also view the community without signing in, they are also considered Anonymous. Note that this widget will show data for the last 30 days only, irrespective of the selected date range. Depending on the time range you choose in the dashboard settings, you may get partial data or no data. Forum This widget shows the engagement on the selected Place for the date range selected. Shows the number and trend line of the number of discussions created, number of likes received, number of replies for the time frame and selected Place. Click View Detailsfor further insights. Blog This widget shows the engagement on the selected Blog for the date range selected. Shows the number and trend line of the number of posts created, number of likes received, and the number of comments for the time frame and selected Place. Click View Detailsfor further insights. Knowledge Base This widget shows the engagement on the selected Knowledge Base for the date range selected. Shows the number and trend line of the number of articles created, number of likes received, and the number of comments for the time frame and selected Place. Click View Details for further insights. Places - Follows The total number of followers for the selected Place. Topics - Follows The total number of followers for the selected Content. Observing vs. Participating vs. Contributing This widget shows the engagement between members who are observing, participating and contributing in the community for the place and time frame selected. Observing members are those who have signed into the community and their engagement is limited only to viewing the contents. Participating members are those who reply or like posts in the community. Contributing members are those who create content or provide solutions in the community. Private Messages This widget shows the number of private messages sent, its trend line and the messages per conversation in the community for the time frame selected. Messages sent The number of private messages sent from the inbox by all the community members during the selected time frame. Messages sent (trend graph) The trend line graph showing the number of private messages sent from the inbox by all the community members during the selected time period. Discussions The number of Discussions in the selected Place during the selected time frame. Likes The number of likes received for the Discussions and replies in the selected Place during the selected time frame. Replies The number of replies received for the Discussions in the selected Place during the selected time frame. Engagement Shows the trend line for number of Discussions, likes, and replies in the Place during the selected time period in Forums Details. Shows the trend line for number of Blog posts, likes, and comments in the Place during the selected time period in Blogs Details. Shows the trend line for number of articles, likes, and replies in the Place during the selected time period in Knowledge Base Details. Shows the trend line for number of ideas, votes, and comments in the Place during the selected time period in Ideas Board Details. Time to First Reply The time taken (average) for Discussions in the selected Place to receive its first reply after it has been initially submitted. It is typically measured from the moment the Discussion is published to the moment someone replies to it. First Replies The total number of first comments on all the Discussions in the selected Place during the selected time frame. If for the selected time frame there are 10 Discussions in the selected Place, and only 4 have received a reply, then the total number of first replies is 4. If for the selected time frame there are 10 Discussions in the selected Place and only 1 Discussion has replies, even if that one Discussion has 5 total replies, the First Replies is 1. Marked As Solved The number of Discussion replies that are marked as an accepted solution for the selected Place and for the selected time frame. There is only 1 solution per Discussion. Marked As Solved Trend Shows the trend line for the number of replies that are marked as an accepted solution for the forums in the selected Place and for the selected time frame. Solutions Authored The number of solutions the member provided for a discussion Time to Solution The average time taken for the replies in Discussions for the selected Place to be marked as an accepted solution. It is measured from the moment the Discussion is posted until one of its replies is marked as an accepted solution. Solution Views A count of page views of Discussions with an accepted solution after the Discussion has had a reply marked as an accepted solution. Forum - Follows The total number of followers for the selected Forum during the time frame selected. Discussions - Follows The total number of followers for the Discussions in the selected Place during the time frame selected. New and Trending Discussions The total number of new Discussions and trending Discussions in the Forum selected during the selected time frame. The metric values for Trending Discussions depends on the minimum number of views set in the Engagement dashboard settings. Posts The number of blog posts in the selected Place during the selected time frame. Comments (for Blogs and Ideas) The number of comments the blog posts or Ideas in the selected Place received during the selected time frame. Articles The number of Knowledge Base articles in the selected Place during the selected time frame. Blog - Follows The total number of followers for the Blog in the selected Place during the time frame selected. Posts - Follows The total number of followers for the Blog posts in the selected Place during the time frame selected. Knowledge Base - Follows The total number of followers for the Knowledge Bases in the selected Place during the time frame selected. Article - Follows The total number of followers for the Knowledge Bases articles in the selected Place during the time frame selected. TTFR Time to First Reply TTFS Time to First Solution Helpful Votes The number of votes the Knowledge Base board or article received stating that they were helpful. Unhelpful Votes The number of votes the Knowledge Base board or article received stating that they were unhelpful. Members Joined The number of members who joined the Group. Members Left The number of members who left the Group. Invitations Sent The number of invitations sent to members to join the Group. Invitations Accepted The number of invitations that were accepted by members to join the Group. Ideas Snapshot (widget) This widget contains the metrics related to Ideas Board. The metrics are number of ideas, number of comments received, number of votes received during the selected time period for the Place selected. Ideas (Groups, Events and Members reports) Total number of ideas created during the selected time period for the selected Place. Votes Total number of votes received during the selected time period for the selected Place. Idea Votes (Members report) Total number of votes given by members during the selected time period for the selected Place. Idea Votes Given(Members report) Total number of votes given by members during the selected time period for the selected Place. Idea Votes Received (Members report) Total number of votes given to the member's ideas during the selected time period for the selected Place. Closed Total number of ideas closed during the selected time period for the selected Place. Completed Total number of ideas completed during the selected time period for the selected Place. Events (Groups, Events, and Members reports) The number of events in the selected Place during the selected time frame. RSVP-Attending (Groups, Events and Members reports) The number of members who RSVP'd 'yes' to the events in the selected Place during the selected time frame. RSVP-Interested(Groups, Events, and Members reports) The number of members who RSVP'd 'Interested' to the events in the selected Place during the selected time frame. Attended The number of members who attended the events in the selected Place during the selected time frame. Events Attendance(Members report) The number of members who attended the events in Groups for selected Place during the selected time frame. Events Attended(Members report) The number of events the member attended during the selected time frame. Events by type (widget) This widget shows engagement on events based on the event type (In-person, Online, and Hybrid). Lead-up to the Event (widget) This widget shows metrics on all the activities that occurred on the event before it started. Note: In Classic Analytics, a summation of all posts in the community (root topics and replies across discussion styles) is presented as the 'Posts' metric in the Categories report. However, in Aurora Analytics, the root topics and replies across content types (Forums, KB, Blog, Idea and Events) are presented as specific/independent metrics, instead of adding them together and presenting as 'Posts' metric. Related topics: About Aurora Analytics Dashboard Settings Aurora Analytics ReportsAbout Aurora Analytics
To have a successful community, you need to know what’s working and what needs improvement. Aurora provides a robust set of analytics so you can get actionable insights to drive traffic and member engagement. You can determine what kinds of content needs improvement, what your members steer away from, and what they want more of from your community. These metrics help you learn where your members come from, what type of content they engage with, and where to focus on to reach new people. Having clear data enables you to plan towards community goals and make informed decisions to change course when things aren’t working. Aurora Analytics provides visual dashboards and interactive reports to provide you with high-level and detailed data on how your community is performing. Note: Currently, users can see the metrics up to the previous day in Aurora Analytics.. Data is reported in Coordinated Universal Time (UTC). Accessing Aurora Analytics To access Aurora Analytics, open your Account menu and click Analytics. Note: Members must have anAdmin or Analytics role to access Aurora Analytics From the Analytics page, you can access Dashboardand Reports. The Dashboardprovides you with an “at-a-glance” view of the activities that best indicate the overall health of your community and member engagement across your community. You can customize Dashboard settings to your requirements and get the most out of your data analysis. Reports present you with key metrics on content, boards, categories, and members in a tabular format. Related topics: Accessing Analytics Dashboard Dashboard Settings Aurora Analytics Metric Definitions Aurora Analytics Reports Refer to the Khoros Communities Analytics Essentials course for training on Communities Analytics.Aurora: Extract member-specific information
If you have the Advanced Analytics role, when you schedule the Members report, you can choose the additional user information you want to download along with other member data available in this report. To download additional information from the Members report: On the Members report, open the Options menu and click Schedule Reports. Enter a title for the report and frequency at which this report must be generated and emailed to you. Choose from the list of member specific data provided under Include additional user data. Click Submit. The data that you choose is extracted along with the other fields in the Members report. Related topics: Schedule Analytics reports to be emailed to you View scheduled reports Download reportsAurora Analytics Reports
The article provides an overview on how to access reports configure reports download reports schedule reports Accessing the Reports page To view the list of available reports: Go to your Account menu and click Analytics. Click Reports. The Reports page opens. Next to each report name, you can see a brief description of the contents for each report. Click a report name to view a report. Here’s a Forum report: Modify settings for a report You can customize report settings to display the exact data you're looking for. Specifically, you can scope reports to a specific place and time period. To scope a report to a specific place: Open a report. Open the Options menu and click Report Settings. Select a specific place (board or category): Click Save. The Forum report shows the Place selected (in this example, the Products category) and displays the metrics for the Forums under the selected place during the selected date range. To scope a report to a specific date range: To view data for specific date ranges, you can select the date range using the dashboard date-range menu. Select one of the following from the menu. By default, the date range is set to Last 30 days for all reports. Here’s an example of a Forums report for the Last 7 days under the Product category: Learn more about date range settings Download reports You can download and analyze data by exporting them to a CSV file. Members with Admin and Analytics roles can schedule reports and have them emailed to them. Notes: Aurora Analytics report exports include up to 2000 rows. In cases where there are more than 2000 rows in a report, only 2000 rows will be exported and the rest will be truncated. Scheduled reports allow for the download of up to 50,000 records. Schedule reports You can schedule reports to be generated and emailed directly to your registered email ID. You can also view the reports that are scheduled to be generated. Understanding Aurora reports To understand the structure of these reports, let's explore a Forums report. All reports share this general structure. In this example, we’ve chosen the “Products” board and have selected to view the metrics for the Last 30 days. The Summary section at the top for the report provides a quick glance at key traffic and engagement metrics. Depending on the report you view, the metrics shown in the Summary section will vary. Learn more about what each of these metrics means. Below the Summary section, the report is displayed in a table. You can view a maximum of 50 records. If there are more than 50 entries, you can export and download the report as a CSV file. In this example, summary metrics are broken down to show the metrics by board. By default, the report is sorted by the number of Page Views. To reverse the sort order (ascending or descending) of a column, click the metric in the heading. To sort the report by a different metric, click the name of that metric. For example, to sort this table by Likes received, click Likes in the header row. Related topics: About Aurora Analytics Dashboard Settings Schedule reports Aurora Analytics Metric DefinitionsAurora Analytics Dashboard Settings
Depending on your role or what actionable data you are trying to gather, what you need from your community dashboards may vary. With Aurora Analytics, you can customize Dashboard settings to your requirements and get the most out of your data analysis. Analytics users can: customize Aurora Analytics Dashboard settings to scope data to the entire community or to a specific place in the community choose the time frame for which they want to view metrics for compare and analyze data with another time period set the parameters for trending discussions. set parameters for the maximum time limit to apply in the Ideas by Age Chart Related topics: About Aurora Analytics Aurora Analytics Metric Definitions Aurora Analytics ReportsAurora Analytics: Idea Status Set trend
TheIdea Status Set trendwidget on the Ideas Dashboard (Options menu>Analytics>Dashboard>IdeasDetails) displays the change inStatus Sets and Statusesof ideas. Idea Status Set/Idea Statuses: When the dashboard isscoped to the communityor to a Group, the widget shows the trend along with the breakdown of ideas based onIdea Status Set. When the dashboard is scoped to a specific Idea board, the widget shows the trend along with the breakdown of ideas based on theStatusesdefined for that board.Aurora Analytics: Engagement drill-down views for Content types
Let’s take a look at how to view engagement data for Forums. In the Forums Details dashboard, click the point on the graph for the date you want to see the drill-down view of Discussions, Replies, and Likes. A window appears that displays the number of discussions created during the selected period and their location in the community, the number of discussions created during the previous period selected in the dashboard settings, and the percentage increase or decrease of the number of discussions created between these periods. You can also view these metrics at the board level: Select Replies to see the number of replies received for the selected period and location along with the number of replies received during the previous period and the percentage change between these periods. To view these metrics by board, select View by boards. To view these metrics by drilling down to the discussions, select View by discussions. Select Likes to see the number of likes received for the selected period and location along with the number of likes received during the previous period and the percentage change between these periods. To view these metrics at the board level, select View by boards. To view these metrics by drilling down to the discussions, select View by discussions. Similarly, you can see engagement for Blogs: Similarly, members can also view engagement data for ideas, comments, and votes. In the Ideas Details dashboard, click the point on the graph in the Ideas Engagement widget for the date for which you want to see the drill-down view of Ideas, Comments, and Votes. You can also view these metrics at the board level: Similarly, you can see engagement data for comments and votes for ideas on the community. You can also view these metrics by board and by ideas. Related topics: Aurora Analytics Dashboard Settings Aurora Analytics Metric DefinitionsAurora: Download reports
You can download analytics data in a couple ways: Export to CSV Download scheduled reports Export to CSV You can download and analyze data by exporting it to a CSV file. To down the report, go to the report you want to download and click the options menu. Then click Download Report Note: CSV exports include up to 2000 rows. In cases where there are more than 2000 rows in a report, only 2000 rows are exported and the rest is truncated. Download scheduled reports After a scheduled report is complete and ready, you will receive an email notification. The report is attached as a CSV file in the same email. You can also download the report from Analytics Reports page by following the steps below: Go to your Account menu and go toAnalytics >Reports. Click Download to download the report. If there is more than one report ready to download: ClickDownload. From here, you can download each report separately. Note: For scheduled reports, you can download up to 50,000 records. In cases where there are more than 50,000 rows in a report, only 50,000 rows are downloaded and the rest is truncated. Related topics: Schedule Analytics reports to be emailed to you View scheduled reports Advanced Analytics Role to extract member specific informationAurora: View scheduled reports
To view all schedules at each report level: Open the report you want to schedule. Click the Options menu Click View Scheduled Reports. The Scheduled Reports window appears. You can view the statuses of every report that was scheduled for that report level. To view schedules at all Report levels: Open the Reports listing page. The Schedule Status column gives you the schedule statuses of all reports at every report level in one glance. Possible scheduled report states include: Waiting: When a report is scheduled for the first time, the Status shows Waiting along with the date on which the report is due to be delivered. Processing: After the data collection commences in the background, the Status changes to Processing. Download: When the report processing is complete and data is ready, the Status changes to Download. Click Download to download the report on your device. Failed: If a schedule fails for any reason, the Status changes to Failed. Receive the reports on your email: After a schedule is complete, the report is directly sent as an attachment to your registered email address. Related topics: Schedule Analytics reports to be emailed to you Download reports Advanced Analytics Role to extract member specific informationAurora: Schedule Analytics reports to be emailed to you
Members with Admin and Analytics roles can schedule reports and have them emailed to them. Note: Scheduled reports allow for the download of up to 50,000 records. To schedule a report: Open the Account menu and clickAnalytics. Click Reports. Click the name of the Report for which you want to create a schedule. In this example, we clickCategories. The Categories report page opens. Open the Optionsmenuand click Schedule Report. The Schedule Report window appears with a default title for the report. Enter a new title for the report and select the frequency at which you want the report to be generated and sent to your email. In this example, we select Daily. Click Submit. A success message appears on the top-right corner of the page to indicate that the schedule is created. Similarly, you can schedule reports to be sent to you on a weekly and monthly basis. Frequency of schedules: Daily: The report contains data from the previous day. Weekly: The report contains data for the previous 7 days and will be available on the selected day of the week. Monthly: The report contains data for a calendar month and will be available on the 1st day of every month. Note: When you attempt to schedule a report using a Report Title that already exists or when the same report is already scheduled, the following error message appears. Related topics: View scheduled reports Download reports Delete Scheduled reports Advanced Analytics Role to extract member specific information
