Usage analytics reference

This page is generated by bin/generate-usage-analytics-docs.bb.

Here is a list of all of the dashboards and models included in the Usage Analytics collection, as well as the list of topics and entity types found in the models.

For an overview of access, retention, and custom reports, see Usage analytics.

For more on AI usage data, see AI usage auditing.

Dashboards

Content with cobwebs

Dashboards and questions that you could consider archiving.

Cards:

• Dashboards without recent views
• Questions that don’t belong to a dashboard
• Questions without recent views

Dashboard overview

Information on the performance, views, activity, and more for a particular dashboard.

Cards:

• Dashboard metadata
• Dashboard views per month
• Most active people on this dashboard
• Questions in this dashboard
• Recent activity on dashboard
• Subscriptions on this dashboard

Dashboard subscriptions and alerts

All active notifications

Cards:

• Active dashboard subscriptions
• Alerts

Embedding Usage

General information about embedding usage, including views across embedded dashboards and questions

Cards:

• Active tenants
• Authenticated views
• Guest views
• Most viewed authenticated embeds
• Most viewed guest embeds
• Most viewed public links
• Public link views
• Tenants with most views
• Unique users
• Views by auth method
• Views by embedding client
• Views by embedding host
• Views by user agent

Metabase metrics

General information about people viewing and creating dashboards, questions, subscriptions, and alerts.

Cards:

• Active users last week
• Alerts and subscriptions created last week
• Dashboards created last week
• Most active creators
• Most active viewers
• Most viewed cards
• Most viewed dashboards
• Question views last week
• Question views per week
• Questions created last week
• Weekly active users

Most viewed content

Most viewed dashboards, questions, and tables in your Metabase.

Cards:

• Most viewed dashboards
• Most viewed models
• Most viewed questions
• Most viewed tables

Performance overview

Question, dashboard and database performance.

Cards:

• 50th and 90th percentile of query running time (seconds)
• 90th percentile of query run time (seconds)
• Dashboards consuming most resources
• Dashboards with more questions in the same tab
• Questions consuming most resources
• Slowest dashboards
• Slowest questions
• Total number of queries
• Total time looking for field values per day
• Total time spent on sync per day
• Users consuming most resources
• Weekly cache hit rate

Person overview

See what someone’s been up to in your Metabase.

Cards:

• Active alerts
• Last downloads
• Last queries
• Last viewed dashboards
• Last viewed models
• Last viewed questions
• Last viewed tables
• Member of
• Most viewed dashboards
• Most viewed models
• Most viewed questions
• Most viewed tables
• Person detail
• Question views per month
• Questions created per month
• Recent activity

Question overview

Views, performance, activity, and other data for a particular question.

Cards:

• Alerts on this question
• Dashboards with this question
• Last activity on question
• Last downloads
• Most active people on this question
• Question metadata
• Question views per month

Models

Activity log

Things that happened in your Metabase.

Columns:

• ID
• Topic
• Timestamp
• End Timestamp
• User ID
• Entity Type
• Entity ID
• Entity Qualified ID
• Details

AI Usage Log

One row per LLM round-trip with per-call tokens, source, model, profile, and more.

Columns:

• Usage Log ID
• Created At
• Source
• Source Name
• Model
• Profile ID
• Prompt Tokens
• Completion Tokens
• Total Tokens
• Conversation ID
• User ID
• User Qualified ID
• User Display Name
• Group Name
• IP Address
• Tenant ID
• Request ID

Alerts

All alerts, both active and archived.

Columns:

• Entity ID
• Entity Qualified ID
• Created At
• Updated At
• Creator ID
• Card ID
• Card Qualified ID
• Alert Condition
• Schedule Type
• Schedule Day
• Schedule Hour
• Archived
• Recipient Type
• Recipients
• Recipient External

Content

All Metabase content, including questions, models, dashboards, events, and collections.

Columns:

