Headless analytics for data teams by Lassoo
Hello HN,

I’m Max, co-founder of Lassoo.io a 'headless analytics' platform for data teams built around Postgres. “'Headless analytics” is a term we’re coining to describe our approach. It’s analytics at its core, decoupled from the overhead of conventional tools (reporting, dashboards, BI, etc) , and it’s something we think the HN community, especially those mired in data work, will appreciate.

Consider the usual route - tools like Google Analytics paired with BigQuery, or niche analytics APIs. They’re powerful, no doubt, but they weren't built with the current demands of data teams in mind. The rigidity, the API fetch limits, the convoluted schemas, the compliance headaches - it's a lot. We imagined a different path, where SQL access to behavioral data isn’t just a feature, it’s the foundation.

Lassoo was born from our team’s experience in marketing attribution where we collected customer behavioral data (millions of data points a second) and mashed it with ad data (cost per clicks for each granular ad) to get an idea of which ads are credited for any given set of sales. We found many data teams going beyond attribution and saying “just give me the raw data''. So that’s what we did; in the simplest, most robust way possible. That’s why we built Lassoo to be headless - its analytics stripped down to its most potent form.

Here’s what Lassoo offers:

Direct SQL Access: Query your data directly. No API middlemen, no gatekeepers.
Governance by Design: Data quality and compliance aren’t afterthoughts; they’re baked into the platform.

Effortless Autotracking: Capture everything users do online with a simple JS snippet. No more convoluted setup or onerous instrumentation

AI/ML-Ready with built in features and classification: Your data comes prepped for the future - whatever algorithm or model you throw at it, Lassoo has it ready.

We chose PostgreSQL for our backend for its reliability and community support. It’s also compatible with every ETL tool on the planet. But Lassoo is so much more than another database service. We offer our data as a fully managed Postgres DB, hosted securely on AWS, with robust security controls accessed through the Lassoo UI (IP whitelist, user credentials, etc).
Currently we offer direct Postgres access and streaming replication using Postgres’ replication slots.

The schema is a data team’s dream. Simple, intuitive, and designed with your workflow in mind.

Want to know the impact of user behavior on sales? Our schema turns complex questions into straightforward queries.

Here’s an example to whet your appetite:

SELECT DISTINCT p.person_id
FROM person p
JOIN event_click c ON p.person_id = c.person_id
WHERE p.orders_total > 100.00
AND c.element_tag = 'button'
AND c.text_content = 'add to wish list'
AND c.timestamp_ BETWEEN '2023-05-01' AND '2023-05-31'

This snippet finds customers who’ve clicked “Add to wish list” in May and have a lifetime value over $100.

It’s just a taste of what’s possible. Oh and the above query was auto-generated by clicking on the actual “add to wish list” button on an e-commerce site running Lassoo.

We’re here to empower data teams to do more, with less. If making your data truly work for you resonates, I invite you to explore Lassoo use cases. Visit us at http://lassoo.io and see what headless analytics is all about.

Thanks for reading, and I'm eager to discuss any thoughts, questions or feedback you may have!