github_copilot_daily_usages

Daily usage details for GitHub Copilot licensees.

id

Primary key
Unique identifier of the row

login

string
The login of the GitHub user

date

date
The date of usage

enterprise_slug

string
Enterprise slug

active

boolean
Boolean indicating whether the user was active on this date

user_initiated_interaction_count

number
Count of user-initiated interactions

code_generation_activity_count

number
Count of code generation activities

code_acceptance_activity_count

number
Count of code acceptance activities

loc_suggested_to_add_sum

number
Total lines of code suggested to add

loc_suggested_to_delete_sum

number
Total lines of code suggested to delete

loc_added_sum

number
Total lines of code added

loc_deleted_sum

number
Total lines of code deleted

used_agent

boolean
Whether the user used Copilot agent features

used_chat

boolean
Whether the user used Copilot chat features

used_cli

boolean
Whether the user used Copilot via the CLI

ai_credits_used

number
Total Copilot AI credits used by the user on this date

used_copilot_coding_agent

boolean
Whether the user used Copilot coding agent features

used_copilot_cloud_agent

boolean
Whether the user used Copilot cloud agent features

used_copilot_code_review_active

boolean
Whether the user used active Copilot code review features

used_copilot_code_review_passive

boolean
Whether the user used passive Copilot code review features

ai_adoption_phase_number

number
Numeric Copilot AI adoption phase reported for the user

ai_adoption_phase_name

string
Copilot AI adoption phase label reported for the user

ai_adoption_phase_version

string
Version of the Copilot AI adoption phase model