Build SEO Reporting Tool w/Google Analytics, Google Trends & Compete.com API Question

Get Started
1

I would like to build a tool that simply pulls queries from Google Analytics, Google Trends, Google Search, Bing, Yahoo, Compete.com, SEOmoz, MajesticSEO, and a few additional service providers through their API’s to generate a report which I can then populate into a Microsoft Excel workbook or Google Docs. I have built the workbook with multiple tabs, know exactly what data sets I want from each of the providers, but just don’t have a clue where to start. I’m a programmer with limited abilities but I have deep resources where I work. Can anyone offer some advice on how to start putting this project together? So far I have:

  1. Downloaded all API documentation for all the service providers I would like to integrate.
  2. Defined a list of all the data variables that I need to complete the report.
  3. Researched which language each API uses.
  4. Research the limitations and advantages of each of the programming languages.

The questions that are really floating around in my brain are:

  1. Are there already tools that do this available? Either paid or open source.
  2. Is this going to be a difficult project considering all the API’s kind of have their own way of doing things i.e. passing variables through URL, Python, etc.
  3. What’s the best language, database, etc to write this in?
  4. How would I go about finding a programming firm that has this type of expertise? (I’m putting this project together for my employer)

Thanks!

BlueHawk74 (Zach)
bluehawk74@gmail.com

2

I think this is a great idea.

I use Web CEO, Rank checker, Google’s External keyword tool, SEO Moz pro SEO tools and a few other services on a regular basis. I guess your biggest competitor would be Web CEO.

How have you put together the variables? What will your proposed software be able to do?