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.