SEO audit of niche and competitors
Property rental in Podolsk. The task was set to analyze the TOP of Yandex PCs on the presence of aggregators before starting the SEO move.
Given that this is Podolsk and the frequency of semantics there is weak, he chose the most frequency phrases in Moscow and then in KeyCollector he removed the data of TOP-20 and the data from Direct. Then the task was to evaluate the number of aggregators on each request, and as you realized, I am not a handjob supporter.
In fact, he has developed an Excel document that does it clearly - https://tpv.sr/uh7bIY/.
Later this development was described by me in the Telegram blog, passed by an announcement by Devaki and Shakina on channels as part of the selection of life hackers for SEO.
Given that this is Podolsk and the frequency of semantics there is weak, he chose the most frequency phrases in Moscow and then in KeyCollector he removed the data of TOP-20 and the data from Direct. Then the task was to evaluate the number of aggregators on each request, and as you realized, I am not a handjob supporter.
In fact, he has developed an Excel document that does it clearly - https://tpv.sr/uh7bIY/.
Later this development was described by me in the Telegram blog, passed by an announcement by Devaki and Shakina on channels as part of the selection of life hackers for SEO.