One of the fundamental business functions we want to enable for Salesforce CDP (Customer Data Platform) is to help our customers harness their unified customer data for intelligent insights and actions.
We bring this intelligence to Salesforce CDP by building purpose and persona-driven tools for data analysis and business intelligence, empowering customers with the right information at the right time to drive data-driven engagements, decisions, and automated flows. Marketers, sales and service professionals, or anyone in an organization can leverage prescriptive and predictive streaming insights across channels and touch-points to guide customer journeys or power business processes that help build richer relationships.
Lead UX designer responsible for end-to-end user experience from ideation through development for multiple releases.
Product Managers, Developers, Architects, UX Researchers, Design Systems Engineers and Designers, Content Writers.
Marketing, traditionally, has been seen as more of an art than a science. While creative ideas play a critical role in marketing and will continue to do so for the foreseeable future, data is becoming more crucial and even table-stakes to the modern marketer. That’s because data is helping marketers meet customers’ growing desire for more personalized engagements and experiences from the brands they interact with. These experiences can include a movie, product, or news story recommendation that seems exactly tailored to an individual consumer’s experiences or interests.
With Calculated Insights, Salesforce CDP customers can leverage their unified data (see Data Streams & Mapping case-study) to create business and individual-level metrics for enabling key use-cases. This system of insight can help marketers navigate thorny problems like calculating marketing ROI and the potential lifetime value (LTV) of a customer. They can even help uncover new buyer personas and customer affinities within their customer base (e.g., they have more foodies among their customers than in the general population). Gathering these types of insights that inform marketing campaigns will be critical in determining the success of marketing departments.
We kicked off the discovery process by identifying the target personas, jobs to be done, key concepts, and customer use-cases. At the point of project kickoff, the UX research team had come back with a validated list of jobs to be done by customers using CDP. These jobs and supporting research helped us identify the target personas and the expected roles in the calculated insights life-cycle.
Create insights for their organization. Consume insights for visualization, reporting and business intelligence.
Consume insights to enable business use-cases.
In most systems today, Analysts calculate insights by writing SQL queries to define their metrics. An example SQL query used to calculate the sum of the total amount as "Total Spend" for every customer is shown below.
The concept of metrics and dimensions can also be seen in the charts and UI representations below.
After cataloging our customer use-cases and business needs, we broke the requirements into two primary flows: Creation and Consumption.
Type: Improvement to existing functionality
Primary persona: Marketing Specialist and Business User
Key use-case: Use a calculated insight (e.g. customer life-time value score) to create a segment of people with high LTV score. Activate this segment to send a personalized email.
One of the most significant value propositions of the Calculated Insights feature is to make the segmentation feature in Salesforce CDP better and easy to use. The segmentation feature is used by marketers to identify a group of people (customers) who share one or more common characteristics, lumped together for marketing campaigns.
With Calculated Insights, marketers can simply drag and drop metrics from the list of defined calculated insights onto the canvas. They can apply additional filters on these insights, and define AND/OR logic rules with other data attributes or insights to create an audience segment.
*Segmentation was an existing product functionality. My role was to work with the PM and UX lead on Segmentation to visualize how the metrics would show up in the left-side attribute library and the canvas interactions for filtering on drag-and-drop.
Type: New Feature
Primary persona: Data Analyst
Key use-case: Define a new calculated insight (e.g. customer life-time value score) by writing a SQL query or using a graphical user interface tool by adding measures, dimensions, and filters.
Based on the identified user flow, we choose to explore two possible UI implementations 1. Writing SQL queries, 2. A graphical interface (No code UI).
Rationale: According to a Salesforce-wide analyst persona research study, 83% of analysts use code to do their job. The proposal here was to allow users to write SQL code assisted with a library of attributes and supported functions in CDP.
Rationale: This concept was inspired by the existing Segmentation feature (see Consumption Flow) in Salesforce CDP. The idea behind this exploration was to re-use the existing drag and drop capabilities and visual styling from the segmentation tool to keep the engineering effort low.
As we were in the middle of this big discovery project, the product team wanted to ship a UI solution within a single release to meet our demanding pilot customer needs. The ability to generate such insights on the unified data in Salesforce CDP was a key functionality that customers saw as "missing" in the current product capability. This lead to an agreement between all involved stakeholders where the product MVP would focus on writing SQL queries to help speed the feature development.
Deliver a quick MVP solution (achievable in a single release) for creating Calculated Insights in Salesforce CDP to address key pilot customer use-cases.
After wrapping up the feature MVP, we kicked off a new design sprint to explore the no-code option for creating calculated insights. It was evident that customers wanted a more user-friendly tool that could work for any Salesforce CDP user. The SQL query experience would continue to co-exist as a more powerful and advanced option for customers.
We ran additional persona research to understand more about our user's mental models, needs, and expectations for a product UI when building statistical and predictive insights.
Defining and creating a calculated insight is an iterative process that is part planned and part organic. Users (Analysts in most cases) are often responding to the business requirements for different parts of their organization such as Sales, Marketing, Service, etc.
Users want a tool where insights are: Easy to build, Easy to edit & maintain, Can scale for future iterations.
Users need to visualize the different steps involved in defining an insight: Select objects, Join objects, Create filters, Group, Rank, Conditional joins, Define scores, and more.
How might we create a graphical UI for defining insights in Salesforce CDP which is approachable for most users yet robust at its core to accomplish key business use-cases?
Part of our new discovery effort was to identify the common steps between customer use-cases ranging from basic to advanced which needed to be accomplished with the insights builder tool. Once the steps were roughly cataloged, we spend time exploring low-fi UI options for the builder.
Rationale: Our first concept was a step-based UI where the users are presented with a list of common steps. Users would be able to add more steps or re-order them if necessary. Every step/node would consist of a configuration UI with curated user assistance and guidance
Rationale: The other approach that we explored was a flow-based user interface. The idea was to create a map or a chart with nodes representing the different steps. More steps could be added on the canvas while supporting branching and supporting scalability.
Salesforce hosts several content, logic, data, and code builders across its vast portfolio of products. The builder framework is a set of code components and visual design guidelines established as a part of the Salesforce Lightning Design System for designing tools that work with the WYSIWYG declarative elements that can be added with clicks and customized with forms.
We leveraged the SLDS Builder Guidelines to create a high-fidelity version of our concepts. We also drew inspiration from other builder tools in Salesforce like Engagement Studio, App Builder, Journey Builder, etc., to design the canvas interactions, including drag and drop, click-to-add, configuration, expand-collapse frames, and more.
We interviewed 7 participants responsible for creating insights, reports and dashboards. Primary user roles - Analyst and Data Systems Architects.
"I really like the direction you are going on with this because every [UX improvement] shouldn't be only about [end user] or about dashboards. What you are trying to do here is improve experience of people responsible for the data." – Optum
The Insight Builder expected to be launched in early 2022. Once the tool becomes public, one of the primary success metrics will be feature adoption and customer satisfaction. Some channels for measuring impact will include: