Campaign tracking

Pieces, response, and sales per cohort and test arm. Calls, leads, and cost are manual until the QR service and monday match-back are live.

Import installs (monday export)

Upload the “Export of Active/Expired” CSV — status is read from the filename. New installs are deduped against existing ones, matched to parcels by normalized address, geocoded where no parcel matches, and mirrored into suppression. Scoring re-runs automatically afterwards.

CohortArmPiecesHoldoutTouchesScansCallsLeadsSalesCost $Resp %Conv %Notes
No cohorts yet — the first logged mail run creates Cohort 1 (split into 1-touch and 3-touch arms plus a 10% holdout).

Scans populate once the standalone QR redirect service is live. Sales pre-fill from automatic match-back (mailed address → install record) once customer exports are re-uploaded; overwrite anytime.