Updated for Winter '26
Marketing Cloud Intelligence AP Exam Tips (Winter '26): How to Pass
The MCI AP exam validates your ability to implement Salesforce Marketing Cloud Intelligence for unified marketing analytics. These tips focus on data stream connections, harmonisation, and dashboard building that define this accreditation.
Written and reviewed by Krishna Mohan — ADM-201, PD1, PD2, App Builder & Consultant certified. Updated for Winter '26. Methodology · Contact
Exam At a Glance
40
Questions
60 min
Time Limit
Pass / Fail
Passing Score
$150
Exam Fee
Quick Answer: What MCI AP Tests
- Data streams and connections — Configuring TotalConnect data streams from marketing platforms (Google Ads, Facebook/Meta Ads, SFMC, Salesforce CRM, LinkedIn), setting up API and file-based connectors, scheduling automated data pulls, validating data stream health, and troubleshooting failed connections and missing data.
- Data harmonisation and modelling — Mapping source fields to MCI dimensions and metrics, creating custom dimensions (campaign taxonomy fields), calculated metrics (ROAS = Revenue / Ad Spend), cross-channel currency normalisation, and the MCI data model (Workspaces, Data Streams, Dimensions, Metrics, Custom KPIs).
- Dashboard design and KPIs — Building executive marketing dashboards with widgets (bar charts, scorecards, trend lines), configuring custom KPI alerts and goals, using Einstein Insights for AI-powered anomaly detection and recommendations, sharing dashboards via links and scheduled email reports, and managing user access and workspace permissions.
Highest-Weight Exam Sections
AP format: 40 questions, 60 minutes, Pass/Fail, $150. Data connections + harmonisation = 55% — getting clean, unified data into MCI is the core implementation challenge.
Scenario Strategy: How to Approach MCI AP Questions
Questions describe a marketing analytics scenario and ask which MCI feature, configuration, or approach addresses it. Marketing analytics domain knowledge (how ad platforms work, what KPIs matter) helps interpret scenarios accurately.
- For data stream questions: when a data stream shows missing data, check: (1) the connection credentials are valid, (2) the API permissions include the required data, (3) the date range of the data pull covers the expected period, (4) the field mappings are correctly configured. When a stream shows 'No Data' after a connection change, the most common cause is a permission scope issue on the connected account credentials.
- For harmonisation questions: cross-channel metrics require mapping each source's field name to one MCI metric. If Facebook uses 'Link Clicks' and Google uses 'Clicks' for the same concept, map both to a single 'Clicks' metric in MCI. Calculated metrics combine metrics with formulas: CTR = Clicks / Impressions × 100. ROAS = Revenue / Cost. When a scenario says 'create a single clicks metric across all ad platforms', configure a harmonised metric mapping — not separate widgets for each platform.
- For KPI alert questions: Einstein Insights automatically detects anomalies in your metrics (a sudden drop in CTR, an unusual spike in cost). KPI Goals set target values for tracking progress. When a scenario says 'alert the marketing team when ROAS drops below 3x', configure a KPI Goal with an alert threshold — not a scheduled report or custom Flow.
AP Exam Benchmark
Pass 3 timed 40-question mocks before booking (Pass/Fail scoring)
MCI AP is for marketing analytics specialists and BI professionals implementing unified marketing measurement. Hands-on experience connecting real ad platforms and building dashboards is essential. Request a Marketing Cloud Intelligence trial through your Salesforce partner relationship for sandbox practice.
3 Concepts That Fail Most Marketing Cloud Intelligence Candidates
These are not the hardest topics — they are the ones where candidates are most confidently wrong. Learn the distinction early.
1. Streams vs Workspaces — Data Ingestion vs Analysis
Streams are the data connectors that ingest raw marketing performance data from ad platforms, email tools, and CRMs into Marketing Cloud Intelligence. Workspaces are the analysis environments where data is combined, visualised, and reported. Candidates try to configure analytics in the Stream setup — Streams are only for ingestion; all analysis happens in Workspaces.
2. Harmonised vs Raw Data — Why Metrics Don't Match Source Platforms
Marketing Cloud Intelligence harmonises metrics from disparate platforms into a common schema (e.g., mapping "clicks" from Google Ads, Meta Ads, and Marketing Cloud into one unified "Clicks" metric). Raw data from each platform may use different field names and definitions. Candidates expect raw platform numbers to appear unchanged — the exam expects understanding of the harmonisation layer and why numbers may differ slightly from native platform reports.
3. Calculated Metrics vs Standard Metrics — Custom Formulas for Cross-Channel KPIs
Standard metrics are ingested directly from source platforms (impressions, clicks, cost). Calculated metrics are custom formulas built in Intelligence (CPC = Cost / Clicks, ROAS = Revenue / Cost). Candidates try to pull ROAS and blended CPM directly from data streams — these cross-platform KPIs require Calculated Metric configuration in the workspace.
Frequently Asked Questions
- What is the Marketing Cloud Intelligence Accredited Professional exam format?
- The Marketing Cloud Intelligence AP (formerly Datorama) exam has 40 multiple-choice questions, a 60-minute time limit, a Pass/Fail result, and a $150 fee. It validates practitioner-level knowledge of Salesforce Marketing Cloud Intelligence: connecting marketing data streams, data harmonisation and mapping, building custom KPIs, and creating executive marketing dashboards.
- What are the highest-weight MCI AP exam sections?
- Data Streams and Connections (30%) and Data Harmonisation and Modelling (25%) together account for 55% of the exam. Connecting data sources (Google Ads, Facebook, SFMC, Salesforce CRM) via TotalConnect, mapping fields to the MCI data model, creating custom dimensions and metrics, and building the unified marketing data model are the most tested areas.
- What is TotalConnect and why is it important for the MCI AP exam?
- TotalConnect is MCI's data integration layer that connects to hundreds of marketing platforms and ad channels. It has native connectors (Google Analytics, Facebook Ads, Salesforce CRM, Marketing Cloud), custom API connectors, and file upload connectors (CSV, FTP). The exam tests how to configure data stream connections, set up scheduling for automated data pulls, and troubleshoot connection failures.
- What is data harmonisation in Marketing Cloud Intelligence?
- Data harmonisation maps incoming data fields from different sources to a unified MCI data model. For example, Facebook calls it "Impressions" and Google calls it "Impr." — harmonisation maps both to a single "Impressions" metric in MCI. The exam tests how to configure field mappings, create custom dimensions and metrics, set up cross-channel calculated metrics, and handle data conflicts when sources use different definitions.
- What concepts do most Marketing Cloud Intelligence candidates get wrong?
- The most commonly misunderstood topics for the Marketing Cloud Intelligence exam are: (1) Streams vs Workspaces — Data Ingestion vs Analysis; (2) Harmonised vs Raw Data — Why Metrics Don't Match Source Platforms; (3) Calculated Metrics vs Standard Metrics — Custom Formulas for Cross-Channel KPIs. Candidates are most confidently wrong on these — learn the distinctions early to avoid losing marks on questions you expect to get right.
- Why do most Marketing Cloud Intelligence Ap candidates fail questions about Streams vs Workspaces?
- Streams are the data connectors that ingest raw marketing performance data from ad platforms, email tools, and CRMs into Marketing Cloud Intelligence. Workspaces are the analysis environments where data is combined, visualised, and reported. Candidates try to configure analytics in the Stream setup — Streams are only for ingestion; all analysis happens in Workspaces.
- Why do most Marketing Cloud Intelligence Ap candidates fail questions about Harmonised vs Raw Data?
- Marketing Cloud Intelligence harmonises metrics from disparate platforms into a common schema (e.g., mapping "clicks" from Google Ads, Meta Ads, and Marketing Cloud into one unified "Clicks" metric). Raw data from each platform may use different field names and definitions. Candidates expect raw platform numbers to appear unchanged — the exam expects understanding of the harmonisation layer and...
- Why do most Marketing Cloud Intelligence Ap candidates fail questions about Calculated Metrics vs Standard Metrics?
- Standard metrics are ingested directly from source platforms (impressions, clicks, cost). Calculated metrics are custom formulas built in Intelligence (CPC = Cost / Clicks, ROAS = Revenue / Cost). Candidates try to pull ROAS and blended CPM directly from data streams — these cross-platform KPIs require Calculated Metric configuration in the workspace.
Related Exam Tips
Start MCI AP Prep
After this exam, consider Sales Cloud Consultant or Service Cloud Consultant next.