@Joe_F did @lilly’s answer help you? If so, can you mark it as the solution?
If not, let us know what you’ve been trying and where you are getting stuck.
I like @pfaffman’s idea too, to create a data explorer query that is run via an automation weekly to send the report via PM. I had a poke around here and did not immediately find that such a query already exists that you can use.
As a hosted customer, you can reach out to team@discourse.org too if you need a more timely and personalized response from our team.