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.

The text above is a summary, you can read full article here.