tm_usage_and_outcomes
1. Dataset Name
tm_usage_and_outcomes
2. Description
Event-level Career Hub / internal-mobility engagement dataset that joins every employee record to raw web server log events (aggregated to daily grain), enriched with profile, demographic, and lifecycle attributes, mentorship opt-in status, and profile-connection (networking) activity. Each row represents a single logged event for an employee, denormalized with the employee's role, business unit, level, location, profile/goal completeness, skill/title preferences, and — where applicable — a matched profile-connection record. Built to power Career Hub feature adoption, career navigation, skill assessment, and internal-mobility engagement analyses.
3. Source Tables
- customer_views.www_server_log (raw event log; aggregated to daily grain)
- customer_views.employee
- customer_views.profile_data (filtered to namespace = 'mentorship', for open_to_mentoring)
- customer_views.profile_connection (for networking/connection activity)
4. Grain
Nominally one row per (employee_email, log event) — but denormalized further by a LEFT JOIN to profile_connection on source_profile_id = profile_id. An employee with multiple profile-connection records will produce multiple rows per logged event (one per matching connection), which inflates row counts and duplicates event_count across those rows. Consumers aggregating event_count must de-duplicate on the event-level columns before summing, or risk overcounting engagement for anyone with multiple connections. An employee with zero logged events still appears once, with all log-level fields null.
5. Dashboards Supported
- TM Outcomes Summary Dashboard (Career Hub adoption, networking, mentorship metrics)
- Career Navigator Engagement Dashboard
- Skill Assessment Dashboard
6. Metrics Supported
| Metric | Supported Breakdowns |
| Feature/Event Usage (count of events) | Event category, business unit, job function, employee level, location, interface — de-duplicate before aggregating (see Grain) |
| Career Hub Returning User Rate | Business unit, employee level (only meaningful for namespace = 'career_hub' rows) |
| Career Navigator Engagement | Event, business unit |
| Skill Assessment Engagement | Event, business unit, job function |
| Mentorship Opt-In Rate | open_to_mentoring, business unit, employee level |
| Networking / Profile Connections | source_profile_id, profile_connection_created_at, business unit |
| Profile Completeness Distribution | Profile completeness band, business unit, job function, employee level |
| Goal Completeness | Business unit, job function, employee level |
7. Known Exclusions / Filters Applied
- Excludes non-production traffic: hostnames stage.eightfold.ai, qa.eightfold.ai, any hostname containing "dev", and any hostname starting with "github-ci" (null hostname passes through).
- Excludes bot traffic (interface in bot, mobile_bot, tablet_bot, pc_bot; null interface passes through).
- Excludes failed requests (only response_code < '400' is kept).
- Scoped to only four namespaces: career_hub, pr_bootstrap_init, saved_searches, smartrefer — events outside these are not in this dataset at all.
- Excludes candidate-role users (user_role <> 'candidate'; null passes through).
- Excludes internal/test events containing "::: " in the event name.
- returning_user_ind is scoped to namespace = 'career_hub' only — all non-career_hub rows are hardcoded to 0 regardless of actual return cadence.
- open_to_mentoring is null for employees with no mentorship profile_data record — should not be interpreted as "opted out."
- JSON-derived skill/title fields only surface the first array element from the underlying JSON.
8. Schema
| Column Name | Data Type | Notes |
| event_count | bigint | Daily count of the logged event; duplicated per matching profile_connection row — see Grain |
| namespace | varchar | One of career_hub, pr_bootstrap_init, saved_searches, smartrefer |
| event | varchar | Raw event name; basis for event_category |
| user_email | varchar | Email from the log record; joined to employee.employee_email (case-insensitive) |
| referrer | varchar | Referrer/source of the logged interaction |
| log_ts | date | Event date, truncated to day |
| previous_log_ts | date | Prior event date for the same (user_email, namespace); null for a user's first event in that namespace |
| interface | varchar | Interface/surface the event occurred on |
| position_id | varchar | Position referenced by the event, if applicable |
| profile_id | varchar | Employee's profile identifier |
| employee_id | varchar | Employee identifier |
| employee_name | varchar | Derived: first + last name |
| role | varchar | Employee's role |
| title | varchar | Employee's job title |
| business_unit | varchar | Employee's business unit |
| job_function | varchar | Employee's job function |
| employee_level | varchar | Employee's level |
| location | varchar | Employee location, full string |
| location_country | varchar | Employee location, country |
| race / ef_race | varchar | Raw and normalized race field |
| gender / ef_gender | varchar | Raw and normalized gender field |
| profile_activated_ts | datetime | Timestamp employee's profile was activated |
| is_employee | bigint | Flag (0/1); active employee status |
| seniority | varchar | Employee seniority |
| termination_date | datetime | Null unless employee has left |
| is_alumni | bigint | Flag (0/1); employee is now an alum |
| profile_completeness | double | Raw completeness score (0–100); basis for profile_completeness_band |
| goal_completeness | double | Raw goal completeness score |
| employee_email | varchar | Employee's email; join key to log's user_email |
| assessment_self_assessed_role_skills | varchar | First self-assessed skill, or 'No self assessed role skills' if null |
| assessment_manager_assessed_role_skills | varchar | First manager-assessed skill, or 'No manager assessed role skills' if null |
| preferred_job_skills | varchar | First preferred skill, or 'No preferred job skills' if null |
| preferred_job_title | varchar | First preferred title, or 'No preferred job title' if null |
| preferred_job_title_long_term | varchar | First long-term preferred title, or 'No preferred long term job title' if null |
| event_category | varchar | Derived category: People and Networking, Profile and Goals, Course Marketplace, Jobs Marketplace, Project Marketplace, Mentorship, Skill Assessment, Career Navigator, Home Page, or Others |
| open_to_mentoring | boolean | Null if no mentorship profile_data record exists |
| source_profile_id | varchar | Employee's profile_id as the source of a connection record |
| profile_connection_created_at | datetime | Timestamp the matched profile_connection record was created |
| returning_user_ind | bigint | 1 if namespace = 'career_hub' AND returned exactly 1 month after previous event, else 0 |
| profile_completeness_band | varchar | Bucket of profile_completeness: <25, 25-50, 50-75, 75-100, 100, OTHERS |