Don't get me wrong - the insights are brilliant.
Just understanding what kind of title tags they use, or what keywords they throw in is a great indicator of how they look at themselves in the market.
But going into page after page, looking for meta was just plain painful.
Until I realized the magic of the "ImportXML" formula in Google Sheets.
This little magic bullet lets you parse the contents of any webpage/ site and create your own nifty little SEO tracker.
How it works: The core formula you'll need is "ImportXML ", which takes 2 parameters - the URL, and the Query.