Send a weekly report to Slack with an overview of the week's metrics

[reichert621]

Problem
A few things:

• Users want to see metrics from Papercups more regularly
• Users want to be able to stay in Slack as often as they can if possible
• Users want to be reassured that their Slack integration is working as expected

Solution
Let's create a job to run every Friday that does the following:

• Finds every account with an active Slack integration
• For each account, pulls metrics for the week, including:
  • Number of new conversations/messages
  • Average/median response/resolution time
  • Maybe number of unique users who sent messages?
  • (See reporting dashboard for ideas of other metrics to include)
• Send these metrics to the connected Slack channel as a formatted message

Additional context
One important part of these feature is reassuring our users that the Slack integration is still working as expected. Maybe for certain users it would even make sense to send a daily report to Slack? (For now let's just start with weekly)

Testing
The reporting metrics should include test coverage if any new queries are added!

Questions, or need help getting started?
Feel free to ask below, or ping us on Slack :)

(You can also check out our CONTRIBUTING.md)

[mikermcneil]

@reichert621 re: whether to start with a threshhold on # of conversations: I'd be ok with it getting sent regardless, especially if it had useful information. Users with high volume might be more annoyed if it didn't have the information.

Main concern this would alleviate is the "Oh crap are my chats still coming through into Slack? Am I missing something?"

[reichert621]

makes sense, thanks @mikermcneil!