Weekly leaderboard reporting

Absolutely crucial couple of usecase @Hannah Bailey, and currently we do not.

So it’s Download the ‘User Activity’ report for the month, Quarter, and stack em by points approach that falls on you.

With you in the queue for these features.

Ooo, done that, yes.

Hi, @Hannah Bailey! Thanks for tagging me, @anirbandutta.

I did some digging and there is no ‘native’ way of reporting on the weekly leaderboard. If you want a code-less solution, then I would recommend using @revote’s method of using the user dashboard and filtering by month/week. It will give you the usernames and point totals, which you can then use to build out a report (or whatever you need).

If you are willing to use the API, you could do it in a few different ways:

1. You could use the Get This Week’s Leaderboard API call, which will then return you the weekly leaderboard. I would suggest running this a day (or at least a few hours) before your leaderboard resets. This could then update a spreadsheet for you.
2. If you want to go beyond the week, you could run a script that does something like this: Fetch all users and then use the last activity date to filter for the last month. Then, use the user IDs to get their assigned points, by using the query parameter of the last month. With this data, you can create a monthly leaderboard for your monthly newsletter.

With all this being said, however, it may be worthwhile doing it manually for now, and then using the upcoming release of the Data Lake to get access to the data more easily in the future. As of my posting this, it is in closed beta, so I cannot comment on when it will be available to the general audience.

I hope this helps!