I would like to send sales owners a weekly report of their clients who have visited the web site. I could create a thousand reports, each with its own subscription, but that is unsustainable. I could create an alert, but that would generate an email for each client, and that would be overwhelming for the recipient. Is there some way to automate/tokenize this?
We don't have sales insight.
I'll tell you how we've rolled this out. But you won't necessarily feel like implementing it... while you wouldn't have to touch it after initial setup, it's certainly complex.
The main concern is you can't be sending high-volume activities like sending every single Send Email event in a webhook. This is b/c webhooks have a practical daily limit, in effect enforced by the speed of light... stay under 50K and ideally under 20K activities.
If you use slack, consider a slack bot that provides notifications in real time to each sales person