SERPs Competitor Scraper Tool – Quick Raw Analysis Using Excel

Keyword research isn’t just about search volume. Knowing which terms you should give priority when optimizing can help save you time and creative juice writing good content. But competitive analysis can be a daunting task, even intimidating for the non-savvy. Continue reading SERPs Competitor Scraper Tool – Quick Raw Analysis Using Excel

Google Analytics Data on Geckoboard Custom Widgets via Google Docs Spreadsheet

About a month ago, I came across Bill French of iPadCTO (a really, really cool person by the way) who wrote on the Geckoboard Blog, April last year, about how Google Docs can be used to provide real-time data for Geckoboard custom widgets. With further modifications, the approach really proved its use in monitoring site metrics at a glance through Geckoboard dashboards though back then we had to manually update or “hardcode” the metric values from Google Analytics daily.

Enter Jamie Steven of SEOmoz who wrote on their blog, October last year, about using GA Data Feed API to fetch data from Google Analytics to Google Docs. To quote him: “Realtime Google Analytics data inside a Google Doc—a panacea!” Indeed. AutomateAnalytics.com’s Mikael Thuneberg was the person behind the nifty app script that drives the whole fetching process.

With the two methods now at hand, I thought to myself: hey, how about a combination of both? Aha! Automation. Continue reading Google Analytics Data on Geckoboard Custom Widgets via Google Docs Spreadsheet