Manual reporting follows a pattern: someone collects numbers, pastes them into a message and sends it on a schedule. Each step can run on its own.
Start with the weekly digest. Then add an alert for churn above your threshold and a task for every new trial that goes quiet.
Keep every automation small and give it a clear owner. A small rule that runs for a year beats a large one that nobody trusts.