👤 Users Data Model
Track individual users within customer accounts.
💡 Note
Overview
The Users Model tracks individual users associated with customer accounts. While Meza AI focuses on account-level analytics, user data enables deeper insights into engagement patterns, power users, and stakeholder identification.
Use the Users Model to identify key stakeholders, track individual adoption, and understand how different users within an account engage with your product.
Key Fields
| Field | Type | Description | Required |
|---|---|---|---|
user_id | String | Unique identifier for the user | Yes |
account_id | String | Links user to their account | Yes |
email | String | User email address | Yes |
name | String | User full name | No |
created_at | Timestamp | When user was created | Yes |
Configuration Steps
Navigate to Data Models
Go to Configuration → Data Models.
Configure Users Model
Find the Users Model card and click Configure.
Write Query
Write a SQL query that includes user_id, account_id, email, name, and created_at.
Map Fields
Map your query columns to the required fields.
Add Custom Properties
Optionally add role, department, or other user attributes.
Save Model
Test and save the model.
Example SQL Query
SELECT id AS user_id, account_id, email, CONCAT(first_name, ' ', last_name) AS name, created_at, -- Optional custom properties role, department, last_login_at FROM users WHERE deleted_at IS NULL AND email_verified = true
Custom Properties
Common custom properties for the Users Model:
| Property | Description | Use Case |
|---|---|---|
| Role | User role in the product | Identify admins vs regular users |
| Department | User department | Understand adoption by department |
| Job Title | User job title | Identify decision makers |
| Last Login | Last login timestamp | Find inactive users |
| Is Admin | Admin flag | Track admin engagement |
User Metrics
Once configured, Meza AI automatically calculates user-level metrics:
- User Count — Total users per account
- Active Users — Users with recent activity
- Power Users — Highly engaged users
- Inactive Users — Users with no recent activity
- New Users — Recently created users
✅ Tip
last_login_at field to identify inactive users who might need re-engagement campaigns.