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
-
Rewriting content dilemma? should i include keywords ?
hi, i am rewriting content since it had 300 words , lower than top 10s i did some keywords research, on ahrefs, moz, keywordtool . io, semrush. and there are lot of variations like, main keyword is (ios 12) has variations like (ios 12 download), (ios 12 install), (ios 12 not supported) and so on, people have been searching all these terms with ios 12, it feels like if my page talks about all these variations. i have more chances to rank. does it make any sense?
Intermediate & Advanced SEO | | SIMON-CULL0 -
Can I data highlight pages that already have schema?
Hi all, I have pages with schema on but there are some gaps. Rather than ask my dev team / wait for the changes to be made, can I use the data highlighting tool in GSC to fill in these gaps? Will it let me add these and will Google generally consider both the schema and the highlighted data? To note, if I have used GSC to highlight data and then test it in Google's Structured Markup Test Tool it won't show so I understand it may be difficult to test whether it's working or not. Any advice would be appreciated. Thanks!
Intermediate & Advanced SEO | | KJH-HAC0 -
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 -
Most important things for seo a travel website
Hello everyone a website working on travel field with this address : https://goo.gl/4gaoAn Let me know what do you think about it and please give me some advises about it get improve on google rankings. If you be able to take time and give me some advises based on what you see on the website, would be great for me. Also what would work best for me to have a great link building strategy after penguin 4.0 update? and what does my site lack right now? Thanks and waiting to hear from you asap.
Intermediate & Advanced SEO | | BahadorGh0 -
Automated Statistical Data Unique Enough?
I have many pages that will soon have a lot of statistical data (real estate related). Each page represents a neighborhood, and the stats will be unique for each neighborhood. However, the stats follow a pattern on all pages: Nr o Sales year-to-date, Median Sales Price etc etc. It is great value to users, but I wonder if such pattern of similar types of calculations (though unique results for each neighborhood) across many pages will potentially be seen as lacking uniqueness as it all pages follow a similar pattern and sentence structure (Nr of Sales year-to-date, Median Sales Price etc). Adding to this, these statistics will be the only stuff that is truly unique content on these pages.
Intermediate & Advanced SEO | | khi50 -
Which search engines still use Meta Keywords?
I know Google doesn't use meta keywords in meta tags, but i was wondering if there are other smaller search engines that still do? Id it worth it to add meta keywords for them?
Intermediate & Advanced SEO | | jhinchcliffe0 -
Best Keyword Taxonomy Discussion
Sorry to bring this up again but I think the title was very misleading resulting in helpful members ignoring the question/thread completely. Also, I believe this should be in the discussion section, but please correct me if I'm wrong? Hi All, This is my first post and hopefully a question that could help others in similar positions as I haven't been able to find a concrete answer on this anywhere. Say we are trying to rank for the keyword "security testing tools". Product name is "Sectest" and its a security testing tool. *We currently have an "SEO" section that is purely good content and the idea with this is to be able to rank for "security testing tools" talking about what to expect and look for in such tools and relevant content - Linking to our product page at the end of it. structure is brand.com/security-testing/tools and that would have a link to brank.com/products/sectest Obviously product pages would get their meta tags and content re-written so we don't compete for the same keywords. Is this approach optimal? or would google want us to link directly to the product page instead of "information" about security testing tools? Nobody in our sector is taking this approach and we have already started it, but I am starting to wonder if I am getting into big trouble further down the line. Thanks and best regards, 2 Responses<a class="image-button add-response-button"> </a><a name="post-131828"></a> | JorgeGarciaAspirant | about 22 hours ago |JorgeGarcia Just to make it clearer. Our competitors seem to be using "security testing tools" directly in their product pages. We would like to use "security testing tools" for a page with content on it and an introduction to our product and then link to our product page. | <a name="post-131872"></a> | SEO5Journeymen | SEO5Director - Marketing at SEO 5 Consulting Hi Jorge, How are your competitors ranking for their approach by using security testing tools directly. If they are doing well then i would adopt the same strategy and try to beat them with quality backlinks and good on site optimization. SEO is not the only thing you have to worry about , you also should keep conversion rates in mind. By first taking the visitors to a security tools page and then your product page you are increasing your conversion funnel and this might impact your conversion rates. At the end of the day , it's all about sales/revenue/leads/ROI so you dont want to do anything to jeopardize your conversions. That one extra step that the visitor has to take might result in fewer conversions. <a class="image-button add-response-button"> </a> | <a name="post-131946"></a> | JorgeGarcia |
Intermediate & Advanced SEO | | JorgeGarcia
JorgeGarcia Hi there, Although I do understand your reasoning, we have the resources and people quantity to focus on all things at once being a big a company. So at the present moment it wouldn't be a matter of prioritizing work - but rather - delivering the best future-proof strategy. I don't mind doing the same as our competitors, but sometimes stepping out of the sheep line is good. You do make a great and very valid point addressing that this is an extra step for the visitor and could lead to fewer conversions. This is holding me back a little bit. But, if properly implemented, wouldn't a content focused site rank way better than a product page would? I guess the real question is if prospects would really find value in the information about "security testing tools" or they would rather just get the product page instead. But just looking from Google eyes, what do you think of this approach? _After re-reading my post I realize I might sound as if all I want is you to agree with me and justify my approach, I don't really. I would really value any honest thoughts and reasoning 🙂 _ |0 -
Ranking locally without local keywords in title?
I have a website that targets national keywords. I would like to be able to rank locally for these keywords as well without having the city in the title. What is the best strategy for this?
Intermediate & Advanced SEO | | cprodigy290