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.
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 -
Longterm wordpress blog not providing seo benefit to main site - help needed please
Hi I have a bigcommerce ecommerce store, with a Wordpress blog on a subdomain. The store and blog have been active for four years, the blog is regularly updated with original content, has many links to the store, is promoted regularly via my brand's social media channels and mailing list, and has the simplest SEO basics covered via a Yoast SEO plugin. But the store sees very little, if any, SEO benefit from the blog. My question is: based on this information, and the details below, is there an issue with the connection between the blog and main site in SEO terms? And if there is, how can I start fixing it? Further info: 1 In my Moz dashboard for the store site, the blog does not show at all as providing any inbound links or linking domains 2 Google Analytics also shows zero referral traffic to the store site from the blog since April 2015 3 Moz crawl issues is flagging ‘duplicate page content issues’ for pretty much every page of the blog, and the analysis provided suggests this may be related to tags but I have only basic SEO knowledge and am fast getting out of my depth here. 4 I have today altered the settings within the Yoast plugin on the blog to ‘noindex’ for Tags, Meta Robots, based on advice I have found in this section but am already well over my head and unsure even this is correct. An agency have been running SEO for the store since 2012 but since uncovering how little they have done in this time for the money paid, I am now taking matters back into my own hands. However I am on a very steep learning curve and this one is beyond me right now - please does anyone have any suggestions where I can start looking to uncover the root issue? Any guidance or advice would be greatly appreciated Thanks very much and hope to hear from someone!
Reporting & Analytics | | Warren_331 -
URL Keyword & Meta Title Problem
I was just reviewing my Moz report and came across something I could use advice on. The Keyword is "irish cardigans" I just moved to down a place to #5. I was going to add content to the page and back link a little to get back up on rankings but I noticed it is not all matching up. My Keyword is "irish cardigans" My Url is structured: products/traditional-irish-clothing-arans My metatitle is: Irish Sweaters - Traditional Irish Clothing - Arans & Cardigans The content title on the page heading is: Irish Sweaters and Cardigans. How will I change this to get my ranking better for "Irish Cardigans" The Page is also ranking for "Traditional Irish Clothing and Irish Sweaters" How do I know if I structure it to "Irish Cardigans" I will not loose traffic etc from the other keywords. Thanks
Reporting & Analytics | | robbieire0 -
If I install google Analytics, that can affect my SEO.?
I purchased a site that has a lot of Backlinks and when I started to make changes like installing google analytics! i suspect the performance in search engine was getting worst because of that, so I removed.
Reporting & Analytics | | pparma
Now I'm trying MOZ and needs GA, should I install it again??
Maybe it analyces the backlinks and tells google, I don't know, is that possible?0 -
Results for wrong keyword
I've started to look at ranking and visitor behaviour within a specific product category and I've come across this strange data in GA that i'm struggling to get my head around. keyword - wishbone necklace gold landing - ...necklace-dive-in.html bounce - 99.31% new visits - 0.00% The landing page is not anywhere in the results for the given keyword (nor does the keyword appear anywhere within the page). The data is spread out to date since Dec 2011 and the landing page accounts for about 97% of the traffic for that keyword. I then looked at browser which is 95% Safari (different versions) and breaking that down into City about 30% is (not set), 30% a single city and then there is a spread of locations. It might be fair to assume that therefore 60% could be the same location but there is still 40% to take into consideration. What I can't get my head around is how the landing page is being accessed so regularly for the wrong keyword. The correctly ranking URL only accounts for 5% of the traffic which is more in line with the estimated search volumes for that keyword. I've checked versions of the page going back and none contain the keyword. Am I missing something, or any ideas how to fix?
Reporting & Analytics | | MickEdwards0 -
Google Analytics - Keywords (not set) or ( not provided) WHY???
In Analytics, most of my visitors are landing on my home page, but when trying to see wich keywords they use, most of them are: (not set) or ( not provided) See screencast: http://screencast.com/t/AKwPW76qLVsN Can you tell why? What is going on? Is there a way to solve this? Thank you, BigBlaze
Reporting & Analytics | | BigBlaze2050 -
Is there any way to see how one my keywords ranked historically before I started tracking it?
Hello there! I'm in need of some historical data on some keywords as they relate to my site. Basically, I'd like to track which events have had the most impact on moving me through the rankings, but I wasn't using Moz at the time I had made some changes to my website... Is there any way to see how I ranked for a particular keyword at a given point in time? Thanks! Gene
Reporting & Analytics | | BGroup0 -
Best practice SEO/SEM/Analaytics/Social reports
Hi All, does anyone have a best practice excel spreadsheet of a internal report we should be using.... ie what are the main factors we should be tracking? Unqiue views? time spent on site? Where they came from? seo/sem/network/direct to site? social media tracking? amount of +1/fb likes/tweets etc thanks
Reporting & Analytics | | Tradingpost0