Historical learning notes and practice questions. See the issuer notice above for credential status and current learning options.
Independent study resource
Exam objectives and policies can change. Confirm current details with the certification issuer.
Check current objectives
Use the official exam guide as the source for current objectives and section weights.
Practice for learning
Use sample questions to review concepts and identify topics for further study.
Works on Any Device
Full practice experience on phone, tablet, or desktop
Free, No Sign-Up
Start practicing immediately, no account or email required
Salesforce Certified Marketing Cloud Intelligence Accredited Professional – Complete 2026 Guide
Historical learning notes for Salesforce Certified Marketing Cloud Intelligence Accredited Professional. See the issuer notice above for credential status and current learning options.
Recommended Prerequisites
We recommend completing this certification first to prepare you better.
Current exam registration and delivery are unavailable. See the issuer notice above for current learning options.
Exam Topics
Last updated:
Who may use this historical learning reference?
- Marketing analytics professionals: You report on campaign and media performance and want to prove you can set up Marketing Cloud Intelligence well.
- Data-driven marketing consultants: You help clients pull marketing data from many platforms into one place.
- BI specialists moving into marketing analytics: You know dashboards and data models and want to apply them to marketing data.
Official references: Use the issuer’s current materials to confirm exam objectives, format, and fees before booking.
Official sources: Salesforce exam pricing·Independent exam-prep resource; details may change.
Marketing Cloud Intelligence: Key Concepts
Intelligence Platform Architecture
Marketing Cloud Intelligence brings marketing data from many sources, such as ad platforms, web analytics, email and CRM, into one place for reporting. Data is organised in workspaces, which can hold different brands or clients. Inside, a shared data model gives every source the same structure, with dimensions (things you describe, like campaign, channel or date) and measurements (things you count, like spend, clicks or conversions). Once data fits the model, it can be compared across channels in one dashboard.
Data Streams and Harmonisation
Each source comes in through a data stream, using a built-in connector or a file upload. During setup you map each source field to a dimension or measurement in the model. Harmonisation makes data from different sources line up. For example, if Google Ads and Meta use different campaign names, you can use a shared key or naming pattern so both link to the same campaign. Classification rules can create new dimensions from patterns in names, such as reading the product line from a campaign name.
Insights, KPIs, and Custom Metrics
Beyond raw data, teams need numbers like cost per acquisition or return on ad spend. Calculated measurements are formulas built from other measurements. Calculated dimensions group or relabel values. Aggregation matters: spend and clicks can be added up, but rates like click-through rate must be recalculated from their parts, not summed. Getting aggregation wrong is a common reason totals look strange. Insights features can flag unusual changes in key numbers.
Dashboards and Data Visualisation
Dashboards are made of pages and widgets, such as charts, tables and single-number tiles. Filters let users narrow by date, channel or campaign. Good dashboards start with the question the viewer needs answered and show only what helps answer it. Share dashboards with the right users, and schedule them to be emailed if people need regular updates. Pivot-style tables help analysts explore data before deciding what goes on a dashboard.
API Integration and Automation
Data streams can run on a schedule, so dashboards stay current without manual uploads. When a built-in connector doesn't exist, data can be sent through files or APIs. Marketing Cloud Intelligence data can also be shared with other tools, such as Salesforce or a data warehouse. Monitor data stream runs and set alerts so failed loads are noticed quickly, since a missed load leaves gaps in reports.
Salesforce Certified Marketing Cloud Intelligence Accredited Professional Practice Questions (With Explanations)
Test your knowledge with these 15 sample questions.
Question 1: The same campaign appears as 'Spring_Sale_US' in Google Ads and 'US Spring Sale' in Meta. The team wants one combined row. What should be done?
Key takeaway: Harmonisation links data from different sources to the same campaign, so it can be combined.
Show correct answer and explanation
Correct answer: A. Harmonise the sources with a shared campaign key or naming pattern
Harmonisation links data from different sources to the same campaign, so it can be combined.
- Manual renaming is slow and breaks easily.
- Separate reports don't give the combined view.
- Deleting a stream loses data.
Question 2: A dashboard shows click-through rate summed across campaigns, giving 340%. What is wrong?
Key takeaway: Rates must be calculated from their parts after adding up clicks and impressions, not summed directly.
Show correct answer and explanation
Correct answer: B. The rate is being summed instead of recalculated from clicks and impressions
Rates must be calculated from their parts after adding up clicks and impressions, not summed directly.
- Widget count doesn't affect the maths.
- Late data wouldn't create a rate over 100%.
- Date filters don't cause summed rates.
Question 3: When setting up a new data stream, what must be done with each source field?
Key takeaway: Mapping puts each field in the right place in the shared model, so it can be used and compared.
Show correct answer and explanation
Correct answer: A. Map it to a dimension or measurement
Mapping puts each field in the right place in the shared model, so it can be used and compared.
- Unmapped fields can't be used in reports.
- Data must be mapped before it can be shown.
- Source names don't need changing.
Question 4: Which of these is a measurement rather than a dimension?
Key takeaway: Measurements are numbers you add up or calculate, like spend.
Show correct answer and explanation
Correct answer: A. Spend
Measurements are numbers you add up or calculate, like spend. Dimensions describe the data, like campaign or channel.
- Campaign name is a dimension.
- Country is a dimension.
- Channel is a dimension.
Question 5: The team needs cost per acquisition for each channel. What should they create?
Key takeaway: Calculated measurements build KPIs from existing measurements.
Show correct answer and explanation
Correct answer: B. A calculated measurement of spend divided by conversions
Calculated measurements build KPIs from existing measurements.
- A new stream brings in data, it doesn't calculate KPIs.
- Filters narrow data, they don't create measures.
- A workspace organises data, it doesn't calculate.
Question 6: Campaign names follow a pattern like 'BRAND_PRODUCT_COUNTRY'. The team wants a Product dimension. What should they use?
Key takeaway: Rules can read values from naming patterns and create new dimensions automatically.
Show correct answer and explanation
Correct answer: D. A classification rule that extracts the product from the name
Rules can read values from naming patterns and create new dimensions automatically.
- Adding fields everywhere is slow and needs every platform to change.
- A workspace doesn't create dimensions.
- A filter can't create a dimension.
Question 7: Dashboards are out of date because someone forgot to upload last week's file. What should be changed?
Key takeaway: Scheduled data streams keep data current without relying on manual uploads.
Show correct answer and explanation
Correct answer: C. Schedule the data stream to run automatically
Scheduled data streams keep data current without relying on manual uploads.
- Widgets don't load data.
- Less often makes it worse.
- Deleting the dashboard doesn't fix the data.
Question 8: An agency manages marketing data for three separate clients who must not see each other's data. How should this be organised?
Key takeaway: Workspaces keep each client's data and setup separate.
Show correct answer and explanation
Correct answer: D. Separate workspaces for each client
Workspaces keep each client's data and setup separate.
- Widgets don't separate access.
- A filter doesn't stop people seeing other clients' data.
- One stream mixes all the data.
Question 9: A data stream failed overnight and nobody noticed for a week. What should be set up?
Key takeaway: Alerts on failed runs let the team fix problems before reports are affected.
Show correct answer and explanation
Correct answer: D. Monitoring and alerts on the runs
Alerts on failed runs let the team fix problems before reports are affected.
- A KPI doesn't monitor loads.
- Filters don't detect failures.
- Dashboard size doesn't detect failures.
Question 10: A dashboard viewer only wants to see last month's results for the email channel. What should they use?
Key takeaway: Filters let users narrow the dashboard without changing the data or building new pages.
Show correct answer and explanation
Correct answer: C. Filters for date and channel
Filters let users narrow the dashboard without changing the data or building new pages.
- A new stream isn't needed to view existing data.
- A calculated measurement creates a new number, it doesn't narrow data.
- A workspace is far more than needed.
Question 11: A connector doesn't exist for a small ad platform the client uses. How can its data be brought in?
Key takeaway: File and API-based streams can bring in data from sources without a built-in connector.
Show correct answer and explanation
Correct answer: B. Through a file upload or API data stream
File and API-based streams can bring in data from sources without a built-in connector.
- Widgets display data.
- Data can still be brought in another way.
- Dashboards display data, they don't store it.
Question 12: What is the main reason to bring all marketing data into one data model?
Key takeaway: A shared model makes data from different sources comparable in one place.
Show correct answer and explanation
Correct answer: A. So results can be compared across channels and platforms
A shared model makes data from different sources comparable in one place.
- The aim is consistency, not difference.
- Speed isn't the reason.
- Keeping data separate defeats the purpose.
Question 13: Total conversions look doubled after adding a second data stream that also reports conversions. What is the likely cause?
Key takeaway: When two sources report the same events, adding them together double-counts.
Show correct answer and explanation
Correct answer: C. The same conversions are counted in both sources and need de-duplicating
When two sources report the same events, adding them together double-counts. Decide which source to trust or de-duplicate.
- Workspace size isn't a factor.
- Page count doesn't double numbers.
- A filter wouldn't double the total.
Question 14: Leaders want an automatic heads-up when cost per click jumps unexpectedly. What helps?
Key takeaway: Insights and alerts flag unusual changes so the team can act quickly.
Show correct answer and explanation
Correct answer: C. Automated insights or alerts on that KPI
Insights and alerts flag unusual changes so the team can act quickly.
- Removing the KPI hides the problem.
- More streams don't spot changes.
- Quarterly checks are too slow.
Question 15: What should a well-designed dashboard start from?
Key takeaway: Good dashboards are built around the decisions viewers need to make.
Show correct answer and explanation
Correct answer: B. The question the viewer must answer
Good dashboards are built around the decisions viewers need to make.
- Colours come after content.
- Too many widgets make dashboards hard to read.
- Data size doesn't decide what to show.
Salesforce Certified Marketing Cloud Intelligence Accredited Professional Exam FAQs
- What is covered on the Salesforce Certified Marketing Cloud Intelligence Accredited Professional exam?
- This page shows the section-wise exam weightage so you know exactly which topics carry the most weight. Use the exam topics and practice questions above to align your study with the official outline.
- What is Marketing Cloud Intelligence Accredited Professional?
- Marketing Cloud Intelligence AP validates skills in Marketing Cloud Intelligence (formerly Datorama), including data models, insights, Ad Studio, and marketing analytics.
- What experience do I need for Marketing Cloud Intelligence AP?
- You need Marketing Cloud experience and understanding of marketing analytics. Experience with Marketing Cloud Intelligence platform is essential.
- Are there free practice questions for the Salesforce Certified Marketing Cloud Intelligence Accredited Professional exam?
- Yes. This page includes free sample practice questions with explanations. Use them alongside the current official documentation.
- How do I prepare for the Salesforce Certified Marketing Cloud Intelligence Accredited Professional certification?
- Use the exam tips, prerequisites, and study strategy on this page. Focus first on the highest-weighted sections, then take the sample practice questions. Schedule the exam when you consistently score well on practice tests.
Next Certifications After This AP
Good next steps after Marketing Cloud Intelligence:
Fast Facts: MCI AP Focus Areas
- 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.
Section Weightings to Prioritise
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.
Before You Book the AP Exam
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.
FAQs From Candidates
- 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 and Data Harmonisation and Modelling are the two heaviest areas of the exam. Check the current section weightings in the official exam guide before you plan your study time, since they move between releases. 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.
Keep Studying
Start MCI AP Prep
After this exam, consider Sales Cloud Consultant or Service Cloud Consultant next.
Share or cite this study guide
Free to link from a forum post, study repo or article. Copy the Markdown and paste it anywhere.