Check and export your Statistics data

Use the Statistics section to access key data about your community. It's an important tool to monitor performance, analyze user behavior and support your reporting needs.

Export data

Most charts and tables in the Statistics section can be exported in CSV or Excel format. The following steps apply to all exportable charts and tables, regardless of the section:

  1. Select a timeframe: choose a and an end date. Wait a few seconds for the data to load properly.

     


     

     

     

     

  2. Export the data: hover the graph or table, click the three dots, then click Export data.

     
  3. Choose export format: select your export preferences (we recommend the left or middle option).

Users

User-related data (Userview) is a key dashboard to take many actions. Access the dedicated article here.

Applications

This dashboard is specific to closed communities

In this dashboard, you can consult a graph representing the distribution of applications by status: Accepted, Declined, Pending and Waiting.

Gamification

Track performance related to Missions, Badges, Statuses, Roles and User detail related to gamification.

  • After selecting a period, no need to select the mission in this section. Missions are automatically displayed based on your selected period
  • Inactive missions are hidden but can be selected.
  • You can filter specific missions by ticking the box close to the relevant missions.

Use the comparison feature to analyze missions performance between two periods directly in the same graph. To do so, select a second time period at the bottom of the page.


You can export:

  • Missions performance
  • Badges, statuses, roles
  • User activity details (points, completed missions, earned rewards)

User activity detail 

In Statistics > Gamification > User detail, you can find user activity related to points, missions and rewards. To find user activity, follow these steps:

  1. Search the user by entering its email address or nickname
  2. Check for each user when the status, role, or badge was earned
  3. Check when the missions have been completed, and the number of points earned

For example: If a community member have more points than expected, you can export all its activities in the user details dashboard and sum up all the points won for the missions, badges or status in an Excel document. Then, you can reach to your CSM to remove the extra points from its profile.

Moderation

In this dashboard, you can track Moderated Users (flagged, blocked, banned users), Deleted Posts and Flagged Posts.

For each section, select the right time period at the top left, then move the computer mouse on the right to see the three dots option and export the data

Content of a Post/Comment deleted by the User

  • Head to Deleted Posts in the Moderation Section
  • Select the Date
  • Down the Graph, you can check the content of the deleted posts and comments

User of the Month

In User of the Month there are two sections:

  • Data: here you can access the data to help you select the member of the month. For each user, you can see the number of posts, comments, likes, tests completed, posts and comments validated, and score. You can export the data by clicking on the 3 dots available at the top right corner
  • History: you can see all the users chosen as members of the month in the past. You can export the data by clicking on the 3 dots available at the top right corner

Acquisition & Retention

This section is split into 3 pages:

  • Acquisition: users of both the community and the chat widget
  • Acquisition chat: users of the chat widget only
  • Acquisition BEP: community members only

If you haven’t implemented the chat widget on your website, data from the Acquisition and the Acquisition BEP tabs will be the same

Number of Users in the Community

  1. Go to the Stats section, Acquisition/Retention entry, Acquisition BEP tab
  2. After selecting dates, you will find the number of new users acquired over the period, the total number of users acquired since launch, and the total number of deleted users over the period
  3. You can see two graphs that allow you to see the acquisition numbers on a daily basis: move the computer mouse from left to right directly on the graph to check both the date and the number of the users acquired in a day

Difference Between Total Users (End Date) and Total Users (All Time)

Total Users (end date) Total users (all time)
Number of Users till the end date you’ve chosen in the Backend Corresponds to all the users registered on your community without taking into account the end date picked in the Backend

Interactions

 In this section you can find data related to Channels, Categories and Products. Find the detailed article about this dashboard here.

Demography

In this section you can find data about your community members demographics (age, location) and emails optins.

Total Number of Opted-In Users

Optins : Users that accepted to receive Emails from the community (manual sendouts, not to be mistaken with automatic notification emails)

  1. Go to Demography
  2. Select a date
  3. Check total number of Optins in the Section Optins
  4. You can also go the the User tab in the Stats icon, select the field “has user accepted marketing email”, click on the filter icon and select the “True” option.

