I need a tool/tools to extract keywords from say 50 sites in one niche and then check the rank tor those sites

[duncan274]

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

[brandonjschwartz]

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.