I'm thinking of something similar to a static site generator. You define s set of queries towards Postgres and visuals with code, check it into git, build it periodically. You can serve the pages publicly or keep them internal. All based on FOSS.

We have some [analytics](/stackers/day) but you mean something else?

k00b

@k00b thinking out loud: could you guys be interested (aka have budget) for developing internal analytics for stacker.news instances as part of the app itself?

pillar

random_

The lifespan / churn of a SN user?

stack_harder

I haven't looked at these stats in a long time (kr took lead on this), but we did a serious review them after SN was around a year old. One of the crazy things was that we retained ~80% (IIRC) of people for at least a month, after they received a comment or zap on something.

Anyway, you made me curious so I looked. Here's the result of a quick query. This would be cool to add to the analytics dashboard.

  count | avg | max
-------|---|------
 25736 | 90d | 1316d

The header is how many at least stayed that long.

1w  | 2w | 1m | 2m | 3m | 6m | 1y | 2y
------|----------|-------|-----------|-------------|-----------|------|-------
10698 |     9531 |  7861 |      6437 |        5677 |      4155 | 2399 | 695