claude_code_daily_user_metrics_breakdowns
Detailed daily usage metrics breakdown for Claude Code AI coding assistant users. Enterprise API rows have NULL organization_id and terminal_type.
-
id
Primary key - Unique identifier for the row.
-
daily_user_metric_id
Foreign key - Foreign key reference to claude_code_daily_user_metrics table.
-
organization_id
Foreign key - Organization UUID identifier. NULL for Enterprise API data.
-
terminal_type
string - Terminal/IDE type used by the user (e.g., vscode, cursor, intellij, iTerm.app). NULL for Enterprise API data.
-
num_sessions
number - Number of Claude Code sessions started by the user on this date.
-
lines_of_code_added
number - Number of lines of code added by the user through Claude Code.
-
lines_of_code_removed
number - Number of lines of code removed by the user through Claude Code.
-
commits_by_claude_code
number - Number of Git commits created using Claude Code.
-
pull_requests_by_claude_code
number - Number of pull requests created using Claude Code.
-
edit_tool_accepted
number - Number of edit tool suggestions accepted by the user.
-
edit_tool_rejected
number - Number of edit tool suggestions rejected by the user.
-
multi_edit_tool_accepted
number - Number of multi-edit tool suggestions accepted by the user.
-
multi_edit_tool_rejected
number - Number of multi-edit tool suggestions rejected by the user.
-
write_tool_accepted
number - Number of write tool suggestions accepted by the user.
-
write_tool_rejected
number - Number of write tool suggestions rejected by the user.
-
notebook_edit_tool_accepted
number - Number of notebook edit tool suggestions accepted by the user.
-
notebook_edit_tool_rejected
number - Number of notebook edit tool suggestions rejected by the user.
-
chat_distinct_conversation_count
number - Number of distinct conversations within Claude.ai (Enterprise API only).
-
chat_message_count
number - Total messages sent within Claude.ai (Enterprise API only).
-
chat_distinct_projects_created_count
number - Number of projects created within Claude.ai (Enterprise API only).
-
chat_distinct_projects_used_count
number - Number of distinct projects used within Claude.ai (Enterprise API only).
-
chat_distinct_files_uploaded_count
number - Number of files uploaded within Claude.ai (Enterprise API only).
-
chat_distinct_artifacts_created_count
number - Number of artifacts created within Claude.ai (Enterprise API only).
-
chat_thinking_message_count
number - Number of thinking (extended) messages within Claude.ai (Enterprise API only).
-
chat_distinct_skills_used_count
number - Number of distinct skills used within Claude.ai (Enterprise API only).
-
chat_connectors_used_count
number - Total number of connectors invoked within Claude.ai (Enterprise API only).
-
web_search_count
number - Number of web searches performed by the user (Enterprise API only).