Hi, I need KEI SCORE MS Excel Sheet for evaluating the Keywords. The sheet in which formula is already provided and gives me good results in decision so that help me to win the SERP rankings. Please also mention the best KEI formula which is best for getting results in short time. Thanks in Advance.
KEI= Searches*searches/result or quantity of searcher multiply quantity of searcher divide competitor in search result. searcher you can find in google keyword tool. search result you can find in google.
create in four column. Type header in the column. column 1=keyword, column 2= searcher column 3=competitor column 4= KEI. Yo add all column manually except KEI. Formula of KEI is =B2*B2/C2.