Automated Data Extraction for various SEO Activities

Hello guys,

I need some help regarding automated SEO data extraction. I am looking for tools which will automate the data extraction work.

Following are activities which we perform manually or are semi-automated:

1. Extracting on-page data (Title, description, Headers, Alt tags, content) - Need tool which will extract all the data into a single excel file.
2. Internal Site Search - Tool which will automatically mail us the report of weekly internal site search.
3. Lead Conversion Data
4. Keyword Research
5. Ranking Report
6. Quarterly Business Review Report

I am searching for 'a tool' or 'tools' which will simplify all the time-consuming data pulling methods from Google Analytics or GWT. I know one tool 'Supermetrics', but I don't know anything about it.

If you have any knowledge of such tools, kindly share.

Thanks