# Exemple de schéma pour les métriques d’utilisation de Copilot Consultez un exemple de schéma des données retournées par l’API Copilot de métriques d’utilisation. Voici des exemples de schémas pour les données au niveau de l’utilisateur, au niveau de l’entreprise et au niveau du référentiel retournées par les Copilot points de terminaison des métriques d’utilisation. Les données réelles retournées peuvent varier en fonction des métriques spécifiques suivies et du niveau d’agrégation. Vous pouvez utiliser ces exemples comme référence pour comprendre la structure des données et comment interpréter les différents champs et métriques inclus dans la réponse de l’API. ## Exemple de schéma au niveau de l’utilisateur ```json copy [{ "ai_adoption_phase": { "phase": "Phase 2", "phase_number": 2, "version": "v1" }, "ai_credits_used": 12.5, "code_acceptance_activity_count": 3, "code_generation_activity_count": 3, "day": "2025-10-01", "enterprise_id": "1", "loc_added_sum": 32, "loc_deleted_sum": 6, "loc_suggested_to_add_sum": 34, "loc_suggested_to_delete_sum": 6, "totals_by_cli": { "last_known_cli_version": { "cli_version": "1.0.8", "sampled_at": "2025-10-01T00:01:43.000Z" }, "prompt_count": 2, "request_count": 2, "session_count": 2, "token_usage": { "avg_tokens_per_request": 4400.0, "output_tokens_sum": 5000, "prompt_tokens_sum": 3800 } }, "totals_by_copilot_app": { "prompt_count": 1, "request_count": 3, "session_count": 1, "token_usage": { "avg_tokens_per_request": 3200.0, "output_tokens_sum": 4200, "prompt_tokens_sum": 5400 } }, "totals_by_3rd_party_agent": [{ "agent_id": "2246796", "agent_name": "Claude (Anthropic)", "user_initiated_interaction_count": 2 }, { "agent_id": "2248422", "agent_name": "Codex (OpenAI)", "user_initiated_interaction_count": 2 }], "totals_by_feature": [{ "code_acceptance_activity_count": 1, "code_generation_activity_count": 1, "feature": "code_completion", "loc_added_sum": 8, "loc_deleted_sum": 0, "loc_suggested_to_add_sum": 10, "loc_suggested_to_delete_sum": 0, "user_initiated_interaction_count": 0 }, { "code_acceptance_activity_count": 2, "code_generation_activity_count": 2, "feature": "copilot_app", "loc_added_sum": 24, "loc_deleted_sum": 6, "loc_suggested_to_add_sum": 24, "loc_suggested_to_delete_sum": 6, "user_initiated_interaction_count": 1 }], "totals_by_ide": [{ "code_acceptance_activity_count": 1, "code_generation_activity_count": 1, "ide": "vscode", "last_known_ide_version": { "ide_version": "1.85.0", "sampled_at": "2025-10-01T00:00:02.000Z" }, "last_known_plugin_version": { "plugin": "", "plugin_version": "", "sampled_at": "2025-10-01T00:00:02.000Z" }, "loc_added_sum": 8, "loc_deleted_sum": 0, "loc_suggested_to_add_sum": 10, "loc_suggested_to_delete_sum": 0, "user_initiated_interaction_count": 0 }], "totals_by_language_feature": [{ "code_acceptance_activity_count": 1, "code_generation_activity_count": 1, "feature": "code_completion", "language": "unknown", "loc_added_sum": 8, "loc_deleted_sum": 0, "loc_suggested_to_add_sum": 10, "loc_suggested_to_delete_sum": 0 }, { "code_acceptance_activity_count": 2, "code_generation_activity_count": 2, "feature": "copilot_app", "language": "markdown", "loc_added_sum": 24, "loc_deleted_sum": 6, "loc_suggested_to_add_sum": 24, "loc_suggested_to_delete_sum": 6 }], "totals_by_language_model": [], "totals_by_model_feature": [], "used_agent": false, "used_chat": false, "used_cli": true, "used_copilot_app": true, "used_copilot_cloud_agent": false, "used_copilot_code_review_active": null, "used_copilot_code_review_passive": null, "used_copilot_coding_agent": false, "user_id": 1, "user_login": "login1", "user_initiated_interaction_count": 1, "etl_id": "green", "day_partition": "2025-10-01", "entity_id_partition": 1 }] ``` Les rapports de l’organisation par utilisateur utilisent les mêmes champs d’entrée `totals_by_3rd_party_agent` et incluent également `organization_id`. Les entrées par utilisateur n’incluent pas `session_count`. Dans cet exemple, `used_copilot_code_review_active` et `used_copilot_code_review_passive` sont `null` parce qu’il n’y avait aucun Copilot code review signal pour l’utilisateur ce jour-là. `used_copilot_cloud_agent` et `used_copilot_coding_agent` ont toujours la même valeur. ## Exemple de schéma au niveau de l’entreprise ```json copy [ { "day_totals" : [ { "code_acceptance_activity_count" : 4, "code_generation_activity_count" : 4, "daily_active_cli_users" : 2, "daily_active_copilot_app_users" : 1, "daily_active_copilot_cloud_agent_users" : 1, "daily_active_copilot_code_review_users" : 1, "daily_active_users" : 2, "daily_passive_copilot_code_review_users" : 0, "day" : "2025-10-01", "enterprise_id" : "1", "loc_added_sum" : 54, "loc_deleted_sum" : 6, "loc_suggested_to_add_sum" : 59, "loc_suggested_to_delete_sum" : 6, "monthly_active_agent_users" : 0, "monthly_active_chat_users" : 0, "monthly_active_copilot_cloud_agent_users" : 1, "monthly_active_copilot_code_review_users" : 1, "monthly_active_users" : 2, "monthly_passive_copilot_code_review_users" : 0, "pull_requests" : { "median_minutes_to_merge" : 2.5, "median_minutes_to_merge_copilot_authored" : 2.5, "median_minutes_to_merge_copilot_reviewed" : 2.5, "total_applied_suggestions" : 1, "total_copilot_applied_suggestions" : 1, "total_copilot_suggestions" : 1, "total_created" : 2, "total_created_by_copilot" : 1, "total_merged" : 2, "total_merged_created_by_copilot" : 1, "total_merged_reviewed_by_copilot" : 1, "total_reviewed" : 1, "total_reviewed_by_copilot" : 1, "total_suggestions" : 1 }, "totals_by_3rd_party_agent" : [ { "agent_id" : "2246796", "agent_name" : "Claude (Anthropic)", "session_count" : 1, "user_initiated_interaction_count" : 2 }, { "agent_id" : "2248422", "agent_name" : "Codex (OpenAI)", "session_count" : 2, "user_initiated_interaction_count" : 2 } ], "totals_by_ai_adoption_phase" : [ { "avg_code_acceptance_activities" : 1.0, "avg_code_generation_activities" : 1.0, "avg_loc_added" : 22.0, "avg_loc_deleted" : 0.0, "avg_pull_requests_created" : 1.0, "avg_pull_requests_median_minutes_to_merge" : 2.5, "avg_pull_requests_merged" : 1.0, "avg_pull_requests_minutes_to_review" : 1.5, "avg_pull_requests_review_cycles" : 1.0, "avg_pull_requests_reviewed" : 0.0, "avg_user_initiated_interactions" : 0.0, "phase" : "Phase 1", "phase_number" : 1, "total_engaged_users" : 1, "total_pull_requests_merged" : 1 }, { "avg_code_acceptance_activities" : 3.0, "avg_code_generation_activities" : 3.0, "avg_loc_added" : 32.0, "avg_loc_deleted" : 6.0, "avg_pull_requests_created" : 1.0, "avg_pull_requests_median_minutes_to_merge" : 2.5, "avg_pull_requests_merged" : 1.0, "avg_pull_requests_minutes_to_review" : 2.0, "avg_pull_requests_review_cycles" : 2.0, "avg_pull_requests_reviewed" : 1.0, "avg_user_initiated_interactions" : 1.0, "phase" : "Phase 2", "phase_number" : 2, "total_engaged_users" : 1, "total_pull_requests_merged" : 1 } ], "totals_by_cli" : { "prompt_count" : 3, "request_count" : 3, "session_count" : 3, "token_usage" : { "avg_tokens_per_request" : 4100.0, "output_tokens_sum" : 7000, "prompt_tokens_sum" : 5300 } }, "totals_by_copilot_app" : { "prompt_count" : 2, "request_count" : 6, "session_count" : 2, "token_usage" : { "avg_tokens_per_request" : 2466.67, "output_tokens_sum" : 6200, "prompt_tokens_sum" : 8600 } }, "totals_by_feature" : [ { "code_acceptance_activity_count" : 2, "code_generation_activity_count" : 2, "feature" : "code_completion", "loc_added_sum" : 30, "loc_deleted_sum" : 0, "loc_suggested_to_add_sum" : 35, "loc_suggested_to_delete_sum" : 0, "user_initiated_interaction_count" : 0 }, { "code_acceptance_activity_count" : 2, "code_generation_activity_count" : 2, "feature" : "copilot_app", "loc_added_sum" : 24, "loc_deleted_sum" : 6, "loc_suggested_to_add_sum" : 24, "loc_suggested_to_delete_sum" : 6, "user_initiated_interaction_count" : 1 } ], "totals_by_ide" : [ { "code_acceptance_activity_count" : 2, "code_generation_activity_count" : 2, "ide" : "vscode", "loc_added_sum" : 30, "loc_deleted_sum" : 0, "loc_suggested_to_add_sum" : 35, "loc_suggested_to_delete_sum" : 0, "user_initiated_interaction_count" : 0 } ], "totals_by_language_feature" : [ { "code_acceptance_activity_count" : 2, "code_generation_activity_count" : 2, "feature" : "code_completion", "language" : "unknown", "loc_added_sum" : 30, "loc_deleted_sum" : 0, "loc_suggested_to_add_sum" : 35, "loc_suggested_to_delete_sum" : 0 }, { "code_acceptance_activity_count" : 2, "code_generation_activity_count" : 2, "feature" : "copilot_app", "language" : "markdown", "loc_added_sum" : 24, "loc_deleted_sum" : 6, "loc_suggested_to_add_sum" : 24, "loc_suggested_to_delete_sum" : 6 } ], "totals_by_language_model" : [ ], "totals_by_model_feature" : [ ], "user_initiated_interaction_count" : 1, "weekly_active_copilot_cloud_agent_users" : 1, "weekly_active_copilot_code_review_users" : 1, "weekly_active_users" : 2, "weekly_passive_copilot_code_review_users" : 0 } ], "enterprise_id" : "1", "report_end_day" : "2025-10-01", "report_start_day" : "2025-09-04", "etl_id" : "green", "day_partition" : "2025-10-01", "entity_id_partition" : 1 }, { "day_totals" : [ { "code_acceptance_activity_count" : 2, "code_generation_activity_count" : 3, "daily_active_copilot_cloud_agent_users" : 0, "daily_active_copilot_code_review_users" : 0, "daily_active_users" : 2, "daily_passive_copilot_code_review_users" : 0, "day" : "2025-10-01", "enterprise_id" : "2", "loc_added_sum" : 50, "loc_deleted_sum" : 3, "loc_suggested_to_add_sum" : 52, "loc_suggested_to_delete_sum" : 3, "monthly_active_agent_users" : 0, "monthly_active_chat_users" : 0, "monthly_active_copilot_cloud_agent_users" : 0, "monthly_active_copilot_code_review_users" : 0, "monthly_active_users" : 2, "monthly_passive_copilot_code_review_users" : 0, "pull_requests" : { "total_applied_suggestions" : 0, "total_copilot_applied_suggestions" : 0, "total_copilot_suggestions" : 0, "total_created" : 1, "total_created_by_copilot" : 0, "total_merged" : 0, "total_merged_created_by_copilot" : 0, "total_merged_reviewed_by_copilot" : 0, "total_reviewed" : 1, "total_reviewed_by_copilot" : 0, "total_suggestions" : 1 }, "totals_by_ai_adoption_phase" : [ { "avg_code_acceptance_activities" : 0.0, "avg_code_generation_activities" : 1.0, "avg_loc_added" : 12.0, "avg_loc_deleted" : 3.0, "avg_pull_requests_created" : 0.0, "avg_pull_requests_median_minutes_to_merge" : 0.0, "avg_pull_requests_merged" : 0.0, "avg_pull_requests_minutes_to_review" : 0.0, "avg_pull_requests_review_cycles" : 0.0, "avg_pull_requests_reviewed" : 0.0, "avg_user_initiated_interactions" : 0.0, "phase" : "No Cohort", "phase_number" : 0, "total_engaged_users" : 1, "total_pull_requests_merged" : 0 }, { "avg_code_acceptance_activities" : 2.0, "avg_code_generation_activities" : 2.0, "avg_loc_added" : 38.0, "avg_loc_deleted" : 0.0, "avg_pull_requests_created" : 1.0, "avg_pull_requests_median_minutes_to_merge" : 0.0, "avg_pull_requests_merged" : 0.0, "avg_pull_requests_minutes_to_review" : 0.0, "avg_pull_requests_review_cycles" : 0.0, "avg_pull_requests_reviewed" : 1.0, "avg_user_initiated_interactions" : 1.0, "phase" : "Phase 1", "phase_number" : 1, "total_engaged_users" : 1, "total_pull_requests_merged" : 0 } ], "totals_by_feature" : [ { "code_acceptance_activity_count" : 1, "code_generation_activity_count" : 2, "feature" : "code_completion", "loc_added_sum" : 38, "loc_deleted_sum" : 0, "loc_suggested_to_add_sum" : 40, "loc_suggested_to_delete_sum" : 0, "user_initiated_interaction_count" : 0 }, { "code_acceptance_activity_count" : 1, "code_generation_activity_count" : 1, "feature" : "copilot_app", "loc_added_sum" : 12, "loc_deleted_sum" : 3, "loc_suggested_to_add_sum" : 12, "loc_suggested_to_delete_sum" : 3, "user_initiated_interaction_count" : 1 } ], "totals_by_ide" : [ { "code_acceptance_activity_count" : 1, "code_generation_activity_count" : 2, "ide" : "vscode", "loc_added_sum" : 38, "loc_deleted_sum" : 0, "loc_suggested_to_add_sum" : 40, "loc_suggested_to_delete_sum" : 0, "user_initiated_interaction_count" : 0 } ], "totals_by_language_feature" : [ { "code_acceptance_activity_count" : 1, "code_generation_activity_count" : 2, "feature" : "code_completion", "language" : "unknown", "loc_added_sum" : 38, "loc_deleted_sum" : 0, "loc_suggested_to_add_sum" : 40, "loc_suggested_to_delete_sum" : 0 }, { "code_acceptance_activity_count" : 1, "code_generation_activity_count" : 1, "feature" : "copilot_app", "language" : "markdown", "loc_added_sum" : 12, "loc_deleted_sum" : 3, "loc_suggested_to_add_sum" : 12, "loc_suggested_to_delete_sum" : 3 } ], "totals_by_language_model" : [ ], "totals_by_model_feature" : [ ], "user_initiated_interaction_count" : 1, "weekly_active_copilot_cloud_agent_users" : 0, "weekly_active_copilot_code_review_users" : 0, "weekly_active_users" : 2, "weekly_passive_copilot_code_review_users" : 0 } ], "enterprise_id" : "2", "report_end_day" : "2025-10-01", "report_start_day" : "2025-09-04", "etl_id" : "green", "day_partition" : "2025-10-01", "entity_id_partition" : 2 } ] ``` Les rapports agrégés de l’organisation utilisent les mêmes champs de saisie `totals_by_3rd_party_agent`, y compris `session_count`, et incluent également `organization_id`. Les exemples suivants de rapports des équipes d’utilisateurs sont renvoyés par les points de terminaison `user-teams-1-day` et sont destinés à être associés au rapport d’utilisation par utilisateur sur `user_id`, `day` et l’ID d’entité approprié (`organization_id` pour le niveau de l’organisation, `enterprise_id` pour le niveau de l’entreprise) afin de calculer des métriques au niveau de l’équipe. Pour plus d’informations, consultez [Métriques d’utilisation Copilot au niveau de l’équipe](/fr/copilot/reference/copilot-usage-metrics/team-level-metrics). > \[!NOTE] > Les équipes avec moins de 5 utilisateurs assis sont omises Copilot des rapports des équipes d’utilisateurs. ## Exemple de schéma des équipes d’utilisateurs de l’organisation ```json copy [ { "user_id": 1001, "user_login": "octocat", "day": "2026-05-14", "organization_id": "999", "team_id": 42, "slug": "frontend" }, { "user_id": 1001, "user_login": "octocat", "day": "2026-05-14", "organization_id": "999", "team_id": 43, "slug": "backend" }, { "user_id": 1002, "user_login": "hubot", "day": "2026-05-14", "organization_id": "999", "team_id": 42, "slug": "frontend" } ] ``` ## Exemple de schéma d’équipe utilisateur d’entreprise ```json copy [ { "user_id": 1001, "user_login": "octocat", "day": "2026-05-14", "enterprise_id": "1", "team_id": 9001, "slug": "eng-platform" }, { "user_id": 1001, "user_login": "octocat", "day": "2026-05-14", "enterprise_id": "1", "team_id": 7001, "slug": "business-analytics" }, { "user_id": 1002, "user_login": "hubot", "day": "2026-05-14", "enterprise_id": "1", "team_id": 9001, "slug": "eng-platform" } ] ``` ## Exemple de schéma au niveau du référentiel L’exemple suivant de rapport au niveau du référentiel est renvoyé dans les fichiers NDJSON téléchargés depuis les points de terminaison `repos-1-day`. Chaque ligne représente un dépôt ayant eu une activité de pull request pour le jour demandé. Les lignes délimitées à l'échelle de l’entreprise et de l’organisation remplissent `organization_id` (l’organisation propriétaire de chaque référentiel). Les lignes de portée entreprise alimentent également `enterprise_id`, et les lignes de portée organisation alimentent `enterprise_id` uniquement pour les organisations appartenant à une entreprise. Pour obtenir la référence de champ, consultez [Données disponibles dans les métriques d’utilisation Copilot](/fr/copilot/reference/copilot-usage-metrics/copilot-usage-metrics#repository-level-fields-api-only). ```json copy [ { "day": "2026-07-14", "enterprise_id": "1001", "organization_id": "2002", "repo_id": 900000001, "repo_owner_name": "octodemo-metrics", "repo_name": "example-service-alpha", "repo_visibility": "INTERNAL", "pull_requests": { "total_reviewed": 1, "total_created": 1, "total_created_by_copilot": 1, "total_reviewed_by_copilot": 1, "total_merged": 1, "median_minutes_to_merge": 372.62, "total_suggestions": 0, "total_applied_suggestions": 0, "total_merged_created_by_copilot": 1, "median_minutes_to_merge_copilot_authored": 372.62, "total_copilot_suggestions": 0, "total_copilot_applied_suggestions": 0, "total_merged_reviewed_by_copilot": 1, "median_minutes_to_merge_copilot_reviewed": 372.62, "copilot_suggestions_by_comment_type": [] } }, { "day": "2026-07-14", "enterprise_id": "1001", "organization_id": "2002", "repo_id": 900000003, "repo_owner_name": "octodemo-metrics", "repo_name": "example-service-gamma", "repo_visibility": "INTERNAL", "pull_requests": { "total_reviewed": 1, "total_created": 0, "total_created_by_copilot": 0, "total_reviewed_by_copilot": 1, "total_merged": 1, "median_minutes_to_merge": 1020.53, "total_suggestions": 0, "total_applied_suggestions": 1, "total_merged_created_by_copilot": 0, "total_copilot_suggestions": 0, "total_copilot_applied_suggestions": 1, "total_merged_reviewed_by_copilot": 1, "median_minutes_to_merge_copilot_reviewed": 1020.53, "copilot_suggestions_by_comment_type": [ { "comment_type": "spelling", "total_copilot_suggestions": 0, "total_copilot_applied_suggestions": 1 } ] } }, { "day": "2026-07-14", "organization_id": "3003", "enterprise_id": "", "repo_id": 900000010, "repo_owner_name": "octodemo-metrics", "repo_name": "example-service-delta", "repo_visibility": "PRIVATE", "pull_requests": { "total_reviewed": 1, "total_created": 0, "total_created_by_copilot": 0, "total_reviewed_by_copilot": 1, "total_merged": 2, "median_minutes_to_merge": 1332.96, "total_suggestions": 1, "total_applied_suggestions": 2, "total_merged_created_by_copilot": 1, "median_minutes_to_merge_copilot_authored": 1329.47, "total_copilot_suggestions": 1, "total_copilot_applied_suggestions": 2, "total_merged_reviewed_by_copilot": 2, "median_minutes_to_merge_copilot_reviewed": 1332.96, "copilot_suggestions_by_comment_type": [ { "comment_type": "documentation", "total_copilot_suggestions": 1, "total_copilot_applied_suggestions": 1 }, { "comment_type": "spelling", "total_copilot_suggestions": 0, "total_copilot_applied_suggestions": 1 } ] } } ] ```