Definition
Preparation Recipe is a core Salesforce concept that supports the management of customer data and business relationships. It is commonly used across sales, service, and marketing processes to maintain a complete view of customer interactions.
Real-World Example
At their company, a business analyst at Clearwater Inc. leverages Preparation Recipe to improve how the organization tracks relationships and interactions. By setting up Preparation Recipe properly, the team gains better visibility into their customer base, which leads to more informed decisions and stronger customer relationships across the board.
Why Preparation Recipe Matters
A Preparation Recipe in Salesforce is a set of data transformation steps used within CRM Analytics (formerly Tableau CRM) to clean, shape, and prepare data before it's loaded into a dataset for analysis. Think of it as an ETL (Extract, Transform, Load) pipeline configured through a visual interface. It can filter rows, rename columns, compute new fields, join data from multiple sources, and handle missing values. This matters because raw CRM data is often messy — fields may be inconsistently formatted, records may contain duplicates, and key metrics may need to be calculated from multiple fields before they're useful for dashboards and reports.
As organizations grow their analytics practice, preparation recipes become the foundation of data quality and consistency. Without standardized preparation steps, different teams may build dashboards using slightly different data transformations, leading to conflicting metrics and eroded trust in analytics. A well-designed preparation recipe ensures that every dashboard consuming a particular dataset uses identically cleaned and transformed data. Organizations that neglect their preparation recipes often discover discrepancies between reports — such as two dashboards showing different revenue numbers — which undermines executive confidence in data-driven decision-making.
How Organizations Use Preparation Recipe
- DataStream Analytics — DataStream Analytics uses a preparation recipe to combine Opportunity data with custom Activity metrics and Account firmographic details into a single enriched dataset. The recipe filters out test records, standardizes currency fields to USD, and calculates a 'deal velocity' metric by dividing deal value by days in pipeline. This unified dataset powers their executive sales dashboard.
- ClearView Healthcare — ClearView Healthcare created a preparation recipe that merges patient Case records with provider Account data and satisfaction survey responses. The recipe anonymizes personal health information by hashing patient identifiers and aggregates satisfaction scores by provider and region, enabling HIPAA-compliant analytics dashboards for quality improvement teams.
- OrbitLogistics — OrbitLogistics built a preparation recipe that joins shipment records from a custom object with weather API data stored in an external connection. The recipe calculates average delivery delays by region and season, allowing operations managers to visualize delay patterns and proactively adjust routing during historically problematic weather windows.