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
-
Keyword research
Do I understand it correctly ? Let's say my keyword is Piedmont bike tours. From what I understand I need to use synonyms of Piedmont bike tours that people would use to find my website such as bike trip in Piedmont or cycling vacation in Piedmont and then closely related phrases in my content which are not necessarily synonyms but that semantically related, correct ? Do I need to do that for every topic that I decide to talk about on my webpage. For example let's say another topic I have decided to talk about on my page about Piedmont bike tour is Barolo. Do I need to do the same process for Barolo ? Thank you,
Intermediate & Advanced SEO | | seoanalytics0 -
Adding a secondary keyword or other keyword variation to the title tag affect ranking for primary keyword?
Hi Moz Community, According to Google Search Console, the main keyword for our website is undergoing a low click through rate, even though we have good ranking for that keyword (top 3). Currently, our homepage's title tag is "Brand Name: Primary Keyword". I am thinking about adding a secondary keyword or other keyword variation to differentiate our company from others in order to possibly increase the click through rate. Will this affect the current ranking for the primary keyword? Also, is the clickthrough data in Google Search Console accurate? Thank you! Best, Raymond
Intermediate & Advanced SEO | | raymondlii0 -
Home page ranks for most keywords with no SEO
Hi Guys, The keyword I am trying to rank is on seperate page with its own Optimization in place. However the HOME page of website starts ranking for that keywords . The keyword is mentioned on Home page Just once in content description, that's all. What should be my ideal strategy. Deleting the Sub Page, will that improve the SEO of my home page and improve the Rank for that keyword ? Also I can see my Own YELP pages rank better than the actual website for few terms . Any way around this ? A Part from building links to page ?
Intermediate & Advanced SEO | | aus00071 -
Keyword not ranking but keyword within a phrase is?
Hi Guys, Google is not indexing the keyword ‘e liquid’ for www.cloudstix.com/e-liquid and it's driving me insane. I cannot understand why, can anyone please shed any light! -On page we have used variations e liquid, e-liquid, eliquid. -The e-liquid product pages are canonicaled to www.cloudstix.com/e-liquid. -3 other pages regarding e liquid were 301 redirected to the page passing good authority. I did this as I believed these pages conflicted as they seemed to target e-liquid. -‘e-liquid’ is being used as an anchor throughout the website pointing to www.cloudstix.com/e-liquid. -The ‘e liquid’ page has generally good authority PA 22, DA26. -The website has good anchor text linking to the site, all relative and e liquid related, along with brand links. Currently the keyword ‘e liquid’ brings up the home page www.cloudstix.com ranked 100+. What’s strange is the other terms relating to 'e liquid' bring up www.cloudstix.com/e-liquid for example: ‘e liquid uk’ ‘the best e liquid’ and ‘e liquid cloudstix’. Any ideas on what the problem may be. Would appreciate any advice on this. Thanks guys! Liam
Intermediate & Advanced SEO | | One2OneDigital0 -
Should I buy a keyword rich domain to prevent competitors from buying it
Some people in the company I work for have suggested that we buy a keyword rich domain that matches a new product line that we're planning to release. I've advised that this in itself is not a good idea, as we'll need to produce high quality content for that site rather than just having it exist for ranking purposes. We already have a section on our main site focussed on this product line, so I don't think having the keyword match domain would really add anything unless we worked out what we'd use this site for. That said, I was wondering whether it might be worth buying the exact match domain anyway, in order to prevent a competitor from using it?
Intermediate & Advanced SEO | | RG_SEO0 -
Keyword Research: How best to target keywords without using a region as part of the search query.
When doing keyword research and trying to rank for a keyword. I am wondering if we need to localize the query by adding a city to it. For example Phoenix Web Design vs. just targeting web design since Google is localizing search results now. Then when creating content and optimizing the site do we just put the keyword in the title and page content or do we also add the region/city to the keyword phrase? Any insight would be appreciated.
Intermediate & Advanced SEO | | hireawizseo0 -
Keyword as domain- worth buying it?
Hi, I just noticed that a top keyword for our industry is available as a domain, but for around $2,500.00 USD. For example, www.chicagoplumber.com. If we already have a pretty well established online identity as, let's say, www.chicagopipes.com, would it be worth buying the new domain and making it our primary? Thanks for your feedback! -Will
Intermediate & Advanced SEO | | WillWatrous0 -
What is the best metric to evaluate keyword difficulty?
Which is better seomoz's keyword difficulty tool or wordtracker's KEI index? Or, do you have another metric you utilize when evaluating a large list of keywords?
Intermediate & Advanced SEO | | nicole.healthline0