This is so accurate, it feels as if our actual customer wrote it :)

We helped many agencies to automate reporting the way you described: https://www.narrative.bi/solutions/agencies