ai_tool_daily_metrics

Daily metrics for all AI tool usage.

id Primary key: Unique identifier for the row.
dx_user_id Foreign key: DX ID of the user, if found.
ai_tool_id Foreign key: ID of the AI tool.
login string: Identifier for the user in the AI tool.
date date: The date for the tool usage metric.
is_active boolean: Indicates if the user was active or not on that day.
source_table_id Foreign key: ID of the row in the tool-specific source table this metric was derived from (e.g. claude_code_daily_user_metrics.id). NULL when the source table uses UUID primary keys, in which case source_table_uuid is set instead.
source_table_uuid string: UUID of the row in the tool-specific source table this metric was derived from, used when that table has UUID primary keys (bespoke tools, and custom tables that were built with UUID ids). NULL when source_table_id is set instead.
input_tokens number: Uncached input tokens consumed on this day. NULL for tools that do not report token usage.
output_tokens number: Output tokens generated on this day. NULL for tools that do not report token usage.
cache_write_tokens number: Tokens written to the prompt cache on this day. NULL for tools that do not report cache token usage.
cache_read_tokens number: Tokens read from the prompt cache on this day. NULL for tools that do not report cache token usage.
credits_used number: Credits or ACUs consumed on this day, for credit-billed tools.
spend_cents number: Spend for this day in US cents. Either reported natively by the tool, or derived for credit-billed tools as credits_used * the ai_tool_credit_rates rate in effect on this row's date. NULL when spend is unknown (e.g. a credit-billed tool with no rate configured, or usage predating the earliest configured rate).