1. Granularity

The d_client_users dbt table has information about a client on a client user level. Notice that: one client can have multiple client users, and one client users can link to different clients.

You will be able to find the following data for each client:

• client_user_id
• client_user_name
• client_id
• client_name
• is_external
• user_role
• is_external
• is_deleted
• is_offboarded
• first_login_datetime
• user_deleted_datetime
• most_commonly_used_assistant_id
• most_commonly_used_assistant_name
• lifetime_delegation_count
• lifetime_usage_revenue
• trailing_30_days_delegation_count
• trailing_30_days_usage_revenue