What is a Data Extension in Salesforce Marketing Cloud?

A Data Extension is a custom relational data table used to store subscriber and campaign data in SFMC. It supports custom fields, SQL queries, segmentation, and Journey Builder integration.

What is Journey Builder in Salesforce Marketing Cloud?

Journey Builder is an automation tool in SFMC used to create multi-step personalised customer journeys triggered by events, behaviors, or data changes across multiple communication channels.

What is AMPscript in Salesforce Marketing Cloud?

AMPscript is Salesforce Marketing Cloud's scripting language used for dynamic personalisation, conditional logic, data lookups, and real-time content rendering inside emails and landing pages.

What is IP Warming in Salesforce Marketing Cloud?

IP Warming is the gradual process of increasing email send volume from a new dedicated IP address to build sender reputation and improve inbox deliverability with email providers like Gmail and Outlook.

What is the difference between Transactional and Commercial emails in SFMC?

Commercial emails are marketing communications requiring subscriber consent and unsubscribe options, while Transactional emails are service-related communications such as receipts or password resets that can be sent regardless of marketing subscription status.

What is Dynamic Content in Salesforce Marketing Cloud?

Dynamic Content allows SFMC emails to display different content blocks to different subscribers based on rules such as demographics, preferences, or customer segments without creating multiple email versions.

110 Salesforce Marketing Cloud Interview Questions 2026 | SFMC, AMPscript & Journey Builder

Q: What is Salesforce Marketing Cloud?

Salesforce Marketing Cloud is a B2C digital marketing platform used to create personalised customer journeys across email, SMS, social media, push notifications, and advertising channels.

Q: What is the difference between a Contact and a Subscriber in SFMC?

A Contact represents any individual stored in Contact Builder across channels, while a Subscriber specifically refers to someone subscribed to email communications in Email Studio.

Q: What is the difference between Lists and Data Extensions in SFMC?

Lists are legacy subscriber storage with fixed fields and limited scalability, while Data Extensions are flexible relational tables with custom schemas, SQL support, and unlimited scalability.

📅 SFMC

110 Salesforce Marketing Cloud Interview Questions 2026 | SFMC, AMPscript & Journey Builder

🏆 #1 Free SFMC Interview Prep — 2026 Edition

110 Salesforce Marketing Cloud Interview Questions & Answers 2026

The most complete free SFMC interview prep — Email Studio, Journey Builder, AMPscript, SQL, Automation Studio, Data Extensions, MC Connect & real-world scenarios. All levels.

110

Questions

Categories

All Levels

Fresher to Senior

Free

No Paywall

Looking for Salesforce Marketing Cloud interview questions? You have found the most complete free resource — 110 SFMC interview questions covering Email Studio, Journey Builder, AMPscript, Automation Studio, Data Extensions, SQL queries, Mobile Studio, Marketing Cloud Connect, and real-world scenario-based questions. Whether you are a fresher or preparing for a senior SFMC Consultant or Marketing Cloud Developer role, this page covers every topic interviewers actually ask in 2026 — with tables, code examples, real world examples, and a one-line answer for every question.

☁️

SFMC Fundamentals & Architecture

Platform overview, studios, builders, editions, contacts — foundation questions every candidate must know

Q1–Q15

Q1What is Salesforce Marketing Cloud and what are its core components? Easy

☁️Salesforce Marketing Cloud (SFMC) is a B2C digital marketing platform that enables businesses to create personalised, cross-channel customer journeys across email, SMS, social, web, and advertising. Its core components are organised into Studios (execution tools) and Builders (strategy and data tools).

📊 SFMC Core Components

Component	Type	Purpose
Email Studio	Studio	Create, send, and track email campaigns
Mobile Studio	Studio	SMS, MMS, push notifications
Social Studio	Studio	Social media publishing and monitoring
Advertising Studio	Studio	Targeted digital advertising
Journey Builder	Builder	Multi-step customer journey automation
Automation Studio	Builder	Scheduled and triggered data automation
Contact Builder	Builder	Manage contact data and relationships
Analytics Builder	Builder	Reports, dashboards, and data insights
Content Builder	Builder	Centralised content and template creation

Say This in Interview

"SFMC is Salesforce's B2C marketing platform built around Studios for channel execution and Builders for strategy and data — Email Studio sends campaigns, Journey Builder orchestrates multi-step journeys, and Contact Builder manages the unified customer data model that powers all of it."

Q2What is the difference between a Contact and a Subscriber in SFMC? Easy

👤A Contact is any individual stored in SFMC's Contact Builder — they have a Contact Key and can receive messages across any channel. A Subscriber is specifically someone who has opted in to receive email communications and is stored in Email Studio's All Subscribers list with a Subscriber Key.

Feature	Contact	Subscriber
Scope	All channels (email, SMS, push)	Email only
Storage	Contact Builder	All Subscribers list in Email Studio
Identifier	Contact Key	Subscriber Key
Opt-in required	❌ No	✅ Yes — must have email subscription
Counts against billing	✅ Yes — contact-based billing	Part of Contact billing

🎯 Key Points for Interviewer

Subscriber Key and Contact Key should be the same value for consistency — usually CRM ID or email
Contact-based billing means every unique Contact Key counts — duplicate keys = duplicate billing
A Contact becomes a Subscriber when they opt in to email communications

Say This in Interview

"Every Subscriber is a Contact but not every Contact is a Subscriber — Contacts span all channels while Subscribers specifically opted in to email. Using the same value for Contact Key and Subscriber Key is critical to avoid duplicate contacts and inflated billing."

Q3What is a Business Unit in SFMC and when do you use a multi-Business Unit setup? Medium

🏢A Business Unit (BU) is a sub-account within SFMC that has its own set of users, content, data, and sending settings. Multi-BU setup is used when a company has multiple brands, regions, or business divisions that need separate marketing operations but centralised administration and data sharing.

Setup	When to Use	Example
Single BU	One brand, one team	Small company, single product
Multi-BU (Parent + Child)	Multiple brands or regions	Global company — India BU, Europe BU, US BU
Enterprise 2.0	Large enterprise multi-brand	FMCG with 5 product brands

✅ Multi-BU Benefits

✅Data isolation: Each BU's data is separate — India team can't see Europe's subscriber lists
✅Shared assets: Parent BU content and data extensions can be shared to child BUs
✅Centralised admin: Global admin manages from parent; local teams work in their child BU
✅Separate IP pools: Different sending IPs per BU for deliverability management

Say This in Interview

"Business Units separate marketing operations within one SFMC account — each BU has its own users, data, and sending settings. I recommend multi-BU for companies with multiple brands or regions where teams need autonomy but IT needs centralised administration and shared data models."

Q4What is the difference between Lists and Data Extensions for storing subscribers? Medium

📋Lists are simple, flat subscriber storage with fixed fields (Email, First Name, Last Name, Status). Data Extensions are relational database tables with custom columns and data types — they're more flexible, scalable, and the recommended approach for any serious SFMC implementation.

Feature	Lists	Data Extensions
Structure	Fixed fields only	Custom columns and data types
Max records	500,000	Unlimited
SQL queries	❌ No	✅ Yes
Relational data	❌ No	✅ Yes
Journey Builder	Limited support	✅ Full support
Best for	Simple, small campaigns	All modern implementations

Say This in Interview

"Lists are legacy — fixed fields, 500K record cap, no SQL. Data Extensions are relational tables with custom schemas, unlimited records, full SQL support, and required for Journey Builder. I always use Data Extensions for any new implementation and recommend migrating existing Lists to DEs for scalability."

Q5What are the different types of Data Extensions in SFMC? Medium

📊SFMC has three types of Data Extensions: Standard (regular data tables), Filtered (subset of another DE based on filter criteria), and Random (random subset for A/B testing or sampling). Additionally, Sendable DEs are linked to subscriber data for email sends, and Testable DEs support test sends.

Type	Description	Use Case
Standard DE	Custom relational table	Storing any subscriber or campaign data
Filtered DE	Subset based on filter criteria	Segmenting customers by region or product
Random DE	Random sample from source DE	A/B testing, control groups, sampling
Sendable DE	Linked to Contact for email sends	Any DE used as email send audience
Synchronized DE	Synced from Salesforce CRM objects	Using CRM data in SFMC via MC Connect

Say This in Interview

"Standard DEs are the workhorse — custom tables for any data. Filtered DEs are pre-computed segments for frequently used audience slices. Random DEs enable statistically valid A/B testing. Synchronized DEs connect CRM objects like Contacts and Leads directly into SFMC without manual data transfer."

Q6What are Publication Lists and Suppression Lists in SFMC? Medium

📋A Publication List represents a topic or category of communication that subscribers explicitly opt into — like "Monthly Newsletter" or "Product Updates." A Suppression List contains subscribers who should NEVER receive a specific communication — they are excluded from sends regardless of their status on other lists.

List Type	Purpose	Effect on Send
Publication List	Opt-in topic subscription	Only those subscribed receive the email
Suppression List	Exclude specific subscribers	Always excluded — overrides everything
All Subscribers	Master opt-out list	Unsubscribed here = no emails from account

🏭 Real World Example

A pharmaceutical company has Publication Lists for "Doctor Updates" and "Patient Newsletter." The Suppression List contains competitors and journalists who should never receive any commercial communication. When a competitor's email is added to the Suppression List, they're automatically excluded from every future send without changing their subscription status.

Say This in Interview

"Publication Lists manage opt-in preferences by topic — subscribers choose which communications they want. Suppression Lists enforce exclusions that override all other subscription statuses — anyone on a suppression list never receives that communication regardless of their preferences."

Q7What are the three levels of unsubscribe in SFMC? Medium

🚫SFMC has three unsubscribe levels — List level (unsubscribes from a specific publication list), Master level (unsubscribes from all sends within a Business Unit), and Global level (unsubscribes from all BUs in the Enterprise account). Each level is progressively broader and harder to reverse.

Level	Scope	Can Still Receive
List Unsubscribe	One publication list	Emails from other publication lists
Master Unsubscribe	Entire Business Unit	Emails from other Business Units
Global Unsubscribe	Entire Enterprise account	Nothing — complete opt-out

🎯 Key Points for Interviewer

SFMC default unsubscribe link creates a Master-level unsubscribe — not just list level
Contact Deletion is different — it completely removes a contact from SFMC including all history
Global unsubscribes require admin action to override for genuine re-opt-ins

Say This in Interview

"SFMC's three unsubscribe levels are List (one topic), Master (entire BU), and Global (entire Enterprise). The default SFMC unsubscribe link triggers a Master unsubscribe — not just the sending list — which is why custom preference centres are important for businesses that need granular opt-in management."

Q8What is Contact Deletion in SFMC and how does the process work? Advanced

🗑️Contact Deletion permanently removes a contact and all associated data from SFMC — required for GDPR right-to-erasure compliance. It's a three-stage process: Notification (contact flagged for deletion), Suppression (contact cannot receive communications during suppression period), and Final Deletion (complete removal from the system).

🔄 Contact Deletion Process

1
Initiate deletion: Submit contact via Contact Deletion UI or REST API — contact is flagged
2
Suppression period: Default 2 days (was 14 days) — contact suppressed from all sends during this window
3
Final deletion: SFMC permanently removes contact, all associated data, and send history

⚠️ Important Limitations

⚠️Can only be initiated from the Parent Business Unit — not child BUs
⚠️Deletion is irreversible — no recovery after final deletion
⚠️Does NOT delete the contact from Salesforce CRM — SFMC and CRM are separate systems

Say This in Interview

"Contact Deletion fulfils GDPR right-to-erasure by permanently removing a contact through a three-stage process — flag, suppression period, then final deletion. It must be initiated from the Parent BU, is irreversible, and only removes data from SFMC — a separate deletion request must be submitted to Salesforce CRM if required."