• Entity ID
• Entity Qualified ID
• Entity Type
• Created At
• Updated At
• Creator ID
• Name
• Description
• Collection ID
• Made Public By User
• Is Embedding Enabled
• Is Verified
• Archived
• Action Type
• Action Model ID
• Collection Is Official
• Collection Is Personal
• Question Viz Type
• Question Database ID
• Question Is Native
• Event Timestamp

Dashboard cards

Records of all dashboard cards (including text cards).

Columns:

• Entity ID
• Entity Qualified ID
• Dashboard Qualified ID
• Dashboardtab ID
• Card Qualified ID
• Created At
• Updated At
• Visualization Settings
• Parameter Mappings

Dashboard subscriptions

Which subscriptions are active, who created them, who’s subscribed to them, when they’re sent, and more.

Columns:

• Entity ID
• Entity Qualified ID
• Created At
• Updated At
• Creator ID
• Archived
• Dashboard Qualified ID
• Schedule Type
• Schedule Day
• Schedule Hour
• Recipient Type
• Recipients
• Recipient External
• Parameters

Databases

Information about your connected data sources.

Columns:

• Entity ID
• Entity Qualified ID
• Created At
• Updated At
• Name
• Description
• Database Type
• Metadata Sync Schedule
• Cache Field Values Schedule
• Timezone
• Is On Demand
• Auto Run Queries
• Cache Ttl
• Creator ID
• Db Version

Fields

All fields from all connected data sources.

Columns:

• Entity ID
• Entity Qualified ID
• Created At
• Updated At
• Name
• Display Name
• Description
• Base Type
• Visibility Type
• Fk Target Field ID
• Has Field Values
• Active
• Table ID

Group Members

Metabase group membership

Columns:

• User ID
• Group ID
• Group Name

Metabot Conversations

One row per Metabot conversation, with message counts, token totals, owning user/group, source, and tenant.

Columns:

• Conversation ID
• Created At
• User ID
• Summary
• User Display Name
• Message Count
• User Message Count
• Assistant Message Count
• Total Tokens
• Prompt Tokens
• Completion Tokens
• Last Message At
• Profile ID
• Profile Name
• Group Name
• Source
• Source Name
• IP Address
• Tenant ID
• Tenant Name
• Model

Metabot Messages

One row per non-deleted Metabot message, with role, profile, tokens, user, and the owning conversation.

Columns:

• Message ID
• Conversation ID
• Created At
• Role
• Profile ID
• Total Tokens
• User ID
• Slack Msg ID
• Channel ID

People

Everyone who’s ever had an account in your Metabase, including both active and deactivated accounts.

Columns:

• User ID
• Entity Qualified ID
• Type
• Email
• First Name
• Last Name
• Full Name
• Date Joined
• Last Login
• Updated At
• Is Admin
• Is Active
• Sso Source
• Locale
• Tenant ID

Query log

Information about all queries Metabase ran across all dashboards

Columns:

• Entity ID
• Started At
• Running Time Seconds
• Result Rows
• Is Native
• Query Source
• Error
• User ID
• Card ID
• Card Qualified ID
• Dashboard ID
• Dashboard Qualified ID
• Pulse ID
• Database ID
• Database Qualified ID
• Cache Hit
• Action ID
• Action Qualified ID
• Query
• Embedding Client
• Is Preview
• Embedding SDK Package Version
• Metabase Version
• Auth Method
• Is Sandboxed
• Is Impersonated
• Is Db Routed
• Parameters
• Tenant ID
• Embedding Hostname
• Embedding Path
• User Agent
• Sanitized User Agent
• IP Address

System tasks

Describes the last 14 days of Metabase internal processes tasks

Columns:

• ID
• Task
• Status
• Database Qualified ID
• Started At
• Ended At
• Duration Seconds
• Details

Tables

List of all tables across all connected data sources.

Columns:

