Filename
organizationName_ANONYMIZED_AGGREGATES_YYYYMMDDZ.extension
Variables:
organizationName: the slugified name of the organization
YYYYMMDD, the week this file contains data from. Week is in ISO format, meaning that Monday is considered the first day of the week.
extension, depending on the format and compression, see below:
Available formats
Format | Compression | Extension |
---|---|---|
This file contains data that Worklytics has preprocessed and aggregated at the week level. Depending on the metric in question, data is either inferred from connected customer data sources or calculated by Worklytics.
NDJSON example (note examples are pretty printed for documentation purposes otherwise will be presented in one row each)
Note that not all metrics in the table below will necessarily appear in your company’s export, as some require specific data connectors (e.g., if your company has not connected GitHub, you will not see any of the github:
metrics). The list of metrics may change as aggregates are added over time.
Field | Type | Description |
---|---|---|
NONE,GZIP
.csv[.gz]
NONE,GZIP
.json[.gz]
NONE,DEFLATE,SNAPPY
.avro
NONE,SNAPPY,GZIP,ZSTD
.parquet[.gz]
employeeId
STRING
Pseudonymized ID of the employee whose work is summarized in the aggregate (ID may be un-pseudonymized for non-proxy users)
week
DATE
ISOWEEK when that work occurred
key
STRING
Metric name (see "Weekly aggregate definitions" below for details)
value
FLOAT
Metric value