Q9What is IP Warming and why is it critical when starting a new SFMC account? Medium

🌡️IP Warming is the process of gradually building the sending reputation of a new IP address by starting with small send volumes and increasing them over 30-45 days. ISPs (Gmail, Outlook etc.) treat new IPs with high send volumes as potential spammers — warming builds trust by demonstrating consistent, low-complaint sending behaviour.

📈 IP Warming Schedule Example

Week	Daily Volume	Focus
Week 1	500 – 1,000	Most engaged subscribers only
Week 2	2,000 – 5,000	Recent openers (last 30 days)
Week 3	10,000 – 25,000	Active subscribers (last 90 days)
Week 4+	Ramp to full volume	Full list, monitor complaint rates

Say This in Interview

"IP Warming builds ISP trust for new sending IPs by gradually increasing volume over 30-45 days — starting with your most engaged subscribers who are least likely to mark you as spam. Skipping warming and sending full volume immediately is the fastest way to get blacklisted and destroy your deliverability permanently."

Q10What is Sender Authentication Package (SAP) in SFMC? Medium

🔐SAP is a premium SFMC add-on that provides dedicated IP addresses, custom domain branding for links and images, and authentication records (SPF, DKIM, DMARC) configured for your domain. Without SAP, emails are sent from shared Salesforce IPs with Salesforce-branded tracking links — with SAP they come from your own domain.

Feature	Without SAP	With SAP
Sending IP	Shared Salesforce IP	Dedicated IP (yours only)
Tracking links	click.salesforce.com	click.yourdomain.com
Image hosting	image.sfmc.email	image.yourdomain.com
Reputation control	❌ Shared with others	✅ Full control
DKIM authentication	Salesforce's DKIM	Your domain's DKIM

Say This in Interview

"SAP gives you a dedicated IP and branded domain for all email links and images — your tracking URLs say click.yourdomain.com instead of click.salesforce.com. For enterprise senders, SAP is essential for deliverability control, brand consistency, and DMARC alignment since shared IPs mean your reputation is affected by other Salesforce customers."

Q11What is the difference between SFMC and Salesforce Pardot (Account Engagement)? Medium

🔄Marketing Cloud is built for B2C — high volume, individual consumer communications with real-time personalisation. Pardot (now Marketing Cloud Account Engagement) is built for B2B — lower volume, longer sales cycles, lead scoring and nurturing aligned with the sales team's pipeline.

Feature	Marketing Cloud (SFMC)	Pardot/MCAE
Target market	B2C	B2B
Database size	Millions of contacts	Thousands of leads
Lead scoring	❌ Not native	✅ Built-in scoring and grading
CRM sync	Via Marketing Cloud Connect	Native real-time sync
Journey complexity	High — multi-channel	Medium — email-focused
Price point	Higher	Lower

Say This in Interview

"SFMC is for B2C at scale — millions of consumers, real-time personalisation, multi-channel journeys. Pardot is for B2B — smaller databases, lead scoring to align marketing with sales, and native CRM sync for pipeline-based nurturing. Choose based on who you're marketing to, not which Salesforce product looks more impressive."

Q12What is a Sender Profile, Delivery Profile, and Send Classification in SFMC? Medium

📧These three components define how emails are sent and branded. Sender Profile defines the From Name and From Email address. Delivery Profile specifies the header, footer, and IP pool for sending. Send Classification combines a Sender Profile and Delivery Profile into a reusable sending configuration.

Component	Defines	Example
Sender Profile	From name and email address	From: "XYZ Company" noreply@xyz.com
Delivery Profile	Header, footer, IP pool	Corporate footer + Dedicated IP pool
Send Classification	Combination of both + unsubscribe type	"Transactional Emails" classification

Say This in Interview

"Sender Profile controls who the email appears to be from, Delivery Profile controls technical sending settings like IP pool and footer, and Send Classification bundles them together into a reusable object — I create separate Send Classifications for marketing emails, transactional emails, and alerts so each category always uses the correct branding and sending infrastructure."

Q13What is SFMC's role-based access model and how are permissions managed? Medium

🔐SFMC uses Roles to control user access. Built-in roles (Administrator, Marketing Cloud Administrator, Content Creator, Data Manager, Viewer) provide preset permissions. Custom roles can be created for granular control. Users are assigned to Business Units with specific roles — they can have different roles in different BUs.

Built-in Role	Access Level
Marketing Cloud Administrator	Full admin — manage users, BUs, settings
Marketing Cloud Viewer	Read-only — view campaigns and reports
Marketing Cloud Channel Manager	Create and send campaigns — no admin access
Marketing Cloud Content Editor	Create content — no send permissions
Marketing Cloud Analyst	Reports and analytics only

Say This in Interview

"SFMC roles are assigned per Business Unit — a user can be a Channel Manager in the India BU but a Viewer in the US BU. I always follow least privilege — content teams get Content Editor, not admin. Custom roles are useful when built-in roles are either too broad or too restrictive for a specific team's responsibilities."

Q14What are the SFMC editions and what are their key differences? Easy

📦SFMC has four main editions: Basic, Pro, Corporate, and Enterprise. Higher editions unlock more channels, advanced features, multiple Business Units, and greater sending volumes. Most enterprise implementations use Corporate or Enterprise.

Edition	Key Features	Best For
Basic	Email only, single BU	Small businesses starting with email marketing
Pro	Email + basic automation	SMB with moderate email needs
Corporate	Multi-channel, Journey Builder, Automation Studio	Mid-market companies with full marketing teams
Enterprise	All features, multi-BU, advanced analytics	Large enterprises with multiple brands/regions

Say This in Interview

"Edition selection should be driven by use case — Basic for email-only small businesses, Corporate for companies needing Journey Builder and multi-channel, Enterprise for organisations with multiple brands, regions, or Business Units requiring centralised administration with local team autonomy."

Q15What is Marketing Cloud Connect and what does it enable? Medium

🔗Marketing Cloud Connect is a managed package installed in Salesforce CRM that creates a native bidirectional integration between SFMC and Salesforce Sales/Service Cloud. It enables Synchronized Data Extensions (CRM data in SFMC), Journey triggers from CRM events, and sending SFMC emails directly from CRM records.

✅ What MC Connect Enables

✅Synchronized DEs: CRM objects (Contacts, Leads, Accounts) automatically sync to SFMC as DEs
✅Journey triggers: CRM events (opportunity stage change, case created) can trigger SFMC journeys
✅Send from CRM: Sales reps can send SFMC email templates from Contact/Lead records
✅Tracking back to CRM: Email engagement data (opens, clicks) flows back to CRM activity records

Say This in Interview

"MC Connect bridges SFMC and Salesforce CRM — CRM data flows into SFMC as Synchronized DEs for targeting, CRM events trigger journeys, and engagement data flows back to CRM so sales reps see email opens and clicks on their prospect records. It's the foundation for any organisation using both platforms."

📧

Email Studio

Content Builder, send methods, deliverability, A/B testing, dynamic content — the heart of SFMC

Q16–Q30

Q16What are the three email sending methods in SFMC Email Studio? Easy

📤SFMC Email Studio has three sending methods: Send Flow (UI-based, flexible audience selection), User-Initiated Send (manual configuration via Send Definition, supports multiple sends to same DE), and Triggered Send (API or automation triggered, real-time single-subscriber email like a welcome or password reset).

Method	Trigger	Audience	Use For
Send Flow	Manual via UI	List, DE, or Report	One-off campaign sends
User-Initiated Send	Manual or scheduled	Data Extension only	Recurring scheduled sends
Triggered Send	API call or automation	Single subscriber	Transactional — welcome, receipt, reset

Say This in Interview

"Send Flow is for ad-hoc campaign sends via the UI, User-Initiated is for recurring scheduled sends via Send Definition, and Triggered Send is for real-time transactional emails fired by API calls — each welcome email, order confirmation, or password reset is typically a Triggered Send."

Q17What is Dynamic Content in SFMC and how does it differ from AMPscript personalisation? Medium

🔄Dynamic Content is a UI-based feature in Content Builder that swaps entire content blocks based on rules — no coding required. AMPscript is a scripting language that allows conditional logic, data lookups, and complex personalisation within email content. Dynamic Content is easier but less flexible; AMPscript handles complex personalisation logic that Dynamic Content can't.

Feature	Dynamic Content	AMPscript
Coding required	❌ UI drag-and-drop	✅ Scripting language
Complexity	Simple rule-based	Complex conditional logic
Data lookup	❌ Limited	✅ Full DE lookup
Nested conditions	❌ No	✅ Yes
Best for	Content block swapping by segment	Complex personalisation, calculations

Say This in Interview

"Dynamic Content swaps entire content blocks via UI rules — great for showing a men's vs women's product banner based on gender. AMPscript handles logic Dynamic Content can't — like calculating a personalised discount percentage from purchase history, looking up real-time inventory data, or building conditional subject lines with nested if-else logic."

Q18What are the content blocks available in Content Builder? Easy

🧩Content Builder provides 8 native content block types that can be dragged and dropped into email templates. Each serves a different purpose — from simple text to complex dynamic personalisation.

Block Type	Purpose
Text	Rich text content with basic formatting
HTML	Raw HTML for custom layouts and styling
Image	Single image with optional link and alt text
Button	CTA button with customisable text and URL
Dynamic Content	Rule-based content block swapping
A/B Test	Content variation testing block
Free Form	Drag-and-drop layout with multiple elements
External Content	Pull content from external URL at send time

Say This in Interview

"Content Builder's block types cover simple to complex needs — Text and Image for standard campaigns, Dynamic Content for segmented personalisation, External Content for pulling live data like RSS feeds or real-time pricing at send time, and HTML for fully custom designs that the drag-and-drop builder can't accommodate."

Q19How does A/B Testing work in SFMC and what can you test? Medium

🔬SFMC A/B Testing sends two or more email variants to a subset of your audience, measures performance (open rate or click rate), and optionally sends the winning version to the remaining audience automatically after a specified time. You can test subject line, From Name, email content, or send time.

✅ What You Can A/B Test in SFMC

✅Subject Line: Most common — test two subject lines to improve open rate
✅From Name: Test company name vs individual person name
✅Email Content: Two completely different email designs or CTAs
✅Send Time: Test whether Tuesday morning or Friday afternoon gets better engagement
✅Preheader: Test different preheader text for inbox preview

Say This in Interview

"SFMC A/B testing splits your audience, sends variants simultaneously, measures open or click rates over a defined period, and can automatically send the winner to the remaining audience. I always test one variable at a time — changing both subject line and content simultaneously makes it impossible to know which change drove the improvement."

Q20What are Transactional vs Commercial emails in SFMC and why does the distinction matter? Medium

📧Commercial emails are marketing communications — promotions, newsletters, product updates. They require explicit opt-in consent and must include an unsubscribe link. Transactional emails are service-related messages triggered by user actions — receipts, confirmations, password resets. They can be sent to unsubscribed users if truly transactional.

Feature	Commercial	Transactional
Requires opt-in	✅ Yes	❌ No — service emails
Unsubscribe link	✅ Mandatory	Optional (legal advice needed)
Send to unsubscribed	❌ No	✅ Yes — if truly transactional
SFMC send type	User-Initiated or Send Flow	Triggered Send Definition
Examples	Newsletter, sale announcement	Order confirmation, password reset

Say This in Interview

"The commercial vs transactional distinction is legally significant — commercial emails require opt-in and unsubscribe links, while transactional emails can reach unsubscribed users for service messages. In SFMC, transactional emails use a Triggered Send Definition with transactional send classification, which bypasses the standard unsubscribe check."