• Entity ID
• Entity Qualified ID
• Created At
• Updated At
• Name
• Display Name
• Description
• Active
• Database ID
• Schema
• Is Upload
• Entity Type
• Visibility Type
• Estimated Row Count
• View Count
• Owner Email
• Owner User ID
• Database ID

Task Runs

Tracks job executions

Columns:

• ID
• Run Type
• Entity Type
• Entity ID
• Entity Qualified ID
• Started At
• Ended At
• Duration Seconds
• Status
• Process UUID
• Updated At

Tenants

All tenants in this Metabase instance

Columns:

• Tenant ID
• Entity Qualified ID
• Name
• Slug
• Is Active
• Attributes
• Created At
• Updated At
• Tenant Collection ID
• Tenant Collection Qualified ID

View log

Each row describes a question, model, table or dashboard view

Columns:

• ID
• Timestamp
• User ID
• Entity Type
• Entity ID
• Entity Qualified ID
• Embedding Client
• Auth Method
• Is Preview
• Metabase Version
• Embedding SDK Package Version
• Tenant ID
• Embedding Hostname
• Embedding Path
• User Agent
• Sanitized User Agent
• IP Address
• Context

Categorical column values

Some columns in the models above hold one of a fixed set of values.

Activity log topics

The Topic column on the Activity log model takes one of:

• action-v2-execute
• alert-create
• alert-delete
• alert-send
• alert-unsubscribe
• alert-update
• api-key-create
• api-key-delete
• api-key-regenerate
• api-key-update
• cache-config-update
• card-create
• card-delete
• card-public-link-created
• card-public-link-deleted
• card-update
• channel-create
• channel-update
• cloud-add-on-purchase
• comment-create
• comment-delete
• comment-update
• create-permission-failure
• dashboard-add-cards
• dashboard-create
• dashboard-delete
• dashboard-public-link-created
• dashboard-public-link-deleted
• dashboard-remove-cards
• database-create
• database-delete
• database-discard-field-values
• database-manual-scan
• database-manual-sync
• database-update
• document-create
• document-delete
• document-update
• glossary-create
• glossary-delete
• glossary-update
• group-create
• group-delete
• group-membership-create
• group-membership-delete
• group-membership-update
• group-update
• install
• measure-create
• measure-delete
• measure-update
• notification-create
• notification-unsubscribe
• notification-unsubscribe-ex
• notification-unsubscribe-undo-ex
• notification-update
• password-reset-initiated
• password-reset-successful
• remote-sync-create-branch
• remote-sync-export
• remote-sync-import
• remote-sync-settings-update
• remote-sync-stash
• security-advisory-acknowledge
• security-advisory-match
• segment-create
• segment-delete
• segment-update
• setting-update
• subscription-create
• subscription-delete
• subscription-send
• subscription-unsubscribe
• subscription-unsubscribe-undo
• subscription-update
• table-manual-scan
• table-manual-sync
• table-publish
• table-unpublish
• tenant-create
• tenant-update
• transform-create
• transform-delete
• transform-inspect-discover
• transform-inspect-lens
• transform-run-start
• update-permission-failure
• update-transform
• upload-append
• upload-create
• upload-replace
• user-deactivated
• user-invited
• user-joined
• user-reactivated
• user-update
• write-permission-failure

Query log query sources

The Query Source column on the Query log model takes one of:

• action
• ad-hoc
• agent
• cache-refresh
• collection
• csv-download
• dashboard
• dashboard-subscription
• embedded-csv-download
• embedded-dashboard
• embedded-json-download
• embedded-question
• embedded-xlsx-download
• json-download
• map-tiles
• public-csv-download
• public-dashboard
• public-json-download
• public-question
• public-xlsx-download
• pulse
• question
• slackbot
• table-grid
• table-rows-sample
• transform-inspector
• xlsx-download

Content entity types

The Entity Type column on the Content model takes one of:

• action
• collection
• dashboard
• document
• event
• glossary
• model
• question
• transform

View log entity types

The Entity Type column on the View log model takes one of:

• card
• collection
• dashboard
• table