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.
- Web Analytics Dashboard
- Data model
The tables behind Web Analytics Dashboard
Web Analytics Dashboard 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 experiment variants establish ownership and measurement context.
Operations
Web properties, web session facts and source snapshots identify sources and captured observations.
Execution and provenance
Operation runs, operation steps, source mappings, metric definitions, metric observations and metric results explain how values were produced.
Review and evidence
Review decisions, evidence documents, follow up actions and state history retain decisions and corrective work.
Every table, by feature
- Web properties
Measured web properties with lifecycle status and observed outcome fields.
Linked to Organizations, People, Experiment variants - Organizations
Organizations measured by web properties in this analytics workspace.
- People
Analysts, owners and reviewers belonging to an organization.
Linked to Organizations - State history
Immutable lifecycle transition history for each source.
Linked to Web properties, People - Operation runs
Workflow execution runs with frozen revision, input hash and result identity.
Linked to Web properties - Follow up actions
Assigned corrective and follow-up actions with due dates.
Linked to Web properties, People
- Web session facts
Consented observation-level session and conversion event facts.
Linked to Web properties - Web properties
Measured web properties with lifecycle status and observed outcome fields.
Linked to Organizations, People, Experiment variants - 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 Web properties - Operation steps
Numbered steps of an operation run with input/output and receipt state.
Linked to Operation runs - Review decisions
Independent reviewer decisions recorded against an exact source revision.
Linked to Web properties, People
- Experiment variants
Configured measurement and experiment definitions with effective dating.
Linked to Organizations - Source mappings
Reviewed field mappings between source and target definitions.
Linked to Experiment variants - Metric definitions
Approved metric definitions with grain, expressions and aggregation method.
Linked to Experiment variants, People - Metric results
Calculated metric results persisted once per approved definition and window.
Linked to Web properties, Metric definitions, Operation runs - Web properties
Measured web properties with lifecycle status and observed outcome fields.
Linked to Organizations, People, Experiment variants - Organizations
Organizations measured by web properties in this analytics workspace.
- Review decisions
Independent reviewer decisions recorded against an exact source revision.
Linked to Web properties, People - Evidence documents
Supporting source evidence documents and verification state.
Linked to Web properties, People - Follow up actions
Assigned corrective and follow-up actions with due dates.
Linked to Web properties, People - Web properties
Measured web properties with lifecycle status and observed outcome fields.
Linked to Organizations, People, Experiment variants - State history
Immutable lifecycle transition history for each source.
Linked to Web properties, People - People
Analysts, owners and reviewers belonging to an organization.
Linked to Organizations
- Operation runs
Workflow execution runs with frozen revision, input hash and result identity.
Linked to Web properties - 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 Web properties, People - Web properties
Measured web properties with lifecycle status and observed outcome fields.
Linked to Organizations, People, Experiment variants - Web session facts
Consented observation-level session and conversion event facts.
Linked to Web properties
- Metric results
Calculated metric results persisted once per approved definition and window.
Linked to Web properties, Metric definitions, Operation runs - Metric definitions
Approved metric definitions with grain, expressions and aggregation method.
Linked to Experiment variants, People - Metric observations
Observation-level metric readings tied to a snapshot and source.
Linked to Web properties, Source snapshots - Source snapshots
Sourced snapshot captures with coverage window and freshness status.
- Web properties
Measured web properties with lifecycle status and observed outcome fields.
Linked to Organizations, People, Experiment variants - Operation runs
Workflow execution runs with frozen revision, input hash and result identity.
Linked to Web properties
Keys and references
Web session facts links to its parent web properties record. A property links to Organizations, People and experiment variants. Review decisions, state history and follow up actions link back to the property; the run record also identifies its source. Metric results can link a property, definition and run. Use these references when tracing a displayed result across collection, review and release.
Migration order
- Prepare Organizations, People and Users.
- Load experiment variants, source mappings and metric definitions.
- Create web properties with their owners, source identities and definitions.
- Add source snapshots, web session facts and metric observations.
- Preserve operation runs, operation steps, review decisions, evidence documents, follow up actions, metric results and state history where historical evidence is needed.
Set up Web Analytics Dashboard your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.