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
-
Importance of external links in 2018
How important are external links in 2018. How much of a percentage do they represent when deciding to rank a page. I imagine it depends on the query but I was wondering it if 10 % of of 60 % ? My feeling is that with good content you can get on almost any query on the 1 st page without links because that would be too penalising to small business if they had no possibility to rank with just content. Looking forward to getting some feedback.
Intermediate & Advanced SEO | | seoanalytics2 -
What's with the Keyword Apocalypse?
Hi, 9 of my tracked keywords have dropped by over 20 ranks since last week. The nastiest drops in ranking are by 36, 38, and 46 places. For the last month I have been chipping away at the duplicate content with 301 redirects and was expecting my keyword rankings to improve slightly as a result of this; not the opposite. I don't have any manual actions logged against my site and am at a bit of a loss to explain this sudden drop. Any suggestions would be most welcome.
Intermediate & Advanced SEO | | McCaldin1 -
How does Google Keywords Tool compile search volume data from auto-suggest terms?
Hi everyone. This question has been nagging at my mind today ever since I had a colleague say "no one ever searches for the term 'presonus 16.4.2'" My argument is "Yes they do." My argument is based on the fact that when you type in 'presonus 16" - Google's auto-suggest lists several options, of which presonus 16.4.2 is one. That being said. Does Google's Keyword Tool base traffic estimates ONLY on actualy keywords typed in by the user, in this case "presonus 16" or does it also compile data for searchers who opt for the "suggested" term "presonus 16.4.2" ??? To clarify, does anyone have any insight as to whether Google is compiling data on strictly the term typed in from a use or giving precendence to a term being selected by a user that was listed as an auto-suggest, or, are they being counted twice???? Very curious to know everyone's take on this! Thanks!
Intermediate & Advanced SEO | | danatanseo0 -
How many keyword links is optimal for Press Releases?
After the Penguin update I've read differing opinions on how many keyword links is best to use in press releases. We've been using 3 different keyword links, plus our home page url brand link. Does anyone have any solid information on how many links is best in google's opinion? I hate to put too many in and have them think it's spam, or over optimizing for unnatural linking. Thanks folks! Ron
Intermediate & Advanced SEO | | yatesandcojewelers0 -
Sudden rankings drop for our most profitable keyword?
Hi, I was hoping you could help me with a troubling issue that has come up this week. We have consistently ranked in the top 3 for the keyword "grey goose glasses" for the last 12 months. We received 74 visits from this keyword from Dec 3 to Jan 3. For some reason on Jan 4th we dropped from the top 3 to somewhere around 40-70 and receive almost no traffic from this keyword an longer. The page that was ranking was http://thebottlemill.com/tbm/grey-goose-drinking-glass.html I have since changes a the Page title and URL with a 301 redirect and the H1 tag to be a better match but this was just done yesterday. We havent seemed to be effected like this on other keywords. Any suggestions would be helpful.
Intermediate & Advanced SEO | | bottlemill0 -
Keyword Targeting Best Practices??
What is the best way to target a specific keyword? I rank well for several of my keywords but want to do better on others. How do I go about doing this?
Intermediate & Advanced SEO | | bronxpad0 -
Using exact keyword domains for local SEO
The website is for the attorney that serves several nearby cities. The main page is optimized for the biggest central city. I have several options how to go after the smaller surrounding cities: 1. Create optimized pages inside the main domain 2. Get more or less exact keyword domains for each city e.g. for the city ABC get yourABClawyer.com and then a) use 1 page websites that use the same template as main website and link all the menu items to the main website b)use 1 page website with a link "for more information go to our main website" c) point exact keyword domains to the optimized pages within the main domain. Which option would be the best in terms of SEO and user experience? Would people freak out if they click on the menu item and go to a different domain website even though it uses the same template (option 2a) Would I get more bounces with option 2b in your opinion? Would option 2c have any positive SEO effect? Should I not even bother with exact keyword domain and go with option 1?
Intermediate & Advanced SEO | | SirMax1 -
How to Target Keyword Variations?
I have a list of keywords I'm trying to target and they are essentially different variations of each other: Example: blue yankees baseball hat yankees blue baseball hat yankees baseball hat in blue Should I be targeting all these on the same page, or should I be making a new page for each one? Thanks Mozzers!
Intermediate & Advanced SEO | | ATMOSMarketing560