Data Tasks/Write the SQLProduct

Write the SQL to calculate DAU and MAU.

Write the SQL to calculate DAU and MAU. Bruin connects to your Amplitude + BigQuery to write and run the SQL for DAU and MAU, and returns a governed answer in plain English with the SQL and column-level lineage behind it. Ask in Slack, Teams, Discord, WhatsApp, or your browser.

Metrics & KPIs

DAUMAUstickiness

Required Data

Activity events

Data Sources

AmplitudeBigQuery

How Bruin does this

Bruin

Bruin AI Data Analyst

Write the SQL to calculate DAU and MAU.

Bruin connects to your Amplitude, BigQuery, writes the SQL, and runs it for you, with column-level lineage behind every number.

It tracks DAU, MAU, stickiness and delivers the result in seconds, in Slack, Discord, Teams, Google Chat, WhatsApp, Telegram, email, or your browser.

Get it done in seconds

Connect your data, ask the question, get the answer. No SQL needed.

Sign up to our newsletter

Practical updates on open-source data pipelines, AI analysts, governance, and what we are shipping at Bruin.