Salesforce Data-Cloud-Consultant - Salesforce Certified Data Cloud Consultant (SP25)

The consolidation rate is the amount by which source profiles are combined to produce unified profiles, calculated as 1 - (number of unified individuals / number of source individuals). For example, if you ingest 100 source records and create 80 unified profiles, your consolidation rate is 20%. To increase the consolidation rate, you need to increase the number of matches between source profiles, which can be done by adding more match rules. Match rules define the criteria for matching source profiles based on their attributes. By increasing the number of match rules, you can increase the chances of finding matches between source profiles and thus increase the consolidation rate. On the other hand, changing reconciliation rules, including additional attributes, or reducing the number of match rules can decrease the consolidation rate, as they can either reduce the number of matches or increase the number of unified profiles. References: Identity Resolution Calculated Insight: Consolidation Rates for Unified Profiles, Identity Resolution Ruleset Processing Results, Configure Identity Resolution Rulesets

A calculated insight is a multidimensional metric that is defined and calculated from data using SQL expressions. A calculated insight can include dimensions and measures. Dimensions are the fields that are used to group or filter the data, such as customer ID, product category, or region. Measures are the fields that are used to perform calculations or aggregations, such as revenue, quantity, or average order value. A calculated insight can be modified by editing the SQL expression or changing the data space. However, the consultant needs to be aware of the following limitations and considerations when modifying a calculated insight12:

Existing dimensions cannot be removed. If a dimension is removed from the SQL expression, the calculated insight will fail to run and display an error message. This is because the dimension is used to create the primary key for the calculated insight object, and removing it will cause a conflict with the existing data. Therefore, the correct answer is B.

New dimensions can be added. If a dimension is added to the SQL expression, the calculated insight will run and create a new field for the dimension in the calculated insight object. However, the consultant should be careful not to add too many dimensions, as this can affect the performance and usability of the calculated insight.

Existing measures can be removed. If a measure is removed from the SQL expression, the calculated insight will run and delete the field for the measure from the calculated insight object. However, the consultant should be aware that removing a measure can affect the existing segments or activations that use the calculated insight.

New measures can be added. If a measure is added to the SQL expression, the calculated insight will run and create a new field for the measure in the calculated insight object. However, the consultant should be careful not to add too many measures, as this can affect the performance and usability of the calculated insight. References: Calculated Insights, Calculated Insights in a Data Space.

A customer who wants to view the last time each segment was published within their Data Cloud org can use the dashboard and report features to achieve this requirement. A dashboard is a visual representation of data that can show key metrics, trends, and comparisons. A report is a tabular or matrix view of data that can show details, summaries, and calculations. Both dashboard and report features allow the user to create, customize, and share data views based on their needs and preferences. To view the last time each segment was published, the user can create a dashboard or a report that shows the segment name, the publish date, and the publish status fields from the segment object. The user can also filter, sort, group, or chart the data by these fields to get more insights and analysis. The user can also schedule, refresh, or export the dashboard or report data as needed. References: Dashboards, Reports

ï‚· Data Stream Deployment: When setting up a data stream in Salesforce Data Cloud, the initial deployment requires a comprehensive data load.

ï‚· Types of Refreshes:

Incremental Refresh: Only updates with new or changed data since the last refresh.

Manual Refresh: Requires a user to manually initiate the data load.

Partial Refresh: Only a subset of the data is refreshed.

Full Refresh: Loads the entire dataset into the system.

ï‚· First-Time Deployment: For the initial deployment of a data stream, a full refresh is necessary to ensure all data from the source system is ingested into Salesforce Data Cloud.

ï‚· References:

Salesforce Documentation: Data Stream Setup

Salesforce Data Cloud Guide

To create a data graph based on several Data Lake Objects (DLOs) , the consultant should map the DLOs to Data Model Objects (DMOs) and use these in the data graph. Here’s why:

Understanding Data Graphs

A data graph in Salesforce Data Cloud represents relationships between entities (e.g., customers, accounts, orders) and their attributes.

It is built using Data Model Objects (DMOs) , which provide a standardized structure for unified profiles and related data.

Why Map DLOs to DMOs?

Role of DLOs and DMOs :

DLOs are raw data sources ingested into Data Cloud.

DMOs are standardized objects used for identity resolution and unified profiles.

Mapping DLOs to DMOs ensures that raw data is transformed into a structured format suitable for data graphs.

Building the Data Graph :

Once the DLOs are mapped to DMOs, the consultant can use the DMOs to define relationships and build the data graph.

This approach ensures consistency and alignment with the unified data model.

Other Options Are Less Suitable :

A. Use a data action to update the data graph with the DLO data : Data actions are used for triggering workflows, not for building data graphs.

C. Map the DLOs directly to a data graph : DLOs cannot be directly mapped to a data graph; they must first be transformed into DMOs.

D. Batch transform the DLOs to multiple DMOs and activate these with the data graph : This is overly complex and unnecessary when mapping DLOs to DMOs suffices.

Steps to Create the Data Graph

Step 1: Map DLOs to DMOs

Navigate to Data Cloud > Data Streams and map the relevant fields from the DLOs to the corresponding DMOs.

Step 2: Define Relationships

Use the Data Model tab to define relationships between DMOs (e.g., linking Individuals to Accounts).

