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.
- Social Media Analytics
- Data model
The tables behind Social Media Analytics
Social Media 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 social channels establish the owning organization and channel context.
Operations
Social profiles carries the measured property; post performance facts and metric observations hold dated readings; source snapshots records capture dates and coverage.
Execution and provenance
Metric definitions and source mappings describe measures and inputs. Metric results, operation runs and operation steps retain values and run history.
Review and evidence
Review decisions, state history, evidence documents and follow up actions preserve decisions, transitions and corrective work.
Every table, by feature
- Profile workspace7
- Post performance4
- Source evidence6
- Metric governance6
- Revision review7
- Follow-up management5
- Shared and settings1
- 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 Social profiles, People - Operation runs
Workflow execution runs with frozen revision, input hash and result identity.
Linked to Social profiles - Operation steps
Numbered steps of an operation run with input/output and receipt state.
Linked to Operation runs
- Post performance facts
Consented observation-level session and conversion event facts.
Linked to Social profiles - 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 Social profiles, Source snapshots
- 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 Social profiles, Source snapshots - Evidence documents
Supporting source evidence documents and verification state.
Linked to Social profiles, People - People
Analysts, owners and reviewers belonging to an organization.
Linked to Organizations - Source mappings
Reviewed field mappings between source and target definitions.
Linked to Social channels
- Metric definitions
Approved metric definitions with grain, expressions and aggregation method.
Linked to Social channels, People - Metric observations
Observation-level metric readings tied to a snapshot and source.
Linked to Social profiles, Source snapshots - Metric results
Calculated metric results persisted once per approved definition and window.
Linked to Social profiles, Metric definitions, Operation runs - Operation runs
Workflow execution runs with frozen revision, input hash and result identity.
Linked to Social profiles
- Review decisions
Independent reviewer decisions recorded against an exact source revision.
Linked to Social profiles, People - State history
Immutable lifecycle transition history for each source.
Linked to Social profiles, People - Evidence documents
Supporting source evidence documents and verification state.
Linked to Social profiles, People - Operation runs
Workflow execution runs with frozen revision, input hash and result identity.
Linked to Social profiles - Operation steps
Numbered steps of an operation run with input/output and receipt state.
Linked to Operation runs - Follow up actions
Assigned corrective and follow-up actions with due dates.
Linked to Social profiles, People
- Follow up actions
Assigned corrective and follow-up actions with due dates.
Linked to Social profiles, People - Review decisions
Independent reviewer decisions recorded against an exact source revision.
Linked to Social profiles, People - Evidence documents
Supporting source evidence documents and verification state.
Linked to Social profiles, People - People
Analysts, owners and reviewers belonging to an organization.
Linked to Organizations
Keys and references
Social profiles links to Organizations, People and social channels. Post performance facts points back through Parent. Metric observations connects a profile with a source snapshots capture. Metric results connects the source profile, metric definition and operation run. Review decisions stores the source revision and reviewer. State history records each source transition with actor and revision. These links let a reviewer move from a reported value to the input, calculation context and decision.
Migration order
- Load Organizations and People, then establish Users access.
- Add social channels and source mappings with their effective dates.
- Create social profiles with owner, definition, source identity and consent context.
- Add source snapshots, post performance facts and metric observations for the pilot window.
- Establish metric definitions and inspect metric results with linked operation runs and operation steps.
- Bring over review decisions, state history, evidence documents and follow up actions with their original references.
Set up Social Media Analytics your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.