Four linked tables for manual records. Green cells are editable; scroll each table sideways to see all fields. Use simple lowercase internal IDs (c-001, d-001, obs-001, evt-001). Keep native source identifiers exactly as supplied.
No automatic save or connection. Data stays only in this open page. Export each populated table before closing. This HTML cannot import or reopen saved CSVs: continue editing in your chosen spreadsheet application, or re-enter rows for another HTML check. Downloads are text CSVs, not workbook formulas or validations. Entries beginning =, +, @ or - receive a leading apostrophe on export to prevent formula interpretation; inspect that text in your chosen application. The added apostrophe is protective text, not part of a new native identifier. Compare imported keys and values with the source before matching; do not blindly strip apostrophes or disable protections.
No records checked yet.
One identified person/organization. Other profiles are references, not extra people.
| creator_id | display_name | primary_platform | primary_profile_url | other_profile_references | contact_reference | owner | updated_at | identity_note |
|---|
One agreed content unit. Keep planned and actual publication different.
| deliverable_id | creator_id | campaign_id | format_and_unit | brief_reference | agreement_reference | planned_publish_at | actual_publish_at | post_url | destination_url | owner | status_note |
|---|
One exact metric snapshot. Status: observed / awaiting / not_available / conflict. Zero needs observed source evidence.
| observation_id | deliverable_id | metric_name | value | unit | window_start | window_end | timezone | captured_at | source_reference | source_status | note |
|---|
One native business record. Use exact source_system + source_event_id once. Keep conflicting attribution unresolved; optional deliverable_id stays blank.
| event_id | source_system | source_event_id | event_kind | current_state | occurred_at | campaign_id | deliverable_id | association_rule | evidence_references | source_status | note |
|---|