M
Meza AI

👤 Users Data Model

Track individual users within customer accounts.

💡 Note

Configure the Accounts Model before setting up the Users Model. Users must be linked to accounts.

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

FieldTypeDescriptionRequired
user_idStringUnique identifier for the userYes
account_idStringLinks user to their accountYes
emailStringUser email addressYes
nameStringUser full nameNo
created_atTimestampWhen user was createdYes

Configuration Steps

1

Navigate to Data Models

Go to ConfigurationData Models.

2

Configure Users Model

Find the Users Model card and click Configure.

3

Write Query

Write a SQL query that includes user_id, account_id, email, name, and created_at.

4

Map Fields

Map your query columns to the required fields.

5

Add Custom Properties

Optionally add role, department, or other user attributes.

6

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:

PropertyDescriptionUse Case
RoleUser role in the productIdentify admins vs regular users
DepartmentUser departmentUnderstand adoption by department
Job TitleUser job titleIdentify decision makers
Last LoginLast login timestampFind inactive users
Is AdminAdmin flagTrack 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

Track the last_login_at field to identify inactive users who might need re-engagement campaigns.

What's Next?