Skip to main content
Create a "Write" Connection To Salesforce

Optimize your CRM with predictive data—learn to connect, configure, and export Pecan insights directly to Salesforce

Ori Sagi avatar
Written by Ori Sagi
Updated over a week ago

In today’s data-driven landscape, integrating predictive analytics into your CRM can transform the way you engage with prospects and manage customer relationships.

This guide provides a comprehensive walkthrough on setting up a seamless connection between Pecan and Salesforce. By creating a dedicated object in Salesforce to house your prediction data, you'll be able to enhance decision-making processes and tailor your strategies to meet customer needs more effectively. Let’s dive into how you can unlock the full potential of your data with Pecan’s powerful predictive capabilities and Salesforce’s robust CRM environment:

Step 1: Create an object in Salesforce

To hold the prediction data. Under the object, create all the fields you’d like to export.
Pecan provides the following fields and types out of the box:

Field label

Field name

Data type

Actual

Actual__c

Text(255)

Classified As

Classified_as__c

Text(255)

Created By

Created_byId

Lookup(User)

Entity Id

Entity_id__c

Lookup(Opportunity)

Last Modified By

LastModifiedById

Lookup(User)

Marker

Marker__c

Date/Time

Owner

OwnerId

Lookup(User,Group)

Pecan Result Name

Name

Text(80)

Probability

Probability__c

Number(16,2)


Step2: Create a connection with Salesforce

Now, you are ready to create a new "Write" type connection to Salesforce. make sure the “ongoing predictions” option is selected:

Step 3: Configure the prediction export settings

Go to the predictive flow you want to use, and click the "Predict" tab at the top.

There, under “Output configuration” make sure you select the new salesforce connection you created. In the field "Destination path" below, fill the name of the Salesforce object you’d like to write to (Pecan__c in the example):

Step 4: Format your output query

Click “Format Output Query (optional)”:


Then, select the relevant columns from the prediction you’d like to export. The predictions are represented by the “RESULTS” table.
Make sure each selected column has the name of the field on Salesforce as an alias of the output query, for example:

SELECT

"entity_id' as id,

"Marker' as pecan_prediction_timestamp_c,

"O' as pecan_prediction_0_c,

"I' as pecan_prediction_1_c

FROM RESULTS

Thats it!

Here is a query that writes to the object Pecan__c in our my_salesforce connection the fields (id, pecan_prediction_timestamp_c, pecan_prediction_0_c, pecan_prediction_1_c):

If you'd like to schedule predictions so they will be sent automatically, please follow this guide.


Now that you’ve successfully configured your Salesforce integration with Pecan, you’re well on your way to leveraging advanced predictive insights within your CRM. This setup not only simplifies the management of predictive data but also enhances your ability to make informed, data-driven decisions swiftly.

Remember, the power of predictive analytics lies in its application, so start using these insights to refine your strategies and drive better business outcomes. If you have any questions or need further assistance as you explore the capabilities of your new setup, don’t hesitate to reach out. Embrace the power of integration and let your data lead the way to success!

Did this answer your question?