Paste The First Url Into The Lightbox. Click Apply.select Queries From The Table Menu And Click Export To Google Sheets.in Your Exported Google Sheet, Sort The Queries By Impressions (See The Sorting Instructions In The Previous Step For A Refresher On How To Do This).repeat This Step For Each Of The Urls. Your Master Google Sheet Should Now Have Tabs. Apply Conditional Formattingconditional Formatting Is A Set Of Rules You Can Use To Analyze Data On A Spreadsheet. Use It To Identify Keywords You Want To Focus On.
For Example, I Applied This Formatting To The Average Position swedish phone numbers Column With The Following Conditions:highlight Rows With Average Position Of Or Lower In Green.highlight Rows With Average Position Between And In Yellow.highlight Rows With Average Position And Higher In Red.you Can Apply Conditional Formatting To A Column Or A Single Cell. Select Format On The Main Menu And Click On Conditional Formatting.i Applied A Similar Set Of Relevant Rules For Each Of The Four Columns Detailing The Metrics. Access This Template, Which Already Includes These Rules (I.
E., Conditional Formatting) For Your Analysis. Analyze The Resultsthe Spreadsheet Now Colorfully Displays Your Keyword And Content Opportunities Using A Traffic Signal Approach. Look At The Green Opportunities First, Followed By Yellow And Finally Red.take Time To Look For Effectiveness Of Your Targeted Keywords, Surprising Keywords, Patterns (E.g., High Impressions But Low Ctr), Etc.let Me Give You Two Examples Of How You Might Use The Information:if A Phrase Is Ranking On The First Page And Has A High Number Of Impressions But A Low Ctr, Optimize The Page’s Metadata To Attract More Clicks.