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.
- Retail Analytics
- Data model
The tables behind Retail Analytics
Retail 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
- 7, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Snapshot workspace
Retail snapshots belongs to Organizations and points to a retail stores definition and People owner.
Observation
Basket facts and metric observations carry the measured inputs; source snapshots preserve capture windows.
Definitions
Metric definitions and source mappings describe calculation and source interpretation.
Review
Review decisions, evidence documents and state history preserve decisions and transition context.
Execution
Operation runs and operation steps retain the work trace; metric results store calculated outcomes.
Follow-up
Follow up actions belong to a retail snapshots source and an assigned People record.
Every table, by feature
- Snapshot workspace6
- Basket facts5
- Source capture5
- Metric definitions5
- Review and evidence6
- Results and provenance6
- Follow-up actions6
- Shared and settings1
- Retail snapshots
Measured web properties with lifecycle status and observed outcome fields.
Linked to Organizations, People, Retail stores - Retail stores
Configured measurement and experiment definitions with effective dating.
Linked to Organizations - Organizations
Customer organizations whose web properties are measured.
- People
Analysts, owners and reviewers belonging to an organization.
Linked to Organizations - State history
Immutable lifecycle transition history for each source.
Linked to Retail snapshots, People - Review decisions
Independent reviewer decisions recorded against an exact source revision.
Linked to Retail snapshots, People
- Basket facts
Consented observation-level session and conversion event facts.
Linked to Retail snapshots - Retail snapshots
Measured web properties with lifecycle status and observed outcome fields.
Linked to Organizations, People, Retail stores - Operation runs
Workflow execution runs with frozen revision, input hash and result identity.
Linked to Retail 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 Retail snapshots, People
- Source snapshots
Sourced snapshot captures with coverage window and freshness status.
- Metric observations
Observation-level metric readings tied to a snapshot and source.
Linked to Retail snapshots, Source snapshots - Source mappings
Reviewed field mappings between source and target definitions.
Linked to Retail stores - Retail stores
Configured measurement and experiment definitions with effective dating.
Linked to Organizations - Retail snapshots
Measured web properties with lifecycle status and observed outcome fields.
Linked to Organizations, People, Retail stores
- Metric definitions
Approved metric definitions with grain, expressions and aggregation method.
Linked to Retail stores, People - Metric results
Calculated metric results persisted once per approved definition and window.
Linked to Retail snapshots, Metric definitions, Operation runs - Retail stores
Configured measurement and experiment definitions with effective dating.
Linked to Organizations - Source mappings
Reviewed field mappings between source and target definitions.
Linked to Retail stores - 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 Retail snapshots, People - Evidence documents
Supporting source evidence documents and verification state.
Linked to Retail snapshots, People - Retail snapshots
Measured web properties with lifecycle status and observed outcome fields.
Linked to Organizations, People, Retail stores - Basket facts
Consented observation-level session and conversion event facts.
Linked to Retail snapshots - State history
Immutable lifecycle transition history for each source.
Linked to Retail snapshots, People - 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 Retail snapshots, Metric definitions, Operation runs - Metric definitions
Approved metric definitions with grain, expressions and aggregation method.
Linked to Retail stores, People - Retail snapshots
Measured web properties with lifecycle status and observed outcome fields.
Linked to Organizations, People, Retail stores - Operation runs
Workflow execution runs with frozen revision, input hash and result identity.
Linked to Retail snapshots - Operation steps
Numbered steps of an operation run with input/output and receipt state.
Linked to Operation runs - Basket facts
Consented observation-level session and conversion event facts.
Linked to Retail snapshots
- Follow up actions
Assigned corrective and follow-up actions with due dates.
Linked to Retail snapshots, People - Retail snapshots
Measured web properties with lifecycle status and observed outcome fields.
Linked to Organizations, People, Retail stores - People
Analysts, owners and reviewers belonging to an organization.
Linked to Organizations - Source snapshots
Sourced snapshot captures with coverage window and freshness status.
- Metric results
Calculated metric results persisted once per approved definition and window.
Linked to Retail snapshots, Metric definitions, Operation runs - Review decisions
Independent reviewer decisions recorded against an exact source revision.
Linked to Retail snapshots, People
Keys and references
Use retail snapshots.source record id to reconcile an external measurement identity, and operation runs.operation key to identify a repeated collection request. Keep the snapshot Revision with a review decisions.source revision. Metric results links the source, metric definition and run; metric observations links a retail snapshot and captured source snapshot. Users is a separate access record, while People supplies operational owners and reviewers.
Migration order
- Load Organizations, People and Users with stable identities.
- Load retail stores, source mappings and metric definitions with effective dates and versions.
- Load retail snapshots and source snapshots for a bounded store period.
- Load basket facts, metric observations and evidence documents with source references.
- Load review decisions, state history, operation runs, operation steps, metric results and follow up actions with their original links and dates.
Set up Retail Analytics your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.