I need a tool/tools to extract keywords from say 50 sites in one niche and then check the rank tor those sites
-
This is for telemarketing of seo services I want to have some insight into an industry before I call them could this be done with the adwords keyword tool api and then exported to excel. It would also be nice to have data on backlinks say from seo moz opensite explorer.. Its just that the research you do before you even call a potential client is so time consuming and you can never really check to see how they are ranking for there main keywords manually. We are trying to automate as much of this initial research as possible...
Any Idea's
Thanks
-
For checking rankings, I've found SEMRush to be very useful. Not sure about automation, but it has fairly easy access to data and it allows you to export to Excel or CSV.
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
-
How can I limit the impact of Google's mobile friendly updates on keyword rankings?
Hi everyone, I have a client on a monthly SEO package that is taking a hard hit in the rankings as their website is not mobile friendly. We are currently building a new website for them that will be fully responsive, but face the predicament of how to keep the current site performing relatively well in the rankings in the meantime. The site is generally well optimised and we always follow SEO best practices, so we've hit a bit of a stumbling block as to how to limit any negative impact the mobile friendly updates have on the site. Does anyone have any suggestions for damage limitation? Any help will be greatly appreciated. Thanks.
Moz Pro | | keyzo0 -
We need your expertise! Do you have a tool hack or trick you use with Moz Pro?
Hey friends! We're looking for any tricks and tips you have for other people using Pro. Everyone has their own way of doing things. We'd love to see if you have any hacks you've created. You can send over just a screenshot, or a blog post, or anything you've got! Here are a couple examples: [blog post] Did you know you can use OSE's anchor text export to see if you are getting setup for a penguin penalty? This is a blog post about it: http://moz.com/academy/google-penguin-and-you [screenshot] Did you know you can get all your keyword ranking historical data by clicking this one little button? http://i.imgur.com/l4KxqBt.jpg Do you have anything you'd like to add? We're hoping to help spread these to others to help people utilize the tools to their potential. Thanks!
Moz Pro | | jennita2 -
Rank Checker Tool Status
Hi I take it the Rank Checker tool is not working right yet as I'm getting bizarre ranks for some of my keywords. Some stating 50th when I know we're on the first page for instance, even using GA > search engine optimisation the averages for this term for instance is 11th across all countries. If this is the case and its still being redeveloped I'll just skip the tool for now Cheers David
Moz Pro | | David-E-Carey0 -
What web page and domain analysis / error checking / testing tools do you use for competitor analysis? sites like webpagetest
Just wondering what everyone is using, I am looking to get as much insight and detail as I can on websites that are not currently being monitored by me... i.e. potential clients. I use tools like pagespeed, webpagetest, loadimpact and open site explorer, google adwords, ispionage, alexa, semrush and well, looking for more. I really just want to rip a website to the tiniest pieces possible in an organized and coherent manner... is there anything out there? I have tried several other's which i no longer use (compete, 4q, woopra, nuestar, to name a few), I am not sure if I know exactly what i want, i just want more.... damn the human condition. lol
Moz Pro | | atb9900 -
Proportion of branded keywords vs targeted keywords in anchor text distribution
Hello, I have a question about the proportion (in %) of branded keywords vs targeted keywords in the anchor text distribution of a website. Suppose if I have a website with 3 targeted keywords and 2 branded keywords in the anchor text distribution that looks like this: 1 main targeted keyword 20% 2 targeted keyword 15 % 3 targeted keyword 15 % 4 branded keyword 10 % 5 branded keyword 5 % 6 more keywords 35% The question is: What would be the best distribution in percentages to aim for the main and other keywords? Should the branded keyword % increase and (main) targeted decrease? Or something else? (I have "Opensite Explorer" and Cognitive SEO" as tools to measure.) Thank you for your answers!
Moz Pro | | ThomasH0 -
Do I need backlinks?
Hi, My theory is yes I do. But the problem I have is a small budget and competitors who have a big one. My problem is we have a small number of external links and linking root domains. My profile from a domain analysis read like this in March and then May... External Followed Links - Mar 103 | May 257
Moz Pro | | YNWA
Total External Links ------- Mar 114 | May 276 Total Links ------------------- Mar 5,577 | May 24,425 Followed Linking Root Domains - Mar 24 | May 47
Total Linking Root Domains ------- Mar 30 | May 55 As you can see, progrss is being made considering I do this part time for a family website. But what I need is a big bump in these numbers as my 3 compeitors are pulling in silly numbers such as 308, 7000 and 45000 external followed links. Does anyone have any suggestions on how to compete with this realisticy without spending a fortune? I am putting the time and effort in so anything you guys can do to help the better. I am using twitter and facebook quite a bit, and seen growth on Twitter go from 40 to 1,350 followers over 7 months. Visits to the site over 7 months have gone up 50% as well. However sales are still looking about 10-15% up on previous year. I need more links coming into the site don't I? And what is the most important part of the Domain Analysis, what shoudl I want to increase first and foremost? Any ideas? Cheers Will0 -
"Rank Tracker Tool" is not agreeing with "Keyword Difficulty Tool"
I usually don't sweat a lot for ranks and such but last couple of days, our rankings have been moving drastically. 'Rank Tracker' shows 1st position for many keywords and the "keyword difficulty tool" shows 2nd and 3rd positions. Is is just me or this is a common thing?
Moz Pro | | Syed10 -
Bing ranking my non-www version of my site.
My site is ranking #1 on Bing for the non-www version of my homepage, but this is not showing in my ranking stats, since the site is setup in SEOMOZ as www version. Do I have to create a whole new campaign for the non-www version or is there a way to pickup these rankings?
Moz Pro | | pdlcom0