Columns for categorizing the keywords

mebrokenheard11

This is what it looks like: visibility by directories Above (source Sistrix): The blue directory only loses later and is not affected by the first crash. Below (source Searchmetrics): Here you can see the same directories - the initially stable directory is green here. Hanns Kronenberg at Sistrix explained in great detail how you can use these standard reports . However, if all directories are lost equally or there is no sensible directory structure, these standard reports reach their limits. What's more, you're only looking at visibility here. This means you cannot assess whether the losses are also relevant in terms of traffic.

Collect data for advanced evaluations Evaluate ranking data off-road So it's time to India Car Owner Phone Number List work off-road! In exactly these cases, export functions and Excel are SEO’s best friend. You should therefore export all rankings before and after the crash using Sistrix, Searchmetrics or a ranking tool of your choice. You then merge these in Excel (via =VLOOKUP or Power Query , I'm assuming how exactly at this point) and expand them to include anything that can be helpful in any way. Ideas include the following: One column for the first (and second or third) directory (via Data → Text in Columns) A column for the category, topic or tag (if not obvious from the URL, then via “Custom Extraction” from Screaming Frog) Columns for page type (product overview, product detail page, content.



Cheap” or another clearly visible intention, explained in more detail in my blog post on keyword research ) The traffic in the week before and after the crash, including the difference (for seasonal topics: the difference from the previous year) The number of products The bounce rate … As always, the motto is: the more data, the better. Of course, it's best to have a certain direction in mind beforehand and focus on it. Before you start, you should filter out all fire search queries. After all, you will be on number 1 for all of these before and after anyway, which will only dilute your evaluation. Analyze ranking changes yourself by subject area Now all options are open to you.