Step 3: Build the Data Graph

Use the mapped DMOs to create the data graph, defining nodes (entities) and edges (relationships).

Step 4: Validate the Graph

Test the data graph to ensure it accurately represents the desired relationships and data flow.

Conclusion

The consultant should map the DLOs to DMOs and use these in the data graph to ensure a structured and consistent approach to building relationships between entities.

 The Contact Point_Email object is the data entity that represents an email address associated with an individual in Data Cloud. It is part of the Customer 360 Data Model, which is a standardized data model that defines common entities and relationships for customer data. The Contact Point_Email object can be mapped to any custom or standard object that stores email addresses in Salesforce CRM, such as the custom Customer Email__c object. The other options are not the correct data entities to map to because:

A. The Contact object is the data entity that represents a person who is associated with an account that is a customer, partner, or competitor in Salesforce CRM. It is not the data entity that represents an email address in Data Cloud.

C. The custom Customer Email__c object is not a data entity in Data Cloud, but a custom object in Salesforce CRM. It can be mapped to a data entity in Data Cloud, such as the Contact Point_Email object, but it is not a data entity itself.

D. The Individual object is the data entity that represents a unique person in Data Cloud. It is the core entity for managing consent and privacy preferences, and it can be related to one or more contact points, such as email addresses, phone numbers, or social media handles. It is not the data entity that represents an email address in Data Cloud. References: Customer 360 Data Model: Individual and Contact Points - Salesforce, Contact Point_Email | Object Reference for the Salesforce Platform | Salesforce Developers, [Contact | Object Reference for the Salesforce Platform | Salesforce Developers], [Individual | Object Reference for the Salesforce Platform | Salesforce Developers]

The correct answer is A. Deactivate the segment. If a segment is no longer needed, it can be deactivated through Data Cloud and applies to all chosen targets. A deactivated segment no longer publishes, but it can be reactivated at any time1. This option allows the user to pause a segment activation with the intent of using that segment again.

The other options are incorrect for the following reasons:

B. Delete the segment. This option permanently removes the segment from Data Cloud and cannot be undone2. This option does not allow the user to use the segment again.

C. Skip the activation. This option skips the current activation cycle for the segment, but does not affect the future activation cycles3. This option does not pause the segment activation indefinitely.

D. Stop the publish schedule. This option stops the segment from publishing to the chosen targets, but does not deactivate the segment4. This option does not pause the segment activation completely.

1: Deactivated Segment article on Salesforce Help

2: Delete a Segment article on Salesforce Help

3: Skip an Activation article on Salesforce Help

4: Stop a Publish Schedule article on Salesforce Help

To meet the requirement of targeting loyal and engaged customers (platinum-tier customers visiting investment pages more than three times in 24 hours) and sending an immediate email offering a private consultation, the best solution is to use a streaming insight with a data action into a journey in Marketing Cloud Engagement . Here’s why:

Understanding the Requirement

The company wants to identify platinum-tier customers who visit their Investment pages more than three times within a 24-hour period.

Once identified, these customers should immediately receive an email offering a private consultation.

This requires real-time monitoring of customer behavior and triggering an automated response.

Why Streaming Insight with a Data Action?

Streaming Insights for Real-Time Monitoring :

A streaming insight in Salesforce Data Cloud monitors customer interactions in real time.

It can detect when a platinum-tier customer visits the Investment pages more than three times within 24 hours.

Data Actions for Immediate Response :

A data action allows you to trigger specific actions based on the insights generated.

In this case, the data action would send the customer's information to a journey in Marketing Cloud Engagement to initiate the email campaign.

Journey in Marketing Cloud Engagement :

Marketing Cloud Engagement journeys are designed to automate personalized marketing activities, such as sending transactional emails.

By integrating the streaming insight with a journey, the system can immediately send the email offering a private consultation.

Steps to Implement This Solution

Step 1: Create a Streaming Insight

Navigate to Data Cloud > Insights > Streaming Insights .

Define the criteria for identifying platinum-tier customers who visit the Investment pages more than three times in 24 hours.

Step 2: Configure a Data Action

Set up a data action that sends the identified customer's information to Marketing Cloud Engagement.

Ensure the data action includes relevant details (e.g., customer ID, email address).

Step 3: Build a Journey in Marketing Cloud Engagement

In Marketing Cloud Engagement, create a journey that listens for incoming data from the data action.

Configure the journey to send a personalized email offering a private consultation.

Step 4: Test and Deploy

Test the entire workflow to ensure that the streaming insight triggers the data action and that the email is sent immediately.

Why Not Other Options?

A. Calculated insight with a data action to a Marketing Cloud Engagement transactional email :Calculated insights are not designed for real-time monitoring. They are better suited for batch processing or periodic calculations, making them unsuitable for this use case.

B. Rapid segment to a data action journey in Marketing Cloud Engagement :While rapid segments are useful for quickly grouping customers, they do not provide the real-time detection required for this scenario.

C. Standard segment with activation into Marketing Cloud Engagement :Standard segments are static or periodically updated and cannot respond to real-time customer behavior.

Conclusion

By using a streaming insight with a data action into a journey in Marketing Cloud Engagement , Cumulus Financial can achieve real-time monitoring and immediate engagement with its loyal customers.