There’s no reason all that granular data would be used to calculate a leaderboard. It can be rolled up in advance and for leaderboard purposes most of it can be ignored.
Parallelism along the location, customer and activity dimensions makes this an easily reducible problem.