These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Manufacturing Analytics
- Data model
The tables behind Manufacturing Analytics
Manufacturing Analytics ships with 17 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 17
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Configuration
Organizations, People and production resources define ownership and measurement context.
Operations
Production snapshots link machine run facts and metric observations to dated production work; source snapshots record capture coverage.
Execution and provenance
Metric definitions and source mappings define the rule; operation runs and operation steps show execution; metric results keep values by period and dimension.
Review and evidence
Review decisions, evidence documents, state history and follow up actions explain decisions, transitions and corrective work.
Access
Users contains login identities and their account status.
Every table, by feature
- Production snapshots5
- Machine run observations5
- Efficiency and metrics6
- Definitions and mappings6
- Execution trace5
- Review and follow-up6
- Shared and settings1
- Production snapshots
Measured web properties with lifecycle status and observed outcome fields.
Linked to Organizations, People, Production resources - Organizations
Customer organizations whose web properties are measured.
- People
Analysts, owners and reviewers belonging to an organization.
Linked to Organizations - Production resources
Configured measurement and experiment definitions with effective dating.
Linked to Organizations - State history
Immutable lifecycle transition history for each source.
Linked to Production snapshots, People
- Machine run facts
Consented observation-level session and conversion event facts.
Linked to Production snapshots - Production snapshots
Measured web properties with lifecycle status and observed outcome fields.
Linked to Organizations, People, Production resources - Source snapshots
Sourced snapshot captures with coverage window and freshness status.
- Operation runs
Workflow execution runs with frozen revision, input hash and result identity.
Linked to Production snapshots - Operation steps
Numbered steps of an operation run with input/output and receipt state.
Linked to Operation runs
- Production snapshots
Measured web properties with lifecycle status and observed outcome fields.
Linked to Organizations, People, Production resources - Metric observations
Observation-level metric readings tied to a snapshot and source.
Linked to Production snapshots, Source snapshots - Metric results
Calculated metric results persisted once per approved definition and window.
Linked to Production snapshots, Metric definitions, Operation runs - Metric definitions
Approved metric definitions with grain, expressions and aggregation method.
Linked to Production resources, People - Operation runs
Workflow execution runs with frozen revision, input hash and result identity.
Linked to Production snapshots - Source snapshots
Sourced snapshot captures with coverage window and freshness status.
- Production resources
Configured measurement and experiment definitions with effective dating.
Linked to Organizations - Metric definitions
Approved metric definitions with grain, expressions and aggregation method.
Linked to Production resources, People - Source mappings
Reviewed field mappings between source and target definitions.
Linked to Production resources - Organizations
Customer organizations whose web properties are measured.
- People
Analysts, owners and reviewers belonging to an organization.
Linked to Organizations - Metric results
Calculated metric results persisted once per approved definition and window.
Linked to Production snapshots, Metric definitions, Operation runs
- Operation runs
Workflow execution runs with frozen revision, input hash and result identity.
Linked to Production snapshots - Operation steps
Numbered steps of an operation run with input/output and receipt state.
Linked to Operation runs - State history
Immutable lifecycle transition history for each source.
Linked to Production snapshots, People - Production snapshots
Measured web properties with lifecycle status and observed outcome fields.
Linked to Organizations, People, Production resources - People
Analysts, owners and reviewers belonging to an organization.
Linked to Organizations
- Review decisions
Independent reviewer decisions recorded against an exact source revision.
Linked to Production snapshots, People - Evidence documents
Supporting source evidence documents and verification state.
Linked to Production snapshots, People - Follow up actions
Assigned corrective and follow-up actions with due dates.
Linked to Production snapshots, People - Production snapshots
Measured web properties with lifecycle status and observed outcome fields.
Linked to Organizations, People, Production resources - People
Analysts, owners and reviewers belonging to an organization.
Linked to Organizations - State history
Immutable lifecycle transition history for each source.
Linked to Production snapshots, People
Keys and references
Production snapshots uses its Number and source record id to identify a dated source, while Revision identifies the state used by a run or decision. Machine run facts.Parent, operation runs.Source and review decisions.Source refer to that source. Metric results relates a source, metric definition and run. Source snapshots identifies a captured coverage window; metric observations links it to the production source. People links owner, reviewer, actor and assignee records, with organization context.
Migration order
- Load Organizations, People and Users with their access scope.
- Load production resources, source mappings and reviewed metric definitions.
- Load source snapshots and production snapshots with stable source IDs and dates.
- Link machine run facts and metric observations to their parent source and capture.
- Bring forward existing results, run history, decisions, evidence and actions only with their original references intact.
Set up Manufacturing Analytics your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.