Dataset: AI Usage
Entity: AI Usage Measurement
Field ID: _system_id
Type: Text
Description: The universal ID assigned to the record to uniquely identify it across all application records.
Source: Calculated
Transformation logic: N/A
App Mapping
GitHub Copilot | Calculated |
Anthropic Claude (coming soon) | Calculated |
Cursor (coming soon) | Calculated |
OpenAI Platform (coming soon) | Calculated |
OpenAI Codex (coming soon) | Calculated |
Reporting Use Cases
The _system_id field is the unique identifier Keypup assigns to every AI usage measurement. It is the reliable basis for counting records and for drilling from a chart down to the individual measurements behind it.
Accurate counting: Use
COUNT_DISTINCT(_system_id)whenever you need a count of measurements rather than a sum of a measure.Drilldowns: It is what allows a widget to list the individual records behind an aggregate figure.
Not a business identifier: It carries no meaning of its own. To identify what a record measures, use
aggregation_level,breakdownand the dimension fields.
