Answer the question
In order to leave comments, you need to log in
How to analyze site positions in Excel using Keycollector?
Good day everyone!
There is Keycollector. I buy limits for a penny here . I get parsing for ~ 5000 requests.
I export data to Excel.
Tasks:
1. Track changes in the number of requests in top1, top3, top10, top20, top50, top100 relative to the previous check.
2. Ideally, get those requests that sank and those that rose.
You can "reinvent the wheel" - sit for 1-2 hours in Excele and solve problems with pivot tables and diagrams.
But I thought that someone could share their experience. After all, not drawings of a perpetual motion machine)
Or maybe there is a video, a course or a link to the manual.
Thank you in advance. )
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question