Data transform
Configure how Nektar maps your engagement data into Salesforce fields using transform rules and formulae.
This feature cannot be configured from the console yet. Contact us to set it up.
To write Nektar Graph data to Salesforce, it must be transformed to match your Salesforce data model. This is accomplished using transform rules, which use formulae to calculate the values of Salesforce fields.
When you set Nektar up, a few default transform rules are configured for you. You can edit these, and also add new rules to instruct Nektar to populate additional Salesforce custom or standard fields.
Transformable objects
All objects written by Nektar into Salesforce are transformable. The transform system classifies objects into two kinds: Activity objects and Record objects.
Activity objects
These consist of Events and Tasks. Activity transform formulae can refer to:
- fields of the Nektar Graph Activity node (e.g. date and time, subject and body etc.)
- the list of buyers and sellers associated with the activity, with basic information
- the record (account, opportunity, etc.) that the activity is associated with.
These formulae CANNOT access:
- the history of changes to the record that the activity is associated with
- other activities that are also associated with the same record / buyer / seller as the one being processed
Important note
- The information about the associated record, buyers and sellers available to activity transform formulae are the latest known information, NOT the information that existed as of the date of the activity.
- Transforms don’t just happen one time when we first sync the activity; these formulae are re-evaluated continuously, just like Excel formulae.
As a result, if an activity transform formula refers to a field from the associated record (say StageName), and that field is updated on Salesforce, the formula will be re-evaluated and its new output written to that Event or Task on Salesforce.
Record objects
These consist of Opportunities, Accounts, Contacts and Leads. Record transform rules can refer to:
- fields of the record itself (if it already exists on Salesforce)
- the list of activities associated with the record, with basic information
- the list of buyers and sellers associated with the record, with basic information
- the history of edits made to the record (e.g. stage changes), as tracked by Salesforce