By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id | session_id | timestamp | utm_source | utm_medium |
---|---|---|---|---|
a | session_1 | 2020-06-15 12:00:00.000 | search.com | search |
b | session_1 | 2020-06-15 12:01:00.000 | null | null |
c | session_1 | 2020-06-15 12:01:30.000 | social.com | social |
d | session_1 | 2020-06-15 12:02:00.250 | ads.com | ads |
e | session_2 | 2020-06-15 14:00:00.000 | null | null |
f | session_2 | 2020-06-15 14:12:00.000 | null | null |
g | session_2 | 2020-06-15 14:25:00.000 | social.com | social |
h | session_3 | 2020-06-16 12:05:00.000 | ads.com | ads |
i | session_3 | 2020-06-16 12:05:01.000 | null | null |
j | session_4 | 2020-06-15 12:00:00.000 | null | null |
k | session_5 | 2020-06-15 12:00:00.000 | search.com | search |
session_id | session_start | session_duration | interaction_count | first_touchpoint | last_touchpoint | last_medium |
---|---|---|---|---|---|---|
session_1 | 2020-06-15 12:00:00.000 | 120 | 4 | search.com | ads.com | ads |
session_2 | 2020-06-15 14:00:00.000 | 1500 | 3 | null | social.com | social |
session_3 | 2020-06-16 12:05:00.000 | 1 | 2 | ads.com | null | null |
session_4 | 2020-06-15 12:00:00.000 | 0 | 1 | null | null | null |
session_5 | 2020-06-15 12:00:00.000 | 0 | 1 | search.com | search.com | search |