CMO Dashboard: Salesforce Marketing Cloud Intelligence in

As Chief Marketing Officers and senior marketing leaders, we face an unprecedented deluge of data and an ever-shifting technological frontier. Keeping a pulse on market dynamics, competitive intelligence, and team performance demands more than just intuition; it requires a centralized, intelligent platform. This tutorial will walk you through setting up and customizing your primary dashboard on Salesforce Marketing Cloud Intelligence (formerly Datorama), establishing it as your go-to website for chief marketing officers and senior marketing leaders to drive strategic decisions.

Step 1: Initial Dashboard Setup and Data Integration

The first hurdle for any CMO is getting all their data in one place. Trust me, I’ve seen countless marketing teams drown in spreadsheets, trying to manually reconcile performance across disparate platforms. That’s a fool’s errand, and frankly, a waste of your most valuable asset: time. We’re going to build a single source of truth.

1.1 Accessing the Workspace and Creating a New Dashboard

1. Log into your Salesforce Marketing Cloud Intelligence account. From the main navigation bar, locate and click “Workspace.”
2. In the Workspace sidebar, you’ll see a list of existing dashboards. To create a new one, click the large “+ New Dashboard” button located at the top right of the sidebar.
3. A modal will appear, prompting you to “Choose a Template.” For CMOs, I always recommend starting with a “Blank Dashboard” template. While pre-built templates offer a quick start, they often come with extraneous widgets that clutter the view. We want precision here. Select “Blank Dashboard” and click “Create.”
4. Give your dashboard a clear, descriptive name like “Executive Marketing Performance – Q3 2026.” This isn’t just for you; it helps your team understand its purpose.

Pro Tip: Don’t be afraid to experiment with dashboard names. You can always rename it later by clicking the three dots next to the dashboard name in the Workspace and selecting “Rename.”

Common Mistake: Over-reliance on default templates. They rarely align perfectly with a CMO’s specific strategic objectives. Customization is king for senior leaders.

Expected Outcome: A pristine, empty canvas ready for your strategic marketing data.

1.2 Connecting Your Core Data Sources

This is where the magic begins. Without robust data, your dashboard is just a pretty picture. We need real, actionable intelligence. I usually start with the big three: Google Ads, Meta Ads, and your primary CRM, like Salesforce Sales Cloud. Don’t forget your website analytics from Google Analytics 4!

1. Within your newly created dashboard, look for the “Data Streams” tab in the left-hand navigation. Click it.
2. You’ll see a button that says “+ Add Data Stream.” Click this.
3. A new pane will slide out, displaying a vast library of connectors. Search for your first data source, for example, “Google Ads.” Select it.
4. Follow the on-screen prompts to authenticate your account. This typically involves signing in with your Google credentials and granting access. For Google Ads, ensure you select the correct MCC (My Client Center) account if you manage multiple ad accounts.
5. Repeat this process for Meta Ads, your CRM (e.g., Salesforce Sales Cloud), and Google Analytics 4. Aim for at least four core integrations to start.

Pro Tip: When connecting your CRM, pay close attention to the data mapping. Ensure that fields like “Lead Source,” “Deal Stage,” and “Opportunity Value” are correctly mapped to your Intelligence platform’s data model. I had a client last year whose entire revenue attribution model was flawed because they missed a critical mapping during their initial Salesforce Sales Cloud integration. It took weeks to unravel!

Common Mistake: Not verifying data ingestion. Just because it’s connected doesn’t mean the data is flowing correctly. Always spot-check a few key metrics against the source platform.

Expected Outcome: All your critical marketing and sales data sources actively feeding into your Intelligence platform, ready for visualization.

Step 2: Designing Your Executive Dashboard Layout and Key Performance Indicators (KPIs)

A CMO’s dashboard isn’t about vanity metrics. It’s about strategic insights. What truly matters for the business? Revenue, customer acquisition cost (CAC), customer lifetime value (CLTV), and marketing’s contribution to pipeline. Everything else is secondary.

2.1 Adding Your First Widgets: The North Star Metrics

1. Navigate back to your dashboard view. Click the “Widgets” tab in the left-hand navigation.
2. Click the “+ Add Widget” button.
3. From the “Widget Type” dropdown, select “Scorecard.” This is perfect for displaying single, high-impact numbers.
4. In the “Data Source” section, select one of your newly connected data streams (e.g., “Google Ads”).
5. Under “Metric,” choose “Cost.” Give it a title like “Total Ad Spend – Google.”
6. Repeat this process, adding Scorecard widgets for:
   • Total Revenue (from CRM or e-commerce platform)
   • New Leads Generated (from CRM)
   • Customer Acquisition Cost (CAC) (calculated metric, which we’ll cover next)
   • Return on Ad Spend (ROAS) (calculated metric)

Pro Tip: Arrange your Scorecards logically. I always put revenue and CAC front and center. These are the numbers that keep me up at night, and they should be immediately visible. Remember the 5-second rule: can you grasp the overall health of your marketing in five seconds?

Common Mistake: Too many widgets. A cluttered dashboard is a useless dashboard. Focus on 5-7 core Digital Marketing KPIs. Anything more belongs in a detailed report, not your executive summary.

