Email Campaign
Start Timer
0:00:00
Your company has begun a new email campaign. You have the tables below-detailing users
visits to the site and timestamps of when emails were sent to users.
- How would you measure the success of this campaign?
- Write a query to analyze the success of your campaign.
Example:
Input:
users
table
Column | Type |
---|---|
id |
INTEGER |
emails
table
Column | Type |
---|---|
id |
INTEGER |
user_id |
INTEGER |
sent_at |
DATETIME |
user_sessions
table
Column | Type |
---|---|
session_id |
INTEGER |
user_id |
INTEGER |
created_at |
DATETIME |
Recommended questions for you
Personalized based on your user activity, skill level, and preferences.
.
.
.
.
.
.
.
.
.
Comments