Skip to main content

copilot_repos_one_day_report

Creates, updates, deletes, gets or lists a copilot_repos_one_day_report resource.

Overview

Namecopilot_repos_one_day_report
TypeResource
Idgithub.copilot.copilot_repos_one_day_report

Fields

The following fields are returned by SELECT queries:

Response

NameDatatypeDescription
download_linksarrayThe URLs to download the Copilot usage metrics report for the enterprise/organization for the specified day.
report_daystring (date)The day of the report in YYYY-MM-DD format.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
copilot_enterprise_repos_one_day_reportselectenterprise, dayUse this endpoint to retrieve download links for the Copilot enterprise repository report for a specific day. The report provides per-repository pull request metrics for Copilot across the enterprise, with one entry per repository.

The report contains repository-level pull request activity for the specified day, including the Copilot Coding Agent (CCA) and Copilot Code Review (CCR) breakdowns. Only repositories that had activity on the specified day are included. Reports are generated daily and made available for download through signed URLs with a limited expiration time.

The response includes download links to the report files, along with the specific date of the report. The report covers a complete day for which data has been processed.

Enterprise owners, billing managers, and authorized users with fine-grained "View Enterprise Copilot Metrics" permission can retrieve Copilot metrics reports for the enterprise. OAuth app tokens and personal access tokens (classic) need either the manage_billing:copilot or read:enterprise scopes to use this endpoint.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
daystring (date)The day to request data for, in YYYY-MM-DD format.
enterprisestringThe slug version of the enterprise name.

SELECT examples

Use this endpoint to retrieve download links for the Copilot enterprise repository report for a specific day. The report provides per-repository pull request metrics for Copilot across the enterprise, with one entry per repository.

The report contains repository-level pull request activity for the specified day, including the Copilot Coding Agent (CCA) and Copilot Code Review (CCR) breakdowns. Only repositories that had activity on the specified day are included. Reports are generated daily and made available for download through signed URLs with a limited expiration time.

The response includes download links to the report files, along with the specific date of the report. The report covers a complete day for which data has been processed.

Enterprise owners, billing managers, and authorized users with fine-grained "View Enterprise Copilot Metrics" permission can retrieve Copilot metrics reports for the enterprise. OAuth app tokens and personal access tokens (classic) need either the manage_billing:copilot or read:enterprise scopes to use this endpoint.

SELECT
download_links,
report_day
FROM github.copilot.copilot_repos_one_day_report
WHERE enterprise = '{{ enterprise }}' -- required
AND day = '{{ day }}' -- required
;