For the Solflare wallet team, we unified on-chain activity and off-chain product analytics into executive dashboards, plus a self-serve experimentation pipeline for PMs.
Illustrative preview · not live data
The challenge
On-chain wallet activity and off-chain product analytics lived in separate worlds, so no one could see the full user journey from transaction to retention.
The approach
We built Dune queries and API pipelines feeding BigQuery, modelled reusable reporting layers with dbt (wallet, transaction, staking, swap, revenue), and unified everything in Tableau. Then a full A/B pipeline: membership, exposure, cohort retention, lift, and stat testing.
The result
One executive view across on-chain and product, reusable dbt models the team owns, and PMs running their own experiments without waiting on data.
Built with
Have data to put to work?
One free call, we'll find your highest-ROI first move.