Q21What is Email Deliverability and what factors affect it in SFMC? Medium

📬Email deliverability is the ability of your emails to reach the inbox rather than spam or bouncing. Key factors are sender reputation (IP + domain), authentication (SPF, DKIM, DMARC), list hygiene (bounces, spam complaints), engagement rates, and email content quality.

✅ Deliverability Factors

✅IP Reputation: Shared IPs affected by other senders — dedicated IPs give full control
✅Authentication: SPF, DKIM, DMARC alignment tells ISPs the email is legitimate
✅Bounce management: Hard bounces should be removed immediately — SFMC auto-unsubscribes after repeated soft bounces
✅Spam complaints: Keep complaint rate below 0.1% — above 0.3% triggers ISP throttling
✅Engagement: ISPs like Gmail use open rates and click rates to determine inbox vs spam placement
✅Content: Spam trigger words, image-to-text ratio, broken links all reduce deliverability

Say This in Interview

"Deliverability is driven by reputation, authentication, and engagement — I maintain it by removing hard bounces immediately, suppressing unengaged subscribers older than 12 months, keeping spam complaint rates below 0.1%, and using SAP for dedicated IP and proper DKIM/DMARC authentication aligned to our domain."

Q22What are the different bounce types in SFMC and how are they handled? Medium

