This worksheet is similar to the Missed Opportunity Matrix but lets you estimate traffic based on the rank you think you can achieve and the buy cycle of the keyword phrase. This is an Excel Version of the more sophisticated model in Back Azimuth’s Rank to Click analysis that uses multiple segments of the keyword […]