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's more accurate? GA queries data or Moz/SEMRush keyword data for rankings
What do you guys think? What's more accurate? GA queries data or Moz/SEMRush keyword data for rankings? Any thoughts appreciated.
Reporting & Analytics | | znotes0 -
International SEO Domains & Avg Session Duration
I have a couple questions 1) Is there any SEO value to forwarding multiple domains to the same domain? For instance, we own dozens of of the same domain name but with International extensions. I haven't seen much on this topic and assume that Google ignores such domain names (they don't really have much of any links to them). 2) Is there any research on whether time on site is declining across the web? I've noticed a trend over the years but I want to make sure this is a standard user behavior as people jump around quicker and search hop for information.
Reporting & Analytics | | ScottOlson0 -
Improved keyword ranking but less traffic
Hello fellow mozzers! My collegue and I are a bit puzzled in regards to our recent website statistics. In november 2013, we upgraded the technological platform of our website to be fully HTML5 coded, and implemented the schema.org Products scheme to systematically tag all our products on the site. To prevent too much loss of visitors, we created a 301-redirect table from almost all our old URL's to the specific new ones, as we implemented a new URL structure as well. The first few months were bumpy as expected, making a huge drop in rankings before rising up again. Our keyword rankings are better then ever (60% of the keywords in top 3, average competition, 25% more on first SERP) but our number of visits dropped by about 10%. Our bounce rate went down from 20% to 14%, our returning visits are stable, but our new visitors stats dropped by 25% as well. This comparison was made between equal periods in the current year and last year, using organic data stats. (new technical platform vs. the old one) What could be the reason that our number of visits dropped 10% while our keyword ranking is better then ever? We don't have any manual penalties in GWT and can't understand why visits would drop so much while ranking improved. May it be so easy that there's just less search volume on our ranked content or does anyone have other ideas? Thank you all in advance!
Reporting & Analytics | | EconostoNL0 -
Does Google encryption of keyword data impact SEO revenue reporting in Google analytics?
Hi there, I know Google has been encrypting SEO keyword data which they rolled out in September 2013. My question is - will this impact SEO revenue figures reported in Google analytics? I have been monitoring SEO revenue figures for a client and they are significantly down even though rankings have not lowered. Is this because of Google's encryption? Could there be another reason? Many thanks!
Reporting & Analytics | | CayenneRed890 -
Not provided keyword?
This may be a realy daft question this is all new to me, when I look at my keyword traffic the top one under keyword says not provided can someone explain this to me please?
Reporting & Analytics | | seoactivejames0 -
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 -
How to export all my keywords from GA new version
Hi I want to know how can i download all my keywords within the kw report of the google analytics new version. It seems to me that the "limit=50000" parameter doesn't work on this new version. If that is true how can i do to export all my keywords let say on CSV format? Thanks a lot
Reporting & Analytics | | FranckNlemba0 -
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