Number of Users in a Specific Country

  • In demography you have three sections : Country, Town and BirthDate
  • Scroll through the section you want and apply the filter

Product Campaign

You are able collect data from previous product testing campaign in the backend. Check out candidates, testers, completion, review date, etc… Also filter by brand name and campaign then export your data

 

In the Application Custom Fields section, you are able to check how many users have responded to the custom fields when applying to test a product.

Filter this section by campaign and/or custom field then export your data.

 

In the Reviews Custom Fields section, you are able to check the answers provided by the testers when leaving a review (if you have created custom fields that your customers can answer to after testing a product).

Filter this section by campaign and/or custom field then export your data.

 

In the Targeted missions section, you will see data if you have created targeted missions linked to a product testing campaign.

 

Events

In Events section you will find two sub-sections:

  • Events
  • Registration list 

Total Number of Event Participants

  1. Go to Events
  2. The number of participants (members who registered to the events) will appear in the dashboard once you’ve chosen the start and end date of the Event
  3. You can also check how many posts, comments and likes the event got on the platform

Download List of Event Participants

  1. Go to Registration list
  2. Choose the start and end date of the event or select the event you’re interested in
  3. In the Backend, scroll though the page to check on the list
  4. Move the computer mouse on the right of the dashboard to see the three dots!
  5. Then click on the first icon to export the data

Contests

In this section, you can find data related to Contests, Posts, Participants, Quizzes / Polls and Comments. Find the detailed article about this dashboard here.

Emails

Marketing Email Performance

  1. Reminder: only members who opted into community emails receive these emails
  2. Select the type of emails you are interested in in the drop down menu
  3. By default, the stats are displayed on a daily basis
  4. On the right of the table, you can select the period of time you’re interested in and you can edit the frequency by selecting the “week” or “month” options

The export button is not available. If you want to do some reporting, copy paste the data to an Excel file

Questions

This data is available only if you’ve implemented the chat widget on your website.

Chat Widget Data

  1. Go to the Stats section, click on the Questions tab
  2. Select the right period of time on the right of the page
  3. Get access to some data such as the number of questions, answers, answer and satisfaction rates
  4. Move the computer mouse on the right of the dashboard to see the three dots!
  5. Then click on the first icon to export the data

Chatrooms

A chatroom-type channel needs to be implemented on your community to access data.

In that section you can see how many messages and emojis are sent on a daily basis in the chatroom and export data if needed.

You can also see the content of the chatroom messages.

If you want to do exports:

  1. Go to the Exports tab
  2. Select the right period of time
  3. Move the computer mouse on the right of the dashboard to see the three dots
  4. Then click on the first icon to export the data 

Socials

In this section, you can see on a daily basis the number of posts shared on social media using a specific hashtag.

After creating external actions and social missions, go to this section to know how many users shared social media posts using these external actions.

If you want to do exports:

  1. Select the right period of time
  2. Select the external action you’re interested in
  3. Move the computer mouse on the right of the dashboard to see the three dots
  4. Then click on the first icon to export the data 

Reviews

If you’re integrated with a review provider (BazaarVoice, Yotpo, PowerReviews…), you will be able to see on a daily basis the number of reviews shared by your community members on your website.

If you want to do exports:

  1. Select the right period of time
  2. Select the external action you’re interested in
  3. Move the computer mouse on the right of the dashboard to see the three dots
  4. Then click on the first icon to export the data 

 

 

FAQs


When I click on export data, the Excel file is empty

When exporting your data, please make sure to select the middle option and not the first one.

118.png

Also, make sure you’ve got the right date before exporting the data.

119.png

The graph is not loading, what can I do?

If you are unable to visualize the content/the graph in the analytics, please try one of the following:

  • Log out and log back in to the backend.
  • Check your internet connection.
  • Contact your CSM if the issue remains.
Am I able to export the charts in Excel as seen on the Backend?

It’s not possible to export directly the charts as seen on the Backend as they’re generated with PowerBI, but you can take a screenshot of the graph if needed!

Was this article helpful?
0 out of 0 found this helpful