Live data from Hacker News

Ask HN: How do you manage event tracking at your workplace

news.ycombinator.com

1–10 of 21 posts

Re: Ask HN: How do you manage event tracking at your workplace

#7
We're using Snowplow and it's quite great. There's a complicated setup process and you have to declare event schema before starting tracking, but it's quite cost effective if that's your priority.

We have millions of rows coming from unique users in realtime at $600/mo, with Segment this would at least be $5000/mo.

We then use Redash to prepare charts, tables, etc for analysis.

Re: Ask HN: How do you manage event tracking at your workplace

#10
Google Cloud Function streaming inserts to BigQuery. Then analysis is carried out with the BigQuery UI (ad hoc analyses or scheduled queries for pipelines), DataStudio (visualizations -- we use this infrequently, it's really not great) or Google Colab (statistical analyses, complex visualizations).

The pros are:

* full SQL access to the data via BigQuery

* simple to set up (yes, you have to write custom code; but a basic implementation is on the order of a couple dozen of lines of code)

* we have full ownership of the data across the pipeline (better for user privacy than using another 3rd party)

Prior to this we used Google Analytics, but their paid solution is too expensive for us and their analytics/aggregation API (though quite powerful) samples a subset of the data which was not acceptable for some of our use cases.

Post reply on HN