Measuring Sense of Community

Hi Ditte,

Knowing the number of unique contributors can indeed give you a lot of interesting insights. You can even take it a step further to see how many unique contributors per forum or category and therefore see how certain forums are better to generate conversations in comparison to others.

Measuring the number of unique contributors per topic is easy to do using our exports. Simply follow these steps:

1) Download a Post export for the selected period you want to evaluate (we suggest to take at least 6 months of data)
2) Open the export and create a table in a new sheet, selecting all the Post data
3) Insert a Pivot Table and make sure to check the box Add Data to model as appears below:

4) Once you do that all the following fields to your pivot table:

5) To make the Distinct Post Creator field you simply need to first add the field post_creator
6) Click this field on your Pivot Table Fields and the click on Value Field Settings

7) Under Summarize Field by choose Distinct count as appears below:

😎 You are done and your pivot table is ready! You can now see the number of unique contributions per topic :)

Hope this helps and let us know what interesting things you find!