⤵️Hard bounces are permanent delivery failures (invalid email address, domain doesn't exist) — SFMC automatically unsubscribes these. Soft bounces are temporary failures (mailbox full, server temporarily unavailable) — SFMC retries and unsubscribes after a configurable threshold of consecutive soft bounces.

Bounce Type	Cause	SFMC Action
Hard Bounce	Invalid address, domain not found	Auto-unsubscribe immediately
Soft Bounce	Mailbox full, server busy, temp issue	Retry, unsubscribe after threshold
Block Bounce	Content filtered, IP blocked	Logged — content or IP issue to investigate
Technical Bounce	DNS or server config issue	Retry — usually resolves automatically

Say This in Interview

"Hard bounces are permanent failures that SFMC auto-unsubscribes immediately — sending to hard bounced addresses damages IP reputation. Soft bounces are temporary and SFMC retries automatically. Block bounces signal a content or IP reputation problem that I investigate via the Email Deliverability report and FBL (Feedback Loop) data."

Q23What are Predefined Folders in SFMC Content Builder and why do they matter? Easy

📁Predefined Folders in Content Builder are default system folders that SFMC uses for specific purposes — Shared, My Content, Content Builder, etc. They control access and sharing across Business Units. Content in shared folders is accessible to child BUs while content in BU-specific folders is local only.

Say This in Interview

"Predefined folders define content sharing scope in multi-BU environments — I place global brand assets and master templates in Shared folders so all child BUs can use them without duplicating content, while BU-specific campaign content stays in local folders to prevent accidental use across the wrong brand or region."

Q24What is Einstein Send Time Optimisation in SFMC and how does it work? Advanced

🤖Einstein Send Time Optimisation (STO) analyses each subscriber's historical email engagement patterns and predicts the optimal time to send them an email for maximum open rate. Instead of sending all subscribers at 9 AM, it staggers delivery over a 24-hour window, sending each subscriber when they're most likely to open.

✅ How STO Works

1
Einstein analyses the subscriber's historical open patterns from the past 90 days
2
Predicts the optimal send time window (e.g., this subscriber opens most at 7-8 PM)
3
Staggers send across 24 hours — each subscriber receives email at their predicted optimal time
4
For new subscribers with no history, uses the population average as baseline

Say This in Interview

"Einstein STO moves from blast-at-9AM to individualised send timing — each subscriber receives the email when their personal engagement history predicts they're most likely to open. It typically improves open rates by 15-25% without changing a word of the email content, purely by optimising delivery timing."

Q25What is an Email Preview and Test Send in SFMC and what are its limitations? Easy

👁️Preview renders the email with a specific subscriber's data so you can see exactly what they'll receive — checking personalisation, dynamic content, and AMPscript output. Test Send delivers the email to a real email address for inbox rendering testing. Preview uses actual DE data; Test Send can use test data attributes.

⚠️ Preview Limitations

⚠️Preview doesn't execute all AMPscript functions identically to actual send — some functions behave differently
⚠️Test Send sends to a specific address but doesn't count as an actual deployment — tracking data is not captured
⚠️Litmus or Email on Acid integrations needed for true cross-client rendering tests

Say This in Interview

"Preview renders personalisation with real subscriber data to verify dynamic content and AMPscript works correctly. Test Send delivers to an actual inbox for rendering verification. I always Preview with 5-10 different subscriber profiles to check edge cases, then Test Send to multiple email clients before any major campaign deployment."

Q26What is Einstein Subject Line Recommendations in SFMC? Medium

🤖Einstein Subject Line Recommendations analyses your organisation's historical email performance and suggests subject line variations that are predicted to achieve higher open rates. It uses NLP to score subject lines for factors like length, word choice, personalisation tokens, and emotional tone based on what's worked for your audience.

Say This in Interview

"Einstein Subject Line Recommendations scores subject line variations based on your organisation's own historical open rate patterns — not generic best practices. It learns what language, tone, and length resonates with YOUR specific audience, making recommendations increasingly accurate as it accumulates more send history."

Q27How do you handle email accessibility in SFMC templates? Medium

♿Email accessibility ensures subscribers using screen readers or visual impairments can understand your emails. Key practices: semantic HTML, descriptive alt text on all images, sufficient colour contrast, large enough font sizes, and a clear logical reading order — even when images are disabled.

✅ Accessibility Checklist

✅Alt text: Every image must have descriptive alt text — not "image.jpg" but "Woman using laptop in cafe"
✅Colour contrast: Minimum 4.5:1 ratio for body text — use WCAG contrast checker
✅Font size: Minimum 14px body, 22px headlines — nothing smaller in mobile
✅Link text: "Click here" is meaningless to screen readers — use "Download the 2026 Product Catalogue"
✅Table structure: Email tables should use role="presentation" so screen readers don't treat them as data tables

Say This in Interview

"Email accessibility is both ethical and practical — screen reader users represent a significant audience and accessible emails also render better when images are blocked. I build accessibility into templates from the start: descriptive alt text, sufficient contrast, semantic link text, and a logical reading order that makes sense without CSS."

Q28What is the difference between Unique Opens and Total Opens in SFMC reporting? Easy

📊Unique Opens counts each subscriber only once regardless of how many times they opened the email. Total Opens counts every open including repeat opens by the same subscriber. Unique Open Rate is the primary performance metric — Total Opens inflates the number and is less meaningful for measuring reach.

Metric	What It Counts	Primary Use
Unique Opens	Each subscriber counted once	Campaign reach measurement
Total Opens	Every open including repeats	Engagement intensity measurement
Unique Open Rate	Unique Opens / Delivered × 100	Primary KPI for email performance

Say This in Interview

"Unique Open Rate tells you what percentage of your audience opened the email at least once — that's your reach metric. Total Opens tells you how engaged they were. If Total Opens is 3x Unique Opens it means highly engaged subscribers are opening multiple times — which is great for engagement scoring but not the primary deliverability benchmark."

Q29How do you implement a Preference Centre in SFMC? Advanced

⚙️A Preference Centre is a CloudPage that allows subscribers to manage their own subscription preferences — choosing which topics they want to receive rather than unsubscribing entirely. It reduces unsubscribes by giving subscribers control. Built using CloudPages, AMPscript for data lookups, and Publication Lists for each topic.

🔄 Preference Centre Implementation Steps

1
Create Publication Lists for each email topic (Newsletter, Promotions, Product Updates, Events)
2
Build a CloudPage with a form showing all available topics as checkboxes
3
Use AMPscript to pre-populate form with subscriber's current subscription status
4
On form submission, update Publication List subscriptions via AMPscript or REST API
5
Replace default SFMC unsubscribe link in email footer with Preference Centre link

Say This in Interview

"A Preference Centre converts subscribers who want to reduce emails into engaged subscribers who choose what they receive — it's the single best tactic for reducing unsubscribe rates. I build it as a CloudPage with AMPscript pre-populating current preferences, updating Publication Lists on submission, and replace the standard footer unsubscribe with the preference centre URL."

Q30What is Litmus/Email on Acid integration in SFMC and why is it used? Medium

🧪Litmus and Email on Acid are third-party email testing platforms that render your email across 90+ email clients, devices, and operating systems simultaneously — showing screenshots of how the email looks in Gmail, Outlook 2016, iOS Mail, Android Gmail, and dozens more. SFMC's native preview only shows one rendering — these tools show all at once.

Say This in Interview

"SFMC's built-in preview shows one client at a time. Litmus and Email on Acid show 90+ client renderings simultaneously — catching issues like Outlook's broken CSS rendering, Gmail clipping long emails, or iOS Dark Mode inverting colours before the campaign deploys to millions of subscribers."

🗺️

Journey Builder

Entry sources, activities, goals, exits, multi-channel journeys — the most tested SFMC topic

Q31–Q45

Q31What are the Journey Builder entry sources and when do you use each? Medium

🚪Journey Builder has 10 entry sources that define how contacts enter a journey. The most common are Data Extension (scheduled or real-time inject), Salesforce Data (CRM record changes), API Event (external system trigger), Cloud Pages Form (form submission), Audience (segment-based), and Inbound Chat.

Entry Source	Trigger	Use Case
Data Extension	Scheduled or manual	Batch welcome series, scheduled campaigns
API Event	REST API call from external system	Real-time triggers from website, app, or CRM
Salesforce Data	CRM record create/update	Opportunity stage change triggers nurture
CloudPages	Form submission	Lead capture form triggers welcome journey
Audience	Segment membership	Segment-based campaign entry
Event	Platform event or data event	Real-time behavioural trigger

Say This in Interview

"Entry source selection depends on what triggers the journey — DE Entry for scheduled batch campaigns, API Event for real-time website or app triggers, Salesforce Data for CRM-based triggers like deal stage changes, and CloudPages for form submissions. The entry source determines the timing model — batch vs real-time."

Q32What is the difference between a Single Send Journey and a Multi-Step Journey? Easy

🔄A Single Send Journey is a simplified Journey Builder configuration for one-time email or SMS sends — it replaces the older Email Studio send flow for simple campaigns. A Multi-Step Journey is the full Journey Builder with multiple activities, waits, decision splits, and channel combinations over time.

Feature	Single Send	Multi-Step
Activities	One message only	Multiple messages + waits + splits
Channels	Email or SMS	Email, SMS, Push, Social, Ads
Decision splits	❌ No	✅ Yes
Setup complexity	Simple	Complex
Best for	Newsletter blast, promo email	Welcome series, nurture, re-engagement

Say This in Interview

"Single Send Journeys replaced Email Studio's Send Flow for simple one-off campaigns — less setup, same result. Multi-Step Journeys are for anything requiring time-based progression, behavioural branching, or multi-channel coordination — like a 5-email welcome series that changes path based on whether the subscriber clicked the product demo link."

Q33What are the Journey Builder activity types and what does each do? Medium

⚡Journey Builder activities are the building blocks of a journey — they define what happens to a contact at each step. Activities include Messages (Email, SMS, Push), Waits, Decision Splits, Customer Updates, Advertising Audiences, and Einstein features.

Activity	Type	What It Does
Email Activity	Message	Send an email from Email Studio
SMS Activity	Message	Send an SMS via Mobile Studio
Wait by Duration	Wait	Pause X days/hours before next step
Wait until Date	Wait	Hold until a specific date/time
Engagement Split	Decision	Branch based on opened/clicked email
Decision Split	Decision	Branch based on contact attribute or data
Random Split	Decision	Randomly split audience by percentage
Update Contact	Action	Update a field in a Data Extension
Sales & Service Cloud Activity	Action	Create CRM record (Lead, Task, Case)
Advertising Activity	Channel	Add/remove from Facebook or Google audience

Say This in Interview

"Journey activities define the what and when — Message activities send communications, Wait activities control timing, Decision Splits personalise the path based on engagement or data, and Action activities connect back to CRM or update subscriber data. Combining these enables sophisticated multi-channel journeys that respond to individual behaviour."

Q34What is a Journey Goal and Exit Criteria and how do they work together? Advanced

🎯A Journey Goal defines what success looks like — when a contact meets the goal condition, they exit the journey early (if configured). Exit Criteria removes contacts from the journey when a condition is met — typically used to stop messaging contacts who have already converted or become ineligible. Both prevent over-messaging.

Feature	Goal	Exit Criteria
Purpose	Measure success + optional early exit	Remove ineligible contacts
Triggered by	DE attribute or event meets condition	DE attribute or event meets condition
Exit on meet	Configurable — on/off	Always exits on condition
Example	Purchase made = goal met, exit nurture	Account closed = exit sales journey

🏭 Real World Example

A pharmaceutical company runs a 6-email doctor nurture journey. Goal: doctor registers for a webinar. Exit Criteria: doctor opts out or is marked inactive in CRM. The Goal stops messaging doctors who already converted; Exit Criteria stops messaging doctors who are no longer eligible, preventing wasted sends and deliverability damage.

Say This in Interview

"Journey Goals measure conversion — when a contact achieves the goal, you can optionally exit them early so they stop receiving nurture messages after converting. Exit Criteria handles ineligibility — customers who churn, unsubscribe, or meet a disqualifying condition are removed regardless of where they are in the journey."

Q35What is a Re-Entry setting in Journey Builder and when would you enable it? Medium

🔁Re-Entry controls whether the same contact can enter the same journey more than once. Options are: No Re-Entry (contact can only go through once), Re-Entry at any time (contact can re-enter immediately after exiting), and Re-Entry after exiting (contact can re-enter once they've completed or exited the journey).

Setting	Behaviour	Use Case
No Re-Entry	Contact enters once only ever	Onboarding — should only happen once
Re-Entry after exit	Can re-enter after completing journey	Seasonal campaigns — Christmas 2025 and 2026
Re-Entry anytime	Can re-enter even while in journey	Transactional — each purchase triggers a new journey

Say This in Interview

"Re-Entry prevents duplicate journey runs for contacts. No Re-Entry for one-time experiences like onboarding — you only get one welcome series. Re-Entry after exit for recurring campaigns like annual renewals. Re-Entry anytime for transactional journeys where each event is independent — every purchase should trigger a new order confirmation journey."

Q36How do you build a Welcome Email Journey with behavioural branching in Journey Builder? Medium

👋A behavioural welcome journey sends an initial welcome email, waits for engagement, then branches based on whether the subscriber opened/clicked — sending a follow-up offer to engaged contacts and a re-engagement nudge to those who didn't open.

🔄 Journey Design

1
Entry Source: DE entry — new subscribers added to Welcome_Subscribers DE trigger entry
2
Email Activity: Send Welcome Email 1 — brand introduction and value proposition
3
Wait 3 days
4
Engagement Split: Did they open or click Email 1?
5
YES path: Send product/service deeper dive email → Wait 5 days → Send offer email
6
NO path: Send re-engagement email with different subject line → Wait 3 days → Update contact field if still no engagement

Say This in Interview

"I build welcome journeys with an Engagement Split after the first email — engaged subscribers (opened or clicked) get a product deep-dive, while non-openers get a re-engagement email with a different angle. This single personalisation typically improves conversion rates by 30-40% vs sending the same sequence to everyone."

Q37What is the difference between Engagement Split and Decision Split in Journey Builder? Medium

🔀Engagement Split branches contacts based on their email or SMS engagement — opened, clicked, or bounced. Decision Split branches based on contact data attributes from a Data Extension — like purchase status, location, or subscription type. Engagement Split is behavioural; Decision Split is demographic or attribute-based.

Split Type	Based On	Example
Engagement Split	Email/SMS interaction	Opened Email 1 → YES path / NO path
Decision Split	Contact attribute/DE field	Country = India → India path / Rest path
Random Split	Random percentage	50% get Offer A, 50% get Offer B

Say This in Interview

"Engagement Splits route contacts based on what they DID — opened, clicked, or ignored an email. Decision Splits route based on who they ARE — their attributes in a DE like customer tier, geography, or product preference. I use both in the same journey — Decision Split at entry for initial segmentation, Engagement Splits throughout for behavioural branching."

Q38What are Journey Templates and how do they speed up implementation? Easy

📋Journey Templates are pre-built journey structures that Salesforce provides for common use cases — Welcome Series, Abandoned Cart, Re-engagement, Birthday, and Post-Purchase. They include pre-configured activities, wait times, and split logic that you customise with your own content and data. They dramatically reduce setup time.

Say This in Interview

"Journey Templates give you a production-ready framework for the most common marketing journeys — I start with the template, customise the wait times and branching logic for the specific business, replace placeholder emails with actual content, and configure the data extensions. What would take 3 hours to build from scratch takes 45 minutes from a template."

Q39How does Journey Builder handle contacts who enter during a version update? Advanced

⚡When you update a live journey, SFMC creates a new version. Contacts already in the journey continue on the original version they entered. New contacts entering after the update start on the new version. This ensures contacts mid-journey aren't disrupted by structural changes.

✅ Journey Versioning Behaviour

✅Version 1 contacts: Continue through Version 1 until they exit — unaffected by Version 2 changes
✅Version 2 contacts: All new entrants after activation of V2 follow the new journey structure
✅Simultaneous versions: Multiple versions can run concurrently — version history visible in Journey Builder
⚠️Stopping old version: You can stop V1 entry but existing contacts must complete or be manually exited

Say This in Interview

"Journey versioning protects in-progress contacts — a subscriber in Week 3 of a welcome series isn't affected when I update the journey for new entrants. Old version contacts complete their journey undisturbed while new contacts get the improved experience. I use this to continuously optimise live journeys without disrupting existing subscribers."

Q40What is an Abandoned Cart Journey and how do you build it in SFMC? Advanced

🛒An Abandoned Cart Journey detects when a customer adds items to a cart but doesn't complete purchase, then sends a timed sequence of reminder emails to encourage completion. It requires a real-time event trigger from the website, cart data passed into a DE, and time-based follow-up with behavioural branching.

🔄 Abandoned Cart Journey Design

1
Entry: API Event fires when cart abandonment detected on website — passes cart data to journey
2
Wait 1 hour — check if purchase was completed (Exit Criteria: Purchase_Complete = true)
3
Email 1: Reminder — "You left something behind" with cart items via AMPscript data lookup
4
Wait 24 hours → Check purchase status again
5
Engagement Split: Clicked Email 1 but didn't buy → Send urgency email. Didn't open → Send different angle email
6
Email 3: Final offer — "10% off if you complete your purchase today"

Say This in Interview

"Abandoned cart journeys are one of the highest-ROI automations in e-commerce — typically recovering 10-15% of abandoned carts. The key is the API Event entry for real-time triggering, Exit Criteria that removes contacts who purchase mid-journey, and personalised cart content using AMPscript to look up exactly what they left behind."

Q41How do you inject contacts into a live running Journey Builder journey? Advanced

💉Use the Journey Builder REST API's /interaction/v1/events endpoint to inject contacts into a running journey in real time. This fires an API Event entry source. Alternatively, use the Data Extension entry source with "Inject from CSV" for batch injections, or Automation Studio to trigger DE-based entry on a schedule.

// REST API — Inject contact into journey via API Event
POST /interaction/v1/events
{
  "ContactKey": "customer_12345",
  "EventDefinitionKey": "APIEvent-abc123",
  "Data": {
    "EmailAddress": "customer@example.com",
    "FirstName": "Riya",
    "OrderId": "ORD-2026-001",
    "OrderAmount": "15000"
  }
}

Say This in Interview

"Real-time journey injection uses the Journey Builder REST API Events endpoint — the external system posts the contact's key and any contextual data like order details, and SFMC immediately places them at the journey entry point. This is how e-commerce platforms trigger post-purchase journeys the moment a transaction completes."

Q42What is a Transactional Journey in Journey Builder and when do you use it? Medium

🔄A Transactional Journey is configured for service-triggered one-to-one communications — order confirmations, shipping updates, appointment reminders. It uses API Event entry, Re-Entry set to anytime (each transaction is independent), and is linked to a Transactional Send Classification to bypass unsubscribe checking for true service messages.

Say This in Interview

"Transactional Journeys are for service emails that must reach every customer regardless of marketing subscription status — order confirmations, shipping alerts, password resets. I set Re-Entry to anytime since each transaction is independent, use a Transactional Send Classification to bypass the unsubscribe check, and keep them separate from marketing journeys for deliverability and compliance clarity."

Q43How do you set up a Re-engagement Journey for inactive subscribers? Advanced

💤A re-engagement journey targets subscribers who haven't opened or clicked any email in 6-12 months. It attempts to win them back with a series of compelling emails — if they engage, they stay active; if not, they're suppressed or removed to protect deliverability. Always better to remove unengaged subscribers than damage sender reputation.

🔄 Re-engagement Journey Design

1
Segment: SQL query to identify subscribers with no opens/clicks in last 180 days into Re_engage_DE
2
Email 1: "We miss you" — highlight what's changed, new content or offers
3
Wait 7 days → Engagement Split
4
Engaged path: Send preference centre link — let them choose what they want to receive
5
Not engaged path: Final email — "Should we keep in touch?" with explicit yes/no buttons
6
No response: Update subscriber status to Unsubscribed in All Subscribers — remove from active list

Say This in Interview

"Re-engagement journeys protect deliverability — unengaged subscribers hurt your sender score even if they don't unsubscribe. I give inactive subscribers 2-3 chances over 3 weeks, then suppress non-responders. A smaller, engaged list delivers better results than a large list full of people ignoring you."

Q44What is Journey Analytics and what key metrics do you monitor? Medium

📊Journey Analytics shows performance data for each step of a journey — contacts processed, emails sent, open rates, click rates, goal achievement rates, and path distribution at splits. Access via the Journey Builder canvas by clicking on any activity or via Analytics Builder for deeper reporting.

Metric	What to Monitor	Action if Low
Email Open Rate	Email 1 open rate (target 20%+)	Test subject line, send time
Click-to-Open Rate	% of openers who click (target 15%+)	Improve CTA and content relevance
Goal Achievement Rate	% reaching journey goal	Review targeting and messaging
Split Distribution	% taking each split path	Unusually skewed? Check split criteria
Journey Exit Rate	% exiting via Exit Criteria	High exit? Segment entering may be wrong

Say This in Interview

"I review Journey Analytics weekly for live campaigns — Email 1 open rate sets the tone for the whole journey, Engagement Split distribution tells me if my segmentation assumptions are correct, and Goal Achievement Rate is the ultimate measure of whether the journey is driving the business outcome it was designed for."

Q45How do you handle multi-channel journeys combining email and SMS in Journey Builder? Advanced

📱Multi-channel journeys add SMS, Push, or Advertising activities alongside email in the same journey canvas. Use channel-preference Decision Splits to route contacts to their preferred channel. Ensure Mobile Studio and MobileConnect are configured before adding SMS activities. SMS requires double opt-in compliance in many regions.

✅ Multi-Channel Journey Best Practices

✅Channel preference check: Decision Split on SMS_Opt_In = true before sending SMS — never SMS to contacts who haven't opted in
✅Complementary not duplicative: Use SMS for urgent/time-sensitive, email for detailed content — don't send the same message on both channels
✅Timing gaps: Don't follow a 9 PM email with a 10 PM SMS — respect time zones and channel fatigue
✅Engagement-based routing: If contact clicked email CTA, skip SMS — they've already engaged

Say This in Interview

"Multi-channel journeys require channel preference checks before every non-email activity — I Decision Split on SMS opt-in before any SMS activity. The channel combination should be complementary: email for rich content and detail, SMS for urgent time-sensitive nudges, push for in-app actions. Never duplicate the same message across all channels simultaneously — that's channel harassment, not personalisation."

🗄️

Data Extensions & AMPscript

SQL queries, AMPscript, data management, retention — the SFMC developer toolkit

Q46–Q68

Q46What are Data Extension field types and which ones are indexed? Medium

📊SFMC Data Extensions support Text, Number, Date, Boolean, Phone, Email, Decimal, and Locale field types. You can mark fields as Primary Key (auto-indexed) or add custom indexes on frequently filtered fields to improve SQL query performance. Indexes should be added on fields used in WHERE clauses of Query Activities.

Field Type	Max Length	Use For
Text	4000 chars	Names, codes, categories
Number	Integer values	IDs, counts, scores
Decimal	Numeric with decimals	Prices, percentages
Date	Date/datetime	Birth dates, transaction dates
Boolean	True/False	Opt-in flags, status flags
EmailAddress	254 chars	Email fields with validation

Say This in Interview

"I always index the Contact Key field and any field used in WHERE clauses of frequent SQL queries — like EmailOptIn, Country, or CustomerTier. Unindexed fields in WHERE clauses cause full table scans that hit the 30-minute query timeout on large DEs."

Q47What is the difference between Lookup, LookupRows, and LookupOrderedRows in AMPscript? Advanced

🔍Lookup retrieves one field value from the first matching row. LookupRows retrieves ALL matching rows as a Rowset (max 2,000). LookupOrderedRows retrieves matching rows sorted by a field (max 2,000). For more than 2,000 rows, pre-process in Automation Studio SQL before the email send.

Function	Returns	Sorted	Max Rows
Lookup()	Single field value	❌ No	1
LookupRows()	Full Rowset	❌ No	2,000
LookupOrderedRows()	Sorted Rowset	✅ Yes	2,000

Say This in Interview

"Lookup for single value lookups, LookupRows when I need multiple records to iterate over, LookupOrderedRows when I need the top N records sorted — like the 3 most recent orders by date. Beyond 2,000 rows I pre-build the data in a Query Activity so AMPscript only fetches what it needs."

Q48What is AMPscript and where can you use it in SFMC? Easy

📝AMPscript is SFMC's proprietary server-side scripting language for personalising email and landing page content at render time. Code blocks are enclosed in %%[ ... ]%% and variables output with %%=v(@var)=%%. Works in Email content, Subject Lines, CloudPages, and SMS messages.

Say This in Interview

"AMPscript executes at the moment each email renders for each individual subscriber — enabling truly dynamic content like personalised product recommendations, real-time data lookups from multiple DEs, conditional content blocks, and calculated values, all resolved at send time per subscriber."

Q49How do you iterate over a Rowset to display multiple records in an email? Advanced

🔄Use LookupRows to get a Rowset, check RowCount() to handle empty cases, then use FOR/NEXT with Row() and Field() to access each record. Always check RowCount before iterating to prevent errors on subscribers with no matching records.

📧 AMPscript Example

%%[ SET @items = LookupRows('Cart_DE','ContactKey',_subscriberkey) SET @count = RowCount(@items) IF @count > 0 THEN FOR @i = 1 TO @count DO SET @row = Row(@items,@i) SET @product = Field(@row,'ProductName') ]%% %%=v(@product)=%% %%[ NEXT @i ENDIF ]%%

Say This in Interview

"FOR/NEXT with Row() and Field() iterates a Rowset — I always check RowCount first so the email renders gracefully for subscribers with no cart items, showing a fallback bestseller section instead of an empty block."

Q50What is IIF() in AMPscript and when do you use it? Easy

⚡IIF(condition, value_if_true, value_if_false) is AMPscript's inline ternary operator. Use it for simple one-condition personalisation directly in HTML — like checking if a name is empty or selecting gender-specific text. For complex multi-condition logic, use IF/THEN/ELSEIF/ENDIF blocks.

Say This in Interview

"IIF is my go-to for inline conditionals — Dear %%=IIF(Empty(@firstName),'Valued Customer',ProperCase(@firstName))=%% handles null names in one line. For anything needing more than two outcomes I switch to IF/THEN/ELSEIF for readability."

Q51What are Data Retention Policies and why are they critical for GDPR? Medium

⏰Data Retention Policies automatically delete DE records after a specified period — days, weeks, or months after creation or last modification. They enforce GDPR's data minimisation and storage limitation principles, preventing DEs from accumulating years of stale subscriber data that should have been deleted.

Say This in Interview

"Without retention policies, DEs grow indefinitely — I've seen orgs with 5-year-old records violating GDPR's storage limitation requirement. I set 90 days on transactional DEs, 365 days on engagement DEs, and have no retention only on the Contact Master DE which requires an explicit deletion process per subscriber request."

Q52How do you write SQL in SFMC Automation Studio and what are the key syntax rules? Advanced

💻SFMC uses T-SQL (Microsoft SQL Server syntax). Key rules: use GETDATE() for current date/time, Ent. prefix to query Parent BU DEs from a child BU, SELECT INTO an existing target DE (no CREATE TABLE), 30-minute timeout per query, and no stored procedures or dynamic SQL.

SFMC SQL Rule	Detail
Date function	GETDATE() not NOW() or SYSDATE()
Parent BU access	Ent.DE_Name prefix
Write results	SELECT INTO existing DE only
Timeout	30 minutes — optimise or split queries
No dynamic SQL	No EXEC() or sp_executesql

Say This in Interview

"SFMC SQL is T-SQL with key restrictions — GETDATE() for dates, Ent. prefix for parent BU queries, SELECT INTO an existing target DE rather than creating tables, and 30-minute timeout. Complex queries exceeding the timeout need breaking into sequential steps in Automation Studio."

Q53What are Synchronized Data Extensions and how do they differ from manual DEs? Medium

🔄Synchronized Data Extensions are automatically populated from Salesforce CRM objects via Marketing Cloud Connect — Contact, Lead, Account, Opportunity, or any custom object. They're read-only in SFMC and refresh near-real-time or hourly. Manual DEs are fully configurable and writable.

Say This in Interview

"Synchronized DEs are live mirrors of CRM objects — I use them to trigger journeys from CRM events without building custom integrations. They're read-only so I JOIN them with writable DEs in SQL to enrich data before targeting."

Q54What is InsertDE vs UpsertDE in AMPscript? Medium

💾InsertDE adds a new row — fails if the primary key already exists. UpsertDE inserts if the key doesn't exist, or updates the existing row if it does. Always use UpsertDE for form handling to avoid duplicate records when the same subscriber submits multiple times.

Say This in Interview

"UpsertDE is the safe choice for any form submission — it handles both new and returning subscribers in one call. I only use InsertDE for pure event logs where each submission must create a distinct record, like tracking every individual page view."

Q55What is RaiseError() in AMPscript and when should you use it? Advanced

🚨RaiseError() stops personalisation processing for a subscriber when critical data is missing. RaiseError('message', true) skips just that subscriber and continues the send. RaiseError('message', false) fails the entire send. Use it to prevent sending broken emails to subscribers missing required personalisation data.

Say This in Interview

"RaiseError with true as the second parameter is my safety valve — if a subscriber is missing critical order data in a receipt email, it skips that subscriber and logs the error rather than sending a blank or broken email. I use false only when I want to stop the entire send, like if a global template lookup fails for everyone."

Q56What is ContentBlockByKey in AMPscript and why use it? Medium

🧩ContentBlockByKey('customer_key') dynamically injects a Content Builder content block into an email at render time using a stable customer key. It's better than ContentBlockByID since IDs can change after imports. Use it for dynamic footers, regional content, and legal disclaimers that vary by subscriber attribute.

Say This in Interview

"ContentBlockByKey lets me select which content block to inject based on subscriber data — IIF(@country=='India','footer-india','footer-global') picks the right regional footer for each subscriber at send time without building separate emails per region."

Q57What is the difference between AMPscript and SSJS (Server-Side JavaScript)? Advanced

⚡AMPscript is SFMC's native language optimised for email personalisation — fast, fully supported in emails. SSJS is JavaScript running server-side on CloudPages — more powerful for web app logic and REST API calls but NOT recommended inside emails due to slower rendering and support limitations.

Feature	AMPscript	SSJS
Use in email	✅ Recommended	⚠️ Avoid
REST API calls	❌ No	✅ Yes
Best for	Email personalisation	CloudPage web apps

Say This in Interview

"AMPscript for emails, SSJS for CloudPages — never mix SSJS into email content. When I need REST API calls in an Automation Studio workflow I use a Script Activity with SSJS; inside an email I stick to AMPscript exclusively."

Q58How do you handle null/empty values gracefully in AMPscript? Medium

🛡️Use Empty() to check if a variable is null or blank before using it in output. Use IsNull() for explicit null checks. Always provide a fallback value — an email saying "Dear !" destroys trust. For critical missing data, use RaiseError() to skip the subscriber entirely.

Say This in Interview

"I null-check every personalisation field — SET @greeting = IIF(Empty(@firstName),'Valued Customer',ProperCase(@firstName)). This one pattern prevents the most embarrassing email personalisation failures. For order data, if the total is null I RaiseError to skip rather than send a ₹0 receipt."

Q59What is a Verification Activity in Automation Studio and why is it critical? Advanced

✅Verification Activity checks if a Data Extension meets a condition (usually row count > 0) before allowing the automation to proceed. If the condition fails, the automation stops — preventing email sends to empty audiences caused by upstream data pipeline failures.

🏭 Real World Example

A nightly campaign automation refreshes the audience via SQL, then sends an email. Without Verification, if the SQL returns 0 rows due to a data issue, the send fires with an empty audience. With Verification checking rows > 0, the automation halts and alerts the admin instead of sending to nobody.

Say This in Interview

"Verification Activity is the safety gate I add after every SQL Query step — it stops the automation and alerts admins when the segment is unexpectedly empty, preventing wasted sends and catching data pipeline failures before they become marketing incidents."

Q60What is the Enhanced FTP in SFMC and how is it used? Easy

📁Enhanced FTP (eFTP) is SFMC's built-in SFTP server for file exchange. External systems deposit data files here for Import Activity to load into DEs. Data Extract Activity exports DE data here for external systems to retrieve. Access via SFTP client with SFMC credentials.

Say This in Interview

"Enhanced FTP is the staging area between SFMC and external systems — inbound data files land here for Import Activity, outbound extracts are placed here by Data Extract Activity. I always run a weekly housekeeping automation deleting files older than 30 days to prevent storage accumulation."

⚙️

Automation Studio

Scheduled automations, activity types, workflow design — the data processing backbone of SFMC

Q61–Q72

Q61What is Automation Studio and how does it differ from Journey Builder? Medium

⚙️Automation Studio is SFMC's workflow engine for data processing and batch operations — SQL queries, data imports, file transfers. Journey Builder is for individual customer communication journeys based on behaviour. Automation Studio processes DATA; Journey Builder communicates with PEOPLE.

Feature	Automation Studio	Journey Builder
Purpose	Data processing and preparation	Customer communication
Triggered by	Schedule or file arrival	Contact behaviour or event
Audience level	Batch — all records	Individual — per contact

Say This in Interview

"Automation Studio prepares the data Journey Builder consumes — it runs the nightly SQL to refresh audience DEs, imports CRM exports from SFTP, and builds suppression lists. They're complementary: AS for data engineering, JB for customer engagement."

Q62What are the Automation Studio starting sources and when do you use each? Medium

▶️Schedule trigger runs at a fixed recurring time — hourly, daily, weekly. File Drop trigger fires when a file matching a pattern arrives on the SFMC Enhanced FTP. Use Schedule for time-predictable operations; File Drop for event-driven processing where external systems control the timing.

Say This in Interview

"Schedule for predictable nightly jobs, File Drop for integrations where the external system controls timing. File Drop means SFMC processes immediately when the CRM exports its data rather than waiting for a scheduled time window — reducing data latency in the pipeline."

Q63How do you build a birthday email automation in SFMC? Medium

🎂Birthday campaigns require a daily SQL Query that selects subscribers where MONTH(BirthDate) and DAY(BirthDate) match today. The query populates a Birthday_Today_DE, a Verification activity checks it's not empty, then an Email Send activity deploys the campaign to that day's birthday subscribers.

Say This in Interview

"Birthday automation is a classic daily SQL pattern — WHERE MONTH(BirthDate) = MONTH(GETDATE()) AND DAY(BirthDate) = DAY(GETDATE()). This runs at 6 AM, Verification confirms there are recipients, then the send fires at 8 AM. Every subscriber gets their birthday email on their actual birthday."

Q64What is a Data Extract Activity in Automation Studio? Medium

📤Data Extract Activity exports DE data, Tracking data (email engagement), or List data to a CSV/TXT file on SFMC's Enhanced FTP. Use it to send engagement data back to CRM, share results with BI tools, or archive data before DE retention deletion.

Say This in Interview

"I use Tracking Extract nightly to export click and open data from SFMC back to the CRM — sales reps then see email engagement on prospect records. The extract creates a timestamped CSV on eFTP, then File Transfer Activity pushes it to the external system's SFTP."

Q65What are SFMC's system data views and what data do they contain? Advanced

📊SFMC system data views are read-only tables that store email engagement tracking data. Key data views: _Open (opens), _Click (clicks), _Bounce (bounces), _Unsubscribe (opt-outs), _Subscribers (subscriber list), _Job (send jobs). Query them in SQL with underscore prefix to build engagement reports and scoring.

Data View	Contains	Retention
_Open	Email open events with timestamps	6 months
_Click	Link click events with URL	6 months
_Bounce	Bounce events with type and reason	6 months
_Unsubscribe	Unsubscribe events	6 months
_Job	Email send job metadata	6 months
_Subscribers	All subscriber records	Current

Say This in Interview

"System data views are the analytics backbone of SFMC — I query _Open and _Click in SQL to build engagement scoring, use _Bounce to identify and suppress high-bounce subscribers, and JOIN _Job with _Click to calculate click rates per campaign. They're only available in SQL queries, not the standard report builder."

Q66How do you build subscriber engagement scoring using SFMC data views? Advanced

📊Query _Open, _Click, and _Bounce data views to calculate recency, frequency, and engagement type scores per subscriber. Store results in an Engagement_Score_DE. Use Automation Studio to refresh scores weekly, then use the score for suppression decisions, segment prioritisation, and re-engagement targeting.

Say This in Interview

"Engagement scoring from data views: CASE WHEN MAX(OpenDate) >= DATEADD(day,-30,GETDATE()) THEN 40 ELSE 0 END for recency, COUNT(DISTINCT JobID) for frequency. Weekly SQL refresh keeps scores current. Scores below 20 go to suppression, 20-60 get re-engagement journeys, 80+ get VIP treatment."

Q67What is a Script Activity and what can it do in Automation Studio? Advanced

💻Script Activity runs SSJS or AMPscript within an Automation Studio workflow — enabling REST API calls, complex data transformations, and webhook notifications to external systems. Use only when native activities don't suffice — debugging complexity and 30-minute timeout make it a last resort.

Say This in Interview

"Script Activity unlocks REST API calls from Automation Studio — I use it to notify an external system via webhook when SFMC data processing completes, or to call a microservice for complex calculations that SQL can't handle. I use it sparingly because SSJS in Automation is harder to debug than AMPscript in emails."

Q68How do you monitor Automation Studio errors and set up notifications? Medium

🔔Monitor via Automation Studio's Activity Log showing each run's status, duration, and error details. Configure email notifications at the automation level for Error, Success, or Skipped status. Always enable Error notifications on production automations — a silent failure means next morning's campaign uses stale data.

Say This in Interview

"Every production automation gets Error notifications to the admin email — no exceptions. The Activity Log tells me exactly which step failed and why. Common causes are SQL timeouts on large DEs, SFTP connection failures when the external server changes credentials, and DE lock conflicts when two automations try to write to the same DE simultaneously."

🔗

Marketing Cloud Connect, Mobile Studio & CloudPages

CRM integration, SMS, push notifications, CloudPages — the multi-channel toolkit

Q69–Q82

Q69What is Marketing Cloud Connect and what does it enable? Medium

🔗Marketing Cloud Connect is a managed package that integrates SFMC with Salesforce CRM — enabling Synchronized Data Extensions (CRM data in SFMC), Journey triggers from CRM events, email sending from CRM records, and engagement data flowing back to CRM activity records.

Say This in Interview

"MC Connect is the bridge between SFMC and CRM — CRM events trigger journeys, CRM data populates Synchronized DEs for targeting, and email opens and clicks flow back to CRM so sales reps see engagement on their prospect records without opening SFMC."

Q70What issues occur after a Salesforce sandbox refresh affecting MC Connect? Advanced

⚠️Sandbox refresh changes the CRM org ID — MC Connect's configuration still points to the old org ID, breaking the integration. The integration user's credentials may also reset. You must reconfigure MC Connect in the refreshed sandbox and re-validate Synchronized DEs.

🎯 Key Points for Interviewer

Sandbox refresh = org ID change = MC Connect reconfiguration required
Never connect a sandbox CRM to Production SFMC — corrupts production data
Keep dedicated integration user credentials documented securely

Say This in Interview

"I budget 2-3 hours after every sandbox refresh for MC Connect reconfiguration — it's a known breaking change. The critical rule: always pair sandbox CRM with sandbox SFMC, never sandbox CRM with Production SFMC. That mistake would inject test data into your production contact database."

Q71What is Mobile Studio and what channels does it support? Easy

📱Mobile Studio supports SMS/MMS messaging via MobileConnect, Push Notifications for iOS/Android apps via MobilePush, and Group Messaging for in-app chat. All channels integrate natively with Journey Builder for multi-channel journeys combining email, SMS, and push in the same automation.

Say This in Interview

"Mobile Studio covers all mobile touchpoints — MobileConnect for SMS/MMS, MobilePush for app notifications. In Journey Builder I combine email for rich content with SMS for urgent nudges for non-openers and push for app-engaged users, creating a coordinated multi-channel experience without building separate campaigns."

Q72What is SMS double opt-in and why is it required? Medium

📱SMS double opt-in requires subscribers to confirm their subscription by replying YES to a confirmation message after initial opt-in. It's legally required in many countries (TCPA in USA, GDPR in EU) and protects against people being texted without genuine consent. Configure in MobileConnect using keyword-based opt-in flows.

Say This in Interview

"SMS double opt-in is legally required in most markets and practically important for deliverability — single opt-in leads to spam complaints that get your short code blacklisted. I always configure STOP, HELP, and CANCEL keywords in MobileConnect as legally mandatory opt-out mechanisms alongside the double opt-in confirmation flow."

Q73What is CloudPages and what are its primary use cases? Medium

🌐CloudPages hosts landing pages, microsites, and forms on Salesforce-managed URLs. Pages use AMPscript for dynamic content and SSJS for complex logic. Primary uses: preference centres, lead capture forms, event registration, campaign microsites, and post-click personalised landing pages linked from emails.

Say This in Interview

"CloudPages is where email marketing meets web — I build preference centres that pre-populate with subscriber data via AMPscript, registration forms that write to DEs and inject contacts into journeys, and post-click landing pages personalised with the same data the email used. No external web server required."

Q74What is Distributed Marketing and how does it benefit sales teams? Advanced

📢Distributed Marketing allows sales reps to send marketing-approved email templates directly from Salesforce CRM records without accessing SFMC. Marketing locks brand elements while defining editable zones where reps add personal context. Maintains brand consistency at scale while personalising outreach.

Say This in Interview

"Distributed Marketing solves the brand vs personalisation tension — marketing owns the locked template and compliance sections, sales reps add their personal relationship context in designated editable zones and send from CRM. It scales personalised outreach without creating an uncontrolled shadow email library."

🎯

Advanced Scenario-Based Questions

Real-world scenarios asked in senior and consultant SFMC interviews

Q75–Q92

Q75Your SFMC campaign has a sudden 40% drop in open rates. How do you diagnose it? Advanced

🔍A sudden 40% open rate drop is a deliverability alarm first. Diagnose systematically — check IP reputation and bounce rates, then spam placement, then audience change, then Apple MPP impact, then subject line regression.

🔍 Diagnostic Steps

1
Check deliverability report — did bounce rate or spam complaint rate spike?
2
Check IP reputation via MX Toolbox — are you blacklisted?
3
Verify SPF/DKIM/DMARC records unchanged in DNS
4
Compare this send's audience vs previous high-performing sends — same segment?
5
Check Apple MPP impact — if iOS subscriber % increased, previous opens may have been inflated

Say This in Interview

"Sudden open rate drop is deliverability first — I check the deliverability report for bounce spikes and complaint rate, then IP blacklist status via MX Toolbox. If delivery is normal but opens dropped, I check whether Apple MPP was artificially inflating previous metrics and whether the audience segment changed."

Q76How do you build a GDPR-compliant SFMC implementation? Advanced

🔐GDPR compliance in SFMC requires five key implementations: explicit consent capture and storage, preference centre for granular opt-in, data retention policies for storage limitation, Contact Deletion process for right-to-erasure, and audit logging of all consent changes.

GDPR Requirement	SFMC Implementation
Consent capture	Consent_DE with timestamp, source, and channel per subscriber
Right to access	CloudPage showing subscriber's stored data via AMPscript
Right to erasure	Contact Deletion API with documented workflow
Storage limitation	Data Retention Policies on all DEs
Preference management	Preference Centre replacing default unsubscribe

Say This in Interview

"GDPR compliance is architecture, not a setting — I design it in from the start: Consent DE with full audit trail, Preference Centre for granular opt-in, Data Retention Policies on every DE, documented Contact Deletion workflow, and never storing data beyond its purpose. Bolting compliance on afterwards is expensive and incomplete."

Q77How do you design a SFMC data model for a company with 5 million customers? Advanced

🏗️Design a hub-and-spoke model in Contact Builder — a central Contact Master DE as the hub, with attribute groups of related DEs as spokes, all connected via a consistent Contact Key (CRM ID, not email). SQL queries create campaign DEs by joining source DEs without modifying master data.

Say This in Interview

"Hub-and-spoke: Contact Master DE holds one row per customer, Purchase History DE, Preference DE, and Engagement DE are spokes linked via CRM ID as Contact Key. Campaign targeting uses SQL to join and filter across spokes into a campaign DE — the master data is never touched by targeting queries."

Q78A Journey Builder journey is not sending emails to some contacts. How do you troubleshoot? Advanced

🔍Journey sending failures have multiple causes — contact not entering, early Exit Criteria exit, All Subscribers unsubscribed status, email send error, or wrong split path. Diagnose using Journey History for the specific contact — it shows every step taken or skipped.

🔍 Troubleshooting Order

1
Journey History: Did the contact enter the journey at all?
2
Exit Criteria: Did contact meet a condition and exit before the email step?
3
All Subscribers: Is the contact Unsubscribed? Unsubscribed contacts skip email activities
4
Decision Split: Did contact take a path that doesn't include the email activity?
5
Email activity error log: Any send validation failures?

Say This in Interview

"Journey History is the forensic tool — it shows every step a contact took or skipped. 90% of journey email failures are: contact unsubscribed in All Subscribers, Exit Criteria fired early, or a Decision Split routing them to a path without the email. Journey History points directly to which of these occurred."

Q79How do you handle time zone management for global email campaigns? Advanced

🌍Store subscriber time zone in the subscriber DE. Use Einstein Send Time Optimisation for individual-level send timing, or SQL segmentation to split audiences by time zone and schedule separate sends at local optimal time per region. Never blast a global list at one fixed time.

Say This in Interview

"Sending to a global list at 9 AM means half your audience gets it at 2 AM. I use Einstein STO for individual timing when available, otherwise SQL splits the audience by TimeZone field and Automation Studio schedules regional sends — India at 2 PM IST, Europe at 10 AM CET, USA at 9 AM EST."

Q80How do you measure ROI of email campaigns in SFMC? Medium

💰Email ROI requires connecting engagement to revenue — UTM parameters on all CTAs tracked in web analytics, CRM opportunity links via MC Connect, Journey Goal conversion rates with monetary values, or unique promo codes tracked through purchase. Open rate alone is a vanity metric.

Say This in Interview

"Open rate is a vanity metric — real ROI means connecting clicks to purchases. UTM parameters on every CTA link track through to Google Analytics revenue. For B2B, MC Connect links email clicks to CRM opportunity pipeline showing marketing's contribution. Journey Goals with monetary values give journey-level ROI directly in SFMC."

Q81What is Apple Mail Privacy Protection and how has it affected email marketing? Advanced

🍎Apple MPP (iOS 15, September 2021) pre-loads email tracking pixels, recording an "open" even when the subscriber hasn't actually read the email. This inflated open rates by 20-40% for many marketers sending to iOS Mail users. Open rate is now unreliable for iOS subscribers — shift primary KPIs to click rate and revenue.

Say This in Interview

"MPP broke open rate as a metric for iOS users — pixels fire automatically regardless of whether the email was read. I've shifted to click rate as the primary engagement KPI and use click inactivity (not open inactivity) for re-engagement suppression to avoid incorrectly suppressing active iOS subscribers."

Q82How do you perform a SFMC org audit for a company that has had SFMC for 3+ years? Advanced

🔍A SFMC org audit covers six areas: Deliverability health (IP reputation, complaint rates), Data quality (duplicates, Contact Key consistency), Automation health (broken automations, error rates), Security (inactive users, over-permissioned roles), Compliance (GDPR, consent records, retention policies), and Performance (large DEs, slow queries).

Say This in Interview

"I start with deliverability — it's the highest-impact risk. Then data quality since Contact Key inconsistency compounds over time. Then automations for reliability, security for compliance, and performance for scale. A 3-year SFMC org has technical debt in all six areas — the audit prioritises by business risk, not technical elegance."

📊

Reporting, Analytics & SFMC Certifications

Analytics Builder, Einstein, certifications, career questions — round out your SFMC knowledge

Q83–Q95

Q83What is Analytics Builder in SFMC and what reports does it provide? Medium

📊Analytics Builder is SFMC's reporting tool providing standard campaign performance reports (Email Performance, Link and Click, Deliverability) and customisable reports via Reports feature. It also includes Datorama (Marketing Cloud Intelligence) integration for advanced cross-channel analytics and executive dashboards.

Report Type	Shows
Email Performance	Sends, Deliveries, Opens, Clicks, Bounces, Unsubscribes
Link and Click	Click rate per link in an email
Deliverability	Delivery rate, bounce breakdown, ISP performance
Account Send Summary	Aggregate metrics across all sends

Say This in Interview

"Analytics Builder provides campaign-level reporting — I use Email Performance for KPI tracking, Deliverability report for inbox health monitoring, and Link and Click to identify which CTAs drive engagement. For executive cross-channel reporting combining email, SMS, and social, Datorama/MC Intelligence provides the unified view."

Q84What is Einstein in SFMC and what features does it include? Medium

🤖Einstein in SFMC is a suite of AI features: Send Time Optimisation (optimal individual send timing), Subject Line Recommendations (AI-scored subject line suggestions), Engagement Scoring (predicts likelihood to engage), Content Tagging (auto-tags Content Builder assets), and Messaging Insights (anomaly detection for campaign performance).

Einstein Feature	What It Does
Send Time Optimisation	Stagger sends to individual optimal time
Subject Line Recommendations	Score and suggest subject line improvements
Engagement Scoring	Predict subscriber likelihood to engage
Messaging Insights	Alert on campaign anomalies

Say This in Interview

"Einstein STO and Subject Line Recommendations are the highest-ROI Einstein features — STO typically improves open rates 15-25% purely through timing optimisation, and Subject Line Recommendations learns from your own organisation's data, not generic benchmarks. I combine both for major campaigns to maximise open rate before optimising click rate."

Q85What are the SFMC certifications and which should you pursue first? Easy

🏆SFMC has four certifications: MC Email Specialist (email campaigns and deliverability), MC Administrator (platform management), MC Consultant (solution design and implementation), and MC Developer (AMPscript, SSJS, REST API). Email Specialist is the most common entry point; Consultant is most valued for consulting roles.

Certification	Best For	Difficulty
MC Email Specialist	Email marketers, analysts	Medium
MC Administrator	Platform admins	Medium
MC Consultant	Solution consultants, architects	Hard
MC Developer	Technical developers	Hard

Say This in Interview

"Start with MC Email Specialist — it validates the daily-use skills most SFMC roles require and opens doors for mid-market roles. MC Consultant is the most valued certification for consulting and architecture roles because it tests end-to-end implementation design, not just feature knowledge."

Q86What are the most common SFMC implementation mistakes? Advanced

⚠️The most costly SFMC implementation mistakes are using email as Contact Key (creates duplicates when email changes), skipping IP warming (destroys deliverability), not building a preference centre (single unsubscribe kills all subscriptions), flat DE design instead of relational model, and no data retention policies.

Say This in Interview

"The mistakes that kill SFMC implementations are foundational — wrong Contact Key strategy creates compounding duplicates, skipping IP warming gets you blacklisted before the first real campaign, and no preference centre means every unsubscribe is a master unsubscribe. Get these three right and you have a solid foundation."

Q87What is the SFMC REST API and what are its primary endpoints? Advanced

🔌SFMC REST API uses OAuth 2.0 client credentials flow. Key endpoints: /interaction/v1/events (inject Journey contacts), /data/v1/async/dataextensions/{key}/rows (DE row operations), /messaging/v1/email/messages (Triggered Send), /contacts/v1/contacts (Contact management), /push/v1/message (push notifications).

Say This in Interview

"The /interaction/v1/events endpoint is the most used — it fires real-time journey entry from any external system. I authenticate with a tenant-specific REST URL, never the generic base URL, and always use the tenant subdomain returned from the OAuth token response for subsequent API calls."

Q88What is Marketing Cloud Engagement vs Marketing Cloud Growth? Advanced

📦Marketing Cloud Engagement (traditional SFMC) is a separate instance from CRM — enterprise-grade, supports AMPscript, complex data models, multi-BU. Marketing Cloud Growth/Advanced is built natively on the Salesforce Platform (same org as CRM) — simpler, lower cost, no AMPscript, designed for SMB without separate integration complexity.

Say This in Interview

"MC Growth/Advanced is for SMB who want marketing automation without SFMC's complexity — same org as CRM, no data sync to build, simpler configuration. MC Engagement remains the right choice for enterprise scale, AMPscript personalisation, and multi-BU requirements. Recommend based on company size and complexity, not prestige."

Q89How do you set up a re-engagement journey for inactive subscribers? Advanced

💤SQL Query selects subscribers with no opens or clicks in 180 days into a Re_Engage_DE. Journey Builder welcome series: Email 1 "We miss you", Wait 7 days, Engagement Split — engaged path leads to Preference Centre, non-engaged path gets a final "Should we keep in touch?" email with yes/no links. Non-responders get suppressed.

Say This in Interview

"Re-engagement journeys protect deliverability — unengaged subscribers hurt sender score even without unsubscribing. I give inactive subscribers 2-3 chances over 3 weeks, then suppress non-responders. A smaller engaged list performs better than a large list full of people ignoring every email."

Q90What is Sender Authentication Package (SAP) and when is it essential? Medium

🔐SAP provides dedicated IP addresses, custom domain branding for tracking links (click.yourdomain.com instead of click.salesforce.com), and properly configured SPF/DKIM/DMARC for your domain. Essential for enterprise senders needing deliverability control, brand consistency, and DMARC alignment.

Say This in Interview

"SAP is essential for enterprises — shared IPs mean your deliverability is affected by other Salesforce customers' behaviour. Dedicated IP plus your own sending domain gives full reputation control and proper DMARC alignment. Without SAP, your tracking links advertise Salesforce to every recipient which also reduces brand trust."

Q91What is the SFMC-Data Cloud connector and what does it enable? Advanced

🤖The SFMC-Data Cloud connector enables Data Cloud segments (built from unified customer profiles across all data sources) to be used as Journey Builder entry sources and email audiences in SFMC. Brings real-time unified customer intelligence — web behaviour, loyalty, purchase history — directly into SFMC campaign execution.

Say This in Interview

"The Data Cloud-SFMC connector transforms SFMC into an AI-powered platform — Data Cloud provides unified intelligence from every customer touchpoint, SFMC delivers the communication. A journey can fire when Data Cloud's churn prediction crosses a threshold using real-time signals from five systems that SFMC alone never had access to."

Q92How do you implement personalised product recommendations in SFMC emails? Advanced

🛒Pre-compute recommendations outside SFMC (external engine or Einstein Recommendations), push results to a Product_Recs_DE per subscriber via API or nightly import, then use LookupOrderedRows in email AMPscript to fetch top 3 recommendations at render time with a bestseller fallback for subscribers with no history.

Say This in Interview

"Product recommendations at scale require pre-computation — doing it inside AMPscript at send time hits performance limits for millions of subscribers. I pre-build the recs DE nightly, use LookupOrderedRows to fetch the top 3 by rank at render time, and IIF fallback to bestsellers for cold-start subscribers with no purchase history."

🚀

Expert-Level & Architect Questions

Advanced architecture, integrations, and career questions for senior SFMC roles

Q93–Q110

Q93How do you design SFMC architecture for a global enterprise with 30+ countries? Advanced

🌍Enterprise 2.0 with Parent BU as global hub and Country BUs as spokes. Parent holds global templates, suppression lists, and governance standards. Country BUs have their own local teams, IP pools, sender domains, and campaign autonomy. EU data stays in EU BUs for GDPR data residency compliance.

Say This in Interview

"Global architecture is driven by three constraints — data residency (EU data in EU BUs), deliverability (regional IPs for regional ISPs), and governance (global brand standards via Shared assets with local execution autonomy). Parent BU enforces global compliance; Country BUs deliver local relevance."

Q94What is the Marketing Cloud SOAP API and when do you use it over REST? Advanced

🔌SFMC's SOAP API handles operations unavailable in REST — managing Triggered Send Definitions, querying tracking data programmatically, managing subscriber attributes on Lists, and some user/BU management. REST is preferred for new integrations; SOAP remains necessary for legacy operations not yet migrated to REST endpoints.

Say This in Interview

"REST first for all new integrations — it's simpler, better documented, and Salesforce is expanding REST coverage. SOAP is still needed for Triggered Send Definition management and programmatic tracking data retrieval that REST doesn't yet support. Most modern SFMC implementations use 80% REST, 20% SOAP for the legacy gaps."

Q95What is Advertising Studio and how does it enable cross-channel retargeting? Medium

📢Advertising Studio syncs SFMC subscriber data with Facebook Custom Audiences, Google Customer Match, Twitter, and LinkedIn. Journey Builder's Advertising Activity adds or removes contacts from ad audiences at specific journey steps — enabling coordinated email + paid social campaigns where email non-openers see the same campaign message as a social ad.

Say This in Interview

"Advertising Studio closes the loop between email and paid media — when a subscriber doesn't open the email after 3 days, the Journey's Advertising Activity adds them to a Facebook Custom Audience showing the same message as an ad. Consistent cross-channel presence without the subscriber knowing they're being reached on multiple platforms."

Q96What is the difference between a transactional and a commercial email and why does it matter? Medium

📧Commercial emails are marketing communications requiring explicit opt-in and mandatory unsubscribe links. Transactional emails are service messages triggered by user actions (receipts, confirmations, password resets) — can be sent to unsubscribed users as they're necessary service communications, not marketing.

Say This in Interview

"The commercial vs transactional distinction is legally significant — transactional emails can reach unsubscribed users under CAN-SPAM and GDPR because they're service communications. In SFMC I configure transactional emails with a Transactional Send Classification bypassing the unsubscribe check, but only for genuinely transactional content."

Q97How do you test personalisation and dynamic content before a large send? Medium

🧪Preview the email using 10-15 different subscriber profiles covering edge cases — subscribers with no purchase history, null name fields, maximum and minimum values for numeric fields, different countries, and different customer tiers. Test Send to real inboxes. Validate AMPscript in Developer Preview mode before deploy.

Say This in Interview

"I preview with edge cases, not just the perfect subscriber — someone with no purchase history, a null first name, the subscriber with 200 items in their cart. AMPscript behaves differently in Preview than in actual send for some functions, so I always do a Test Send to real addresses on the primary email clients before any campaign over 10,000 subscribers."

Q98What is Social Studio in SFMC and what are its core capabilities? Easy

📱Social Studio is SFMC's social media management tool — publishing, scheduling, and monitoring social media across Facebook, Twitter, LinkedIn, Instagram, and YouTube. It enables social listening (brand mentions, sentiment analysis), content publishing, community management, and social analytics. Note: Salesforce announced Social Studio sunset in 2024.

Say This in Interview

"Social Studio covers social publishing, listening, and engagement management within SFMC. Worth noting that Salesforce announced Social Studio end-of-life in late 2024 — many organisations are migrating to third-party social tools like Sprout Social or Hootsuite. For new implementations I'd evaluate whether native Social Studio or a dedicated social platform better serves the use case."

Q99How do you implement a lead nurture journey in SFMC using Salesforce Data entry? Advanced

🌱Configure Salesforce Data entry source monitoring the Lead object for new records or specific criteria (Lead Source = Web Form). Journey sends an educational email series over 4-6 weeks. Decision Splits check Lead Status updates in the Synchronized DE — when Lead Status changes to MQL, exit nurture and create a Salesforce Task for the sales rep.

Say This in Interview

"Lead nurture journeys combine Salesforce Data entry for CRM-triggered start, educational email sequence with engagement-based branching, Decision Splits checking Synchronized DE for Lead Status changes, and Sales & Service Cloud Activity to create a CRM task when the lead reaches MQL. The journey hands off to sales automatically at the right moment."

Q100What is AMP for Email and does SFMC support it? Advanced

⚡AMP for Email enables interactive, dynamic content within emails — carousels, forms, live data updates without leaving the inbox. SFMC supports sending AMP emails alongside HTML versions. Limited ISP support (Gmail, Yahoo) and implementation complexity have limited widespread adoption despite the engaging subscriber experience it creates.

Say This in Interview

"AMP for Email enables in-email interactivity — product carousels, in-email forms, live inventory status — but only renders in Gmail and a handful of clients. SFMC supports it but requires sending three versions (AMP, HTML, plaintext). I'd recommend it only for Gmail-heavy audiences like tech or B2B where the interactive experience meaningfully improves conversion."

Q101What is Contact Builder and why is it important for the SFMC data model? Medium

🏗️Contact Builder is SFMC's master data management layer — it defines how Data Extensions relate to each other and to the Contact record via Contact Key. Creates a unified customer view by linking purchase history, preferences, and engagement data to a single identity, enabling cross-source personalisation in journeys and emails.

Say This in Interview

"Contact Builder is the data model layer that makes SFMC more than a list of email addresses — it links all DEs through Contact Key into a unified customer profile. Without Contact Builder relationships defined, Journey Builder can't use data from multiple DEs for decision splits and personalisation."

Q102What is the difference between Unique Opens and Total Opens? Easy

📊Unique Opens counts each subscriber once regardless of how many times they opened. Total Opens counts every open including multiple opens by the same subscriber. Unique Open Rate is the primary performance metric — Total Opens indicates engagement intensity but inflates the raw number.

Say This in Interview

"Unique Open Rate is reach — what percentage of your audience opened at least once. Total Opens is engagement intensity — if Total is 3x Unique, your subscribers are highly engaged and opening multiple times. I report Unique Open Rate to stakeholders as the headline metric and use Total Opens only for engagement scoring models."

Q103How do you handle duplicate contacts in SFMC? Advanced

👥Prevent duplicates with a consistent Contact Key strategy using CRM ID rather than email address. Detect existing duplicates using SQL to find matching emails with different Contact Keys. Resolve with the Contact Merge REST API. Regular monthly dedup queries catch new duplicates before they compound.

Say This in Interview

"Duplicates are SFMC's most expensive problem — they inflate billing, cause double-sends, and corrupt engagement data. Prevention is the CRM ID Contact Key strategy. Detection is a monthly SQL identifying email addresses with multiple Contact Keys. Resolution is Contact Merge API. Once you fix the root cause, duplicates stop forming."

Q104What is IP Warming and why does skipping it destroy deliverability? Medium

🌡️IP Warming gradually builds sending reputation for a new IP by starting with small, highly-engaged audiences and increasing volume over 30-45 days. ISPs treat new IPs sending high volumes as potential spammers — warming builds trust through consistent low-complaint behaviour before scaling to full volume.

Say This in Interview

"Skipping IP warming and sending full volume day one is the fastest way to get blacklisted — ISPs have no trust history for the new IP and route it to spam. I start warming with the top 10% most engaged subscribers, double volume each week while monitoring complaint rates, and never add less-engaged segments until the IP has proven itself."

Q105What is a Preference Centre and why is it better than the default unsubscribe? Medium

⚙️A Preference Centre lets subscribers manage which types of emails they receive rather than unsubscribing entirely. The default SFMC unsubscribe creates a Master-level unsubscribe — removing them from all communications. A Preference Centre built on CloudPages with Publication Lists gives subscribers control, dramatically reducing unsubscribe rates.

Say This in Interview

"The default unsubscribe link is an all-or-nothing sledgehammer — a subscriber who wants fewer promotional emails clicks it and stops receiving everything including receipts. A Preference Centre converts that moment into a preference adjustment — they unsubscribe from promotions but stay subscribed to product updates. Typically reduces unsubscribe rate by 40-60%."

Q106How do you approach SFMC implementation for a new client from scratch? Advanced

📋Start with discovery (business goals, audience size, channels needed, existing data), then design (Contact Key strategy, data model, BU structure), then foundation (SAP setup, IP warming plan, authentication), then build (templates, journeys, automations), then UAT, then go-live with IP warming schedule.

📋 Implementation Phases

1
Discovery: Business goals, volume, channels, data sources, compliance requirements
2
Foundation design: Contact Key strategy, data model in Contact Builder, BU structure, SAP setup
3
Authentication: SPF, DKIM, DMARC configured, IP warming plan
4
Data migration: Historical subscriber import, deduplication, Contact Key standardisation
5
Build: Templates, preference centre, automations, journeys
6
UAT and go-live: Test with real subscriber profiles, IP warming schedule

Say This in Interview

"The decisions made in the first two phases determine success or failure — Contact Key strategy and data model mistakes compound over years. I spend disproportionate time on discovery and design, getting client sign-off on the data architecture before writing a single line of AMPscript."

Q107What is email accessibility and how do you implement it in SFMC templates? Medium

♿Email accessibility ensures subscribers using screen readers or visual impairments can understand your emails. Key practices: descriptive alt text on all images, sufficient colour contrast (4.5:1 minimum), minimum 14px font size, meaningful link text (not "click here"), and table role="presentation" so screen readers don't treat layout tables as data.

Say This in Interview

"Accessible emails benefit everyone — they render better with images blocked, work for screen reader users, and score better in spam filters. I build accessibility into templates from the start: descriptive alt text, meaningful link text, sufficient contrast, and testing with images disabled to ensure the email communicates its message without any visuals."

Q108What is the difference between a Single Send Journey and a traditional Email Studio send? Easy

📧Single Send Journeys are the modern replacement for Email Studio's Send Flow — they provide a simpler Journey Builder interface for one-off campaign sends. They offer the same reporting as Journey Builder, support Einstein features like STO, and are the Salesforce-recommended path for all new campaign sends.

Say This in Interview

"Single Send Journeys replaced Send Flow for one-off campaigns — same simplicity but with Journey Builder's reporting, Einstein STO support, and goal tracking. For new implementations I use only Single Send or Multi-Step Journeys, never the legacy Email Studio Send Flow which Salesforce is de-emphasising."

Q109How do you use AMPscript to dynamically select email content based on subscriber segment? Advanced

🔄Use IF/THEN/ELSEIF to branch content based on subscriber attributes from the sending DE or a Lookup, combined with ContentBlockByKey to pull different pre-built content blocks per segment. This enables one email send to deliver completely different content to Gold, Silver, and Basic tier subscribers.

Say This in Interview

"Dynamic segment content: lookup the subscriber's tier, use IF/ELSEIF to set a @blockKey variable, then ContentBlockByKey(@blockKey) injects the correct pre-built content block. Gold members see the VIP offer, Silver members see the standard offer, Basic members see the introductory offer — all from one send with one email asset."

Q110What are the key differences between SFMC and other marketing automation platforms like HubSpot or Marketo? Advanced

⚡SFMC excels in volume, personalisation depth, and multi-channel capabilities for B2C at scale. HubSpot is simpler and better for SMB with built-in CRM. Marketo (Adobe) is strong for B2B lead management with deep CRM integration. SFMC's AMPscript and Data Extensions enable personalisation depth HubSpot can't match, but at significantly higher cost and complexity.

Platform	Strength	Best For
SFMC (Engagement)	Volume, personalisation, multi-channel	Enterprise B2C, 500K+ contacts
HubSpot Marketing Hub	Simplicity, built-in CRM, SMB pricing	SMB and mid-market
Marketo (Adobe)	B2B lead management, deep CRM sync	Enterprise B2B, complex lead scoring
MC Growth/Advanced	Native Salesforce, simple setup	Salesforce SMB customers

Say This in Interview

"Platform selection should follow use case — SFMC for enterprise B2C needing AMPscript-level personalisation and multi-BU, HubSpot for SMB wanting marketing automation without enterprise complexity, Marketo for B2B with deep lead scoring needs. I've seen companies spend millions on SFMC for 50,000 contacts when HubSpot at 5% the cost would have served them perfectly."

110 Salesforce Marketing Cloud Interview Questions 2026 | SFMC, AMPscript & Journey Builder

110 Salesforce Marketing Cloud Interview Questions & Answers 2026

🎯 Complete Your Salesforce Interview Prep — All Free!