Average Weighted Formula
This formula can be found in Google Sheets. For the purpose of our Daily and Monthly Snapshot by Tags reports, there are 3 calculations run:
- Average Volume: the average of the search volume for all keywords in the tag group
- % of Avg. Volume: each keyword's search volume percentage of the Average Volume
- Average Weighted Rank: utilizes the Average Weighted formula taking into account the rank for all keywords in the tag group and percentage of average volume.