Write SQL and Python, run instantly in your browser, and track your progress.
You are a Customer Success Analyst at Atlassian. The Product team needs complete login data for engagement analysis. For users who have never logged in, use their account creation date as a placeholder for last_login.
| Column Name | Type |
|---|---|
| user_id | int64 |
| org_id | int64 |
| object | |
| full_name | object |
You are a Customer Success Analyst at Atlassian. The Product team needs complete login data for engagement analysis. For users who have never logged in, use their account creation date as a placeholder for last_login.
| Column Name | Type |
|---|---|
| user_id | int64 |
| org_id | int64 |
| object | |
| full_name | object |
| role | object |
| role | object |
| seat_type | object |
| seat_type | object |
| status | object |
| status | object |
| mfa_enabled | int64 |
| mfa_enabled | int64 |
| created_at | object |
| created_at | object |
| last_login | object |
| last_login | object |
| user_id | org_id | full_name | role | seat_type | status | mfa_enabled | created_at | last_login | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | feng.ferrari@vividdata.app | Feng Ferrari | owner |
| user_id | org_id | full_name | role | seat_type | status | mfa_enabled | created_at | last_login | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | feng.ferrari@vividdata.app | Feng Ferrari | owner |
| user_id | org_id | full_name | role | seat_type | status | mfa_enabled | created_at | last_login | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | feng.ferrari@vividdata.app | Feng Ferrari | owner | full | active | 1 | 2025-07-29 | 2025-08-31 20:18:24 |
| user_id | org_id | full_name | role | seat_type | status | mfa_enabled | created_at | last_login | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | feng.ferrari@vividdata.app | Feng Ferrari | owner | full | active | 1 | 2025-07-29 | 2025-08-31 20:18:24 |
Showing first 5 of 224 rows.
Showing first 5 of 224 rows.
1. Data Selection:
2. Cleaning:
3. Output:
1. Data Selection:
2. Cleaning:
3. Output:
| full |
| full |
| active |
| active |
| 1 |
| 1 |
| 2025-07-29 |
| 2025-07-29 |
| 2025-08-31 20:18:24 |
| 2025-08-31 20:18:24 |
| 2 | 1 | tao@vividdata.app | Tao Schneider | viewer | full | invited | 1 | 2025-08-18 |
| 2 | 1 | tao@vividdata.app | Tao Schneider | viewer | full | invited | 1 | 2025-08-18 |
| 3 | 1 | fang.al-farsi@vividdata.app | Fang Al-Farsi | member | full | invited | 0 | 2025-07-18 |
| 3 | 1 | fang.al-farsi@vividdata.app | Fang Al-Farsi | member | full | invited | 0 | 2025-07-18 |
| 4 | 1 | rennakamura@vividdata.app | Ren Nakamura | member | full | deleted | 0 | 2025-06-17 |
| 4 | 1 | rennakamura@vividdata.app | Ren Nakamura | member | full | deleted | 0 | 2025-06-17 |
| 5 | 1 | ychoi@vividdata.app | Yan Choi | admin | read_only | active | 1 | 2025-07-02 |
| 5 | 1 | ychoi@vividdata.app | Yan Choi | admin | read_only | active | 1 | 2025-07-02 |
| 2 | 1 | tao@vividdata.app | Tao Schneider | viewer | full | invited | 1 | 2025-08-18 | 2025-08-18 |
| 2 | 1 | tao@vividdata.app | Tao Schneider | viewer | full | invited | 1 | 2025-08-18 | 2025-08-18 |
| 3 | 1 | fang.al-farsi@vividdata.app | Fang Al-Farsi | member | full | invited | 0 | 2025-07-18 | 2025-07-18 |
| 3 | 1 | fang.al-farsi@vividdata.app | Fang Al-Farsi | member | full | invited | 0 | 2025-07-18 | 2025-07-18 |
| 4 | 1 | rennakamura@vividdata.app | Ren Nakamura | member | full | deleted | 0 | 2025-06-17 | 2025-06-17 |
| 4 | 1 | rennakamura@vividdata.app | Ren Nakamura | member | full | deleted | 0 | 2025-06-17 | 2025-06-17 |
| 5 | 1 | ychoi@vividdata.app | Yan Choi | admin | read_only | active | 1 | 2025-07-02 | 2025-07-02 |
| 5 | 1 | ychoi@vividdata.app | Yan Choi | admin | read_only | active | 1 | 2025-07-02 | 2025-07-02 |