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
-
Organic vs SEO in Analytics
In my analytics account, the Acquisition / All Traffic / Google organic searches shows me around 19,000 hits from 1st Jan to 1st Feb. But if I go to the Search Engine Optimization tab / Queries or Landing pages I can only count 1,800 clicks from 1st Jan to 1st Feb. Why such a huge discrepancy ? Am I getting 1800 clicks from the Google organic search, or 19,000 ?
Reporting & Analytics | | coadr930 -
Landing page URL appearing as keyword
Hi Mozers, I've recently experienced the URLs of my key landing pages coming up as keywords. This has been on the rise since early July (when it was relatively insignificant) to the current position (see image below) where they make up the majority of my top keywords. Drilling down into a bit more detail, this seems to be almost exclusively Desktop traffic but in terms of Technology there are no clear standouts (seems to be mostly Windows OS and Chrome). Has anyone else been experiencing this?
Reporting & Analytics | | mopland0 -
Traffic by keyword- phenomenon
I have several keywords that seem to bring visitors in but when I look at my rankings it shows that I have no ranking authority at all. Are these just robots or some non human click? Or how do I even get these visitors?
Reporting & Analytics | | Retail_Endeavors0 -
Has anyone attended or hired anyone from Full Sail University? Or schools offering Internet Marketing or SEO
We are actively looking for a couple of positions. A qualified SEM (for PPC, etc) pro that has experience with Google but also others including BING and Yahoo. And a good SEO person who gets it is about delivering a result and not blowing sunshine up someone's skirt or pant leg.
Reporting & Analytics | | RobertFisher
That said I got a resume the other day from a guy and he stated he had a Master's Certificate in Internet Marketing from Full Sail University. I looked them up and they offer a Bachelors Degree and a Masters Degree in Internet Marketing. They also offer a certificate in Internet marketing they call a Master's certificate. So, I set a time for him to call me as I was mildly skeptical.
When I started asking about the certificate (His LinkedIn page had Masters Degree in IM) he said he had taken the certificate and I did not pursue the LinkedIn. I asked how long he was in school for the certificate and he stated 6 months (curriculum is 4 months and is fairly t h i n.
I asked what he had done and he had completed an Internship with a Texas company and helped a construction firm move to page one. When I asked how he started telling me about inserting keywords in the meta tag field in the CMS..... He did not know what a title tag was, knew nothing of content, H1, H2, Local Optimization and then wanted to tell me how when you put their Domain name in google they are number two on page One. So you get it, I believe. I am just really frustrated with the whole "certification" etc. thing and believe we do need it. Market Motive is as close to good as I can see, but I would love to hear from you. (Note on MM- I do not like the if you pay monthly you get Provider or whatever but it you shell out $3500 you are a Master. Just doesn't feel right to me. And, I did speak with someone a while back with a masters from them and again, I scratched my head). Would just like to hear of your experience and if anyone has hired from these schools with success.0 -
301 Tracking with Google Analytics hurts SEO?
Hey guys, I have an old-domain.com and a new-domain.com. old-domain.com has reputation and through a 301 redirect it's handling it over to new-domain.com. I want to know how many people still visit old-domain.com and track this with Google Analyitcs. I read the best solution for this would be a Google Campaign URL. My question: Does a URL like "http://www.new-domain.com /?utm_source=&utm_medium=redirect&utm_campaign=" hurt the effectiveness of the 301 redirect?
Reporting & Analytics | | optimiert-es0 -
Keyword referrals in GA
Hi chaps, Quick question for you. I'm drilling down in GA to one of our eCommerce pages which has a pretty high bounce rate. I'm looking at referring keywords and they don't seem to make much sense. The page I'm looking at is a pretty deep page but the top referring keywords are all branded terms. The page isn't included in our site links. To explain a little further, this is the scenario I think is happening: User searches using "Brand term". They then click through to our homepage and eventually land on the deep shopping page (on a different subdomain) In GA Content > Site Content > Pages > Primary dimension set to keyword - "Brand term" shows as the referring keyword. Does this sound right? We have a custom GA script set up to track multiple subdomains.
Reporting & Analytics | | Confetti_Wedding0 -
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 -
What factors does the Keyword Difficulty Tool measure?
Hi Guys I am new to this community and finding loads of informative stuff here. The keyword difficulty tool looks very interesting. I think google keyword tool competetion field is based on PPC competetion? Will i be right in saying that the moz keyword difficulty tool measures top 10 ranking pages, their age, backlinks etc?
Reporting & Analytics | | SamBuck0