How do you guys prepare boring client reports in agency ?

Hi all,

So i joined this SEO/Marketing small agency. Handling 3 clients right now, running their ADs, keyword research and all. I have to generate Weekly reports, every Friday and sent them before 3 . It is really boring work. Sometimes it takes me 2-3 hours to take a screenshots, apply filters on data and all . I was thinking what other peoples are using? any tool or suggestion or anything that i can improve this part ?