co/efficient
Back to inventory

Opt-Out Scrubber

PRD-046

Identity

ID
PRD-046
Product / Service
Opt-Out Scrubber
Description
Automates the flow of opt-outs
Definition
-

Classification

Part of
-
Layer
Software
Category
-
Audience
Both
Supports / Supported By
-

Where it lives

Platform
-
Environment
coefficient-tools-staging.pages.dev/opt-outs (hub Google auth; Cloudflare Container jessica-scrub-app)
Vendor / Tooling
-
GitHub repo
-

Lifecycle & ownership

Stage
Development
Status
Active
Owner
Walker
Primary Developer
Walker

Roadmap

Strategic Value
-
Start Date
2026-09-14
Target Date
-

Momentum

Latest Update
10/6Maintenance mode
9/22Automated scrubbing from ReadyGOP with daily email digest
9/15Created a new app at optouts.coefficient.org
9/15Live behind hub Google auth at /opt-outs; public URL and password gate retired Skye shipped the service-binding proxy and tile (verified, including upload POSTs and the cookie collision check: none, hub uses tools_session). App redeployed with SCRUB_TRUST_PROXY_AUTH=1, a new env flag that skips the app's own password page; flag is off by default so Walker's original gate is unchanged anywhere else the app runs. workers_dev and preview URLs disabled: the hub's Google sign-in is now the only way in (public URL 404s, /opt-outs/healthz 302s to hub sign-in when anonymous). Single sign-in end to end, per house auth standard for internal apps.
9/15Deployed live to Cloudflare Containers as jessica-scrub-app Walker's scrub app (Flask + DuckDB Docker image) deployed code-unmodified behind a thin Worker. Live at https://jessica-scrub-app.ryan-b48.workers.dev behind a password gate; AWS credentials bound from the account Secrets Store (coefficientp2p key pair), nothing in the bundle. Verified against the live bucket: login flow, org freshness table (4 orgs). Ryan approved via Signal. Skye requested (thread 1a0a5d0ae266c84f): tools hub tile plus mounting behind the hub's Google auth at /opt-outs via service-binding proxy; the public workers.dev URL gets disabled after that cutover. Known limits: uploads capped around 100-200 MB by Workers; container cold start ~15s after 30 min idle.
Show 3 older
9/14Walker acquired credentials for the Creative Direct and Big Dog opt-out buckets; first batch of opt-outs uploaded successfully Open questions from PUSH: get more people access to limit bottlenecks; streamline communication; clearly define which clients/accounts go into which buckets
9/14Walker is the only one who can currently update this and it's all manual
9/14Promoted from intake (submitted 9/14/2026 by Jessica (app)). Why: MAGA, Inc. asked for it
Next Step
9/22Wire in opt-outs from co/nnect to scrub and send to bucket via API
9/15Automating uploads on a cronjob type
9/15Jessica: click the hub tile and verify the no-password flow end to end Then: Walker rotates the password that traveled in the zip (it is unused now but was exposed); consider removing the unused SCRUB_APP_PASSWORD secret later.
9/15Skye: hub tile + Google-auth proxy at /opt-outs; then lock down the public URL Once Skye ships the proxy, Jessica disables the public workers.dev route so the hub's Google sign-in is the only way in. Walker: decide whether to drop the app's own password gate behind the hub, and rotate the password that traveled in the zip.
9/14Automate the flow of opt-outs so that it's 1) not manual and 2) not entirely dependent on Walker
Goals
-
Last Reviewed
-

From the stash

Cloudflare platform · company account · used for Cloudflare Container