Creating a Marketing Dashboard in Salesforce: Tips, Tricks and Examples
- April 7, 2022
- Jenna Molby, Reporting
Creating a Salesforce marketing dashboard is an effective way to see how you are doing against your marketing targets. What channels are most effective for generating pipeline? How many leads did we generate this month compared to last month? In this post, I’ll share some example marketing dashboard components and some tips and tricks for creating dashboards in Salesforce.
Hot Tip: Check out this blog post to learn more about choosing a Salesforce marketing reporting tool.
Salesforce Marketing Dashboard Tips & tricks
Create a reports folder for your dashboard reports
Anyone accessing your dashboard also needs access to the underlying reports. Creating a separate folder for your reports allows you to easily control who has access to them. And (bonus!) it’s easier to find your reports when you are creating your dashboard.
Choose your dashboard running user wisely
Each dashboard has a running user, whose security settings determine which data to display in a dashboard. If the running user is a specific user, all dashboard viewers see data based on the security settings of that user—regardless of their own personal security settings. For this reason, you’ll want to choose the running user wisely, so as not to open up too much visibility.
Add a chart directly to your report
Adding a chart directly within your report can speed up your dashboard setup time, especially if you are going to use the same report on multiple dashboards. It is also helpful if you are going to share the report directly instead of the dashboard.
Change your dashboard palette
Give your dashboard a fresh new look by changing the dashboard palette. There are 14 themes available in both light and dark mode.
Resuse reports within your dashboard
The same report can be used many times within your dashboard. This is a great way to visualize the same data in different ways without creating multiple reports.
Example Dashboard Components
Let’s dive into some examples of what type of reports you might want to add to your dashboard. In these examples, I’m specifically looking at the pipeline and revenue marketing has generated. To pull these reports, I have the primary campaign source field populated on the opportunity and I use the campaigns with influenced opportunties report type. Your setup might be differ depending on how you associate marketing campaigns with opportunities.
Marketing vs Target
What this reports answers: How are we tracking against our pipeline target?
Report setup
- Report type: Campaigns with Influenced Opportunties
- Filters: Show me all opportunities CREATED this fiscal quarter
- Grouped by: Create date
Dashboard component setup
- Chart type: Gauge
Closed won revenue
What this reports answers: How much marketing generated pipeline has been closed-won?
Report setup
- Report type: Campaigns with Influenced Opportunties
- Filters: Show me all opportunities CLOSED this fiscal quarter
- Grouped by: Close date
Dashboard component setup
- Chart type: Gauge
Leads created by source
What this reports answers: What are our top lead sources this quarter by month?
Report setup
- Report type: Leads
- Filters: Show me all leads created in the last fiscal quarter
- Grouped by: Create date and lead source
Dashboard component setup
- Chart type: Stacked vertical bar chart
- X-axis: Create date
- Y-axis: Record count
Contacts created by source
What this reports answers: What are our top contact sources this quarter by month?
Report setup
- Report type: Contacts and Accounts
- Filters: Show me all accounts created in the last fiscal quarter
- Grouped by: Create date and lead source
Dashboard component setup
- Chart type: Stacked vertical bar chart
- X-axis: Create date
- Y-axis: Record count
Pipeline by source
What this reports answers: What are the top marketing channels for generating pipeline?
Report setup
- Report type: Campaigns with influenced opportunities
- Filters: show me all campaigns where created date (opportunity) is this fiscal quarter
- Grouped by: Campaign type
- Columns: Opportunity amount summarized by sum and average
Dashboard component setup
Table component
- Chart type: Lightning table
- Grouped by: Campaign type
- Measure: Opportunity amount (summarize by sum and average amount)
Donut component
- Chart type: Donut
Marketing qualified leads (MQLs)
If you want to learn how to display MQL reports within your dashboard, check out this blog post.
This Pardot article written by:
Jenna Molby
Jenna is a Salesforce Certified Pardot Specialist, Salesforce Certified Pardot Consultant and Salesforce Marketing Champion 2020. Jenna is a marketing operations leader with over ten years of B2B and B2C experience working on both the agency and client-side.
Original Pardot Article: https://jennamolby.com/creating-marketing-dashboard-in-salesforce/
Find more great Pardot articles at https://jennamolby.com/
Pardot Experts Blog
We have categorized all the different Pardot articles by topics.
Pardot Topic Categories
- Account Based Marketing (ABM) (7)
- Business Units (14)
- ChatGPT / AI (3)
- Completion Actions (5)
- Connectors (10)
- Custom Redirects (4)
- Data Cloud (2)
- Demand Generation (8)
- Dynamic Content (6)
- Einstein Features (12)
- Email Delivery (17)
- Email Open Rates (3)
- Pardot A/B Testing (2)
- Email Mailability (16)
- Do Not Email (1)
- Double Opt-in (2)
- Opt Out / Unsubscribe (14)
- Email Preferences Page (6)
- Engagement Studio (16)
- Industries (1)
- Non Profit (1)
- Landing Pages (9)
- Lead Generation (1)
- Lead Management (13)
- Lead Routing (3)
- Lead Scoring (16)
- Leads (3)
- Marketing Analytics – B2BMA (9)
- Marketing Automation (1)
- Marketing Cloud (3)
- Marketing Cloud Account Engagement (4)
- Marketing Cloud Growth (2)
- New Pardot Features (6)
- Opportunities (2)
- Optimization (2)
- Pardot Admin (64)
- Duplicates (1)
- Marketing Ops (1)
- Pardot Alerts (1)
- Pardot API (2)
- Pardot Automations (3)
- Pardot Careers (12)
- Pardot Certifications (4)
- Pardot Consulting (1)
- Pardot Cookies (3)
- Pardot Custom Objects (3)
- Pardot Email Builder (8)
- Pardot Email Templates (9)
- HML (6)
- Pardot Events (16)
- Pardot External Actions (1)
- Pardot External Activities (4)
- Pardot Forms (29)
- Form Handlers (8)
- Pardot Integrations (20)
- Data Cloud (1)
- Slack (1)
- Pardot Lead Grading (5)
- Pardot Lead Source (2)
- Pardot Lightning (1)
- Pardot Migration (1)
- Pardot Nurture / Drip Campaigns (1)
- Pardot Personalization (3)
- Pardot Profiles (1)
- Pardot Releases (18)
- Pardot Sandboxes (2)
- Pardot Segmentation (5)
- Pardot Strategy (7)
- Pardot Sync (2)
- Pardot Sync Errors (1)
- Pardot Tracker Domains (5)
- Pardot Training (3)
- Pardot Vs Other MAPs (4)
- Pardot Website Tracking (2)
- Reporting (22)
- Salesforce and Pardot (31)
- Marketing Data Sharing (2)
- Pardot Users (3)
- Salesforce Automation (5)
- Salesforce Flows (2)
- Salesforce Campaigns (20)
- Salesforce CRM (3)
- Record Types (1)
- Salesforce Engage (3)
- Salesforce Queues (2)
- Security and Privacy (1)
- Tags (3)
- The Authors (504)
- Cheshire Impact (9)
- Greenkey Digital (51)
- Invado Solutions (37)
- Jenna Molby (9)
- Marcloud Consulting (6)
- Nebula Consulting (60)
- Pardot Geeks (44)
- Salesforce Ben | The Drip (235)
- SalesLabX (3)
- Slalom (4)
- Unfettered Marketing (46)
- Uncategorized (1)
- Website Tracking (2)
- Website Search (1)
More Pardot Articles
See all posts
This Pardot article written by:
Jenna Molby
Jenna is a Salesforce Certified Pardot Specialist, Salesforce Certified Pardot Consultant and Salesforce Marketing Champion 2020. Jenna is a marketing operations leader with over ten years of B2B and B2C experience working on both the agency and client-side.
Original Pardot Article: https://jennamolby.com/creating-marketing-dashboard-in-salesforce/
Find more great Pardot articles at https://jennamolby.com/