Activity Conversion
You’re given three tables, users
, transactions
and events
. We’re interested in how user activity affects user purchasing behavior.
The events table holds data for user events on the website where the action
field would equal values such as like
and comment
.
Write a query to prove if users that interact on the website (likes, comments) convert towards purchasing at a higher volume than users that do not interact.
users table
column | type |
---|---|
id |
INTEGER |
name |
VARCHAR |
created_at |
DATETIME |
transactions table
column | type |
---|---|
user_id |
INTEGER |
name |
VARCHAR |
created_at |
DATETIME |
events table
column | type |
---|---|
user_id |
INTEGER |
action |
VARCHAR |
created_at |
DATETIME |
.....
Loading editor