Last Updated on November 6, 2022 by Rakesh Gupta
Big Idea or Enduring Question:
- How to save recipe results to more than one dataset?
After reading this blog, you’ll be able to:
- Understand CRM Analytics recipe and dataset
- Create a recipe by joining tables
- Save recipe outcomes to two datasets
Business Use Case
Donna Serdula is a System administrator at Gurukul On Cloud (GoC). She just started learning CRM analytics from Trailhead and got the following requirements from her manager:
- Create a dataset combining Opportunity and Account using Account Id (using lookup join)
- Save the recipe result to two datasets
Automation Champion Approach (I-do):
A dataset is a set of source data specially formatted and optimized for interactive exploration. Dataset is used to create lenses and dashboards.
A recipe is an alternate way to create a dataset. Recipes must be created from an existing dataset or connected data (data sync) and are built in a visual interface called Data Prep.
With recipes, you can able to do the following:
- Combine data from multiple datasets or synced data
- Transform (Buket, formula field, change field attributes, etc.) or filter fields
- Add or remove fields
- Write the recipe result to datasets, connections, or CSV files
Connect disconnected nodes or branches to join or append data from any node to any other node in a recipe. You can also create a branch at an intermediate node and join or append it to another path in the recipe.
Guided Practice (We-do):
There are 7 steps to solve Donna’s business requirement using CRM Analytics Recipe. We must:
- On the Data Manager app page, navigate to Data Manager | Recipes | New Recipe.
- Click Add Input Data option, and select the check box next to the connected object Opportunity.
- Click Next.
- The next step is to add the join node to bring data from the account object.
- Click Add Node and select Join.
- Select the connected object Account to join and choose which columns to include.
- Click Next.
- Select the join type, i.e., Lookup
- Select Account Id as the Join Key.
- Use the Preview tab to preview columns and their data.
- Once ready, click Apply to add the node to the recipe.
- It’s time to save the recipe result to the first dataset.
- Let’s save the recipe result to another dataset.
- Almost there! Once everything looks good, click the Save and Run button.
- Click Save again.
Schedule a Recipe to Run Automatically
You can run your recipes automatically at the scheduled time or after an event. For example, Use time-based scheduling to ensure that new data is available to your dataset. Use event-based scheduling to run a recipe after the sync runs to ensure that datasets include the latest data.
You can schedule a recipe to run hourly, weekly, monthly, or on specific days of the week or dates.
- In the data manager, click the Recipes tab.
- Click the drop-down to the right of the recipe name you want to run, and select Schedule.
- Select the Scheduled Mode and the time to run the recipe.
Proof of Concept
The Jobs subtab under data manager shows the status of data sync and recipe CRM Analytics jobs. You can view error messages about a job, the run-time details about every transformation processed, and monitor the number of jobs remaining from your org’s 24-hour limit.
Once the job status is changed to Successful, navigate to Data Assets tab to access newly created datasets.
I want to hear from you!
What is one thing you learned from this post? How do you envision applying this new knowledge in the real world? Feel free to share in the comments below.
4 thoughts on “CRM Analytics: Write Recipe Results to Multiple Datasets”
What a great idea. We’re using CRMA more and more and so this is a very interesting approach – thanks for sharing.