Coverage ledger
What we have read, what remains unknown, and which read comes next.
22 warehouse datasets, 509 physical objects. The 223 substantive tables exclude 180 GA4 shards and 106 staging copies. GA4 has three logical families tracked separately. With those families included, the non-staging total is 226.
Content-read coverage is unreconciled. The historical 118/223 query flags are not a read rate. For example, airbyte.user_usage was flagged unread although an August 16 read exists. Today’s Gemini comparison and the September 3 cost-column reads are carried forward.
Next programme reads: S2 — customer voice, session feedback and review prompts. S3 — all 20 KPI workbook tabs. These are queued programme slots on invocation, not running jobs.
Definition test: a separately generated recording can cross-check an observed fact; Product, Finance or Support must own the business rule. Two mirrors of one source are correlated evidence.
Read the 28 room dispositions
App_usage
- Objects
- 38 physical / 38 in 223
- Content-read evidence
- At least 3 named objects plus one conditional receipt: App_usage_events (sample + column facts; audit receipt not re-verified in S1), App_usage_cancel_reasons (aggregate/regex), users_churn_reasons (flags); users_app_activity (TRACE-001 source per C3 §3; receipt outside S1 set); exact room total unreconciled. users_churn_reasons and claude.vpn_churns share the retained row count/date; shared lineage is a warning to test, not proved by that signature
- Historical scanner
- 25/38 flagged yes on 09-05; App_usage_events flagged no, a second scanner false negative conditional on the 08-17 audit receipt
- Reader/date/source
- Talos audit 2026-08-17; Tris 2026-09-02; C1/U1 and audit COVERAGE.json
- Next action
- scheduled read — S2 on invocation: sessions.feedback/reasons aggregate first, then screened sample; full cancel free-text codebook. Owner: S2 writer. pseudo_id_funnel: not reading, because shared/reset pseudo IDs require a source identity contract before its 66M-row funnel can support transitions. Remaining reads need their own question.
- Denominator/falsifier/expiry
- Denominator: 38 physical / 38 in 223; read scope: preceding cell. Falsifier: a dated SQL/result or content-read receipt for additional objects/fields. Expiry: next matching read/lineage receipt or 2026-09-16, whichever comes first.
Google_events
- Objects
- 5 physical / 5 in 223
- Content-read evidence
- At least 1: events notificationType by month; other object content reads unreconciled
- Historical scanner
- 2/5 flagged yes on 09-05
- Reader/date/source
- Tris, 2026-09-05; C2
- Next action
- not reading, because notification-source completeness and actual grace settings remain unresolved; google_subscription_lifecycle is deferred until its producer mapping and relation to the notification stream are recovered.
- Denominator/falsifier/expiry
- Denominator: 5 physical / 5 in 223; read scope: preceding cell. Falsifier: a dated SQL/result or content-read receipt for additional objects/fields. Expiry: next matching read/lineage receipt or 2026-09-16, whichever comes first.
Marketing
- Objects
- 1 physical / 1 in 223
- Content-read evidence
- Unknown; 1 historical query flag is not a per-object content receipt
- Historical scanner
- 1/1 flagged yes on 09-05
- Reader/date/source
- Actor/date unestablished; C1 register
- Next action
- not reading, because S1 has no commissioned acquisition question for this object; locate original query and field list before commissioning exposure.
- Denominator/falsifier/expiry
- Denominator: 1 physical / 1 in 223; read scope: preceding cell. Falsifier: a dated SQL/result or content-read receipt for additional objects/fields. Expiry: next matching read/lineage receipt or 2026-09-16, whichever comes first.
Mysterium_VPN
- Objects
- 1 physical / 1 in 223
- Content-read evidence
- Unknown; 0 positive receipts recovered in this bounded S1 source set / 1 object
- Historical scanner
- 0/1 flagged yes on 09-05
- Reader/date/source
- Actor/date unestablished; C1 register
- Next action
- not reading, because its purpose and present analytical use are unestablished; first recover table purpose and a decision it can inform.
- Denominator/falsifier/expiry
- Denominator: 1 physical / 1 in 223; read scope: preceding cell. Falsifier: a dated SQL/result or content-read receipt for additional objects/fields. Expiry: next matching read/lineage receipt or 2026-09-16, whichever comes first.
Test
- Objects
- 10 physical / 10 in 223
- Content-read evidence
- Unknown; 0 positive receipts recovered in this bounded S1 source set / 10 objects
- Historical scanner
- 0/10 flagged yes on 09-05
- Reader/date/source
- Actor/date unestablished; C1 register
- Next action
- not reading, because experimental/stale names do not justify full scans; dark_vpn_earnings is a separate supply-cost lead, outside this VPN journey read.
- Denominator/falsifier/expiry
- Denominator: 10 physical / 10 in 223; read scope: preceding cell. Falsifier: a dated SQL/result or content-read receipt for additional objects/fields. Expiry: next matching read/lineage receipt or 2026-09-16, whichever comes first.
airbyte
- Objects
- 10 physical / 10 in 223
- Content-read evidence
- At least 2: devices_time_from_click_to_connect and user_usage; stored-average and counter profiles only
- Historical scanner
- 3/10 flagged yes on 09-05
- Reader/date/source
- Tris 2026-09-05; historical user_usage receipt 2026-08-16; 2026-09-07 correction, actor unestablished in C1; C1/C2
- Next action
- not reading, because timing/usage profiles already exist; recover producing SQL and counter grain before interpreting averages or recurrence.
- Denominator/falsifier/expiry
- Denominator: 10 physical / 10 in 223; read scope: preceding cell. Falsifier: a dated SQL/result or content-read receipt for additional objects/fields. Expiry: next matching read/lineage receipt or 2026-09-16, whichever comes first.
airbyte_internal
- Objects
- 106 physical / 0 in 223
- Content-read evidence
- Unknown; staging excluded from 223; inventory is not a content read
- Historical scanner
- outside scan denominator
- Reader/date/source
- Metadata inventory 2026-09-02; content actor/date unestablished
- Next action
- not reading, because redundant ingestion copies are outside the substantive denominator; reopen only to resolve a specified lineage/replay defect.
- Denominator/falsifier/expiry
- Denominator: 106 physical / 0 in 223; read scope: preceding cell. Falsifier: a dated SQL/result or content-read receipt for additional objects/fields. Expiry: next matching read/lineage receipt or 2026-09-16, whichever comes first.
analytics_354300879
- Objects
- 180 physical / 0 in 223; 3 GA4 logical families (non-additive)
- Content-read evidence
- 3 families inventoried; content-read object total unknown. first_open/login route is reported, but exact GA4 shard attribution is unestablished here
- Historical scanner
- outside scan denominator
- Reader/date/source
- Audit family metadata 2026-08-17; C3 first_open result; content actor/date per shard unknown
- Next action
- not reading, because S1 is not a GA4 event sweep; first bind first_open/login SQL to exact shards, event windows and identity fields. Full warehouse capture remains excluded.
- Denominator/falsifier/expiry
- Denominator: 180 physical / 0 in 223; 3 GA4 logical families (non-additive); read scope: preceding cell. Falsifier: a dated SQL/result or content-read receipt for additional objects/fields. Expiry: next matching read/lineage receipt or 2026-09-16, whichever comes first.
apify
- Objects
- 10 physical / 10 in 223
- Content-read evidence
- Unknown; 0 positive receipts recovered in this bounded S1 source set / 10 objects
- Historical scanner
- 0/10 flagged yes on 09-05
- Reader/date/source
- Actor/date unestablished; C1 register
- Next action
- not reading, because competitor price scrape is a market comparison, not a customer journey fact; revisit for an explicit price-comparison decision.
- Denominator/falsifier/expiry
- Denominator: 10 physical / 10 in 223; read scope: preceding cell. Falsifier: a dated SQL/result or content-read receipt for additional objects/fields. Expiry: next matching read/lineage receipt or 2026-09-16, whichever comes first.
claude
- Objects
- 13 physical / 13 in 223
- Content-read evidence
- At least 7: users_cycles; vpn_primer_payments; vpn_stripe_charges; vpn_users/purchases/churns/refunds (four S5 comparisons). Selected fields only
- Historical scanner
- 10/13 flagged yes on 09-05
- Reader/date/source
- Tris 2026-09-03 cost bridge, 09-05 Primer, 09-09 S5; 09-07 reachability actor unestablished; C2/U1/U2/U3
- Next action
- not reading, because documented reads already answer the inventory question; excluded vpn_purchases remains outside default analysis authority. Fee/cost lineage and Primer decline-code review are distinct next questions.
- Denominator/falsifier/expiry
- Denominator: 13 physical / 13 in 223; read scope: preceding cell. Falsifier: a dated SQL/result or content-read receipt for additional objects/fields. Expiry: next matching read/lineage receipt or 2026-09-16, whichever comes first.
gemini
- Objects
- 5 physical / 5 in 223
- Content-read evidence
- 5/5 objects aggregate-read in S5: four monthly pair comparisons and traffic date/count inspection; no full-row semantic read claim
- Historical scanner
- 0/5 flagged yes on 09-05
- Reader/date/source
- Tris, 2026-09-09, U2 and retained s5-two-truths SQL/JSON
- Next action
- not reading, because S5 already performed the deferred comparison; inspect transformations/direct Looker configuration next. Similar values or names do not prove independent lineage or downstream wiring.
- Denominator/falsifier/expiry
- Denominator: 5 physical / 5 in 223; read scope: preceding cell. Falsifier: a dated SQL/result or content-read receipt for additional objects/fields. Expiry: next matching read/lineage receipt or 2026-09-16, whichever comes first.
goproxies_web
- Objects
- 2 physical / 2 in 223
- Content-read evidence
- Unknown; 2 historical query flags / 2 objects
- Historical scanner
- 2/2 flagged yes on 09-05
- Reader/date/source
- Actor/date unestablished; C1 register
- Next action
- not reading, because GoProxies-specific customer analysis is outside this VPN journey programme; preserve its coverage row.
- Denominator/falsifier/expiry
- Denominator: 2 physical / 2 in 223; read scope: preceding cell. Falsifier: a dated SQL/result or content-read receipt for additional objects/fields. Expiry: next matching read/lineage receipt or 2026-09-16, whichever comes first.
imports
- Objects
- 1 physical / 1 in 223
- Content-read evidence
- Unknown; 0 positive receipts recovered in this bounded S1 source set / 1 object; country_tier is inventoried
- Historical scanner
- 0/1 flagged yes on 09-05
- Reader/date/source
- Actor/date unestablished; C1 register
- Next action
- not reading, because table-name discovery does not commission pricing tiers; use only after version/effective-date and classification rule are recovered.
- Denominator/falsifier/expiry
- Denominator: 1 physical / 1 in 223; read scope: preceding cell. Falsifier: a dated SQL/result or content-read receipt for additional objects/fields. Expiry: next matching read/lineage receipt or 2026-09-16, whichever comes first.
intercom
- Objects
- 13 physical / 13 in 223
- Content-read evidence
- At least 5/13: contacts, conversations, conversation parts, activity_logs, tickets (examined but zero rows in retained inventory); bounded keys/content, not all message bodies
- Historical scanner
- 2/13 flagged yes on 09-05
- Reader/date/source
- Six-stream execution 2026-09-03/04 reviewed in C3; per-query actor needs receipt reconciliation; reachability 2026-09-07, actor unestablished
- Next action
- scheduled read — S2 on invocation: audit existing classified payer conversations. Owner: S2 writer; keep raw bodies in private store and release aggregates only.
- Denominator/falsifier/expiry
- Denominator: 13 physical / 13 in 223; read scope: preceding cell. Falsifier: a dated SQL/result or content-read receipt for additional objects/fields. Expiry: next matching read/lineage receipt or 2026-09-16, whichever comes first.
intercom_myst_nodes
- Objects
- 13 physical / 13 in 223
- Content-read evidence
- At least 3/13: contacts, conversations, conversation parts in six-stream execution; whole-body read count unknown
- Historical scanner
- 0/13 flagged yes on 09-05
- Reader/date/source
- Execution 2026-09-03/04, C3; per-query actor needs receipt reconciliation
- Next action
- not reading, because node-runner support is a distinct supply-side question; raw discovery stays registered, not treated as VPN customer evidence.
- Denominator/falsifier/expiry
- Denominator: 13 physical / 13 in 223; read scope: preceding cell. Falsifier: a dated SQL/result or content-read receipt for additional objects/fields. Expiry: next matching read/lineage receipt or 2026-09-16, whichever comes first.
intercom_superproxy
- Objects
- 13 physical / 13 in 223
- Content-read evidence
- At least 3/13: contacts, conversations, conversation parts in six-stream execution; whole-body read count unknown
- Historical scanner
- 3/13 flagged yes on 09-05
- Reader/date/source
- Execution 2026-09-03/04, C3; per-query actor needs receipt reconciliation
- Next action
- not reading, because proxy support is outside the VPN customer denominator; reuse only for an explicitly scoped proxy question.
- Denominator/falsifier/expiry
- Denominator: 13 physical / 13 in 223; read scope: preceding cell. Falsifier: a dated SQL/result or content-read receipt for additional objects/fields. Expiry: next matching read/lineage receipt or 2026-09-16, whichever comes first.
looker
- Objects
- 14 physical / 14 in 223
- Content-read evidence
- At least 1: users_revenue, 08-17 reconciliation cited by U2; receipt not re-executed. Review-prompt table separately tracked below; exact room total unknown
- Historical scanner
- 12/14 flagged yes on 09-05
- Reader/date/source
- C1 register 2026-09-05; U2 cites users_revenue read 2026-08-17, actor unreconciled
- Next action
- scheduled read — S2 on invocation: app_users_review_prompt positive/negative/feedback-opened counts by period; retain unknown states. Owner: S2 writer. app_users_protocol_events: not reading, because protocol event-to-attempt mapping and success meaning need a producer contract first.
- Denominator/falsifier/expiry
- Denominator: 14 physical / 14 in 223; read scope: preceding cell. Falsifier: a dated SQL/result or content-read receipt for additional objects/fields. Expiry: next matching read/lineage receipt or 2026-09-16, whichever comes first.
postgre
- Objects
- 67 physical / 67 in 223
- Content-read evidence
- At least 1: mv_user_revenue_actual; mv_vpn_cancel_reasons has a historical query flag only pending receipt. Mirrors of claude reads are not independent recordings
- Historical scanner
- 52/67 flagged yes on 09-05
- Reader/date/source
- U2 METRIC-CONTRACT and capture-manifest OID bridge; exact content actor/date and room total unreconciled
- Next action
- not reading, because economics requires per-cycle build lineage and payment-component reconciliation first. omnisend_contacts and omnisend_consent_contacts are deferred until a lifecycle exposure/consent question specifies the intended join and policy; a contact inventory alone cannot establish exposure.
- Denominator/falsifier/expiry
- Denominator: 67 physical / 67 in 223; read scope: preceding cell. Falsifier: a dated SQL/result or content-read receipt for additional objects/fields. Expiry: next matching read/lineage receipt or 2026-09-16, whichever comes first.
subscriptions
- Objects
- 2 physical / 2 in 223
- Content-read evidence
- 2/2: subscription and subscription_events; keys, event types and timestamp availability read, meanings open
- Historical scanner
- 2/2 flagged yes on 09-05
- Reader/date/source
- Six-stream execution 2026-09-03/04; reachability 2026-09-07, actor unestablished; C3/U3
- Next action
- not reading, because joint reachability and chronology profiles exist; next read is event producer/transform contract, including null emitted_at and mutable subscription state.
- Denominator/falsifier/expiry
- Denominator: 2 physical / 2 in 223; read scope: preceding cell. Falsifier: a dated SQL/result or content-read receipt for additional objects/fields. Expiry: next matching read/lineage receipt or 2026-09-16, whichever comes first.
superproxies
- Objects
- 2 physical / 2 in 223
- Content-read evidence
- Unknown; 2 historical query flags / 2 objects
- Historical scanner
- 2/2 flagged yes on 09-05
- Reader/date/source
- Actor/date unestablished; C1 register
- Next action
- not reading, because this is a proxy namespace outside the VPN customer programme; historical flags remain visible.
- Denominator/falsifier/expiry
- Denominator: 2 physical / 2 in 223; read scope: preceding cell. Falsifier: a dated SQL/result or content-read receipt for additional objects/fields. Expiry: next matching read/lineage receipt or 2026-09-16, whichever comes first.
users
- Objects
- 2 physical / 2 in 223
- Content-read evidence
- At least 1/2: creations root frame; root creation is not the full 2026 paying estate
- Historical scanner
- 2/2 flagged yes on 09-05
- Reader/date/source
- Six-stream 2026-09-03/04; 2026-09-07 reachability, actor unestablished; C3/U3
- Next action
- not reading, because the existing frozen-frame read is reusable; a paid-estate question must explicitly include pre-2026-created payers and keep its separate denominator.
- Denominator/falsifier/expiry
- Denominator: 2 physical / 2 in 223; read scope: preceding cell. Falsifier: a dated SQL/result or content-read receipt for additional objects/fields. Expiry: next matching read/lineage receipt or 2026-09-16, whichever comes first.
vpn_web_tracking
- Objects
- 1 physical / 1 in 223
- Content-read evidence
- Unknown; events_recent was excluded from the six-stream run pending lineage, not proved unread across Kairos
- Historical scanner
- 0/1 flagged yes on 09-05
- Reader/date/source
- Execution 2026-09-03/04, C3
- Next action
- not reading, because its source lineage is unresolved under that run contract; recover producer evidence and define a new bounded read before admission.
- Denominator/falsifier/expiry
- Denominator: 1 physical / 1 in 223; read scope: preceding cell. Falsifier: a dated SQL/result or content-read receipt for additional objects/fields. Expiry: next matching read/lineage receipt or 2026-09-16, whichever comes first.
Drive capture
- Objects
- 3 selected files; KPI workbook 20 tabs; whole Drive denominator unknown
- Content-read evidence
- 2 other files content-read; KPI workbook 2/20 tabs reported read (26 VPN MRKT, SP MRKT); 18 tab reads unconfirmed
- Historical scanner
- not applicable
- Reader/date/source
- Talos, 2026-09-07 21:43–22:10; capture MANIFEST addendum 09-08
- Next action
- scheduled read — S3 on invocation: all 20 tabs, formulas/blank/#REF states and target/actual denominators, with blind extraction. Owner: S3 writer.
- Denominator/falsifier/expiry
- Denominator: 3 selected files; KPI workbook 20 tabs; whole Drive denominator unknown; read scope: preceding cell. Falsifier: a dated additional content-read receipt, including its actual object/field IDs. Expiry: next matching receipt or 2026-09-16, whichever comes first.
ClickUp capture
- Objects
- 7,068 distinct tasks / 226 lists / 13 spaces; 1,979 comment response files
- Content-read evidence
- 7,068 task records parsed for capture; semantic task coverage unknown. Six-stream searched 3,605 comments / 2,305 files in its own captured scope; unique overlap with this capture unreconciled
- Historical scanner
- not applicable
- Reader/date/source
- Capture complete 2026-09-03 12:48Z; source capture script, agent identity not recorded in receipt; C3 execution 09-03/04
- Next action
- not reading, because parsing and literal search do not establish semantic understanding; next work should bind a named journey/incident to task and comment IDs before reading relational support links.
- Denominator/falsifier/expiry
- Denominator: 7,068 distinct tasks / 226 lists / 13 spaces; 1,979 comment response files; read scope: preceding cell. Falsifier: a dated additional content-read receipt, including its actual object/field IDs. Expiry: next matching receipt or 2026-09-16, whichever comes first.
Grafana definitions capture
- Objects
- 152 dashboard definitions + 17 folder records + 18 datasource definitions in 09-02 capture
- Content-read evidence
- 152/152 dashboards structurally parsed in prior commissioning; 2,280 panels / 3,133 queries / 286 variables inventoried in 08-27 snapshot. Semantic query-definition coverage unknown; snapshot folder counts differ
- Historical scanner
- not applicable
- Reader/date/source
- Talos, 2026-08-27 commissioning; 2026-09-02 capture script (agent not in receipt); U5
- Next action
- not reading, because a definition inventory is not telemetry or a semantic contract; next read is one source-owned metric expression, unit, retention and producer path for a named outcome.
- Denominator/falsifier/expiry
- Denominator: 152 dashboard definitions + 17 folder records + 18 datasource definitions in 09-02 capture; read scope: preceding cell. Falsifier: a dated additional content-read receipt, including its actual object/field IDs. Expiry: next matching receipt or 2026-09-16, whichever comes first.
Slack frozen export
- Objects
- 237 channels / 1,085,280 messages; snapshot ends 2026-08-18
- Content-read evidence
- 1,085,280 indexed/identifier-searched rows; semantic read total unknown. Contract 2A examined 322 records; the 114-hit fixture is a different bounded retrieval and must not be added
- Historical scanner
- not applicable
- Reader/date/source
- Talos/Tris prior analyses 2026-08-24–27; U6/U4 and Operating Map
- Next action
- not reading, because whole-archive indexing has already run; inspect selected historical lineage/decision threads when an exact field or task provides a retrieval key. Attachments/private channels/later activity have separate unknown denominators.
- Denominator/falsifier/expiry
- Denominator: 237 channels / 1,085,280 messages; snapshot ends 2026-08-18; read scope: preceding cell. Falsifier: a dated additional content-read receipt, including its actual object/field IDs. Expiry: next matching receipt or 2026-09-16, whichever comes first.
Intercom raw — cross-dataset view
- Objects
- 39 warehouse objects across 3 workspaces; overlaps intercom* rows above; not additive
- Content-read evidence
- At least 11 named raw objects in six-stream (3×contacts/conversations/parts plus activity_logs/tickets); 8,606 payer conversations model-classified in programme, blind audit of 339 still open
- Historical scanner
- not applicable
- Reader/date/source
- Six-stream 2026-09-03/04; paying-map classification reported in U1 2026-09-08; exact classification actor/date in that run receipt
- Next action
- scheduled read — S2 on invocation: blind audit, 339 records in batches of 40, against one codebook. Owner: S2 writer; existing classifier output remains provisional.
- Denominator/falsifier/expiry
- Denominator: 39 warehouse objects across 3 workspaces; overlaps intercom* rows above; not additive; read scope: preceding cell. Falsifier: a dated additional content-read receipt, including its actual object/field IDs. Expiry: next matching receipt or 2026-09-16, whichever comes first.
Review prompt — looker.app_users_review_prompt
- Objects
- 1 warehouse table / about 241k rows in C1; overlaps looker; not additive
- Content-read evidence
- Content-read total unknown; inventory/name recognition does not settle positive/negative/feedback-opened counts
- Historical scanner
- not applicable
- Reader/date/source
- C1 2026-09-03; S2 pending in U1 2026-09-08; content reader/date unestablished
- Next action
- scheduled read — S2 on invocation: count prompt state/outcome by period and platform, inspect source event mapping; store-star ratings and prompt-positive are distinct outcomes.
- Denominator/falsifier/expiry
- Denominator: 1 warehouse table / about 241k rows in C1; overlaps looker; not additive; read scope: preceding cell. Falsifier: a dated additional content-read receipt, including its actual object/field IDs. Expiry: next matching receipt or 2026-09-16, whichever comes first.
Inspect the 83 definition gaps
F001 · source
- Stage
- Acquisition
- Field/fact
- source
- Meaning gap
- Mutable contact attribution versus source-at-time-of-acquisition
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: web/app events ↔ affiliate reporting
- Resolution/owner
- Empirical → business rule — Data + Marketing
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F002 · campaign_id
- Stage
- Acquisition
- Field/fact
- campaign_id
- Meaning gap
- Campaign identity and cross-system namespace
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: campaign catalogue ↔ exposure events
- Resolution/owner
- Empirical → business rule — Marketing + Data
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F003 · creative / offer identifier
- Stage
- Acquisition
- Field/fact
- creative / offer identifier
- Meaning gap
- Version at exposure; a campaign name is insufficient
- Independent recording
- No second recording established in the named evidence; source search remains open
- Resolution/owner
- Empirical → business rule — Marketing
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F004 · click_id / install_id
- Stage
- Acquisition
- Field/fact
- click_id / install_id
- Meaning gap
- Click-to-install join, resets and collisions
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: affiliate click/OID ↔ GA4 install/login
- Resolution/owner
- Empirical — Data + acquisition source owner
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F005 · exposure_time
- Stage
- Acquisition
- Field/fact
- exposure_time
- Meaning gap
- Event time versus ingest time; actual visibility versus eligibility
- Independent recording
- No second recording established in the named evidence; source search remains open
- Resolution/owner
- Empirical → business rule — Marketing + experiment owner
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F006 · consent / attribution window
- Stage
- Acquisition
- Field/fact
- consent / attribution window
- Meaning gap
- Permitted window, first/last-touch choice and consent meaning
- Independent recording
- No second recording established in the named evidence; source search remains open
- Resolution/owner
- Business rule required — Marketing + privacy owner
- Next action
- Locate adopted policy and consent record; request a rule only for unresolved policy
- Source
- C4 §5
F007 · visitor_id / user_pseudo_id
- Stage
- Identity
- Field/fact
- visitor_id / user_pseudo_id
- Meaning gap
- Install-scoped identifier, resets and Windows shared identifier
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: account login events ↔ source install records
- Resolution/owner
- Empirical — Client engineering + Data
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C1 timing correction; C3 limits; C4 §4
F008 · user_id / account uuid
- Stage
- Identity
- Field/fact
- user_id / account uuid
- Meaning gap
- Account versus person; namespace, merge/split and effective ownership
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: account roots ↔ subscription/support source identifiers
- Resolution/owner
- Empirical → business rule — Data + identity source owner
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C3; C4 §4; U3
F009 · created_date / account creation
- Stage
- Identity
- Field/fact
- created_date / account creation
- Meaning gap
- Creation event semantics, timezone and left-censored root eligibility
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: creation events ↔ account source record
- Resolution/owner
- Empirical → business rule — Data
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C3 §7; U3
F010 · login method
- Stage
- Identity
- Field/fact
- login method
- Meaning gap
- Account linkage and anonymous-to-known transitions
- Independent recording
- No second recording established in the named evidence; source search remains open
- Resolution/owner
- Empirical → business rule — Identity source owner
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F011 · device_id
- Stage
- Identity
- Field/fact
- device_id
- Meaning gap
- Device versus install/account; shared/reused values
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: client event ↔ device registry
- Resolution/owner
- Empirical → business rule — Client engineering + Data
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F012 · platform / app_version
- Stage
- Identity
- Field/fact
- platform / app_version
- Meaning gap
- Capture origin, missing values and version validity
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: client headers ↔ telemetry dimensions
- Resolution/owner
- Empirical — Client engineering
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F013 · identity edge / merge history
- Stage
- Identity
- Field/fact
- identity edge / merge history
- Meaning gap
- Cardinality, effective dates, deleted accounts and conflict precedence
- Independent recording
- No second recording established in the named evidence; source search remains open
- Resolution/owner
- Empirical → business rule — Identity source owner + Data
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F014 · order_id / purchase_id
- Stage
- Payment
- Field/fact
- order_id / purchase_id
- Meaning gap
- Retry deduplication, immutable transaction identity and rail coverage
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: gateway events ↔ warehouse transactions
- Resolution/owner
- Empirical → business rule — Payments + Data
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F015 · payer identifier
- Stage
- Payment
- Field/fact
- payer identifier
- Meaning gap
- One payer/many accounts; account identity is not payer identity
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: processor customer ↔ account/subscription mapping
- Resolution/owner
- Empirical → business rule — Payments + Data
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F016 · subscription_id / user_uuid
- Stage
- Payment
- Field/fact
- subscription_id / user_uuid
- Meaning gap
- Membership versus purchase/entitlement; namespace and orphan events
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: subscription source ↔ payment records
- Resolution/owner
- Empirical → business rule — Subscriptions + Data
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C3; C4 §4; U3
F017 · authorization state
- Stage
- Payment
- Field/fact
- authorization state
- Meaning gap
- Authorized is not captured/settled; transition and reversal rules
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: processor ledger ↔ emitted authorization events
- Resolution/owner
- Empirical → business rule — Payments + Finance
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F018 · capture / SETTLED / succeeded state
- Stage
- Payment
- Field/fact
- capture / SETTLED / succeeded state
- Meaning gap
- State mapping, currency and final cash treatment across rails
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: source processor settlement ledger ↔ Primer/Stripe records
- Resolution/owner
- Empirical → business rule — Payments + Finance
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C2 Primer; U3 Stripe caveat; C4 §3
F019 · currency
- Stage
- Payment
- Field/fact
- currency
- Meaning gap
- Minor-unit exponent, transaction/settlement currency and FX rule
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: processor source currency ↔ warehouse field
- Resolution/owner
- Empirical → business rule — Finance + Data
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- U3 Stripe minor-unit caveat; C4 §5
F020 · gross amount / amount_usd
- Stage
- Payment
- Field/fact
- gross amount / amount_usd
- Meaning gap
- Attempt value versus booked amount; FX date, null and duplicate logic
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: processor settlement/export ↔ warehouse rows; curated mirrors are correlated
- Resolution/owner
- Empirical → business rule — Finance + Data
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F021 · refund amount / refund_date
- Stage
- Payment
- Field/fact
- refund amount / refund_date
- Meaning gap
- Refund request versus paid refund; partials, attribution and April layer discrepancy
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: refund source event/settlement ↔ modelled refund rows
- Resolution/owner
- Empirical → business rule — Finance + Payments
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5; U2 (comparison only)
F022 · dispute / chargeback state
- Stage
- Payment
- Field/fact
- dispute / chargeback state
- Meaning gap
- Opened, won/lost and debited are different states; netting scope
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: dispute source lifecycle ↔ gateway/warehouse events
- Resolution/owner
- Empirical → business rule — Finance + Payments
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F023 · gateway/store fee / fee_per_tx
- Stage
- Payment
- Field/fact
- gateway/store fee / fee_per_tx
- Meaning gap
- Actual charged fee versus assumed rate; tax/FX/reversal handling
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: processor/store statements ↔ cost model
- Resolution/owner
- Empirical → business rule — Finance
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C1; U1 cost bridge correction; C4 §5
F024 · payment_error_decline_code
- Stage
- Payment
- Field/fact
- payment_error_decline_code
- Meaning gap
- Issuer/processor code meaning and recoverability; first read skipped codes
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: processor response ↔ Primer code field
- Resolution/owner
- Empirical, then recovery policy — Payments
- Next action
- Read code/message aggregates; recover provider mapping and policy before recovery claims
- Source
- C2 Primer
F025 · payment_error_processor_message
- Stage
- Payment
- Field/fact
- payment_error_processor_message
- Meaning gap
- Free-text processor explanation; taxonomy and truncation
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: original processor response ↔ Primer message
- Resolution/owner
- Empirical — Payments
- Next action
- Inspect screened messages and versioned processor mapping
- Source
- C2 Primer
F026 · plan / obligation
- Stage
- Entitlement
- Field/fact
- plan / obligation
- Meaning gap
- Plan identity, purchased duration, obligations and offer versions
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: product catalogue ↔ purchase/subscription payload
- Resolution/owner
- Empirical → business rule — Product + Subscriptions
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F027 · entitlement start / end
- Stage
- Entitlement
- Field/fact
- entitlement start / end
- Meaning gap
- Access window versus billing cycle; timezone, overlaps and corrections
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: access-control entitlement ↔ billing lifecycle
- Resolution/owner
- Empirical → business rule — Product + Subscriptions
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F028 · grace / retry / hold
- Stage
- Entitlement
- Field/fact
- grace / retry / hold
- Meaning gap
- Notification absence is not proof a console policy was disabled
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: Google RTDN ↔ Play Console configuration/audit history (not captured here)
- Resolution/owner
- Empirical → business rule — Subscriptions + Play Console owner
- Next action
- Check source completeness and archived setting history; only human owner settles undocumented policy intent
- Source
- C2 Google events; C4 §5
F029 · pause / renewal effective date
- Stage
- Entitlement
- Field/fact
- pause / renewal effective date
- Meaning gap
- Requested versus effective state; late arrival and recovery transitions
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: store/backend lifecycle ↔ subscription events
- Resolution/owner
- Empirical → business rule — Subscriptions
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F030 · cancellation effective date
- Stage
- Entitlement
- Field/fact
- cancellation effective date
- Meaning gap
- Customer request versus access ending; voluntary/involuntary mapping
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: cancellation source event ↔ entitlement and payment histories
- Resolution/owner
- Empirical → business rule — Subscriptions + Product
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F031 · subscription_events.event_type
- Stage
- Chronology
- Field/fact
- subscription_events.event_type
- Meaning gap
- Producer meaning of create/update; no conversion implication
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: subscription state transitions ↔ source producer code
- Resolution/owner
- Empirical → business rule — Subscriptions + Data
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C3 §4; U3
F032 · subscription_events.emitted_at
- Stage
- Chronology
- Field/fact
- subscription_events.emitted_at
- Meaning gap
- Mostly null; U3 measured emitted_at = period_start on all 87,569 populated 2026 update rows, so it is not event time and cannot measure delivery lag; timezone and missingness mechanism remain unresolved
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: producer event log ↔ receipt event (same event lineage, not independent by default)
- Resolution/owner
- Empirical — Subscription engineering
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C3 §4; U3 chronology
F033 · subscription_events.received_at
- Stage
- Chronology
- Field/fact
- subscription_events.received_at
- Meaning gap
- Reception semantics, duplicates, ties and backfill; not event order
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: ingestion/job logs ↔ source clock
- Resolution/owner
- Empirical — Data engineering
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C3 §4; U3 chronology
F034 · _airbyte_extracted_at
- Stage
- Chronology
- Field/fact
- _airbyte_extracted_at
- Meaning gap
- Ingestion timestamp versus business observation window
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: ingestion run logs ↔ table extraction timestamp
- Resolution/owner
- Empirical — Data engineering
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C3 bounded-day step 1
F035 · attempt_id / session_id
- Stage
- Product attempt
- Field/fact
- attempt_id / session_id
- Meaning gap
- Eligible attempt grain, retries and session-to-attempt relationship
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: client attempt events ↔ server/session records
- Resolution/owner
- Empirical → business rule — Product + client/backend engineering
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F036 · destination / use-case code
- Stage
- Product attempt
- Field/fact
- destination / use-case code
- Meaning gap
- Customer job representation and allowed collection scope
- Independent recording
- No second recording established in the named evidence; source search remains open
- Resolution/owner
- Business rule + customer recording required — Product/Research + privacy owner
- Next action
- Inspect already supplied job evidence; define privacy-safe coding only under source-owner authority
- Source
- C4 §5
F037 · start / end / event_timestamp
- Stage
- Product attempt
- Field/fact
- start / end / event_timestamp
- Meaning gap
- Client/server clocks, duration unit, poisoned dates and event pairing
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: client events ↔ server clock/log
- Resolution/owner
- Empirical — Client/backend engineering
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C1 timing correction; C3; C4 §5
F038 · error_code
- Stage
- Product attempt
- Field/fact
- error_code
- Meaning gap
- Raw emitted fault versus user survey label; version-specific mapping
- Independent recording
- Separately authored recording exists; linkage unchecked: separate free-text customer reports exist alongside survey choices; exact attempt linkage unconfirmed
- Resolution/owner
- Empirical → Product interpretation — Client engineering + Product
- Next action
- Map actual source codes/version to telemetry, survey choice and independent text; keep unmatched reports
- Source
- U1 S2; C3 sessions schema; C4 §5
F039 · error_type
- Stage
- Product attempt
- Field/fact
- error_type
- Meaning gap
- Classification producer, nulls and whether multiple errors collapse
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: source client/server event ↔ sessions field
- Resolution/owner
- Empirical — Client engineering
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F040 · status_code
- Stage
- Product attempt
- Field/fact
- status_code
- Meaning gap
- Protocol/client state versus technical/business success
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: server/session state ↔ client event
- Resolution/owner
- Empirical → business rule — Client/backend engineering + Product
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C3 sessions; C4 §3/5
F041 · server / node / path reference
- Stage
- Product attempt
- Field/fact
- server / node / path reference
- Meaning gap
- Network entity and timing; aggregate Grafana label is not account identity
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: server/session logs ↔ Grafana series; per-account edge unconfirmed
- Resolution/owner
- Empirical — Network/backend engineering
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F042 · opened_app_total
- Stage
- Product attempt
- Field/fact
- opened_app_total
- Meaning gap
- False could mean no joined telemetry rather than no open
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: raw open events ↔ churn flag, lineage may be shared
- Resolution/owner
- Empirical → business rule — Data + client engineering
- Next action
- Recover SQL and compare raw opens by identity/platform/window; retain unknown matches
- Source
- C4 §10; U1 S4
F043 · was_connected_total
- Stage
- Product attempt
- Field/fact
- was_connected_total
- Meaning gap
- False flag overlaps users_cycles; grain/window/identity uncommissioned
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: app_session_connections ↔ churn flag/users_cycles, independence unproven
- Resolution/owner
- Empirical → business rule — Data + Product
- Next action
- Reconcile same identifiers and windows from source SQL; do not relabel false as customer failure
- Source
- C4 §10; C5; U1 S4
F044 · no_success
- Stage
- Product attempt
- Field/fact
- no_success
- Meaning gap
- Counter is not an owned failure verdict; nonzero behavior uncommissioned
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: raw attempts/result codes ↔ app activity counters
- Resolution/owner
- Empirical → business rule — Client engineering + Product
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C5 defects; C4 §3
F045 · airbyte.user_usage counters / date grain
- Stage
- Product attempt
- Field/fact
- airbyte.user_usage counters / date grain
- Meaning gap
- Repeated ID/date rows; snapshot/increment and future dates unresolved
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: raw traffic/session event totals ↔ counter rows; lineage unconfirmed
- Resolution/owner
- Empirical — Telemetry producer + Data
- Next action
- Recover producing SQL; test ANY/EVERY reductions and counter units against independent source
- Source
- C1 usage-source correction
F046 · avg_connection_time_from_connect_to_vpn
- Stage
- Product attempt
- Field/fact
- avg_connection_time_from_connect_to_vpn
- Meaning gap
- Stored average, missing event-count weight, success/error mixture, Windows pseudo-id
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: source event gaps ↔ stored averages share likely lineage; not independent validation
- Resolution/owner
- Empirical — Telemetry producer
- Next action
- Recover producer SQL and event denominator; test against source-owned independent timing before performance claims
- Source
- C1 timing correction; C2 (superseded interpretation)
F047 · eligible attempt
- Stage
- Technical outcome
- Field/fact
- eligible attempt
- Meaning gap
- Which initiated attempts belong in the success denominator
- Independent recording
- No second recording established in the named evidence; source search remains open
- Resolution/owner
- Business rule required — Product
- Next action
- Locate adopted eligibility contract and positive/negative examples
- Source
- C4 §5
F048 · success / partial / failure / unknown verdict
- Stage
- Technical outcome
- Field/fact
- success / partial / failure / unknown verdict
- Meaning gap
- Raw connected/traffic/payment is not technical success by definition
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: client and server evidence; owned verdict definition unresolved
- Resolution/owner
- Business rule required; empirical implementation test — Product + engineering
- Next action
- Product owns verdict/exclusions; validate implementation against independent client/server observations
- Source
- C4 §5
F049 · disconnect / recovery
- Stage
- Technical outcome
- Field/fact
- disconnect / recovery
- Meaning gap
- Normal end versus failure; recovery time and resumed usability
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: client recovery event ↔ server continuation
- Resolution/owner
- Empirical → business rule — Product + engineering
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F050 · customer-job outcome
- Stage
- Technical outcome
- Field/fact
- customer-job outcome
- Meaning gap
- Customer task success cannot be inferred from traffic/payment/silence
- Independent recording
- Separate support and survey text exists; a linked explicit job-outcome recording is unconfirmed
- Resolution/owner
- Customer recording + business rule required — Product/Research
- Next action
- Read existing screened voice first; preserve unknown job outcome where no explicit account exists
- Source
- C3/C5; C4 beyond-Simonas table
F051 · evidence provenance / verdict version
- Stage
- Technical outcome
- Field/fact
- evidence provenance / verdict version
- Meaning gap
- Source identity, algorithm version, time and auditability
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: source run/version metadata ↔ derived verdict
- Resolution/owner
- Empirical — Data + Product
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F052 · external_id / contact_id
- Stage
- Support
- Field/fact
- external_id / contact_id
- Meaning gap
- Identity coverage, contact merges and effective-dated account ownership
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: support source ID ↔ account/customer identity
- Resolution/owner
- Empirical → business rule — Support + Data
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C3 limits; C4 §4; U3
F053 · conversation_id / conversation parts
- Stage
- Support
- Field/fact
- conversation_id / conversation parts
- Meaning gap
- Conversation versus support episode; participant and message-type semantics
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: support source conversation ↔ part records; same-system corroboration only
- Resolution/owner
- Empirical → business rule — Support + Data
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F054 · incident grouping / linked attempt
- Stage
- Support
- Field/fact
- incident grouping / linked attempt
- Meaning gap
- One incident across conversations/devices; accepted incident/attempt edge missing
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: incident log ↔ support messages and attempt telemetry
- Resolution/owner
- Empirical → business rule — Support + Engineering
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F055 · support timestamps / first reply time
- Stage
- Support
- Field/fact
- support timestamps / first reply time
- Meaning gap
- Reply-time fields disagree; business-hours, bot/human and timing basis
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: message-part timestamps ↔ Intercom reply-time field (same source, not independent)
- Resolution/owner
- Empirical → business rule — Support + Data
- Next action
- Recompute from event parts; obtain support-hours and qualifying-reply rule; second independent time log unconfirmed
- Source
- C5 defects; C4 §5
F056 · actions / escalation
- Stage
- Support
- Field/fact
- actions / escalation
- Meaning gap
- Task status versus action actually carried out; stable incident edge
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: support event ↔ ClickUp task/history
- Resolution/owner
- Empirical → business rule — Support + Engineering
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F057 · closed / resolved
- Stage
- Support
- Field/fact
- closed / resolved
- Meaning gap
- Closed workflow state versus customer-confirmed resolution
- Independent recording
- Separately authored recording exists; linkage unchecked: customer replies/free text are separate authored recordings from agent closure; coverage/linkage unconfirmed
- Resolution/owner
- Business rule required + empirical corroboration — Support
- Next action
- Recover closure/resolution policy; check linked customer follow-up without treating silence as success
- Source
- C4 §3/5; C5
F058 · recorded labour / handle time
- Stage
- Support
- Field/fact
- recorded labour / handle time
- Meaning gap
- Actual work versus elapsed/reply time; activities and units
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: time entries ↔ support/engineering work records; neither full denominator established
- Resolution/owner
- Empirical → business rule — Support + Engineering
- Next action
- Inspect authorized retained time-entry/worklog routes before asking whether time is generated
- Source
- C4 §5/11; C5
F059 · App_usage_cancel_reasons.feedback
- Stage
- Voice
- Field/fact
- App_usage_cancel_reasons.feedback
- Meaning gap
- Free-text coding completeness and respondent/response denominator
- Independent recording
- Candidate only; selected reasons and free text belong to the same submission. Independent candidates: support conversation text or telemetry for the same user; linkage and lineage unconfirmed
- Resolution/owner
- Empirical coding + interpretation — S2 writer + Product/Research
- Next action
- Read 3,947 responses / 2,255 distinct texts against one codebook; retain mixed/unknown classes
- Source
- U1 S2
F060 · app_usage_sessions.feedback
- Stage
- Voice
- Field/fact
- app_usage_sessions.feedback
- Meaning gap
- STRING schema known; populated content and scope unknown
- Independent recording
- No second recording established in the named evidence; source search remains open
- Resolution/owner
- Empirical — S2 writer
- Next action
- Aggregate null/non-null/grain first, then screened sample; no raw text in shared output
- Source
- C3; U1 S2
F061 · app_usage_sessions.reasons
- Stage
- Voice
- Field/fact
- app_usage_sessions.reasons
- Meaning gap
- STRING schema known; taxonomy and null meaning unknown
- Independent recording
- No second recording established in the named evidence; source search remains open
- Resolution/owner
- Empirical — S2 writer
- Next action
- Profile values and locate producer taxonomy before treating values as customer reasons
- Source
- U1 S2
F062 · review prompt positive / negative / feedback-opened state
- Stage
- Voice
- Field/fact
- review prompt positive / negative / feedback-opened state
- Meaning gap
- Prompt event semantics, eligibility/branching and denominators; not actual store rating
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: client prompt event ↔ review flow definition; store aggregate not same-person cross-check
- Resolution/owner
- Empirical → business rule — Product + S2 writer
- Next action
- Map real columns/event values, count all states by period/platform; unknown exact physical field name retained
- Source
- C1; U1 S2
F063 · active / retained
- Stage
- Lifecycle
- Field/fact
- active / retained
- Meaning gap
- Meaning: usage, entitlement, payment or explicit relationship; equal windows
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: source usage/payment/entitlement each records a different fact
- Resolution/owner
- Business rule required — Product + Finance
- Next action
- Choose and version the decision-relevant definition; report component observations separately
- Source
- C4 §5
F064 · churned / lapsed
- Stage
- Lifecycle
- Field/fact
- churned / lapsed
- Meaning gap
- Cancellation, expiry, failed renewal and inactivity are different clocks
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: lifecycle notifications ↔ entitlement/payment histories
- Resolution/owner
- Business rule required + empirical test — Product + Finance
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F065 · reactivated / recovered payer
- Stage
- Lifecycle
- Field/fact
- reactivated / recovered payer
- Meaning gap
- Gap and return definitions; same account/payer/window
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: renewed payment ↔ entitlement/usage return
- Resolution/owner
- Business rule required + empirical test — Product + Finance
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F066 · D30 / D90 / D180 observation window
- Stage
- Lifecycle
- Field/fact
- D30 / D90 / D180 observation window
- Meaning gap
- Day zero, maturity, censoring and missing-event treatment
- Independent recording
- No second recording established in the named evidence; source search remains open
- Resolution/owner
- Business rule required — Decision owner + Data
- Next action
- Freeze day-zero and horizon; keep immature and timestamp-unknown accounts in denominator
- Source
- C4 §5
F067 · recognized revenue
- Stage
- Economics
- Field/fact
- recognized revenue
- Meaning gap
- Recognition basis differs from cash settlement
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: Finance ledger ↔ processor settlement (different facts)
- Resolution/owner
- Business rule required — Finance
- Next action
- Locate adopted recognition policy and component ledger; do not substitute settled cash
- Source
- C4 §5
F068 · affiliate fees / commission
- Stage
- Economics
- Field/fact
- affiliate fees / commission
- Meaning gap
- Accrual versus approved/paid, reversals and order attribution
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: CJ/impact source commission ↔ warehouse order/component
- Resolution/owner
- Empirical → business rule — Finance + Marketing
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F069 · cycle_resi_cost_usd
- Stage
- Economics
- Field/fact
- cycle_resi_cost_usd
- Meaning gap
- Rate-sheet model versus actual node payout; attribution window
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: payout statement ↔ per-cycle model; sheet and model may share input
- Resolution/owner
- Empirical → business rule — Finance + network owner
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C1; U1 cost bridge; C4 §5
F070 · cycle_dc_cost_usd
- Stage
- Economics
- Field/fact
- cycle_dc_cost_usd
- Meaning gap
- Datacenter cost components, actual settlement and allocation
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: provider invoice ↔ cost model
- Resolution/owner
- Empirical → business rule — Finance + network owner
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- U1 cost bridge; C4 §5
F071 · cycle_total_gb_cost_usd
- Stage
- Economics
- Field/fact
- cycle_total_gb_cost_usd
- Meaning gap
- Sum formula, included components and missing terms
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: source payouts/invoices ↔ model; independence unconfirmed
- Resolution/owner
- Empirical → business rule — Finance + Data
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- U1 cost bridge; C4 §5
F072 · residential / datacenter GB fields
- Stage
- Economics
- Field/fact
- residential / datacenter GB fields
- Meaning gap
- Bytes versus GB/GiB, billable directions, deduplication and cycle window
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: network usage source ↔ per-cycle traffic; shared lineage possible
- Resolution/owner
- Empirical → billing rule — Network + Finance
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C1; U1 cost bridge
F073 · cycle_profit_usd
- Stage
- Economics
- Field/fact
- cycle_profit_usd
- Meaning gap
- Model contribution before payroll/ads/tools/infra versus full profit
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: independent settlement and cost components; full set not established
- Resolution/owner
- Business rule required + empirical reconciliation — Finance
- Next action
- Retain measured component contribution; commission netting and all missing components before full profit
- Source
- U1 correction; C4 §5; C5
F074 · support / engineering labour cost
- Stage
- Economics
- Field/fact
- support / engineering labour cost
- Meaning gap
- Recorded time × actual allocation rule; missing time is unknown
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: worklogs/payroll cost basis; retained account-level linkage unconfirmed
- Resolution/owner
- Business rule required + empirical time evidence — Finance + Support/Engineering
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F075 · CAC
- Stage
- Economics
- Field/fact
- CAC
- Meaning gap
- Acquisition spend inclusion, cohort/window attribution and organic treatment
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: source ad/affiliate spend ↔ joined acquisition exposure; customer denominator open
- Resolution/owner
- Business rule required + empirical attribution — Finance + Marketing
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F076 · attributable abuse cost
- Stage
- Economics
- Field/fact
- attributable abuse cost
- Meaning gap
- Loss components, causal attribution and double counting
- Independent recording
- No second recording established in the named evidence; source search remains open
- Resolution/owner
- Business rule required + empirical case evidence — Finance + Risk/operations
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F077 · net contribution / netting rule
- Stage
- Economics
- Field/fact
- net contribution / netting rule
- Meaning gap
- Refund, dispute, tax, fees, delivery, labour and acquisition treatment
- Independent recording
- No second recording established in the named evidence; source search remains open
- Resolution/owner
- Business rule required — Finance
- Next action
- Finance owns component inclusion/allocation; one known missing term keeps result partial
- Source
- C4 §5
F078 · intervention / experiment_id
- Stage
- Decision exposure
- Field/fact
- intervention / experiment_id
- Meaning gap
- Stable intervention version and account-level mapping
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: decision/task log ↔ experiment system
- Resolution/owner
- Empirical → business rule — Decision/experiment owner
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F079 · eligibility / assignment
- Stage
- Decision exposure
- Field/fact
- eligibility / assignment
- Meaning gap
- Eligible population and randomization/assignment rule
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: assignment log ↔ eligibility query; recording unestablished
- Resolution/owner
- Business rule required + empirical implementation test — Experiment owner
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F080 · account exposure
- Stage
- Decision exposure
- Field/fact
- account exposure
- Meaning gap
- Assigned versus actually exposed; campaign metadata is not exposure
- Independent recording
- No second recording established in the named evidence; source search remains open
- Resolution/owner
- Empirical → business rule — Experiment owner + Data
- Next action
- Find account-level exposure records and source event; preserve unexposed/unknown separately
- Source
- C4 §5
F081 · decision date / owner
- Stage
- Decision exposure
- Field/fact
- decision date / owner
- Meaning gap
- Adopted decision and accountable owner versus discussion/task update
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: approved decision record ↔ action/task history
- Resolution/owner
- Business rule/authority record required — Decision Steward
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F082 · mature outcome window
- Stage
- Decision exposure
- Field/fact
- mature outcome window
- Meaning gap
- Outcome definition, baseline, measurement date and causal comparison
- Independent recording
- Candidate only; independent lineage/record availability unconfirmed: pre-registered plan ↔ outcome event ledger (different roles)
- Resolution/owner
- Business rule required + empirical evaluation — Decision owner + Data
- Next action
- Recover source contract and test keys/windows before promotion
- Source
- C4 §5
F083 · users_cycles per-cycle activity/health: successful/failed requests, error codes, days active, sessions, seconds online, health status, first-open latency, churn flag/reason
- Stage
- Product attempt
- Field/fact
- users_cycles per-cycle activity/health: successful/failed requests, error codes, days active, sessions, seconds online, health status, first-open latency, churn flag/reason
- Meaning gap
- Units, aggregation windows, outcome mapping and coverage; a per-cycle summary does not itself define product success
- Independent recording
- Candidate: raw app_usage tables; independence and lineage relative to vpn_purchases unresolved, and excluded raw tables remain outside default analysis authority
- Resolution/owner
- Empirical → business rule — Data + Product
- Next action
- Recover producer SQL and per-cycle grain; reconcile only within existing read authority, then commission the success rule
- Source
- U3 addendum
Every read gap: named denominator, evidence that would overturn it, and expiry at the next matching receipt or 16 September 2026. No whole-estate exhaustion claim.
Read structured ledger data · Source: Kairos — Coverage Ledger · 44e70dd51d39