Quick overview of tool (video & references below):

This template provides instant and useful information for conducting keyword competitor research in a dynamic, easy to use Google spreadsheet. You type in a keyword and you get:
  • Top 10 links on Google’s SERP, and for each result:
    • Retrieves Title Tag, H1 tag, meta description
    • Number of outbound links
    • Identifies presence of facebook, linkedin, and/or twitter links
  • On a result by result basis, it returns:
    • Image info (links, alt descriptions, thumbnails)
    • Back link info (results from “link:” search on Google)

Link to google doc template (note: you need a google doc account, once you open it, under file, make a copy for yourself and begin editing!)