A couple of years ago I wrote a post about how to create an SEO dashboard in Google Docs by using theMozScape API and the Google Analytics integration with Apps Script in order to have the most important data regarding the organic search performance and link popularity of a site in a single place, that we could easily share and refresh.
Unfortunately as time passed the rise of not provided killed the capacity to get keyword data from Google Analytics, -we have been forced to use Google Webmaster Tools instead, along third party sources such as SEMRush, SearchMetrics or SimilarWeb-; and the dashboard was not as useful as before, it needed to integrate keyword data from one of these new sources.
In order to look for a solution I played with Supermetrics, as I saw I could pull data from both Google Analytics and Webmaster Tools, but I was not convinced by it since it was still not flexible regarding the integration of data coming from different sources in a single sheet and the ability to easily refresh it all at the same time -especially if I needed to pull additional link popularity data with the MozScape API.
