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 is Local SEO in Google Analytics (Organic Source)
Recently, I saw "Local SEO" is mentioned as the organic source. Can someone please tell what is this and from where Google is fetching data for this source?
Reporting & Analytics | | Kevin.Monks0 -
How to measure Seo Roi with GA?
Do you have any dashboard or suggestion to measure Seo Roi with GA? I want to create a report that makes visible these fields: Monthly increase in visits from Google Time spend on site Number of conversions Other things that can i add?
Reporting & Analytics | | markovald0 -
Campaign Tracking URLs and the Impact on SEO
Hi Guys, I am setting up tracking for a couple of offline campaigns in Analytics and would just like to know if this will cause issues. The situation is below: Two URLs Ranking Well Organically: www.domain.co.uk/area-covered/area-a www.domain.co.uk/area-covered/area-b URLs Setup for the Purpose of Offline Campaigns www.domain.co.uk/campaign1 www.domain.co.uk/campaign2 Plan to Track this in Analytics www.domain.co.uk/campaign1 redirecting to www.domain.co.uk/area-covered/area-a_&utm_medium=qr&utm_source=test1&utm_campaign=test1_ www.domain.co.uk/campaign2 redirecting to www.domain.co.uk/area-covered/area-a&utm_medium=qr&utm_source=test2&utm_campaign=test1__ So the idea is that the user gets a nice simple URL to input from the off-line media (www.domain.co.uk/campaign1). This then redirects to one of the pages thats performing well organically (www.domain.co.uk/area-covered/area-a) but with the relevant tracking (www.domain.co.uk/campaign1 redirecting to www.domain.co.uk/area-covered/area-a&utm_medium=qr&utm_source=test1&utm_campaign=test1). The only way that the tracking URL can be accessed by the user is if the off-line media URL is entered. My main concern here is how Google will treat this. Obviously I don't want to cause issues with the two URLs that are ranking well organically. Would having a version of exactly the same URL, just with tracking do so? Any help is appreciated! Thanks in advance.
Reporting & Analytics | | CarlWint0 -
How to identify rising keywords in analytics?
Hi Guys I just spotted in the Google Analytics > Traffic Sources > Search Engine Optimisation > Queries section a keyword that on the 27th Feb went from generating 35 impressions per day to 2000 impressions per day. This was down to people searching for a newly launched product. Does anyone know how I can identify any increases like this easily? I only came across this by accident, and I am 1 month behind the times. It would have been ideal to pick this up closer to the time so I could capitalise and write some great content on the topic. Thanks Paul
Reporting & Analytics | | TheUniqueSEO0 -
Is there a way to do this sort of keyword research?
I'd like to be able to do some keyword research as follows: Let's say I have two (or maybe more) separate keyword phrases I want to rank, is there a way to find out what combination and/or additional keyword phrases/descriptors are searched for the most? For example, let's say I want to rank well for the following terms. "Green widgets" and "boxes" Is there a tool I can use that will give me ideas/suggestions on how to use those two keywords the best way? Especially showing me long tell keyword suggestions I may not even know about. The tool may show me things people search for like "best boxes for your green widgets" gets more serach results than "best boxes for my green widgets." (Helping me figure out which combo of words in a long tail phrase is better. Or it may tell me a suggestion I didn't think about like "how to build boxes for your green widgets," or "how to put your green widgets into boxes," or "where to find boxes for your green widgets" or other combinations of things people search for using those two phrases? This may be possable using google keyword tools, but if it is, I'm not sure how to do it. Looking forward for any feedback. Thanks!
Reporting & Analytics | | NoahsDad0 -
What is the SEO Impact of Adding a Directory to URL
I would like to add a new directory named “products” for all of the product detail pages on my site. Instead of having the URL for a product be “mysite.com/product-details-page.aspx” we would like to change it to “mysite.com.com/products/product-detail-page.aspx.” I want to do this to enable us to add product pages to our traffic funnel analysis by filtering visits to the "product" directory - right now we can't track visits to product pages in the funnel because they are just one-off the main site. I know this change will require redirects for every single product. Is there anything else that needs to be done? My main question is, will this change negatively impact the SEO value of the product pages? We have several product pages ranking in the SERPs, and I don't know if pushing them one directory further will change that. Thanks for your input!
Reporting & Analytics | | pbhatt0 -
Tool to check pervious rankings for a keyword ?
I am looking a tool/site to check ranking history of specifc keyword . Is this possible ? Thanks
Reporting & Analytics | | bfletc40 -
Top Notch SEOs on the forum - I have a challenge for you!
I have been hitting my head again the wall trying to figure out why Google does not move my page up. All the SEOMOZ numbers show that the page has higher authority than the competition, more links, more domain authority, older domain, and higher Page rank. In addition the page is error free and I've gotten a W3C HTML 4.01 approval. About a month ago We were at #10 , then after the changes I've made to content and the page Google moved the page to #8, Now the Page is back to #9. I've done plenty of SEO to drive traffic to the page and created some very powerful and quality links. However, it seems like the page is being punished for something. Much weaker competitors are outranking our page and I am not sure why. On page optimization, title tags, Meta Tags, keyword density, etc - everything is there. In fact I have a check list that I go by and everything is by the book. Not only that, one competitor now shows up twice. First the domain and then specific page. I've looked into specific page and all they did is create 600 internal links from their own website. So now they are number #2 and #3 If anyone can take a look and give me an idea of what is going on and maybe suggest Keyword: Laser Marking Url: http://tinyurl.com/3nt3g2h Any help would be appreciated..
Reporting & Analytics | | DmitryP0