Make Your SFDC Dashboard More Versatile With Filters

marketing-2-dash-dashboard-filter
While Marketo offers a rich set of reporting functionality many organizations want Salesforce.com to be the go-to system for sales and marketing dashboards. Rather than create a separate dashboard to show Monthly, Quarterly, or Yearly data, use a SFDC dashboard filter to create one dashboard that works for all time periods.

The dashboard supports filtering by time period, so report information can be viewed by Month, Quarter, or Year.

Creating SFDC Dashboard Filters

marketing-2-dash-sfdc-filters
SFDC supports up to four filters on a dashboard. For example, the following filter shows a SFDC dashboard filter for Time Period.

Filters can be created while in the Dashboard “edit” mode when you click on the “Add Filter” button, which opens the following dialog:

Dashboard Filter Rules of the Road

The Marketing 2.0 Dashboard requires the following architectural settings:

Date fields used for the dashboard filters must be Datetime fields. Salesforce.com and Marketo system fields use Datetime, and are also common fields to use as filters (Create Date, Modify Date).

All reports should default to All Time or THIS YEAR date ranges.

All dashboard components should default to “Use chart type as defined in source report” = TRUE.

New SFDC fields: MQL Date (lead and contact), MQL Latest Date (lead and contact), Disqualified Reason (lead and contact), SQL Date (lead and contact), SAL Date (lead and contact).

Your marketing technology experts.

At Digital Pi, we use technology to connect revenue to marketing efforts. We fuse marketing strategies, processes, data and applications to make marketing technology solutions work for clients' businesses.

Learn More
Share this resource
Facebook
Twitter
LinkedIn
Tags

Cookies help us keep the site running smoothly and inform some of our advertising, but if you’d like to make adjustments, you can visit our Cookie Notice page for more information.