We've been looking for analytics for web application, which could be run in our own servers. I like Mixpanel, but because of the nature of the service, we have to keep the data on our servers.
Any recommendations or experiences?
If you're looking for MixPanel/KissMetrics style arbitrary event tracking, I do not have a good recommendation for you for an OSS or off-the-shelf solution. I'd be interest in hearing others' experiences.
A lot of consulting clients end up rolling their own. You can get pretty far with Postgres or Redis and hourly/daily cron jobs which dump their output to a few admin screens. They're several orders of magnitude more expensive than the SaaS alternatives (+), marketing can't use them w/o engineering helping out to set them up, and they're generally going to produce less pretty output, but they're often perfectly adequate for decisionmaking.
(+ I struggle to think of a consulting client which does metrics in-house that does not have six figures or more of implicit engineering cost in their metrics systems.)
In it you can find multiple open source solutions such as Piwik (see sheff comment), snowplow (https://github.com/snowplow/snowplow) and Graphite (http://graphite.wikidot.com/start).
Hope this helps.
We don't need to know where our users come etc, but more following certain events and patterns and how they engage with the app.
Its open source, fairly well established and can be self hosted.
A list of its main features can be seen here : http://piwik.org/features/list/ .