I have a request because I can't find any way to do what I want
I have a table with the following columns:
- keywords, which correspond to the keywords of several 10 competing sites (so there are duplicate keywords.)
- search volume for each keyword
- url positioned on the keywords
- NDD of the positioned url (extract)
I want to know how many ndd's are positioned for each keyword
Keyword 1 = 4 sites
keyword 2 = 2 sites
Keyword 3 = 8 sites
In the charts, I can do this easily (I put the keywords column in X and the NDD column of the positioned url in Y)
However, I would like to obtain a table at the output of the data set, but I can't.
Thank you very much for your help.
Operating system used: windows