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
-
Drupal SEO Issues
Hi, I have two questions regarding my enterprise website. It is built on the Drupal CMS. First, and in looking at Google Analytics, I'm seeing more than 6k pages listed, but over 5k have received less than 10 page views in six months. In fact, most of them are not really content pages at all. The URLs I'm seeing listed, which to me indicates actual crawlable content in GA, shows pages like this: http://www.domainname.com/node/2153
Reporting & Analytics | | jaccardi62
http://www.domainname.com/company/careers?gnk=apply&gni=8a87142e4d086a73014d2a0d65242b8e&gns=glassdoor+free
http://www.domainname.com/blog?page=1
http://www.domainname.com/resources/videos?field_video_category_value=all&page=4&page=1
http://www.domainname.com/search/site?search_api_views_fulltext=talent+pool What is the problem here? Why are these non-pages being indexed as content and why are they showing up in GA? Second question is about my blog and blog best practices. While I know blog content is important for SEO, why is my site blog pagination being indexed as content. For example, these "pages" are showing up in SERPs: http://www.domainname.com/blog/tag/business_intelligence?page=2
http://www.domainname.com/blog/topic/expansion?page=5
http://www.domainname.com/blog/weeks_news_april_26 What is the best way to fix this? Thanks in advance for your help!0 -
Alternative tools for Keyword Traffic
Hi There, Wondering if anyone has any other tools they would recommend using for finding out keyword traffic on websites. Currently (and I'm sure like most), my website is connected to Google Analytics and Google Search Console. My biggest frustration becomes the "(not set)" variable that appears when I go to review the keywords section. It's always such a large number and I have no way of finding out what people might be typing in and coming across my website. Of course, I understand the privacy factor as to why Google must do this but it's certainly difficult to analyze what's working and what's not. Any tips, tricks or suggestions are greatly appreciated! Thanks, Lindsay
Reporting & Analytics | | MainstreamMktg0 -
Bing vs Google Keyword Research
Hi All, I have carried out keyword research based on Google Analytics, Keyword Planner, competitors and various other toolsets.
Reporting & Analytics | | Mark_Ch
My research has been based on performance metrics favored towards Google.
I'm looking to research keyword traffic metrics and suggestions based on Bing Ads Intelligence. My Logic
I have compiled my master list based on Google metrics.
I will carry out Bing search traffic metrics based on my Google master list.
I will carry out Bing keyword suggestions based on my Google master list. My Questions
#1 Will my logic yield me any favorable benefits based on the high number of Google users vs Bing users
#2 Should Bing favor a particular keyword with high search traffic compared to Google, is there a fear that creating a 'seo user friendly website page' could dilute link juice based on the high Google users. Any other useful advice would be welcome. Regards Mark0 -
How To Determine ROI For Specific Keywords
I have been looking through our analytics, and nealy all our conversions are from (not provided) keywords. I am trying to find the keywords that are performing best and also to determine the return I am getting from SEO efforts. I have been told the "not provided" keywords are due to people being logged into Google when they browse. However, this doesn't make sense to me. How is it that only the keywords that convert are "not provided"? Can anyone help with this?
Reporting & Analytics | | inhouseseo0 -
Can you filter referring keywords in Google Analytics by language?
Hi All! So yes, I know that you can see/filter the language that the computer or browser was set to (en-us, ru, fr, etc.), but if you look at the keywords used by visitors falling under "fr", some are in English. Is there any way to get, say, just the keywords in Russian - regardless of what the visitor's browser language was set to? Thanks! Aviva
Reporting & Analytics | | debi_zyx0 -
I am new to SEO. Would appreciate anyone share with me how can i further optimize my website to attract more visitors based on this scenario?
Hi all, Thanks and really appreciate for your time helping me out here, and i am very new to SEO. Just a brief introduction, our team have been developing a gaming review website (specifically targeting MMO game, facebook game, and browser-based game) since September 2011, and the website show significant improvement for the 1st month, and we got daily UV spiking up to 2k in November. The issue here is that the visitors start to become very stagnant, and even dropping now. Even though we try hard to publish more game reviews and there is NO IMPROVEMENT AT ALL for past 2 months in terms of number of visitors, and we have no idea how should we further proceed to attract more visitors...We have about 7 k site pages (however not all are with content). For the past 2 months it seems like there is nothing going on that proportionate to the effort we put in. Pretty discouraging, so we decided to sign up SEOMOZ to get SEO help from the community here. Some general questions we have: 1. Is it because of the the quality of the content we write ? (not enough keyword density, review too short, etc). 2. Is it because of the website designed not user friendly and not optimized? 3. Is it because of the general gaming trend, or other competitors? 4. Are we penalized by google by any chance? Are we spamming or anything wrong that deter our improvement? 5. Our main revenue source is on advertising, and currently we are using adsense. Would the ads placement affect anything? 6. Based on your knowledge and expertise, any advice would you give us? Would appreciate if you can take a kind look at the website to understand the scenario better: www.gameonline2.com, with 3 subdomain of: wiki.gameonline2; gameplay.gameonline2; cheats.gameonline2. For your reference, example our competitors are: www.onrpg.com; www.bbgsite.com; www.mmohut.com I would be happy to share with you any further information including google analytics if needed. I have report generated from SEOMOZ but i would appreciate the pros to help me take a look to give me a more complete ideas of how can i further improve to gain at least 10k visitors per day. Thanks again for your kind help and time. Andrew
Reporting & Analytics | | andrewsoh070 -
Analytics/Google Keyword comparison
Hi I'm trying to establish a methodology to best show the gap between potential and realised organic keyword traffic. To obtain potential keyword traffic I'm using the Google Adwords keyword tool to derive local monthly search volumes for exact keyword matches. However, I'm confused as to which is the best way of getting a comparable metric from Google Analytics (GA). I was using custom reports and the 'organic searches' metric. However, this provides different values to a standard report selecting non-paid search in the default advanced segments. What is the best report/metric in GA to use for both organic and paid search volumes that would be comparable to the Google Adwords keyword tool. Also, I'm having problems getting my kids to eat their greens, any advice! 😉 Thanks Neil
Reporting & Analytics | | mccormackmorrison0 -
Subdomains and SEO - Analytics & Webmaster Tools Setup Help
Any advice on the following greatly appreciated: How to get multiple subdomain data into 1 Google Analytics profile? Can we get multiple subdomain data into Google Webmaster Tools (and if so how?) or do we need to set GWT up per subdomain?
Reporting & Analytics | | AndyMacLean0