amazon_q_daily_user_metrics
Daily metrics for Amazon Q users.
-
id
Primary key - Unique identifier for the row.
-
user_id
Foreign key - Foreign key to amazon_q_users.
-
email
string - Email of the user.
-
date
date - The date for which metrics are recorded.
-
chat_ai_code_lines
number - Number of AI-generated code lines in chat interactions.
-
chat_messages_interacted
number - Number of chat messages the user interacted with.
-
chat_messages_sent
number - Number of chat messages sent by the user.
-
codefix_acceptance_event_count
number - Number of code fix acceptance events.
-
codefix_accepted_lines
number - Number of code lines accepted from fixes.
-
codefix_generated_lines
number - Number of code lines generated by fixes.
-
codefix_generation_event_count
number - Number of code fix generation events.
-
code_review_failed_event_count
number - Number of failed code review events.
-
code_review_findings_count
number - Number of code review findings.
-
code_review_succeeded_event_count
number - Number of successful code review events.
-
dev_acceptance_event_count
number - Number of development acceptance events.
-
dev_accepted_lines
number - Number of development lines accepted.
-
dev_generated_lines
number - Number of development lines generated.
-
dev_generation_event_count
number - Number of development generation events.
-
inline_chat_acceptance_event_count
number - Number of inline chat acceptance events.
-
inline_chat_accepted_line_additions
number - Number of line additions accepted in inline chat.
-
inline_chat_accepted_line_deletions
number - Number of line deletions accepted in inline chat.
-
inline_chat_dismissal_event_count
number - Number of inline chat dismissal events.
-
inline_chat_dismissed_line_additions
number - Number of line additions dismissed in inline chat.
-
inline_chat_dismissed_line_deletions
number - Number of line deletions dismissed in inline chat.
-
inline_chat_rejected_line_additions
number - Number of line additions rejected in inline chat.
-
inline_chat_rejected_line_deletions
number - Number of line deletions rejected in inline chat.
-
inline_chat_rejection_event_count
number - Number of inline chat rejection events.
-
inline_chat_total_event_count
number - Total number of inline chat events.
-
inline_ai_code_lines
number - Number of AI-generated code lines in inline interactions.
-
inline_acceptance_count
number - Number of inline acceptances.
-
inline_suggestions_count
number - Number of inline suggestions.
-
test_generation_accepted_lines
number - Number of test lines accepted from generation.
-
test_generation_accepted_tests
number - Number of tests accepted from generation.
-
test_generation_event_count
number - Number of test generation events.
-
test_generation_generated_lines
number - Number of test lines generated.
-
test_generation_generated_tests
number - Number of tests generated.
-
is_active
boolean - Whether the user is active.