MAU Transaction Sequence in 30 Days | Dataford Interview Questions

Write a query to find the monthly active users (MAU) who completed a specific transaction sequence within a 30-day window at Intuit Management Consultancy.

Assume the sequence is initiated, followed by approved, followed by completed for the same transaction. The completion must occur no more than 30 days after initiation, and MAU is based on the completion month.

Output

One row per completion month
Columns: activity_month, formatted as YYYY-MM, and mau, the distinct qualifying user count
Sort by activity_month ascending

Schema

transaction_events

Column	Type	Description
event_idPK	INT	Unique event identifier
user_id	VARCHAR(20)	User associated with the event
transaction_id	VARCHAR(20)	Transaction associated with the event
event_type	VARCHAR(20)	Transaction lifecycle event
event_at	TIMESTAMP	Timestamp when the event occurred

Your question is MAU Transaction Sequence in 30 Days. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Write a query to find the monthly active users (MAU) who completed a specific transaction sequence within a 30-day window at Intuit Management Consultancy.

Output

One row per completion month
Columns: activity_month, formatted as YYYY-MM, and mau, the distinct qualifying user count
Sort by activity_month ascending

Schema

transaction_events

Column	Type	Description
event_idPK	INT	Unique event identifier
user_id	VARCHAR(20)	User associated with the event
transaction_id	VARCHAR(20)	Transaction associated with the event
event_type	VARCHAR(20)	Transaction lifecycle event
event_at	TIMESTAMP	Timestamp when the event occurred

Your question is MAU Transaction Sequence in 30 Days. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.