Authorized users:
Authorized users:
Authorized users:
Set Up Keyword Rank Tracking – Lil Assistance

Set Up Keyword Rank Tracking

by | Sep 17, 2022

🎯 What’s the goal?
Monitor your Search Engine Ranking Position.
⚠️ Why does it matter?
To measure the success of your SEO Strategy.
🏁 What’s the result?
Your most important keywords are monitored daily.
⌚ When do you do this? 
When you start to implement an SEO Strategy.
βœ… Any special requirements?
πŸ™‹β€β™‚οΈWho should do it?
The person in charge of SEO and Analytics.

πŸ‘‰ Where this is done: Google Search Console / Sheets or tools such as SERProbot or SEO Buddy.

⏳ How long will this take? about 15 minutes

Let’s get started.  In less than 15 minutes you’ll start to
efficiently monitor your Search Engine Ranking Position 

Environment setup:

  • We recommend that you use the Google Chrome browser to navigate the web.
  • Access to your Google Search Console / Google Sheet
  • Optional: an SEO Buddy or SERProbot account.

Find all your ranking Keywords using Google Search Console

  • Click on β€œStart now”.
  • Sign in with the Google Account associated with the GSC Account of your Domain.
  • Make sure that you set the property which you want to check (upper left corner).
  • Choose β€œPerformance” from the left side menu.
  • Here you can find all the Queries for which our domain ranks, as well as the number of β€œClicks” for each keyword. As you can see, we have a total of 844 results here.

In the next part of this SOP, we will show you a more efficient way to generate reports from this.

Generate a report using a free Google Sheets Add-on

  • Click β€œ+” to create a new spreadsheet.
  • Then from the upper menu choose β€œAdd-ons”, then β€œGet add-ons”.
  • The Marketplace will open. Now you need to search for the desired add-on
  • We are looking for the β€œSearch Analytics for Sheets” add-on.
  • Once you will find it, click on it.
  • Then press β€œInstall”.
  • You need to β€œAllow” add-on to access your Google data.
  • Finally, click on β€œDone”.
  • Back the blank Google Spreadsheet
  • Navigate to β€œAdd-ons”, then β€œSearch Analytics for Sheets” and β€œOpen Sidebar”.
  • Wait for the add-on to open.
  • Now there should be a β€œSearch Analytics for Sheets” sidebar on the right side:
  • Start selecting a β€œVerified Site” associated with your Google Search Console account 
  • Set a desired β€œDate Range”.
  • Make sure that β€œSearch Type” is set to: β€œDefault (Web)”.
  • Choose β€œPage” and β€œQuery” in the β€œGroup By:” module:
  • Make sure that β€œAggregation Type:” is set to β€œDefault (auto)”.
  • Choose the value for β€œRows returned:”. Use β€œEverything” only in case your site is relatively new. Otherwise, we recommend you select β€œ1000 rows” here for accurate yet not overwhelmingly long results.
  • Select β€œCreate New Sheet” for β€œResults Sheet:”. It will help in the following steps.
  • Once everything is set, click on β€œRequest Data”.
  • You will see a confirmation message:
  • And your results will be added to your spreadsheet.
  • Select one of the cells on the data table.
  • Then press β€œCtrl + A” on the keyboard in order to select all of the data.
  • Now click on β€œData”.
  • Then press on β€œPivot table”.
  • Make sure that β€œNew sheet” is selected and press on β€œCreate”.
  • Now a pivot table will appear in the new sheet. Click on β€œRows”.
  • β€œPivot table editor” will open on the right side of the spreadsheet. 
  • Click on β€œAdd” next to the β€œRows” category.
  • Choose β€œPage” from the drop-down list.
  • Click on β€œAdd” again and this time choose β€œQuery”.
  • Repeat this one more time and add β€œClicks”.
  • You just added: β€œPage”, β€œQuery” and β€œClicks” to your pivot table.
  • Deselect β€œShow totals” for each one of your selections for a cleaner look.
  • The result is a report showing all your ranking keywords for each of your landing pages

Now that you have determined which keywords you are already ranking for,
you are ready to move to the next part of this SOP

Track your Keyword for free using SERProbot

  • Choose your region (or the region you want to check your keyword ranking).
  • Enter your domain name.
  • Enter keywords you want to check.
  • Once you set everything up, check the β€œI’m not a robot” box and solve the reCAPTCHA.
  • Then click on β€œCheck SERP Now!”.
  • Wait for the checking process to end…
  • …and you will be able to see the result at the top of the page.
  • You can compare your keyword with β€œTOP TEN” by clicking on it.
  • Click on β€œRUN SEARCH” …
  • …and you will be redirected to Google Search results for your keyword with some additional data.

Track your Keyword using SERProbot (Paid Version)

  • Fill in the registry form with your β€œEmail” (1). Come up with a β€œPassword” (2) and confirm it (3). Finally, solve the reCAPTCHA to confirm that you are not a robot.
  • Click on β€œCreate Account”.
  • Make sure that you check your mailbox and confirm your email for SerpRobot.
  • After creating your account, you will be granted with free 14 days of access. After that, if you want to continue using the SerpRobot tool, you will have to choose a payment method by clicking on the β€œHire a paid SERP bot!”.
  • After confirming your email, click on β€œ+ New project”.
  • Start with naming your project and entering your domain name.
  • Fill in the keywords you want to check. By clicking on β€œ+ add another keyword” you will create another box for more keywords.
  • Choose the desired region.
  • Once everything is set up, click on β€œAdd project”.
  • Click on your newly added project on your account main page.
  • And there you have your ranking results for selected keywords.

Set Up Keyword Rank Tracking with SEOBuddy (Paid Option)

  • After signing in, enter your dashboard by clicking on β€œDashboard”.
  • Choose β€œKeywords” from the left side menu.
  • Click on β€œ+” in the upper right corner to add new keywords.
  • Type in the desired keyword or more of them into the box and click on β€œAdd Keyword(s)”.
  • The newly added keyword will be displayed in your keyword list…
  • …with all the ranking data, you need right next to it.

That’s it! Now you have BOT monitoring daily your Search Engine Ranking Position!

You can finally measure the success of your SEO Strategy for each of your keywords.

Set Up Keyword Rank Tracking

🎯 What’s the goal?Monitor your Search Engine Ranking Position. ⚠️ Why does it matter?To measure the success of your SEO Strategy. 🏁 What’s the result?Your most important keywords are monitored daily. ⌚ When do you do this? When you start to implement an SEO Strategy. βœ… Any special requirements?N/A. πŸ™‹β€β™‚οΈWho should do it?The person in charge […]
You May also Like: