Create Insights with the Insights Builder
Learning Objectives
After completing this unit, you’ll be able to:
- Use Insights Builder to create an insight in Data Cloud.
- Link data for unified individuals.
Before You Begin
In this module, we assume you have the proper permissions to create insights in Data Cloud. We recommend reviewing Data Cloud Insights Using SQL and Data Cloud Insights before you begin creating insights. Don’t try to follow the steps in this module in your Trailhead Playground. Data Cloud isn’t available in the Trailhead Playground.
Insight Builder
To enrich and use data brought into Data Cloud, you can create calculated and streaming insights using SQL (Structured Query Language). Familiar with SQL, but don’t know how to write it? You can still build both calculated and streaming insights using Insights Builder in Data Cloud. This tool allows you to build your SQL statements using drag and drop. Check out this video to see how you can create an insight using Insights Builder.
Create a New Insight
To help guide you through using Insights Builder, let’s review the steps you follow and the questions you need to answer with each step. First, let’s create a new insight.
- Click the New button from the Calculated Insights tab in Data Cloud.
- Select Create with Builder and then Next.
You are now on a blank canvas. While SQL requires an understanding of keywords and syntax, Insights Builder helps guide you through options in a drag-and-drop interface. Let’s walk through these steps. First up: selecting objects.
Select Objects
Start by answering: What data do you want to use as the base of your search? Do you want to query sales data or customer data? Once you have identified that data, complete these steps.
- Click Select Objects to select that data model object.
- Locate your data model object—for example, unified individuals—and then click Next.
Join
Next ask yourself: What additional data needs to be included in your search? If no additional data is needed, then you can skip these steps. If you do have additional data, add the join node to your query with these steps.
- Click the + icon next to your selected object.
- Click the node, Join.
- Search the objects in your data model for that data source—for example, party identification or sales order. Once found, click Next.
Now that you have added the join node, it’s time to answer a few more questions and complete the necessary steps.
Question |
Description |
Steps |
---|---|---|
What data do you want from one data source versus the other? |
Join Type
The join type identifies what data you are looking for. All data or matches in one or both sources. The UI text tells you exactly what data you should expect from choosing a left, right, inner, or full join. |
|
How does that data connect? |
Join Keys
Identify how the data connects by identifying a foreign key in each data object. |
|
Unified Profiles
One last question: Are you using identity resolution and unified profiles? For example, in the video in this unit, NTO was using the unified individual DMO to start its SQL expression. If you are doing the same, you first need to connect your unified individual DMO to the unified individual link DMO (also known as a bridge table), before joining with any other DMOs.
Why? Because your engagement data (or other DMO) has an individual customer ID and not a unified individual ID. Essentially it knows your original data, not your data that has been unified because of identity resolution rulesets. This is why the unified individual link DMO needs to be joined first. This helps the system connect the dots between the engagement and unified individual DMOs.
Aggregate
Now let’s move on to another required step to create your insight: the Aggregate node. The aggregate function performs a calculation on a set of values in Data Cloud and returns a single value. In the builder, you need to identify two key features, measures and dimensions. Here’s what you need to answer and the steps you need to take.
Question |
Description |
Steps |
---|---|---|
What metrics are you looking for? |
Measures
Select the metric you are looking for and the field to base that metric on, like sales order. |
|
How do you want the system to group the data? |
Dimensions
Select what field or piece of data you want to use to organize the data. |
|
Next Up: Enhance Your Insights
Now that you know how to create your insight, in the next unit we review the remaining builder options to enhance your insights.
Resources