How to track user activity?

To increase user activity, we plan to hold a challenge, who is the most active user in our forum, to be rewarded.

Therefore, we wanted to get some additional data, to make the challenge even more interesting.

The data we have, using the query from @simon is Topics, Posts, Words Count and Likes Receive

Some additional data include:

  • Likes Given: How many likes were given
  • Visit: How many times the user opens the forum
  • Read Time: How long the user is in the forum
  • Following and Followers
  • Topics View: How many topic views the user gets for all the topics he created..
  • Topics replies: How many replies (posts) the user gets for all the topics he created..

Please help us, so that we can get these additional data.

For the weighting of each item, we plan to use excel. Is there any advice on how to weight each item to choose the winner?

We want to make this challenge serious but fun. The best users are the combination of most active, most helpful, and most popular. :partying_face: :partying_face: :partying_face:

Once again, thank you very much for your help.

Note: Can we get the data in groups, so we only enter the group id. Our plan is that we will put all participants into a group. This time, we have to enter the participant’s user id one by one