Moz Q&A is closed.
After more than 13 years, and tens of thousands of questions, Moz Q&A closed on 12th December 2024. Whilst we’re not completely removing the content - many posts will still be possible to view - we have locked both new posts and new replies. More details here.
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
-
How important is admin-ajax.php?
Hi there! It's been a long time since I last did a technical audit of a site. I've currently playing with the 'fetch as google' tool to find out if we're blocking anything vital. The site is based on Wordpress, and after a recent hacking incident, a previous SEO moved the login portal from domain.com/wp-admin/ to domain.com/pr3ss/wp-admin/ - to stop people finding it. Fair enough. But they then updated the robots.txt file to look like this: User-agent: *
Intermediate & Advanced SEO | | Muhammad-Isap
Disallow: /pr3ss/wp-admin/ Now, some pages are trying to draw on theme elements like: http://www.domain.com/pr3ss/wp-admin/admin-ajax.php
http://www.domain.com/pr3ss/wp-content/themes/bestpracticegroup/images/column_wrapper_bg.png And are naturally being blocked (not that this seems to affect the way pages are rendering in Google's eyes) A good SEO friend of mine has suggested allowing the theme folder, and any sub folders where this becomes an issue. What are your thoughts? Is it even worth disallowing the /pr3ss/wp-admin/ path? Cheers guys and gals! All the best, John. I've found a couple of the theme's0 -
How to measure traffic for a keyword
Sitting in Country A I want to see how much traffic a particular keyword receives in Country B. Whats the best way to do it? Also, will the search results differ if I am analyzing the above sitting in Country A viz-a-viz Country B. In other words, will the IP of the country I am making the search from play a role in the results?
Intermediate & Advanced SEO | | KS__0 -
Advanced SEO - What would you do after you run out of keywords?
Hello! Our company has been growing in terms of traffic and ranking well for a couple of years but we are now kind of stagnating because we just don't know what to do next. We have a good blog - and with our blogs, we have been targeting all major keywords with their related keywords as a bucket. - "keyword theme / page" for a long time. But it seems we now don't have any major keyword theme to write about. What is worse is that we don't see any traffic growth since 2014 September. (although we added many good blogs) So what would do you when you run out of keywords? or keyword themes? Would you just keep pumping in more blogs and hope that you get more clicks? or at some point, you just don't care about keywords and write whatever relevant to your site? Wouldn't it hurt our site if we create similar keyword themed pages? (like regurgitating our keywords?) or even same keyword targeting pages? You must have similar experience if you are an owner of a niche site. Can you please share your experience with this kind of headaches? Thank you and look forward to your comments.
Intermediate & Advanced SEO | | joony3 -
No matter what the keyword, only the homepage shows in the SERP
Hi, wondered if someone could help. My clients website shows up well for terms but its always the homepage rather than the targeted landing page. For example, if you search for "teeth whitening anglesey" they appear http://goo.gl/ohJdua however, its the homepage rather than the tooth whitening page http://goo.gl/uVI8gK Thanks Ade
Intermediate & Advanced SEO | | popcreativeltd0 -
What Constitutes Keyword Stuffing?
Greeting MOZ Community: I have been attempting to add certain keywords phrases to the home page text of our real estate web site (www.nyc-officespace-leader.com). When I check the keyword density and look at the keyword cloud, the frequency of certain terms appear substantially higher than they should be (see attached keyword cloud and keyword density chart. Certain terms like "office space" have a 5 or 6% frequency which seems high. Last thing we need is a Panda penalty. When I viewed the code for the home page (see enclosed), I noticed HREF tags, SRE tags and ALT tags repeating certain keyword phrases, driving up their density. I have attached a keyword cloud for the home page of a competitor and the use of language seems more diverse. Does Google take the text in these various tags into account? I know the ALT tag is important for SEO, but how about the others? Does the use of text in the tags for this page make the overall page look spammy? Also, there are text and tags for the carousel in the home page that appear in the code for the home page. If this code were somehow concealed, would we be better off from an SEO perspective? Thanks, Alan pkM7CZG 1DFFMZ0
Intermediate & Advanced SEO | | Kingalan10 -
Are backlinks the most important factor in SEO?
I have had an agency state that "Backlinks are the most important factor in SEO". That is how they are justifying their strategy of approaching bloggers. I believe there are a lot more factors than that including Target Market definition, Keyword identification an build content based on these factors. What's everyone's thoughts?
Intermediate & Advanced SEO | | AndySalmons0 -
Exact keyword URL or not?
Hi all, I have a quick question about the proper use of permalinks. Let's say that I have a website about sports and I want to create an internal page dedicated to shoes. I know that the keyword "shoe" has 15.000 monthly visits, while the keyword "shoes" has 1.000 monthly visits. How do I have to name the internal page? http://www.example.com/shoe or http://www.example.com/shoes (with a final 's')? I would think that by naming the URL http://www.example.com/shoes, the search engine would consider that page for the keywords "shoe" and "shoes", but I am not sure about it. Should I create a URL that only focuses on one specific keyword ("shoe", in this example) or a URL that may encompass more than one keyword ("shoe" and "shoes")? I hope this is clear. Thank you for your time and help. All best, Sal
Intermediate & Advanced SEO | | salvyy0
