seamlessly fetch Google Analytics data into excel and allow us as analyst to do more analysis.
We started with very raw versions of macro that pulls GA data into Excel and slowly built up a nice App which makes our life easier as an agency. We are kicked about the fact that it got covered on Google’s blog and we are passionate to make this tool better in future and indebted for the help & overwhelming feedback that we have received from customers.
Now that we have made it quite good, we are hoping that this will make other agencies life easier as well !
We initially focused it to be reporting focused and now we are adding more features that helps actually analysis and how can it use the analysis capability of excel.By this blogpost , I basically wanted to show the features that we have implemented and in later blog posts, I will cover as how can you utilize this tool.
Here are some of the salient features that we have for our tool :
Support for Both Excel 2007 and Excel 2003
Tatvic Google Analytics Excel Client works with both the version of the Excel. This tool is very easy to install and it creates an Add-in for your Microsoft Excel. Since it is based on the simple macro, it doesn’t need any other compatible software as well.
Take input from a Cell in Excel
Often power users of web analytics tools want the reports to be updated really quick. Excel is the best tool when such need arises. With our Google Analytics Excel Plugin, you can set up a dashboard in excel inserting dates via cell reference. This categorically helps when the dashboard is required for a different time duration, power users can change the data and refresh the data.