Tracking with Google Sheets is it worth it? Then Google the selected keywords and enter the data into the spreadsheet. To do this open a new window in Chrome and go to File > New Incognito Window. It’s not perfect but will give you an average idea of their rankings by looking at their search engine results pages. If you don’t have Google Seach Console as it’s not set up or you are looking at a competitor’s site you can use Google incognito window. You can also use the export tool if you want to save a bit of time. As you enter this data in you will start to understand it more and when you are ready can take the plugin into a paid tool. You can even dill down on a page or blog post and check google’s position for a keyword or check a website’s position on a keyword as a whole.Ĭontinue to add columns for each day, week or month. Once you have this data you can plug it into the spreadsheet. If the Google search console is set up (previously Google webmaster tools), then select your website and click on search traffic performance to see your website’s search results and check google position by keywords.įrom here you can select the pages, devices, queries (and check google rankings in each) etc that you want to track SERPS for.įor this example, we will just look at desktop results in the UK for the query “SEO tips” (google position keyword)Īfter this, we can set the date range as this week, last month or over a 3-month aggregate. There are many tools that can automate this but sometimes it’s good to strip everything back. Once you have your keywords entered, it’s time to set up the SERP tracker information. For this example, we’ll use “SEO tips”, “SEO tools”, and “SEO trends”. In the cells below these headers (A2 and B2), start typing in the keywords that you want to track. This is going to be our second column header. Now, in cell B1 type “Rank” (again, without the quotations). This is going to be our first column header. Next, in cell A1 type “Keyword” (without the quotations).
There are many other options around but sometimes the number of options that these tools have can confuse an SEO newcomer.įirst, you need to create a new sheet and title it whatever you want. This will allow you to track your keyword rankings over time without any fancy software. If you are just getting started in SEO, only tracking a few keywords for a small site you may want to start with Google sheets – rank google checker. He was discussing some of the paid ranking tools and how overwhelming they are and we suggest stripping everything back so that they understood the theory before jumping into a full-fledged tool. This week we were in Lady Green speaking to someone who was learning SEO.
0 kommentar(er)
