Enhance Your Insight with the Builder
Learning Objectives
After completing this unit, you’ll be able to:
- Manipulate data in Insights Builder.
- View an example of an insight that can be created with the builder.
Manipulate Your Data
The basic requirements of an insight are data sources, measures, and dimensions (how you group the data). Now let’s look at how to further manipulate the data in the selected data model objects using Insights Builder.
We covered the Join and Aggregate nodes in unit 1. Now let’s cover the remaining interface node options.
Node |
Description |
Example |
|---|---|---|
Case |
Create a logic statement that narrows the result based on specific criteria. |
When create date is greater than Dec. 1, 2020, provide the account name |
Filters |
Define filters on the measures and dimensions to reduce the results based on when a condition is met. |
Where total quantity > 100 |
Transform |
Change or clean data based on the fields in your selected data object. |
Update the created date to show the day of the week |
Arithmetic Expression |
Write arithmetic calculations to create insights used in segmentation filters. |
Subtract customer lifetime value (CLV) by total lifetime customer discounts |
What else do you need to do with or to that data? Do you need to reduce the results? Do a further calculation? Based on your needs, you can use case, filters, transform, and arithmetic expressions to add more complex filters and data clean-up activities to your query.
As you work with the builder, it’s important to know your available options. View the full list of supported and non-supported features on the Insights Builder Supported Functions page.
Insights Builder Example
Let’s review the steps to create an insight for outdoor gear and apparel retailer Northern Trail Outfitters (NTO) using Insights Builder. Technical marketer Michele Hansley has been asked to find how many units of a specific product have been sold. This data lives in NTO’s order details data model object (DMO). For this example, Michele wants to know the total quantity across orders for each productID. Here is some sample data.
Order ID |
Product ID |
Quantity |
|---|---|---|
13131 |
3131 |
2 |
52613 |
3155 |
5 |
23154 |
3131 |
1 |
14524 |
3521 |
10 |
To do this, Michele follows these steps.
- From the Data Cloud tab Calculated Insights, she clicks New.
- Michele selects Create with Builder and then Calculated Insights.
- From the builder interface, Michele clicks Select Objects.
- She searches for the order details DMO and then clicks Next.
- Next to the order details DMO she clicks the + icon and selects Aggregate.
- Under Measures, she clicks the + button and views her options for metric functions. She chooses + button and selects the radio button next to Quantity, then clicks Next.
- She adds in a name for this measure and then clicks Apply.
- Under Dimensions, she clicks the + button and views her field options. She selects the radio button next to Product ID as the dimension and clicks Next.
- She adds in a name for the dimension and then clicks Apply.
- Once she has added both her measure and dimension, she clicks Apply.
- Then she clicks Save.
- She names the insight Total Quantity Sold by Product, adds a brief description, and then clicks Done.
These steps create an insight whose results are the same as an insight that uses this SQL expression.
SELECT ProductID, SUM(Quantity) as Total Quantity FROM OrderDetails GROUP by ProductID
But what does the data look like after the insight has been built and is active? The outcome of this insight might look like this.
Product ID |
Total Quantity |
|---|---|
3131 |
3 |
3155 |
5 |
3521 |
10 |
While this insight might not be used directly in a marketing campaign, Michele plans to use this information to create a campaign that promotes the products that have sold the least. Michele can also use this new insight in the future to build another insight or she can use it in a new segment.
This is just the beginning of what can be done with insights in Data Cloud! You now have the knowledge to create your own insights using Insights Builder.
Resources
