Answer: To construct team-level Copilot usage metrics, pair the appropriate reports (organization_user_teams_1_day with organization_users_1_day for organization teams, or enterprise_user_teams_1_day with users_1_day for enterprise/business teams) and inner-join them on (user_id, day, entity_id), then filter by day and group by team_id to aggregate. Status: Confirmed Entry: tool/github-copilot/admin-and-enterprise/construct-team-level-metrics Revision: 3 Digest: sha256:910434968da5d69a (changes whenever the content changes) Timeline: Created: 2026-11-13T03:32:04Z Last changed: 2026-11-19T13:07:25Z (enterprise entity id: — → enterprise_id) Last verified: 2026-11-20T13:13:42Z Next check: 2026-11-21T13:13:42Z Check interval: Daily Expected change: No fixed schedule Data: Field | Value | Source | As of join keys | (user_id, day, entity_id) | [1] | 2026-11-20 organization team report pair | organization_user_teams_1_day with organization_users_1_day | [1] | 2026-11-20 enterprise team report pair | enterprise_user_teams_1_day with users_1_day | [1] | 2026-11-20 organization entity id | organization_id | [1] | 2026-11-20 enterprise entity id | enterprise_id | [1] | 2026-11-20 grouping key | team_id | [1] | 2026-11-20 distinct-user aggregation | COUNT(DISTINCT user_id) | [1] | 2026-11-20 Sources: [1] GitHub. "Team-level Copilot usage metrics - GitHub Docs". https://docs.github.com/en/copilot/reference/copilot-usage-metrics/team-level-metrics Role: primary. Accessed: 2026-11-20T13:13:42Z Quote: "Inner-join the two reports on (user_id, day, entity_id) ." (Supports: join keys) Quote: "For organization teams, pair organization_user_teams_1_day with organization_users_1_day ." (Supports: organization team report pair) Quote: "For enterprise and business teams, pair enterprise_user_teams_1_day with users_1_day ." (Supports: enterprise team report pair) Quote: "The shared entity id is organization_id ." (Supports: organization entity id) Quote: "The shared entity id is enterprise_id ." (Supports: enterprise entity id) Quote: "Group by team_id (and slug for the team's display name) and aggregate." (Supports: grouping key) Quote: "Use: COUNT(DISTINCT user_id) for distinct-user counts such as active users." (Supports: distinct-user aggregation) Snapshot SHA-256: dfd1ba66780b9ccdd737ec978f066512202f87dd723a116d4770db51cd3df86e (captured 2026-11-18T13:09:50Z) Verification: Method: Automated extraction from [1] with deepseek-flash (JSON output, thinking disabled). Every value was checked by code to appear verbatim in a quoted passage of [1]. On this check the text of [1] was unchanged since 2026-11-18T13:09:50Z, so the values verified then were kept. Cross-check: not-available at 2026-11-20T13:13:42Z. No independent second source is configured for this entry Last successful check: 2026-11-20T13:13:42Z Last attempt: 2026-11-20T13:13:42Z Notes and limitations: Extracted automatically from a single official source (section "How to construct team-level metrics"). Related: https://latestn.com/tool/github-copilot/admin-and-enterprise/control-copilot-clients-and-features How do I control which GitHub Copilot clients and features my enterprise's licensed users can access? https://latestn.com/tool/github-copilot/admin-and-enterprise/control-costs-with-budgets How can I set budgets to control GitHub Copilot costs for my organization or enterprise? https://latestn.com/tool/github-copilot/admin-and-enterprise/control-image-generation-access How do I control access to image generation in GitHub Copilot? https://latestn.com/tool/github-copilot/admin-and-enterprise/configure-self-hosted-runners-code-review How do I configure self-hosted runners for GitHub Copilot code review? https://latestn.com/tool/github-copilot/admin-and-enterprise/configure-subscription-network-routing How do I configure Copilot subscription-based network routing for my GitHub enterprise or organization? https://latestn.com/tool/github-copilot/admin-and-enterprise/connect-insights-to-outcomes How do I connect GitHub Copilot adoption insights to engineering outcomes? https://latestn.com/tool/ All entries in AI tools Change log: Time | Event | Change | Source 2026-11-19T13:07:25Z | changed | enterprise entity id: — → enterprise_id | [1] 2026-11-19T13:07:25Z | changed | organization entity id: — → organization_id | [1] 2026-11-19T13:07:25Z | changed | enterprise team report pair: enterprise_user_teams_1_day → enterprise_user_teams_1_day with users_1_day | [1] 2026-11-19T13:07:25Z | changed | organization team report pair: organization_user_teams_1_day → organization_user_teams_1_day with organization_users_1_day | [1] 2026-11-17T13:33:13Z | changed | enterprise team report pair: — → enterprise_user_teams_1_day | [1] 2026-11-17T13:33:13Z | changed | organization team report pair: — → organization_user_teams_1_day | [1] 2026-11-17T13:33:13Z | changed | enterprise entity id: enterprise_id → — | [1] 2026-11-17T13:33:13Z | changed | organization entity id: organization_id → — | [1] 2026-11-17T13:33:13Z | changed | enterprise team reports: enterprise_user_teams_1_day with users_1_day → — | [1] 2026-11-17T13:33:13Z | changed | organization team reports: organization_user_teams_1_day with organization_users_1_day → — | [1] 2026-11-13T03:32:04Z | added | Entry created | — Changes for this entry as a feed: https://latestn.com/tool/github-copilot/admin-and-enterprise/construct-team-level-metrics/latest Challenge this entry: Open challenges: None How: If a value here is wrong or out of date, send what is wrong and a link to evidence. Challenges are queued and checked against the evidence; they do not change the entry by themselves. If the entry changes as a result, the change log says so. Form: https://latestn.com/dispute/tool/github-copilot/admin-and-enterprise/construct-team-level-metrics POST: https://latestn.com/dispute/tool/github-copilot/admin-and-enterprise/construct-team-level-metrics with claim, evidence_url, and optionally field and contact (form-encoded or JSON) GET: https://latestn.com/dispute/tool/github-copilot/admin-and-enterprise/construct-team-level-metrics?claim={what is wrong}&evidence_url={link} How to cite: LatestN. (2026). How do I construct team-level Copilot usage metrics by joining user-teams and per-user usage reports? Revision 3, last verified 2026-11-20T13:13:42Z. https://latestn.com/tool/github-copilot/admin-and-enterprise/construct-team-level-metrics (accessed 2026-11-21T09:59:37Z). @misc{LatestN_tool_github_copilot_admin_and_enterprise_construct_team_level_metrics_r3, title = {How do I construct team-level Copilot usage metrics by joining user-teams and per-user usage reports?}, author = {{LatestN}}, year = {2026}, howpublished = {\url{https://latestn.com/tool/github-copilot/admin-and-enterprise/construct-team-level-metrics}}, note = {Revision 3; digest sha256:910434968da5d69a; last verified 2026-11-20T13:13:42Z; accessed 2026-11-21T09:59:37Z} } Reuse: License: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/) Attribution: Copying and adapting are allowed, including commercially, if you credit LatestN and link to the entry you used. Each entry ends with a ready-made citation. URL: https://latestn.com/tool/github-copilot/admin-and-enterprise/construct-team-level-metrics