Grab the first 100 and put

[zihadhasan019]

If it had a rank of 3, it received a score of 9.5 (a factor of 0.95). A rank of 4 gave it a score of 9.025. So if keyword X ranks #29, it receives a score of roughly 2.5. Let's say keyword X gets 386 daily searches. To get the Value of that term, simply multiply the score by the daily searches (2.5 X 386). That being said, here is your recipe.


The Ingredients Google Analytics Google SpreadS usa email database heets or Microsoft Excel Rank checking tool (SEOBook.com's Rank Checker Firefox plugin will do just fine, although it has a limitation of 100 keywords) Wordtracker The Instructions Determine the top 1,000 keyword traffic sources from Google Analytics. To do so, first grab the top keywords over a six-month span and then the top over the past week (to make sure you don't miss any recent high-traffic terms). Combine them in Excel and delete duplicates.





them into Rank Checker. In the settings, choose the engine that gets you the most traffic. Export the results as CSV. Repeat until you've completed the keywords list. Combine the exported files into one. Import the keywords list into a Wordtracker bucket and get the number of searches per keyword. Save the tab delimited document and open in Excel. From the rankings Excel document, do a vLookUp (instructions here) to pull the number of daily searches from the Wordtracker export.