“Quick Overview” Keeping track of your website’s keyword rankings is an essential aspect of Search Engine Optimization (SEO). It allows you to monitor your website’s performance on search engine result pages and make informed decisions to improve your online visibility. In this blog, we’ll walk you through a step-by-step process to check keyword rank in Google Sheets using a simple powerful formula.
=CONCATENATE(“https://www.google.com.au/search?q=”,LOWER(SUBSTITUTE(TRIM(A2),” “,”+”)),”&near=melbourne”).
Let’s dive in!
Understanding the Formula
Before we proceed with the step-by-step guide, let’s break down the formula to understand how it works:
=CONCATENATE(“https://www.google.com.au/search?q=“, LOWER(SUBSTITUTE(TRIM(A2), ” “, “+”)), “&near=melbourne”)
This formula combines different functions to create a Google search URL that includes your target keyword and location.
Step 1: Set Up Your Google Sheet
To get started, open a new or existing Google Sheet where you want to track keyword rankings. If you don’t have one yet, create a new sheet and give it an appropriate title.
Step 2: Enter Keywords in Column A
In Column A of your Google Sheet, list the keywords for which you want to check the rankings. Enter each keyword in a separate cell starting from cell A2 (leave cell A1 blank for the title or any other information you may need).
Step 3: Enter the Formula
In an empty cell (for example, cell B2), enter the formula:
=CONCATENATE(“https://www.google.com.au/search?q=”,LOWER(SUBSTITUTE(TRIM(A2),” “,”+”)),”&near=melbourne”)
This formula takes the keyword from cell A2, formats it correctly, and creates a Google search URL. The “&near=melbourne” part of the formula sets the location to Melbourne. If you want to check rankings for a different location, replace “melbourne” with your desired location, or leave it out if you want a general search.
Step 4: Copy the Formula for Other Keywords
Once you have entered the formula in cell B2, you can use the fill handle (a small square at the bottom right corner of the cell) to copy the formula to other cells in Column B. Drag the fill handle down to apply the formula to all the keywords in Column A.
Step 5: Checking Keyword Rankings
As you copy the formula to other cells, each cell in Column B will generate a unique Google search URL based on the corresponding keyword in Column A. Now, click on any URL in Column B, and it will open a new tab displaying the Google search results for that keyword and location. The search results will reveal your website’s ranking for the specific keyword in the Google search engine.
Conclusion
Using the =CONCATENATE(“https://www.google.com.au/search?q=”,LOWER(SUBSTITUTE(TRIM(A2),” “,”+”)),”&near=melbourne”) formula in Google Sheets simplifies the process of checking keyword rankings. With this powerful formula, you can easily monitor your website’s performance for specific keywords in Google search results.
By regularly updating the data in your Google Sheet, you can analyze trends, make data-driven SEO decisions, and enhance your website’s visibility to attract more organic traffic.
So, start implementing this formula in your Google Sheets and take your keyword tracking to the next level today!
For step by step guide: https://youtu.be/ijZlnLNbwZI
