[question]
I’m trying to figure out how you automate the rankings in the Google Visibility Report. It looks as though the Excel spreadsheet dynamically updates the information. However, I don’t understand the spreadsheet formulas and how to sync the spreadsheet to Advanced Web Ranking.
[/question]
[answer]
The universe tab in the GVR dynamically updates the AWR information. After the AWR runs, export the keyword rank report. This will give you the keywords and their ranked position in Google.
In the GVR, the formula in the Google Rank column is:
=INDEX(‘AWR Data’!A$1:K$1594,MATCH(A6,’AWR Data’!A$1:A$1594,0),5), which is asking to match the phrase in cell A6 from the universe tab to the same one that it finds in the AWR tab.
However, before it can perform that function:
(1) The range from the AWR tab needs to be the full range of the data (in the above it is A$1:K$1594);
(2) the keyword column in the AWR report needs to be the very first column; and
(3) the “position” column must be column #5.
[/answer]
