Hi,
I have uploaded a file containing data on keywords - the month they were collected, their ranking position and keyword name. One table shows keywords collected twice per month (most of the time) and the other is keywords that have been collected 4.3 times per month (weekly).
I want to investigate the difference in ranking positions between each frequency of collection. My idea is to have an average for each month for each keyword i.e. Keyword10 April average = (5+6)/2, which could be put in an 'Average' column but couldn't figure out a way of doing this without manually calculating for 450 to 900 entries!
If anyone has any ideas that can make this work then I would welcome them massively!
Thank you,
Tom
I have uploaded a file containing data on keywords - the month they were collected, their ranking position and keyword name. One table shows keywords collected twice per month (most of the time) and the other is keywords that have been collected 4.3 times per month (weekly).
I want to investigate the difference in ranking positions between each frequency of collection. My idea is to have an average for each month for each keyword i.e. Keyword10 April average = (5+6)/2, which could be put in an 'Average' column but couldn't figure out a way of doing this without manually calculating for 450 to 900 entries!
If anyone has any ideas that can make this work then I would welcome them massively!
Thank you,
Tom