How to easily create an SEO Dashboard using DashThis
A couple of years ago I wrote a post about how to create an SEO dashboard in Google Docs by using the MozScape 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.
I also tested the lately popular Dashboards services, which would facilitate the different data sources integration and their web share-ability: Geckoboard, Ducksboard, Leftronic and Cyfe. Nonetheless, they’re not online marketing focused, and only Cyfe supports Google Webmaster Tools but does not give the query and pages visibility impressions, clicks or average position specifically; but a “rating” (which I’m still wondering how it’s calculated) for the keywords.
I retook my search for a solution a few days ago since now with my own SEO consulting have the need to easily monitor and report to clients and then discovered an online marketing focused reporting solution called DashThis.
DashThis works like the above mentioned Web based dashboard tools but supports Google Webmaster Tools, Google Analytics, Moz, Facebook, Twitter, Instagram, Twitter, Google AdWords, Mailchimp, ComScore… among others.
The first thing I did was to put together a similar dashboard than the one I had created before in Google Docs: With the top organic search keywords, landing pages and external links related data from Google Analytics, Google Webmaster Tools and Moz, which I connected through the Authorizations panel:
This is the result of the dashboard I created, for which I could select the time range (day, week, month and year), the graphic type from a couple of available options (there’s still room for more here) and the elements organization, personalizing the logo and title:
The dashboard is shared online by default but its access can be controlled by using IP filters -it would be great to have a multi-user, read only option here to clients only with certain clients specifically-, and can be also shared by email and downloaded as PDF.
As the tool allows the integration of many other data sources, like Twitter, Facebook or Mailchimp; I created an online marketing dashboard with this additional data, that you can see here:
It would be great to have the integration of more keyword related data sources such as the ones of SEMRush or SimilarWeb, link related with Majestic, crawling related issues or alerts from Google Webmaster Tools, the flexibility to feature more metrics and personalized segments from Google Analytics for example, and to display and organize the dashboards in even more ways; nonetheless, it’s already a better looking and scalable alternative than the Google Docs dashboard.
Of course, all this comes with a price, the tool is not free and has different plans starting with $39 for 3 dashboards… which can be somewhat not cheap if you have many clients (as a disclaimer I should say that I’m still using the trial account at the moment) but if you have some very specific needs as I do, this can be a good alternative to have.
If you know of other dashboards tools that offer similar functionality let me know in the comments, it would be great to have another alternative!