M
M
Mikhail Petrov2016-03-11 07:02:10
Search Engine Optimization
Mikhail Petrov, 2016-03-11 07:02:10

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

1 answer(s)
V
Valentine, 2016-03-11
@vvpoloskin

Excel has filters, sorting, line fixing, they are done with two clicks.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question