Find the Keywords you Lost After Google‘s Algorithm Update

Google‘s algorithm changed in order to make web pages faster and more relevant. What some SEO experts are noticing is a decrease in searches that they have been tracking. The keywords they lost after the update were not just searching related, but also included word combinations that cannot be found on Google today such as “I love you mommy ” or “How many ounces are in half a gallon?

The “google analytics” is an important tool for marketers. It helps them to gain insights on their marketing efforts, and also helps them to measure the success of those efforts. The algorithm update that Google released has caused a lot of people to lose keywords after the update.

Consider the following scenario: 

It’s 8:30 a.m., and you’re sipping your steaming coffee while browsing Twitter. There’s a lot of SEO talk regarding a fundamental algorithm upgrade. You open Google Analytics, curious and suspicious, to see that traffic has decreased. You make a frowning expression. You launch your keyword research tool. Your scowl becomes even more pronounced. In your rank tracking tool, everything seems to be in order. You’re not sure which keywords on which sites have decreased, and you need to know before your client call at 10:00 a.m. What should I do?

That is the purpose of this tutorial. You may be creative and uncover keywords that you lost following the newest upgrade if you have Google Analytics, Google Search Console, and Webinomy. You may also want to check which keywords are causing increases, and you can do so using the same method. 

The first step is to determine which pages had significant increases or decreases in traffic. We’ll utilize the All Pages report in Google Analytics for this. 

1. Login to Google Analytics 2. Go to Behavior > Site Content > All Pages 3. Set your segment to Organic Traffic 4. Set your date range to only look at the period of time since the algorithm update affected your traffic

If your company is seasonal, you’ll want to analyze traffic year over year by using a date range comparison. You should compare it to the prior week if you don’t have seasonal traffic. 

Find-the-Keywords-you-Lost-After-Google%E2%80%98s-Algorithm-Update

It’s worth noting that we’re not concerned about sessions or pageviews. We’ve limited our section to organic traffic, so we’re just looking at entrances. Entrances is the number of times people visited your site via a given page or collection of pages; this signifies that these specific pages have undergone a change in rankings, either for the better or for the worse, as a result of the traffic entering that page through search. Because an user might come on a homepage from organic, then browse other pages on the site and raise organic sessions, even though they did not land on that page from Google, we do not utilize sessions or pageviews. 

So you can view your best performers, sort your table by organic entrances in decreasing order. This may need changing the default 10 rows to something a bit bigger, depending on your site. You may go up to 5000 rows, but we’re more interested in the biggest losses or increases, since many websites receive most of their traffic from the first 25 or 50 pages. Copy the URL of the page you wish to look at. 

1636642387_473_Find-the-Keywords-you-Lost-After-Google%E2%80%98s-Algorithm-Update

I’m going to Webinomy to find out what keywords are causing this unexpected surge in traffic. Open your website on the Dashboard or search for it in the search box. Select Organic Research, then Positions from the drop-down menu. Scroll to the bottom of the page, open the advanced filters, and match your filters to the ones in the picture below, then press apply. 

1636642390_584_Find-the-Keywords-you-Lost-After-Google%E2%80%98s-Algorithm-Update

This will give you a list of all the terms that your site was ranking for in Webinomy’s index, which is a useful list, but we’ll need to export it to Excel to compare before and after rankings. You’ll see that the column “last updated” has been transformed to a timestamp after it’s been exported. Select the cell next to the timestamp (on mine, this is cell N2) and type in the following formula:

=(((M2/60)/60)/24)+DATE(1970,1,1) 

Because the M2 is referring the timestamped cell, be sure to update the reference if you remove columns. Select Format Cells from the context menu of the selected cells, then go to the Number tab, pick Date from the left-hand sidebar, and then select the date type. Once you’ve clicked OK, you’ll have regular dates. 

Create a name for the column, such as “Last Checked,” then pick row 1, click Data on the top ribbon, and choose a Filter. Then, under the “Last Checked” filter, uncheck all of the dates since the change had an effect on your site. Because my site was not affected until August 3rd, this deleted all keyword rankings obtained by Webinomy after August 2nd.

You now have a list of all the terms you were ranking for before the algorithm upgrade in Webinomy’s index. Copy and paste the keywords into a new tab. Remove all columns except keyword, position, search volume, and last-checked date, and rename the tab PRE ALGO. These are the keywords you’ll use to acquire your new ranks in a position monitoring tool later, so you can compare changes before and after the algorithm upgrade.

Reopen your filter and invert the filter so that you are only looking at rankings acquired after the upgrade by Webinomy. Those should be copied and pasted into a new tab. Remove all columns except term, position, previous position, search volume, and date last checked from the tab POST ALGO and rename it POST ALGO. We can put a cell formula in a blank cell to =(previous position)-(position) and click enter to display the change in rank for each keyword after the algorithm update* since we have the current position, which was verified after the algorithm update, and the prior position as well. To indicate questions where I went up or down, I prefer to utilize conditional formatting. This allows me to check which keywords improved following the upgrade in real time. I’m looking for two things: climbing up on high-volume inquiries and going from page 2 to page 1. Simply flip your thinking and highlight the negative numbers if you’re looking for huge declines. 

