{"product_id":"seo-keyword-rank-tracker","title":"SEO Keyword Tracker Spreadsheet","description":"\u003cp\u003eThis SEO keyword tracker is for small business owners and bloggers who check their Google ranking once a month. List the searches you want to be found for, then type where each one ranks, and the file shows the latest position, the change since the last check, the best it has been and whether it is on page 1.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003ePick any keyword group and the page follows. It fills itself from your checks.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eKeywords on page 1 now, and at the first check\u003c\/li\u003e\n\u003cli\u003eTop 3, the rest of page 1 and page 2, check by check\u003c\/li\u003e\n\u003cli\u003eA shaded rank map of your biggest keywords, one position per check\u003c\/li\u003e\n\u003cli\u003eKeywords just past page 1, biggest searches first\u003c\/li\u003e\n\u003cli\u003eWhich target pages bring the searches on page 1\u003c\/li\u003e\n\u003cli\u003eKeywords that moved down, the biggest moves up and down, and where everything ranks from the top 3 to outside the top 100\u003c\/li\u003e\n\u003cli\u003eThe searches your page 1 keywords get, at each check\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eA year of checks, colored\u003c\/h2\u003e\u003cp\u003eThe Keywords tab holds each keyword with its target page and how many people search for it, which is where your keyword research lands. Rank History has a column for each month's check: dark green is the top 3, green is page 1 and amber is page 2. Every keyword shows the change since the last check, since the first check, and its best position.\u003c\/p\u003e\u003ch2\u003eWhat moved\u003c\/h2\u003e\u003cp\u003eThe Movers tab lists the biggest climbs and drops since the last check, and every keyword that came onto page 1 or fell off it. Keywords almost on page 1 are listed with the biggest searches first: the ones most worth working on.\u003c\/p\u003e\u003ch2\u003ePage by page\u003c\/h2\u003e\u003cp\u003eEvery page on your site appears with the keywords it ranks for, how many are on page 1 and its best position, which keeps your website seo work tied to real pages.\u003c\/p\u003e\u003ch2\u003eSix connected tabs\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Keywords, Rank History, Movers and Dashboard. Think of it as a simple rank tracker in a seo spreadsheet you own.\u003c\/p\u003e\u003ch2\u003eLight and dark editions\u003c\/h2\u003e\u003cp\u003eEvery download includes a light edition and a dark edition. Every tab is restyled, not only the dashboard, and both run on the same formulas, so you simply pick the look you prefer. Each edition comes filled with a worked example and as a blank copy, in Excel and in Google Sheets.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you take a copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eLight edition: the Excel workbook filled with a worked example (42 keywords and a year of monthly checks for a roofing company), and a blank one\u003c\/li\u003e\n\u003cli\u003eDark edition: the same two files in the dark design\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (light and dark, filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. They are for personal and business use on your own devices, so please do not share or resell them. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eCan I use it in Google Sheets instead of Excel?\u003c\/h3\u003e\u003cp\u003eYes. The download includes Excel workbooks for Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.\u003c\/p\u003e\u003ch3\u003eDoes it check my rankings automatically?\u003c\/h3\u003e\u003cp\u003eNo. Once a month you type where each keyword ranks, and the file works out the change, the best position and whether it is on page 1.\u003c\/p\u003e\u003ch3\u003eHow are the positions colored?\u003c\/h3\u003e\u003cp\u003eDark green marks the top 3, green the rest of page 1 and amber page 2, so a year of checks reads at a glance.\u003c\/p\u003e\u003ch3\u003eWhich keywords should I work on first?\u003c\/h3\u003e\u003cp\u003eThe file lists keywords just past page 1 with the biggest searches first, which are the ones most worth working on.\u003c\/p\u003e\u003ch3\u003eWhat is the difference between the light and dark editions?\u003c\/h3\u003e\u003cp\u003eOnly the look. Both have every tab restyled with the same formulas, and both come with every download.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597875347550,"sku":"OPX-232","price":16.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/seo-keyword-rank-tracker-01.jpg?v=1790833252","url":"https:\/\/opxviashop.com\/products\/seo-keyword-rank-tracker","provider":"OPXVIA","version":"1.0","type":"link"}