Dive into Marketing Cloud Intelligence Formulas with insights on JavaScript syntax, date parsing, and field references for seamless data …
Here are highlights from article Mastering Marketing Cloud Intelligence Part 1: Unveiling Formula Secrets – The Spot
1. Formula Syntax with JavaScript:
– Intelligence platform allows for Excel-like formulas and variations of formula work using MVEL, a Java-based language.
– You can use lowercase ‘ifs’ in JavaScript to write if statements without needing to define a false condition.
– Lowercase ‘ifs’ can improve performance compared to uppercase IF statements.
2. Parsing Dates:
– Intelligence formulas can parse dates using the toDate() function.
– You can specify the format of the date string using the ‘format’ parameter in the toDate() function.
3. Referencing CSV/Data Model Fields and When to Use Each Syntax:
– You can reference CSV fields using the column name wrapped in double curly brackets, like {{column_name}}.
– Data model fields can be referenced using double square brackets, like [[data_model_field]].
– CSV fields are useful for importing data from external sources, while data model fields are more useful for working with data already in the Intelligence platform.
4. Formula Fears – Goodbye!:
– Intelligence formulas can be intimidating, but understanding the syntax and available functions can help alleviate fears.
– Salesforce provides an overview of formula governance and basics to help get started.
5. What’s on the Horizon?:
– The blog post goes beyond the basics of the Intelligence platform to uncover hidden formula secrets.
– Areas covered include formula syntax with JavaScript, parsing dates, referencing CSV and data model fields, and overcoming formula fears.
You can read it here: https://sfdc.blog/tkOWy
Source from thespotforpardot(dot)com