# Desk log AERS-JOIN-20260823

**Status:** First-party illustrative assignment composite; not customer, production, randomized-trial, benchmark, or independently audited data  
**Run date:** 2026-08-23  
**Evidence checked:** 2026-08-31  
**Operator:** InfiniSynapse Data Team  
**Attestor:** William Zhu, InfiniSynapse cofounder ([GitHub @allwefantasy](https://github.com/allwefantasy))

The operator compared two illustrative joins over 64,200 assigned users. The first-event clock displayed +2.9 points; the `assigned_at` clock displayed +1.1 points and a +0.3-point refund guardrail. The first-event query was rejected and shipping remained held.

The [CSV](https://infinisynapse.com/blog-media/analyze-experiment-results-in-sql/downloads/join-summary-AERS-JOIN-20260823.csv) exposes four aggregates and two held items. The [verification script](https://infinisynapse.com/blog-media/analyze-experiment-results-in-sql/downloads/verify-AERS-JOIN-20260823.py) checks displayed output only. Assignment/outcome rows, SQL, denominators, variances, intervals, SRM, clock-skew diagnostics, and metric CASE definitions are unavailable.

External context: [ASA p-value statement](https://www.amstat.org/asa/files/pdfs/p-valuestatement.pdf), [NIST/SEMATECH e-Handbook](https://www.itl.nist.gov/div898/handbook/), and [FTC Advertising Substantiation](https://www.ftc.gov/legal-library/browse/advertising-marketing/advertising-substantiation) (retrieved 2026-08-31). These publishers did not review this run.