Weekly active slack users

[pnadolny13]

With our slack plan its possible to see how many active users we have but we cant see who they are. We want to be able to reach out and schedule users interviews for feedback.

Right now extract data using tap-slack but its only a small subset right now. Do the following:

• extract public channels/threads. Potentially addressed by https://github.com/meltano/squared/pull/264 already
• aggregate weekly active users
• compare numbers against whats in the slack admin page for validation
• Expose the active users list

[tayloramurphy]

@DouweM do you have access to Snowflake? Once we get the data in from https://github.com/meltano/squared/pull/264 it might be reasonable for you to just write a quick query to get a rough list of users who have posted in the pas X weeks rather than have Pat dedicate too many cycles beyond what he's already doing. My thinking in this is that if your specific goal is to ahve a clearer list of people to reach out to, we can get a rough estimate of that with some point in time queries instead of investing in this for the longer term.

[DouweM]

@tayloramurphy Totally works for me. I do have access to Snowflake.