SEO Keyword Research
-
Is there a way to insert Google API into Excel? I want to have a search volume column that would automatically fill out with query
Another question is that I have a list of keywords in one column in Excel with another column that have search volume. I then go and do some research on keyword groups with a grouping tool but if this tool doesn't find a group for a keyword it removes it. So then when I want to copy and past keywords and match keyword columns in excel that already exist with search volume I have to do it manually because some rows are missing. Is there a way this could be done automatically so that when I paste it in the column with keywords it automatically finds that the current column exists and adds a group column ?
-
I can definitely answer the first question that yes, you can bring search data and suggestions into Excel. Use SEO Tools:
http://seotoolsforexcel.com/google-adwords/
This plugin should be mandatory for SEO work so if you're not using it, it's a great time to start and learn it well.
I don't know about the second part - I suppose I'd have to see what you're trying to accomplish but I don't know of any keyword tools that are quite that advanced.
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
-
What is Local SEO in Google Analytics (Organic Source)
Recently, I saw "Local SEO" is mentioned as the organic source. Can someone please tell what is this and from where Google is fetching data for this source?
Reporting & Analytics | | Kevin.Monks0 -
Been stuck on seo duplication issues shopify
hey there we have been working on some of our webshops and recently started with analytics/moz,but we have basicly hit a brick wall when it comes to www.krawattenwelt.de since we have had 5k high priority issues (duplicate content) and 20k medium priority issues now i have tried a large amount of solutions regarding the duplicate content issues but it didnt work so we basicly reverted it back to for now and i have the feeling i am really running out of options is there anyone who has an idea on how to do this? duplicate content issues are as follows example:http://krawattenwelt.de/collections/budget-9-15 issues with:http://krawattenwelt.de/collections/budget-9-15/modell_normal and with:http://krawattenwelt.de/collections/budget-9-15/modell_normal?page=1
Reporting & Analytics | | WebMaster2050 -
Why would our client's site be receiving significant levels of organic traffic for a keyword they do not rank for?
We have a client that has received 100+ organic visits for the keyword 'airport transfers', yet the site does not rank in the top 100 search results for this keyword. We have checked that it is not untagged PPC traffic. Truly baffling. Can anybody help?
Reporting & Analytics | | mrdavidingram0 -
How can I see keyword rankings past 50?
The rankings in the campaigns appear to be limited to tracking terms in the top 50. is there a way to view past that? I understand that for the most part no one is ever going to see past that so 50+ might as well be 5000. But a client has requested for a handful of key terms. If this is not possible, can someone recommend another tool I might use? Thank you! Kevin
Reporting & Analytics | | yandl0 -
How to see traffic for specific keywords in GA
Hell guys, What i want to achieve is to generate a list of specific keywords showing traffic for a certain periode of time. I also want so be able to compare this time period with historical data. I want a list as shown in: Traffic sources -> sources -> search -> organic. This shows a list of keywords generating traffic out of the organic search results. When you use a filter you can only use one word so it seems. I just want to create that list but with the specific keywords i choose to display. I tried advanced reports and advanced segments but that doesn't really give me what i want. The idea behind this whole thing is that i want to give my client an overview of the traffic received on the words we are optimizing for. this traffic has to be compared to the previous month so they can see clearly if there were changes. Thx !
Reporting & Analytics | | 5MMedia0 -
Massive raise and drop in keyword ranking
2 weeks ago I had a massive spike in keyword rankings 99 keyword went up. It was a quite happy week. the week later all keywords that went up dropped down to the same positions before the spike. now I have the same situation. this is the happy week with a very high spike. Anybody got a clue what is going on ?
Reporting & Analytics | | interelectronix0 -
Best SEO Analysis Tool
I'm looking for a tool that will analyze a webpage for a specific keyword phrase and deliver good recommendations as to what I can do (on page and off page) to increase the Google ranking for that keyword phrase. I'm trying IBP now, but so far the results haven't been good. Any suggestions?
Reporting & Analytics | | urbanscooters0 -
Video topic research
I am developing a video strategy for a pediatric dentist office. I am trying to develop a set of topics based on which existing videos perform best. What are the characteristics I should be evaluating (besides basics like views and comments)?
Reporting & Analytics | | joshfialkoff-778630