News for hackers. Stuff that matters.
Re:Tell HN: My Web App has 13 Users by charliepark on Saturday March 16, 2013 @08:13PM (#5387354)
Joel, what are you using for your cohort analysis? An internally-built tool? A third-party service?
Re:Tell HN: My Web App has 13 Users by joelg87 on Saturday March 16, 2013 @08:38PM (#5387430)
Hey Charlie! We've been back and forth on this in the lifetime of the startup, but we're now doing all metrics ourselves, so it is internally built. I built an early version of the cohort analysis (which didn't scale, but that didn't matter) just a few months in and it was massively valuable. It's not too hard to knock something together.
Re:Tell HN: My Web App has 13 Users by adambenayoun on Saturday March 16, 2013 @09:43PM (#5387606)
Thanks for the answer Joel! By the way - I'm curious why you guys had to built this internally - I always get the feeling people prefer using a 3rd party service like kissmetrics than building something.
Re:Tell HN: My Web App has 13 Users by robertocr on Sunday March 17, 2013 @10:43PM (#5392101)
Internal BI is the way to go. It gives better vision to those who make decisions. Congratulations! :)
Re:Tell HN: My Web App has 13 Users by charliepark on Sunday March 17, 2013 @06:44AM (#5388793)
Solid. Thanks!
Re:Tell HN: My Web App has 13 Users by nanch on Saturday March 16, 2013 @09:40PM (#5387599)
Would be an interesting third party tool. Does anyone do this already? Something as simple as receiving a list of usernames over time.
Re:Tell HN: My Web App has 13 Users by lubos on Saturday March 16, 2013 @09:56PM (#5387652)
MixPanel can do this and they have a free plan.

I custom-built my own cohort reports but as number of users grow in my own app, I'm planning to replace it with MixPanel. You don't really want to put stress on your own database servers which are meant for production, not for analysis.

Re:Tell HN: My Web App has 13 Users by aaronblohowiak on Sunday March 17, 2013 @03:53AM (#5388532)
You should not be doing analysis (OLAP) on your main transactional database (OLTP). Moving from transaction-processing system (TPS) to analysis is done through a process call ETL (Extract, Transform, Load.) You will want to transform your data into facts and dimensions -- this is going from a relational model to a multidemensional model (using a star schema.)
Re:Tell HN: My Web App has 13 Users by lubos on Monday March 18, 2013 @03:27PM (#5396559)
but that would be another system to maintain. I'm happy to outsource this to MixPanel or some other company. My needs are pretty generic. I appreciate your response though.
Re:Tell HN: My Web App has 13 Users by aaronblohowiak on Tuesday March 19, 2013 @09:49PM (#5405060)
Yes, I 100% believe in focusing on your core competencies. If the OLAP is self-hosted or external, the key takeaway is to not do analysis against production (once your data set is larger than RAM ;) before that, who cares?)
Re:Tell HN: My Web App has 13 Users by ryanjm33 on Sunday March 17, 2013 @11:20AM (#5389488)
Cohort.ly does a great job. They are in private beta so you can request access. It has been really beneficial to us.

http://cohort.ly/

Re:Tell HN: My Web App has 13 Users by mh- on Sunday March 17, 2013 @08:57PM (#5391790)
I really dislike this trend of only having videos to share info about a product or service.

Not even a blurb on there.

Re:Tell HN: My Web App has 13 Users by mh- on Sunday March 17, 2013 @09:05PM (#5391810)