Hi there,
I kept this topic private so you can get the idea.
We are currently using appacitive and we really loved it, only reason is lack of custom scripting and great support like you guys here.
www.appacitive.com
Please take a look at their apis and graph which allow us to make complex queries and with graph based connections we can see data from any angle.
Regards