Does anyone know of a way to get monthly visitor data for a subdomain that I do not manage?  I would normally use SEMRush or Compete, but they only provide domain level data.

Hey Fellow Mozzers, I am trying to determine if Bing Places for Business is worth the time and effort it takes to create listings.  My business has 900 locations, and would take some time to create the bulk upload file to load into the Bing Places for Business dashboard. My question is, since Bing already does a good job of creating business listings using data from 3rd party sources such as Yelp and Citysearch, where I already have a strong presence for each of my locations, is there any value in overriding the automatically created business page for each of my location with information that I upload?

I am curious to know if there is a way to view or calculate the average time it takes site visitors to convert per session.  For example, based on a current website design, the average time on site might be 3 minutes and the number of conversions might be 100.  is there a way to say that for the current website design, it takes 3 minutes for the average site visitor to submit a web form? Then, as I redesign the site, my goal would be to improve the average time to conversion by making the web form more accessible and require less information within the form itself. I don't think this is currently possible in GA.  Has anyone figured out a way to accomplish this by use of traditional tracking tools?  Or, am I facing having to code my site to record each visitor's time on site from the second they enter and then stop the clock when they submit the form?

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.

I have 2,871 keywords that I need to check Google rank for on 4 separate domains.  Does anyone know of any FREE tools or plugins available that will allow for this volume that wont get my IP banned by Google? Even the Moz Rank Checker only allows to enter 1 keyword at a time for up to 200 per day.  Who would seriously enter in 200 keywords, one by one all day, every day?