If you run a lot of ads, that means your store is doing well... congrats!
I actually was experiencing the same issues, so we built a tool that automate reporting across all marketing channels.
We have over 50+ Shopify brands using the service and saving an average of 2.4 days a month.
You can try it here: https://www.polaranalytics.co. Feel free to schedule a demo if you want to learn more about it.
I think you'll find great value by adding the BeProfit - Profit Tracker app to your Shopify store. BeProfit takes into account a broad array of data points to help you track and analyze your business's profits & expenses, including marketing (Facebook Ads/Google Ads/etc.), shipping, production, and more.
You can use BeProfit to:
Give it a try, it might be your new favorite app!