Welcome to the Q&A Forum

I just pulled a search term report for all of 2013 from my PPC account.  What I got was 673,000 rows of terms that have garnered at least 1 impression in 2013.  This is exactly what I was looking for. My issue is that the vast majority of terms are geo-modified to include the city, the city and state or the zip code.  I am trying to remove the geographic information to get to a list of root words people are interested in based on their search query patterns. Does anyone know how to remove all city, state and zip codes quickly without having to do a find and replace for each geo-modifier in excel? for example, if i could get a list of all city and state combinations in the US and a list of all zip codes, and put that list on a separate tab and then have a macro find and remove from the original tab any instances of anything from the second tab, that would probably do the trick.  Then I could remove duplicates and have my list of root words.

Hi All, I am in process of doing and SEO overhaul for our five global sites in: US, UK, Canada, Sweden, France I'd like to track hundreds of keywords and rankings per site - I'm talking at least 300-400 keywords each site. Each site has its own country domain with both www and www2 domains. So, I need a keyword tool that will let me track massive amounts of keywords. I know that the Moz Pro tool helps, but we only have 350 keywords on this account. I think on this. Any suggestions on something reliable that will provide good data? I'm sure I can get some budget to purchase something, but I also can't spend too too much money. I'm not looking for a massive analytics package. Right now, I'm concerned mainly with our keyword rankings Thanks in advance!

First Q&A here, so take it easy on me. Hopefully this is not a dumb question. 99% of the on page reports I look at are for local keywords. I'm finding that some of the page reports get and F where they should be receiving A's. I noticed if I manage a long-tail keyword like "books in houston tx"  that I get a grade based on the exact phrase as opposed to a combination of the keywords. So when I have text in the body saying "books in the Houston area" or "Houston Books" for example, instead of using my exact managed keyword, it will tell me that the keyword is not mentioned in the body anywhere. When it is, it's just not in the exact order... I'm trying to write my pages for users and I don't think the users want to hear "books in houston tx" several times. If I do a report on the same page for the keyword "books" I get an A. So this is where it gets a little in the grey area for me. I need a solid on page report for local long-tail search terms. Anyone have any advice? Is there a way I could be using this tool to better suit my needs?

This may be more of a developmental comment, however... Is there any way to pull an overview of keyword ranking over the week (or any period of time) for one of your campaigns? It looks like you can pull graphs on individual keyword performance, however not for the full set of keywords for a campaign. Anyone have suggestions on how to do this within Pro Moz... or is it best to compile the keyword data every week and track it in Numbers or Excel? Thanks everyone!

This is what I get on the main Keyword Difficulty Tool page.

I have all my key phrases in excel (csv) and would like to upload all of them to get the traffic that they generate on Google UK. Is there a way of doing this?

So the ratio is MozTrust to MozRank, but what is this good for?  What can I deduce from this and what can I use it for?