A dynamic dashboard to measure effectiveness of different channels

I own an online retail website, and I am looking for a dynamic dashboard where I can insert some figures monthly, and it calculates… even better would be an extension for Magento 1, that automatically inserts these figures in.

So, a tool that calculates:
channels sales, ROI
KPIs for online business (nr of visitors, return visitors, orders, basket size, etc)

Something in Google sheets, perhaps?