Expected Outcome: A clean, executive-level view of your most critical marketing performance indicators.

2.2 Creating Calculated Metrics for Deeper Insights

Raw data is good, but derived metrics are where the true strategic value lies. CAC and ROAS aren’t just handed to you; you have to calculate them. This is where the platform’s power truly shines.

1. From the main navigation, click “Data Model” (often represented by a database icon).
2. In the Data Model editor, select “Calculated Metrics.”
3. Click “+ New Calculated Metric.”
4. Let’s create CAC (Customer Acquisition Cost).
   • Name: “Customer Acquisition Cost”
   • Formula: SUM(Total_Marketing_Spend) / SUM(New_Customers). You’ll need to select the appropriate “Total_Marketing_Spend” and “New_Customers” fields from your connected data streams. Ensure your CRM data accurately tracks new customers.
   • Format: Currency.
5. Next, let’s create ROAS (Return on Ad Spend).
   • Name: “Return on Ad Spend”
   • Formula: SUM(Revenue) / SUM(Ad_Spend). Again, select the correct “Revenue” and “Ad_Spend” fields.
   • Format: Percentage or Ratio.
6. After creating these, go back to your dashboard and edit the relevant Scorecard widgets to display these new calculated metrics.

Pro Tip: Always double-check your calculated metric formulas. A single wrong field can skew your entire analysis. I’ve seen marketing teams make critical budget decisions based on miscalculated CAC, leading to significant overspending. Verify, verify, verify!

Common Mistake: Not understanding the underlying data fields. Ensure that “New_Customers” truly represents new customers and not just new leads or opportunities.

Expected Outcome: Your dashboard now displays sophisticated, business-critical metrics that provide a true pulse on marketing efficiency.

Step 3: Advanced Visualizations and Automation

Once you have your core KPIs, it’s time to add context and automate reporting. A static number is only half the story; trends and comparisons are what inform strategy. This is where you can truly differentiate a website for chief marketing officers and senior marketing leaders from a basic reporting tool.

3.1 Adding Trend Lines and Comparison Charts

1. From your dashboard view, click “+ Add Widget.”
2. Select “Line Chart” for visualizing trends over time.
3. Under “Data Source,” select your unified data model (or the specific source for the metric).
4. For “Metric,” choose “Total Revenue.” For “Dimension,” select “Date.” This will show you revenue trends.
5. Add another widget, this time a “Bar Chart” to compare performance across different channels.
6. For “Metric,” select “New Leads Generated.” For “Dimension,” choose “Channel” (e.g., “Google Ads,” “Meta Ads,” “Organic Search”).

Pro Tip: Use consistent color palettes across your charts for the same metrics or channels. Visual consistency reduces cognitive load and allows for faster interpretation. A good rule of thumb: green for positive trends, red for negative, and blues/grays for neutral comparisons.

Common Mistake: Using too many chart types. Stick to line charts for trends, bar charts for comparisons, and pie charts (sparingly) for composition. Anything more complex often confuses rather than clarifies.

Expected Outcome: A visually rich dashboard that not only shows current performance but also historical trends and channel comparisons, offering deeper insights.

3.2 Setting Up Automated Reporting and Alerts

As CMOs, we don’t have time to manually pull reports every week. Automation is non-negotiable. Plus, proactive anomaly detection can save you from costly missteps.

1. From your dashboard, click the “Schedule” icon (often looks like a calendar or clock) in the top right corner.
2. Click “+ New Schedule.”
3. Configure the schedule:
   • Frequency: “Weekly.”
   • Day of Week: “Monday.”
   • Time: “8:00 AM.”
   • Recipients: Enter your email and the emails of your senior leadership team.
   • Format: “PDF” (for a static snapshot) and “CSV” (for underlying data if needed).
4. Next, let’s set up anomaly detection. Go to the “Alerts” section within the platform’s main navigation.
5. Click “+ New Alert.”
6. Metric: Select “Total Ad Spend.”
7. Condition: “Greater than.”
8. Threshold: Set this to “Average Last 30 Days” and add a “Deviation Percentage” of 15%. This means if your ad spend jumps 15% above the 30-day average, you’ll get an alert.
9. Recipients: Your email and your Head of Paid Media.
10. Repeat this for “New Leads Generated” with a “Less than” condition and a 15% deviation. A sudden drop in leads is always cause for concern.

Pro Tip: Don’t set too many alerts initially. Start with 2-3 critical ones. Alert fatigue is real, and if every minor fluctuation triggers an email, you’ll start ignoring them. Refine your thresholds over time. We ran into this exact issue at my previous firm – too many alerts led to critical warnings being overlooked.

Common Mistake: Not testing schedules or alerts. Always send a test report to yourself first. Ensure the data is correct and the formatting is readable.

Expected Outcome: You and your team receive timely, automated performance reports, and you are proactively notified of significant deviations in key metrics, allowing for swift strategic adjustments.

By establishing a robust, customized dashboard within Salesforce Marketing Cloud Intelligence, you transform raw data into actionable intelligence, empowering you and your senior team to make informed, impactful decisions that drive marketing excellence and business growth. This approach also aligns with strategies for boosting ROI with marketing analytics and ensuring you avoid common CMO marketing myths.