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
-
Keywords under product listing pages
Hi guys, One of my main concerns when we start redesigning the site Trespass.co.uk, is the current pages like this one http://www.trespass.co.uk/snow-sports/clothing/ski-jackets/womens-ski-jackets are bordering over optimisation. Is this the case as each product listed in the url above has "womens ski jacket" under each product. If we have 50 products on each product listing page with the product name + type of product, ie. flora womens ski jacket, xyz mens waterproof jacket. Are we over optimising the page for the main keywords by having them under each product? Would that page be over optimised for womens ski jackets? Thanks guys
Intermediate & Advanced SEO | | Trespass0 -
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 -
Correct strategy for long-tail keywords?
Hi, We are selling log houses on our website. Every log house is listed as a "product", and this "product" consists of many separate parts, that are technically also products. For example a log house product consists of doors, windows, roof - and all these parts are technically also products, having their own content pages. The question is - Should we let google index these detail pages, or should we list them as noindex? These pages have no content, only the headline, which are great for long-tail SEO. We are probably the only manufacturer in the world who has a separate page for "log house wood beam 400x400mm". But otherwise these pages are empty. My question is - what should we do? Should we let google index them all (we have over 3600 of them) and maybe try to insert an automatic FAQ section to every one of them to put more content on the page? Or will 3600 low-content pages hurt our rankings? Otherwise we are ranking quite well. Thanks, Johan
Intermediate & Advanced SEO | | JohanMattisson0 -
Are Silos Still Important for SEO?
I am in the process of migrating www.nyc-officespace-leader.com from Drupal to Wordpress and my developer is of the opinion that it is not necessary to implement silos to achieve favorable ranking for competitive keywords. I know a lot has changed in the last two years with Panda and Penguin. Is it SEO best practices to implement silos in the course of the redesign? Will this make a significant difference for SEO? Thanks, Alan Rosinsky
Intermediate & Advanced SEO | | Kingalan10 -
SEO Ecommerce Keywords
Hi guys got a question regarding ecommerce seo do you think its a better idea to target more long tail terms and try get links directly to product pages, brand pages and categories. Rather than focus on short keywords that do bring in good traffic but are very broad, i will prob do both, but i would like a second opinion please about other users strategies thanks
Intermediate & Advanced SEO | | Will_Craig0 -
Shortening Keywords in a title tag
in my title tag i want to have: 3D Renders of Office Refurbishment & Interior Design Kent | Complete Group which unfortunatly is longer than 70 characters, however, to make it fit in 70 characters i could put: 3D Renders of Office Refurb & Interior Design Kent | Complete Group Notice that refurbishment has been changed to refurb, would this be ok for SEO purposes?
Intermediate & Advanced SEO | | CompleteOffice0 -
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 -
Am I keyword stuffing my titles?
I run a site where I answer questions. As I answer each question I choose a title for the page. I have been trying to get good keywords in my titles, but now I am wondering if I have been keyword stuffing them and perhaps I should be more succinct. So, let's say I had a question about a sore back. Here would be the title tag I would use: Why is my back sore? I have spinal pain and need relief and help. | My Main Keyword That's a fictitious example, but the idea is that I would be trying to get the keywords "back", "sore", "spinal", "pain", "relief" "help" and my main website keyword into the title. As I'm writing this I'm seeing the folly in this. I think it would likely be much better to simply have a title of Why is my back sore? So, I have three questions: 1. Is it better to have a succinct title targeting one keyword/keyword phrase than to get lots of keywords in my title? 2. Should I be putting my main keyword after each of my title? Shortly after doing this on 1700+ pages I was #1 for my main keyword. But, I was also doing other things as well to boost my presence for this keyword. 3. If I decide to do more succinct titles, how would you suggest I go about running a test to see which is better? Looking forward to your responses! Thanks!
Intermediate & Advanced SEO | | MarieHaynes0