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
-
Unsolved Google Analytics (GA4) recommendations for SEO analysis?
Guides on Moz and elsewhere mostly refer to Google Analytics' Universal Analytics (UA). However, UA is being replaced with GA4, and the interface, options, and reporting are very different. Can you recommend a clear, thorough, and effective walkthrough of how to set up useful SEO reports in GA4? Is there a simple tool you recommend that will help connect historical data from UA to GA4 when GA4 is the only option available? If there's no simple tool, what values do you recommend retaining from UA for effective historical reporting? How would you use them? At minimum for reporting, I'd want to show month-to-month changes and year-to-year changes (in percentages and in real numbers) for the following: all site visits all organic visits organic visits as a percentage of all site visits organic visits that led to a specific goal completion organic visits that led to any goal completion Thanks in advance for your help!
Reporting & Analytics | | Kevin_P1 -
Does intercom support pages and redirect issue can affect the SEO performance of our website?
I noticed that in the redirect issues I have, most of the issues are coming from our Intercom support links. I want to ask, does intercom support pages and redirect issue can affect the SEO performance of our website?
Reporting & Analytics | | Envoke-Marketing0 -
Massive decrease in search volumes from Keyword planner
The search volumes that I'm getting out of Keyword planner are approximately 10% (some as low as 1%) of the search volumes for the same keywords back in April. Is there something I missed in this time? I'm using the same account, same language and location settings. Anyone have an explanation for this? To be honest these new search volumes sound a lot more plausible to me - I'm just intrigued by what might have happened!
Reporting & Analytics | | a-champ0 -
Best way to measure local search keyword rank
I have several clients that have a regional or local presence and want to track their rankings for various keywords, but only in the areas they are located in. What are the best ways to track keyword rank in specific locations or regions of the US?
Reporting & Analytics | | TheURLdr0 -
How to force keyword check?
I used to have only 5 keywords that I tracked, but I have just added about 100 more. But when I look in the overview, it says: "Rankings Updated Every: Tuesday Last Data Update: 01/07/2013" It is not Tuesday yet, but seems that it was updated on January 7th. Will I have to wait another week? How can I force a re-check? I'm in rush to get this data 😞
Reporting & Analytics | | Rank4Stuff1 -
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 -
Google Shopping & Keyword Tracking
When tracking Google Shopping using the URL builder is it possible to pull through the Keyword used or will analytic do this automatically?
Reporting & Analytics | | TPSUK1 -
Free Keyword Tracking Tool
Hi, Any suggestion which is the best FREE keyword ranking tool. I know digital point offers one but they will install some script in the site which might slow it down... Is there any alternative?
Reporting & Analytics | | krishru0