Any alternatives to Mixpanel ?
emmett: I don't really understand your problem fully, but if Mixpanel looks like a good fit I would recommend using them for your new data, and creating a separate system for viewing your historical data.That reduces the requirements for the code you have to write (it only has to be able to deal with historical data, you don't need to figure out how to deal with updates), while giving you maximal features in the long run.