Email Campaign
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 |
.....
Loading editor