SaaS Use Cases/Product AnalyticsProduct Manager

Which enterprise accounts have created more than 25 custom roles in the last 90 days, and how many roles have fewer than 3 assigned users?

Detects role sprawl in enterprise permission models that may signal confusion with RBAC configuration and create future support burden.

Metrics & KPIs

Total custom rolesorphan role countroles per account trend

Required Data

Custom role definitionsrole creation datesuser-role assignments

Data Sources

Product AnalyticsData Warehouse

Works with tools like

MixpanelAmplitudeHeapPendoPostHogSnowflakeBigQueryRedshiftDatabricksClickHouse

How Bruin answers this

Bruin

Bruin AI Data Analyst

Which enterprise accounts have created more than 25 custom roles in the last 90 days, and how many roles have fewer than 3 assigned users?

Bruin connects to your Product Analytics, Data Warehouse and runs the analysis automatically.

It tracks Total custom roles, orphan role count, roles per account trend and delivers the answer in seconds, in Slack, Discord, Teams, Google Chat, WhatsApp, Telegram, email, or your browser.

Bruin for SaaS

Use cases across every team in your SaaS company, from churn & retention to revenue operations, product analytics to engineering. One AI that speaks your data.

C-Level/ExecutiveCustomer Success ManagerData AnalystDevOps EngineerEngineering ManagerFinance/FP&A AnalystGrowth ManagerMarketing ManagerProduct ManagerRevenue Operations ManagerSales Operations ManagerSupport Manager

Get this answer in seconds

Connect your data, ask the question, get the answer. No SQL needed.