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
-
How to uncover GA "Not Provided" organic keywords?
Hello, Google Analytics has a lot of keywords which are tagged as "Not Provided" So how can i uncover what these are? Otherwise how do i know which organic keywords are doing well or not?
Reporting & Analytics | | Riz_Khan0 -
Is there a way to map your on-page SEO changes with the organic growth?
Hi Mozzers, I was just wondering if there's a way we can map our on-page SEO changes with the increase/decrease in organic traffic. For instance, I introduced brand pages' link the product page breadcrumbs and suddenly organic traffic for my brand pages increase from X to 2X in 1 couple of weeks. Now, this can be because of this breadcrumb change purely or because of some algorithm update or may be, bots started finding the content interesting and hence, started ranking them up (in case the brand pages were launched recently). So, you can't say which change should be mapped to what increase/decrease in organic traffic. Or, is there a way to map this?
Reporting & Analytics | | _nitman0 -
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 -
Why are there url's in my np Keywords in google analtyics?
I have been scratching my head at this one. On my not provided keywords, there is a url. Keyword is the primary dimension. It doesn't makes sense why there would be url keywords for pages with a different url. For example, the keywords for page www.xyz.com/abc np - /someotherurl.com Thanks for your insights in advance!
Reporting & Analytics | | konverge0 -
Best use of Keyword Rankings report
is there a guide for getting the most out of the keyword ranking tool? I currently have 250 or so keywords, some move up, some move down on a weekly basis but generally trend up. That's about as much info as I gain from it though. anyone got any good tips? thanks
Reporting & Analytics | | benj450 -
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 -
GoDaddy SEO Services?
So one of my client's wants to know why he shouldn't just hire GoDaddy to "do SEO" for him! He found this page: http://www.godaddy.com/search-engine/seo-services.aspx Without actually trying it, It looks like a bunch of stuff I already do (rank tracking, PR tracking, traffic tracking, ROI projections), stuff I shouldn't do (site submissions to search engines), and stuff I probably don't need ("keyword wizard"). That said, I am intrigued by: the dedicated phone number with track and monitor (is it better than Hosted Numbers?), the business listing (is it a link worth the $6/mo?), site analysis and optimization, and ROI dashboard. Does anyone have any experience with this? Does any piece of it have any value?
Reporting & Analytics | | TheEspresseo1