Remove census
article thumbnail

10 Steps to Blend STAT Ranking Data with Site Performance Metrics

Moz

I used US Census Bureau data to identify all cities with populations over 100,000 , because I wanted a representation of local bank SERPs across the country. Duplicate the Ranking URL column to a new column called Normalized URL. Duplicate the new, clean Normalized URL column to a new column called TLD.