arrow_back Data & Analytics work
Web3 · ProductData & BI

Solflare, one source of truth.

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.

solflare · executive analyticsLive
Active wallets
1.24M
Staked
18.4M SOL
Revenue
$2.1M
On-chain volume, 30d+27%
Activation funnelA/B: variant B +9%
ConnectSwapStakeRetain

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.

Unified
on-chain + product
Reusable
dbt reporting layers
Self-serve
A/B for PMs
1 view
wallet to retention

Built with

BigQuery dbt Dune Analytics Tableau PostHog SQL

Have data to put to work?

Let's unify your data.

One free call, we'll find your highest-ROI first move.

More work