LOCAL AI BRIDGE
Context Pack Builder Build a structured context bundle for any LLM without granting direct access to your Atlas or private environment.
Public Atlas focus None dataview // _Sent dataview // _Open dataview // _Click dataview // _Bounce dataview // _Unsubscribe dataview // _Job dataview // _Journey dataview // _JourneyActivity dataview // _Subscribers dataview // _BusinessUnitUnsubscribes dataview // _AutomationInstance dataview // _AutomationActivityInstance dataview // _SMSMessageTracking dataview // _SMSSubscriptionLog dataview // _UndeliverableSMS snippet // Deterministic Deduplication — Latest Record snippet // Anti-Join / Exclusion Audience snippet // Latest Version per Journey snippet // Journey → Activity → Email Tracking snippet // Find Job IDs for Journey Email Activities snippet // Subscriber Engagement — 120 Day Flags snippet // Recent Bounce Diagnostics snippet // Current Email Subscriber Status snippet // Random Audience Split with NTILE() snippet // Incremental Window with Overlap snippet // Defensive LookupRows() snippet // Tracked Dynamic URL snippet // Iterate JSON Arrays with BuildRowsetFromJson() snippet // Encrypted CloudPagesURL Parameters snippet // CloudPage — Read & Validate Request Parameters snippet // SSJS HTTP POST Webhook snippet // WSProxy Retrieve with Pagination snippet // WSProxy DataExtensionObject UpdateAdd Batch snippet // Email HTML — Minimal Defensive Shell snippet // n8n Public Webhook Contract snippet // Docker Compose — Service Baseline snippet // Never Hardcode Secrets in SFMC Scripts snippet // Python — Normalize Extracted Metadata snippet // LLM Assistance — Constrain Output to a Schema snippet // ROW_NUMBER() with a Deterministic Tie-Breaker snippet // ROW_NUMBER() with Business Priority snippet // Second Most Recent Record per Key snippet // SARGable Rolling Date Window snippet // Pre-Aggregate Tracking Before Joining snippet // First Unique Open in a Window snippet // Latest Unique Click per Subscriber snippet // COALESCE() for Ordered Fallback Values snippet // CASE-Based Business Segmentation snippet // UNION ALL for Multi-Source Staging snippet // Fast Approximate Split with _CustomObjectKey Modulo snippet // TOP + ORDER BY for a Limited Ordered Set snippet // Explicit Column Contract — No SELECT * snippet // Stage Before Large Add/Update snippet // Latest Run Status per Automation snippet // Automation Failures / Skips in the Last 24h snippet // Automation Activity Runtime & Error Health snippet // Query Activities Trending Toward Timeout snippet // SMS Tracking by Journey Version snippet // Recent MobileConnect Opt-Outs snippet // Held / Undeliverable Mobile Numbers snippet // Bounce Concentration by Domain & Category snippet // Review Held / Bounced Subscriber State snippet // Defensive AttributeValue() + Empty() Fallback snippet // Bounded LookupOrderedRows() snippet // RaiseError() for a Broken Recipient, Not Segmentation snippet // CloudPagesURL() with Encrypted Parameters snippet // Validate CloudPage Request Parameters Before Writes snippet // CloudPage Upsert Instead of Blind Insert snippet // WSProxy Retrieve All Pages snippet // Inspect WSProxy updateBatch() Results snippet // OAuth Token Cache Pattern snippet // 429 + Retry-After Exponential Backoff snippet // Journey Email Sends in the Last 24 Hours snippet // Automation Runtime Regression — Current vs 30-Day Average snippet // Docker Compose Healthcheck — Fail Closed on Dependency Readiness snippet // Docker Compose — Explicit Persistent Volume snippet // systemd Unit for a Docker Compose Stack snippet // n8n Webhook — Stable Error Envelope snippet // Webhook HMAC Verification — Canonical Pattern snippet // Load Secrets from Environment — Keep Them Out of Git snippet // Python — Shallow Snapshot Schema Diff snippet // LLM Review — Bounded Context + Provenance Prompt sql-guide // ROW_NUMBER() — The Workhorse of SFMC SQL sql-guide // Deduplication by Business Priority sql-guide // SARGable Filtering in Query Activities sql-guide // Join Grain Before Join Syntax sql-guide // Stage Large Queries Instead of Being Clever sql-guide // Target Action Is Part of Query Design sql-guide // Audience Splitting: Precision vs Throughput sql-guide // ORDER BY Is Not a Storage Contract sql-guide // My SFMC SQL Operating Rules runbook // Journey Not Sending — 360° Check runbook // Query Activity Timeout / Failure runbook // SFMC Migration Discovery runbook // Take Over an Undocumented SFMC Account runbook // Deliverability / Bounce Investigation runbook // Automation Studio Health Investigation runbook // Journey Builder Zero Injection — Advanced Triage runbook // MobileConnect / Journey SMS Troubleshooting runbook // CloudPage Production Incident runbook // SFMC API Integration Troubleshooting runbook // Email Personalization / Render Failure runbook // Docker Compose Stack Recovery runbook // n8n Webhook Incident Triage runbook // Linux Service Startup / Boot Check runbook // Backup / Restore Readiness Check pattern // Persist Tracking History Beyond Data View Retention pattern // Explicit SELECT Lists pattern // Intermediate Tables for Large Transformations pattern // Externalize Heavy SSJS Processing pattern // Golden Record Inside SFMC — Constrained Architecture pattern // Hardcoded Credentials in Scripts or Assets pattern // SELECT * in Production Automations pattern // Redesign Before Discovery pattern // Operational Baselines Before Alerts pattern // Idempotent Integration Writes pattern // Precompute Heavy Message-Time Personalization pattern // “Complete” Means Healthy pattern // Webhook Ingress Boundary pattern // Backup Before Upgrade pattern // Schema-First Metadata Ingestion pattern // AI Output With Provenance Boundaries pattern // Public Admin Surface by Convenience bite // The Journey Is Running. The Triggered Send Is Not. bite // Personalization Can Become a Throughput Problem bite // The Sendable Relationship Quietly Defines Your Contact Identity bite // Journey Data Is a Snapshot. Contact Data Is a Moving Target. bite // Overwrite Can Change How a Scheduled Entry DE Gets Evaluated bite // Skipped Automations Are Often a Scheduling Smell bite // _AutomationInstance Can Duplicate a Run Because of Notification Recipients bite // Automation Health Is UTC While Classic Tracking Often Is CST bite // A STOP Can Exist Without a SubscriberID bite // Status 2000 on a Shared Code Is Not Necessarily Handset Delivery bite // Encrypted Query String Does Not Mean “Skip Validation” bite // CloudPagesURL from SMS/Push Has an All Subscribers Trap bite // LookupRows() Stops at 2,000 Rows bite // RaiseError Can Skip the Send but Still Show Up in Tracking Metrics bite // A WSProxy Retrieve Is Not “All Rows” Just Because It Returned Results bite // Do Not Mint an OAuth Token for Every API Call bite // A Tight Retry Loop Turns Rate Limiting into Self-DDoS bite // Joining _Open Directly to _Click Can Explode Rows bite // “Six Months” Is a Default, Not a Universal Rule for Every Data View deployment // New Journey Deployment deployment // Journey Version Update deployment // Automation Deployment deployment // SQL Query Change deployment // Data Extension / Schema Change deployment // Email Campaign / Content Release deployment // CloudPage Release deployment // MobileConnect / SMS Launch deployment // WhatsApp Journey deployment // API Event / Integration deployment // SFTP Ingestion Pipeline deployment // SFMC Migration Object Validation deployment // Emergency Hotfix deployment // Deliverability-Sensitive Change deployment // Automation Incident Recovery / Rerun deployment // Bulk Backfill / Historical Load deployment // New Audience / Data Source Onboarding deployment // Multi-Channel Journey Release recipe // Deterministic Deduplication & Merge recipe // Journey Email Tracking Dataset recipe // 120-Day Engaged Audience recipe // Automation Health Baseline recipe // SMS Delivery & Opt-Out Diagnostic recipe // CloudPage Safe Write Flow recipe // Resilient REST Integration recipe // SFMC Migration Discovery Pass recipe // Pragmatic Golden Record inside SFMC recipe // Self-Hosted n8n Service Baseline recipe // Reliable Public Webhook Ingress recipe // Metadata Snapshot & Drift Review recipe // Bounded AI-Assisted Engineering Review Private environment object None Graph depth 1 hop 2 hops Include my private notes Include active environment context
Suggested instruction Use only the context below. Separate documented facts, production observations, inferences and gaps. Do not invent fields, relationships or limits that are not present.
Regenerate Copy Context Pack Download Markdown Nothing is sent. The text is assembled locally in your browser.
Review the preview before copying. Pasting this pack into an external service sends that service any private context you chose to include.
Preview