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
-
PDF best practices: to get them indexed or not? Do they pass SEO value to the site?
All PDFs have landing pages, and the pages are already indexed. If we allow the PDFs to get indexed, then they'd be downloadable directly from google's results page and we would not get GA events. The PDFs info would somewhat overlap with the landing pages info. Also, if we ever need to move content, we'd now have to redirects the links to the PDFs. What are best practices in this area? To index or not? What do you / your clients do and why? Would a PDF indexed by google and downloaded directly via a link in the SER page pass SEO juice to the domain? What if it's on a subdomain, like when hosted by Pardot? (www1.example.com)
Reporting & Analytics | | hlwebdev1 -
Keyword Rank Dip - Estimated Wait Time to Return to Higher Spot?
The organic traffic to our site (fairly new) took a ~50% hit about a month ago due to the drop in our most important keyword. The numbers have come back up and are now exceeding the number before the dip. While this is all fine and dandy, we're still not ranking in the top 50 for our most valuable keyword. We've put out a number of guest post on reputable outside sites and are building a regular cadence of those posts, but my question is, what is the realistic wait time for those organic rankings to increase again?
Reporting & Analytics | | smf434340 -
Webmaster tools traffic on one keyword dropped through the floor - ideas?
Hi there, We design and sell our own product range in a narrow niche, and we are also stocked by Amazon and a lot of other big retailers in the UK. During the first two weeks of Dec 2012 the position of one of our main keywords, which was in google SERPs on page 1 (8 or 9), dropped to page 4. The keyword describes the niche we're in. The drop is shown in the webmaster tools traffic report for that keyword. But it's the only one of our keywords where this has happened, and furthermore it hasn't happened for variations of the keyword. And in Adwords our quality score for the keyword is 10 For example say we were making and selling shopping trolleys - our keyword "shopping trolleys" has dropped through the floor, but "shopping trolleys (on) wheels" is just fine. Can anyone shed any light on what's going on here? Losing this one keyword has cost us some good organic traffic. i1uxSlB.png
Reporting & Analytics | | w1ll1am0 -
How To Determine ROI For Specific Keywords
I have been looking through our analytics, and nealy all our conversions are from (not provided) keywords. I am trying to find the keywords that are performing best and also to determine the return I am getting from SEO efforts. I have been told the "not provided" keywords are due to people being logged into Google when they browse. However, this doesn't make sense to me. How is it that only the keywords that convert are "not provided"? Can anyone help with this?
Reporting & Analytics | | inhouseseo0 -
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 -
Exporting Keywords in Google Analytics
In the old Google Analytics, I would simply add &limit=30000 in the URL. Does anyone know how to export all keywords from the new Google Analytics?
Reporting & Analytics | | TommySwanson520 -
Subdomains and SEO - Analytics & Webmaster Tools Setup Help
Any advice on the following greatly appreciated: How to get multiple subdomain data into 1 Google Analytics profile? Can we get multiple subdomain data into Google Webmaster Tools (and if so how?) or do we need to set GWT up per subdomain?
Reporting & Analytics | | AndyMacLean0 -
GoDaddy SEO Services?
So one of my client's wants to know why he shouldn't just hire GoDaddy to "do SEO" for him! He found this page: http://www.godaddy.com/search-engine/seo-services.aspx Without actually trying it, It looks like a bunch of stuff I already do (rank tracking, PR tracking, traffic tracking, ROI projections), stuff I shouldn't do (site submissions to search engines), and stuff I probably don't need ("keyword wizard"). That said, I am intrigued by: the dedicated phone number with track and monitor (is it better than Hosted Numbers?), the business listing (is it a link worth the $6/mo?), site analysis and optimization, and ROI dashboard. Does anyone have any experience with this? Does any piece of it have any value?
Reporting & Analytics | | TheEspresseo1