A list of some helpful tools to ease your pain:
1) Google Data Studio – there are some GREAT pre-built templates, easiest to implement when just pulling data from Google platforms. Free. If you want to get fancy, check out SuperMetrics add-ons.
2) I just spent $49 and got lifetime access to a tool called Oviond – this was an AppSumo deal, so not sure it is still live. Anyhow, amazing cost to value ratio and can integrate with most popular ad platforms. Clunky builder, but once you get the templates set up, you can automate them. Compare that price to what I was using before – Report Garden – and now it feels like I was being robbed blind all those months!
Hope that helps!