Keyword area ranking and data normalization