SEO Keyword Research
-
Is there a way to insert Google API into Excel? I want to have a search volume column that would automatically fill out with query
Another question is that I have a list of keywords in one column in Excel with another column that have search volume. I then go and do some research on keyword groups with a grouping tool but if this tool doesn't find a group for a keyword it removes it. So then when I want to copy and past keywords and match keyword columns in excel that already exist with search volume I have to do it manually because some rows are missing. Is there a way this could be done automatically so that when I paste it in the column with keywords it automatically finds that the current column exists and adds a group column ?
-
I can definitely answer the first question that yes, you can bring search data and suggestions into Excel. Use SEO Tools:
http://seotoolsforexcel.com/google-adwords/
This plugin should be mandatory for SEO work so if you're not using it, it's a great time to start and learn it well.
I don't know about the second part - I suppose I'd have to see what you're trying to accomplish but I don't know of any keyword tools that are quite that advanced.
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Webmaster Tools Average keyword position
Hello! For the last month i have notices a drastic change in Avg.position for a keyword on my clients site http://livoart.lv keyword: "kapu pieminekļi". According to webmaster tools it went from 13 to 4-2. The problem is that in orgranic search i keep seeing the keyword on the second page and the CTR of the keyword did not change at all. Why would webmaster tools show false data?
Reporting & Analytics | | AlexElks0 -
How come de results from the old Google Keyword Tool are so different from the results from the keyword planner?
When I insert the keyword 'IT jobs' with Belgium as country and Dutch as the language, there is a huge difference between the results in the keyword planner and the keyword tool. Keyword tool says 1,000,000 local searches per month Keyword planner says 590 local searches per month This is a really big difference and I don't know which results I should trust. Can anybody help me with this?
Reporting & Analytics | | Murielleu0 -
Results for wrong keyword
I've started to look at ranking and visitor behaviour within a specific product category and I've come across this strange data in GA that i'm struggling to get my head around. keyword - wishbone necklace gold landing - ...necklace-dive-in.html bounce - 99.31% new visits - 0.00% The landing page is not anywhere in the results for the given keyword (nor does the keyword appear anywhere within the page). The data is spread out to date since Dec 2011 and the landing page accounts for about 97% of the traffic for that keyword. I then looked at browser which is 95% Safari (different versions) and breaking that down into City about 30% is (not set), 30% a single city and then there is a spread of locations. It might be fair to assume that therefore 60% could be the same location but there is still 40% to take into consideration. What I can't get my head around is how the landing page is being accessed so regularly for the wrong keyword. The correctly ranking URL only accounts for 5% of the traffic which is more in line with the estimated search volumes for that keyword. I've checked versions of the page going back and none contain the keyword. Am I missing something, or any ideas how to fix?
Reporting & Analytics | | MickEdwards0 -
Large content snippets showing up as keywords?
I've started to notice something very strange: the search keywords report in analytics show a bunch of instances where a person copied large snippets of our site content and then pasted it into the search box. Half these searches are coming from the US and half from...India. I'm worried that this may be the sign of a competitor attempting to perform negative SEO on our site (though admittedly I don't know how). Anyone seen anything like this? Advice? Thanks!!
Reporting & Analytics | | SarahLK0 -
Does anyone know what's happened to google analytics -> traffic sources -> SEO -> queries many of my accounts are showing a drop to zero in the laste few days
Howdy mozzers It's in the question title really. Zero impressions showing for the last few days on. Multiple accounts Any thought out there
Reporting & Analytics | | Big_Partnership0 -
Keyword Diversity: What Does it Mean?
I recently read this awesome article by Ian Lurie on the Portent blog: http://www.portent.com/blog/analytics/seo-analytics-middle-earth-style.htm However, I keep getting stumped by what he means under the "Grade Yourself" section by "keyword diversity." Of course, I've tried to ask him, but he hasn't yet responded. Besides, I like to get the opinion of the SEOMoz crowd anyway. So what is "keyword diversity"? Is it the total number different link texts out there linking to my site? The total number of keywords I'm actively tracking and optimizing for? The total number of phrases for which I rank in a Google search engine (if it's even possible to know that)? Thanks, Benjamin
Reporting & Analytics | | 1000Bulbs0 -
Analytics tagging parameters effect on site SEO
One of the effective tools used in analytics tagging is the use of analytics parameters that starts with '?' or '#'. Example on site tagging: Main link: www.domainname.com./category/sub-category/ www.domainname.com./category/sub-category/?lid=topnav www.domainname.com./category/sub-category/?lid=sidenav All three links link to the same landing page, with an extra parameter. Using email or campaign tagging: www.domainname.com./category/sub-category/ www.domainname.com./category/sub-category/?utm_source=launch&utm_medium=email&utm_term=html&utm_content=getscoop&utm_campaign=hwdyrwm2012 With that we create many tagged links based on the campaign internal strategy. How do these effect indexing, and link juice? How do thy effect SEO in general?
Reporting & Analytics | | RAPPLA0 -
What impact will Google's 10/18/2011 announcement of 'Making Search More Secure' have on the ability to track specific keyword queries via Analytics?
The full announcement is here: http://googleblog.blogspot.com/2011/10/making-search-more-secure.html My concern is that the ability for Google Analytics to parse information on specific keyword queries will be diminished. The article hints that Google Webmaster Tools will be exempt from the problem, and I've never relied on Webmaster tools as a go-to for tying specific keyword queries to Goal Tracking (form submissions and sales). The community's thoughts on this one are appreciated. 🙂
Reporting & Analytics | | MKR_Agency0