Monthly Active Users by Campaign | Dataford Interview Questions

Write a query to find the monthly active users who signed up via a specific marketing campaign.

Use the users, campaigns, and activity_events tables. For this exercise, the campaign is Copilot Launch, and an active user has at least one recorded activity event during the month.

Output

One row per month with columns activity_month and monthly_active_users.
Include only users whose signup campaign is Copilot Launch; count each user once per month.
Sort chronologically by activity_month.

Schema

campaigns

Column	Type	Description
campaign_idPK	INT	Unique campaign identifier
campaign_name	VARCHAR(100)	Marketing campaign name
channel	VARCHAR(50)	Primary acquisition channel

users

Column	Type	Description
user_idPK	INT	Unique GitHub user identifier
email	VARCHAR(255)	User email address
signup_date	DATE	Date the user signed up
campaign_id	INT	Campaign attributed to the signup

activity_events

Column	Type	Description
event_idPK	INT	Unique activity event identifier
user_id	INT	User who generated the event
activity_at	TIMESTAMP	Timestamp when the activity occurred
event_type	VARCHAR(50)	Type of product activity

Your question is Monthly Active Users by Campaign. Start with the requirements and the three tables 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