Question

Retrieve aggregated community statistics via API

  • 17 July 2020
  • 2 replies
  • 129 views

Hi, 

 

Is it possible to retrieve aggregated community statistics via the REST API?

Examples of the kind of queries I’m interested in include:

  • What are the most popular topics/questions on the site? (by views and/or replies)
  • What search terms/keywords are most popular?
  • What are the busiest times of day/days of week for users to be interacting with the platform?
  • Which users are the most active on the site (I think these stats can actually be obtained via the ‘Users’ API)?

Many thanks, 


2 replies

Userlevel 2
Badge +3

Hi,

thanks for sharing your question with us. As far as I know, it should not be a problem using the REST API. I know some communities who use it to show e.g. only the most viewed solved questions of a certain community category.

In general, our documentation should help you to figure out which metrics can be used in general. But maybe @tom.shaddock could check your examples and see if there is anything that we do not support currently.

And if you know which data exactly you would like to collect, please let us know so that we can advise if necessary.

Hi there so, 

  1. https://api2-us-west-2.insided.com/docs/community/#operation/getTopicList - can be used to retrieve and sort content based on the number of replies as well as the number of likes a particular topic has. If you look at the sort options for the call you should see how to query this via a GET request.
  2. This search data isn’t available via the api but can be obtained either by us providing an export of the data manually or through a third party script - an example of how to do this with Google analytics is here: 

     

  3. This kind of data might be better retrieved via another analytics tool e.g Google Analytics again as it provides a much more granular level of detail. At the moment it’s not available via the API.
  4. Yep you’re correct - the ‘lastActivity’, ‘posts’, ‘solved’, ‘topics’ and ‘followers’ fields on this endpoint https://api2-us-west-2.insided.com/docs/user/#tag/User/paths/~1user/get will allow you to create some cool algorithms to determine which users are most active on the community - the power users essentially. Alternatively this call: https://api2-us-west-2.insided.com/docs/gamification/#operation/allTimeLeaderboard will give you an already created ‘out of the box’ view of which users are most active.

Hope this helps, just let me know if anything isn’t clear!

Reply