1636642392_60_Find-the-Keywords-you-Lost-After-Google%E2%80%98s-Algorithm-Update

This data reveals that following the change, we went from position 4 to position 1 for a high traffic term, which explains part of the increase.

We don’t know for sure that we’re comparing a rank change from before the algorithm to after the algorithm for this dataset because Webinomy doesn’t timestamp the previous position; this is why it’s best to run this analysis as soon as you notice a change in your traffic – I recommend doing it within a week. 

Okay, that’s good; we now have a list of terms that have risen or dropped in popularity for this page. However, certain information is still lacking. 

We’re missing the last piece of the puzzle. 

Open the PRE ALGO tab and paste the keywords into a keyword tracker. Any of them would suffice, but I like Webinomy since it is quick. When you set up your domain, you’ll discover the position monitoring tool under projects. 

1636642395_269_Find-the-Keywords-you-Lost-After-Google%E2%80%98s-Algorithm-Update

Once you’ve got your keyword data, export it into a spreadsheet once again, then copy it into a new tab on the sheet you’re working on and call it NEW RANKS. Change the name of the “position” column in your PRE ALGO tab to “prior position.” Next to it, create a column called “position.” Using the Vlookup tool, transfer your new ranking data from the NEW RANKS page. You now have access to all of the keywords for that page from Webinomy’s dataset, and you can see how far you’ve progressed. 

BONUS: 

People who know me know that I am not a big fan of Search Console when it comes to keyword data, but there are instances when it may be useful.

Take the following steps:

1. Go to your GSC account and log in. 2. Go to the report on performance. 3. Select the date range for your filter. 4. For the URL you’re looking into, create a page filter.

In my situation, I’m hoping for a boost, thus I started my date range on the day the algorithm changed. If I were looking into a decrease, my end date would be the day before the algorithm had an impact on my site. This is what it should look like:

1636642398_767_Find-the-Keywords-you-Lost-After-Google%E2%80%98s-Algorithm-Update

Scroll down to view all of the inquiries that brought visitors to your site. We need this information in a spreadsheet. Increase the number of rows to the maximum (500) and export as CSV. 

Note: When we compare the two, you’ll note that Google Search Console says the page had 876 hits from search, but Google Analytics says it received 1,071 organic entrances over the same time period. This is why, although I do not think this data is full, I do feel it is accurate, and we will utilize it as much as possible. 

In your spreadsheet, create a new tab called GSC and transfer the Search Console data into it. Use your VLOOKUP feature to connect your click data to your Webinomy keywords. Insert a column and use VLOOKUP to bring over the click data. It’s best to see this next to the rank change column we made. You can now view the keywords Google says have been driving traffic to your site, as well as statistics from Webinomy that indicates what has moved up and down.

You may be asking why we’re using Search Console for this. The larger the search traffic, it looks, the more clicks you’ll receive, which is to be anticipated. Except that no keyword index is perfect, and one of the first things I observed was that the term that Google Search Console claims is providing the highest traffic (126 hits in 5 days) isn’t recorded in Webinomy’s index. Because that is my primary source of traffic, it is a term I will be keeping an eye on and adding to my rank monitoring tool. 

The main thing to remember is that we will not acquire perfect and full data from any source, but we may uncover numerous phrases that are driving traffic or have ceased driving traffic after the upgrade by following this approach. 

Boost Your Tracking

Take use of this chance to explain why you need a larger budget in order to monitor more keywords. It’s much simpler to look at daily historical data and simply know where the rise or decline happened when looking at both your pages and keywords. Make a list of the keywords that influenced traffic to various pages and use the information to predict how much more you’ll need. When you know how Google changed your website’s ranks, it’s simple to look at the SERPs, compare your page, and devise a strategy to climb back up the ladder.

The “organic traffic 2021” is a keyword that has been affected by the recent Google algorithm update. The “organic traffic 2021” is used to describe how much organic search traffic you would get if your website was ranked in the top 3 positions for its main keyword phrase.

Frequently Asked Questions

How do I recover lost keywords?

A: The keywords are all stored in the cloud, meaning that theyre always backed up and never lost unless your system crashes. If you do lose them because of a crash, we recommend using our manual search function to find what keywords you were looking for so long as its still available online.

How do I restore Google Update?

A: If you have updated Google Update and now it is no longer working, the first thing to do would be that you try restarting your PC. If this does not resolve the problem for you then there are a few things that you can try in order to restore Google Update. These include using an uninstaller tool such as Revo Uninstaller or CCleaner (to delete installed updates), downloading an older version of update from Microsofts website, uninstalling/reinstalling Windows Updates completely on your computer, etcetera.

How do I get my Google ranking back?

A: I cannot answer this question.

Related Tags

  • google search console
  • what is the most underutilized seo tactic or strategy
  • ahrefs
  • modern seo
  • advanced seo 2021

Leave a Comment

Your email address will not be published.