Importing Keyword Planner Data into Excel?
-
What is the most efficient way to import search volume information into excel? We have 130K keywords that we need search volume information for.
-
So, there isn't any way to directly pull search volume directly into excel? I'm looking at a data set of 400K keywords
-
Great question! Google Adwords Keyword Planner doesn't make the place where you can do this very obvious or easy to find. Here's where you can do what you need to do:
1. Log in to Keyword Planner
2. Click "Get Search Volume for a List of Keywords"
3. Upload your keyword list via the resulting popout screen
4. Run the report
5. In the subsequent screen, upper right, just below the chart is a link that says "Download Ideas" - Click that
Then you will have all the data in Excel, provided you are running something newer than Excel 2003 which I believe had limited capabilities (45,000 rows maybe?)
Does that answer your question or was I way off Let me know. Hope it helps!
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
-
Replacing keywords by synonyms. Will it increase risk of google keyword stuffing penalization?
I have a page which is ranking already pretty well for a relative competitive keyword.
Intermediate & Advanced SEO | | lcourse
Google also ranks us on first page for synonym of keyword we optimize the page for (even though synonym does not appear on our page). I am now considering to replace some occurences of the keyword in the page by different synonyms, in the hope that our ranking may further improve for these synonyms.
However I am concerned that google may penalize me for keyword stuffing if I am using a wide range of synonyms of one keyword on our page. My plan is only to replace some occurences of keyword with synonyms. I am a bit nerveous here since page is already ranking quite well in a competitive niche. Any thoughts?0 -
Why Is Google Webmaster Tools Pulling Zero Keyword Data?
I just linked a Google Webmaster Tools account to Google Analytics for a client, and Search Engine Optimization reports are showing up in Google Analytics as enabled, but there is zero keyword data, landing page data, etc., in the reports themselves. Has anyone encountered this?
Intermediate & Advanced SEO | | yoursearchteam0 -
Redirecting Domain / Maintaining Keyword Ranking
Right now we have two sites: "our-company.com" and "cool-widgets.com." We rank high for "cool widgets" searches due to our keyword-friendly URL, but we're merging everything into our newly-redesigned company site. Should we redirect the old "cool-widgets.com" homepage to "our-company.com" (to directly transfer the old PR and links), or would it be more prudent to redirect the old homepage to "our-company.com/cool-widgets" to keep the "cool widgets" keyword in the URL? This option seems like it would be good for maintaining organic search results, but it wouldn't pass the strong link backbone to the new site's homepage.
Intermediate & Advanced SEO | | versare0 -
None branded keyword Sitelink?
Hi Friends I have sitelink when people search my brand. Can I have another sitelink for none branded keyword that my site is more than 1 year top of google position?
Intermediate & Advanced SEO | | vahidafshari450 -
Is this misuse of scheme data?
A directory list page that uses the individual business page review data. Instead of the scheme markup indicating the a particular business page has a review, the page that lists all of the businesses gets the review instead. This means the list page can get hundreds of reviews which could potentially affect its SERPs. A competitor is doing this now. Is this an abuse of the system? Should it be reported? How does on report this kind of this?
Intermediate & Advanced SEO | | designquotes0 -
High search volume keywords
The problem is that our index is not in serps anymore with the high volume keywords (Pfizer, Roche, johnson & johnson).
Intermediate & Advanced SEO | | bele
We still keep these keywords in title, but it brings not much results. We made page www.domain.com/pfizer , added there Pfizer products with unique descriptions.
Product pages started to drive visitors, but not the www.domain.com/pfizer page. If we add a blog to the top of this page and add unique posts about Pfizer company news, would it help?
In this case this page would be unique, refreshed with new info, and have rotating pfizer products. Maybe some other suggestions?0 -
How important is it to canonicalize mobile URLs to desktop URLs?
I know many SEO's prefer a stylesheet and single URL, but if you use m.domain.com, do you canonicalize to your desktop URLS?
Intermediate & Advanced SEO | | nicole.healthline0