Territory Management in CRM Analytics

Territory Management in CRM Analytics
Data security has always been critical. And sometimes it becomes difficult to align business processes and the data security model. To be honest, I realized this was the case with some of our users who were struggling with implementing Territory Management in CRM Analytics. This was a cue for me to write this blog. Now, ...

Flag to clean with Salesforce Data Pipelines

Flag to clean with Salesforce Data Pipelines
Are you a Salesforce admin or Salesforce owner and get requests that “those contacts are not clean”? There are probably duplicates, information that hasn’t been completed, or maybe you haven’t actually touched or worked with this contact in more than a year. If you use this data for your marketing campaigns then it becomes important ...

Multi-level Account Hierarchy: Flatten, Aggregate, Join, Transform and Report!

Multi-level Account Hierarchy: Flatten, Aggregate, Join, Transform and Report!
In this use case, we will discuss how to leverage Recipes, hierarchical aggregations, and transformations in CRM Analytics to help a company “CRM Test Inc.” which has a complex multi-level account hierarchy in Salesforce without having a holistic view of all their accounts and child records (such as related opportunities, activities or any other custom ...

What’s New in Data Prep for Summer ’22?

What’s New in Data Prep for Summer ’22?
The Summer ‘22 release is here!  And we’re excited that you get to try out all the new Data Prep features that we’ve been working on! See a demo of everything that’s new in these short video clips, directly from the team! Multi-value functions Eric shows us the new multi-value functions: split, array_join, array_contains, size, ...

Abra Cadabra, Dataflows to Recipes!

Abra Cadabra, Dataflows to Recipes!
Do you love how simple it is to join, cleanse, and enrich your data using Data Prep Recipes, and wish you can transform all of your TCRM dataflows to recipes? But there are just too many of them and you don’t have time for all that work? Even more, perhaps you have these massive, spaghetti-looking ...

Demystifying Dates in Recipes

Demystifying Dates in Recipes
If you’ve been doing date manipulations using the Date/DateTime functions in recipes, you may have come across these validation error messages: Or you swear you had created a “Date” field in a dataset, but it changed to “Date Time” magically somehow. Or you find yourself balling up your fists, incredulous at how difficult it is ...