Skip to main content

AI Usage > ID (system)

Written by Tom Williams

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, breakdown and the dimension fields.

Did this answer your question?