Engineering Journal
Tutorials, troubleshooting notes and implementation patterns for Salesforce marketing and data teams.
Engineering Journal list
AMPscript LookupRows vs LookupOrderedRows: Examples and Performance
When to use each function, how to loop the rowset safely, and how to keep lookups fast at send time.
Read more
DLO vs DMO: Data Cloud Data Architecture Explained
Data Lake Objects hold ingested data as it arrives. Data Model Objects give it a shared shape. Here is how they fit together.
Read more
Salesforce Winter '27 Release Highlights
A grouped guide to Salesforce Winter '27: what changed in each area, which items are GA, beta or pilot, and how to prepare your org.
Read more
How to Debug AMPscript Personalization Errors
A practical routine for finding the AMPscript line that breaks a send, reproducing it with a known subscriber and writing personalisation that fails gracefully.
Read more
Marketing Cloud SQL Query Activity Errors and How to Fix Them
Duplicate primary keys, truncation, type mismatches, ORDER BY rules and timeouts — what causes them and how to fix each one.
Read more
Designing a Multi-Step Journey Builder Automation
A design-first approach to multi-step journeys in Marketing Cloud Engagement, from entry rules and timing to splits, goals and a worked post-purchase example.
Read more
Marketing Cloud Email Deliverability Audit Checklist
A working checklist for auditing deliverability in Marketing Cloud Engagement, covering authentication, sender configuration, bounce and complaint data, list h…
Read more
Data Extension Design: Primary Keys, Sendable Fields and Retention
How to choose primary keys, configure sendable and testable data extensions, pick field types and set retention so Marketing Cloud data stays reliable as it gr…
Read more
Deduplicating Records in Marketing Cloud SQL with ROW_NUMBER
How to use ROW_NUMBER() in Marketing Cloud SQL to keep exactly one row per subscriber or order, pick the right record to keep and stop primary key errors.
Read more
Using Data Views for Engagement Reporting
How to turn Marketing Cloud system data views into reliable engagement reports, with correct join keys, unique counts, journey attribution and a history that o…
Read more
Journey Builder Decision Splits vs Engagement Splits
Decision splits branch on data, engagement splits branch on how someone reacted to an earlier email. Here is how each one evaluates, and when to use which.
Read more
Building a Preference Center with CloudPages and AMPscript
A step-by-step guide to a custom Marketing Cloud preference centre on CloudPages, from secure subscriber identification to saving choices and handling unsubscr…
Read moreTell us what you are trying to fix.
Share your Salesforce setup, goals and constraints. A practitioner reads every message and replies with questions, first thoughts or an honest view of whether you need outside help at all.
Talk to a Salesforce Expert