Lead scoring in Salesforce Marketing Cloud
Tags: salesforce, tutorial, beginning, coding
Published: 2019-12-02 12:05:11

---
title:  Lead scoring in Salesforce Marketing Cloud
published: true
date: 2019-05-10 09:41:41 UTC
tags: Salesforce, tutorial, beginning, coding
canonical_url: https://www.girikon.com/blog/girikons-salesforce-consultants-provide-some-on-their-learnings-on-lead-scoring-in-salesforce-marketing-cloud/
---

Girikon’s **[Salesforce Consulting Services](https://www.girikon.com.au/salesforce-consultant/)**team are certified and experienced with both Pardot and Salesforce Marketing Cloud. They have a depth of knowledge about both automated marketing solutions and have many insights to share.

Pardot and Salesforce Marketing Cloud are both marketing automation solutions where Pardot can be seen as a tool, Salesforce Marketing Cloud is seen a comprehensive toolkit for Marketeers. Both Pardot and Salesforce Marketing Cloud both allow for a level of social media sharing through their tool/toolkit and both also grant a user access for building custom email campaigns.

Despite these similarities, Pardot and **[Salesforce Marketing Cloud](https://www.girikon.com/salesforce-marketing-cloud/)** have some differences including the Lead Scoring Model. does not include a lead scoring model however Pardot has default scoring functionality and model that allows for various prospect activities to be scored.In this Blog our Salesforce Consultant will endeavor to show a user how to generate lead scoring from Email based on [\_Sent], [\_Open] & [\_Click] Data Views.

**Data from [\_sent] , [\_open] & [\_click] by join operation in query to be saved in Data Extension ‘ DE\_1’ :**

Simple perform a Query and join these data view in a separate Data Extension based on your JobID.

          Ex:

```
                  from [\_sent] as a full JOIN [\_open] as b on a.[subscriberkey]= b.[subscriberkey] full join [\_click] as c on b.[subscriberkey] = c.[subscriberkey] Where a.[JobId] = < JobID >.
```

**For your reference**

: join syntax: https://www.w3schools.com/sql/sql\_join.asp.[![Data](https://www.girikon.com/wp-content/uploads/2019/05/data-1024x386.png)](https://www.girikon.com/wp-content/uploads/2019/05/data.png)

**Create a Data Extension with default score value and save it in Data Extension ‘DE\_2’:**

Import a file containing subscriber key & Initial Score using Import wizard and save these records in separate Data Extension.

**Note:** At least match a few SubscriberKey with ‘DE\_1’ while creating import file.

[![data](https://www.girikon.com/wp-content/uploads/2019/05/data1-1024x392.png)](https://www.girikon.com/wp-content/uploads/2019/05/data1.png)

**Join the two Data (DE\_1 & DE\_2) Extensions and save it to third Data Extension (DE\_3):**

Using case Statement in Query increment or decrement your Initial Score and save it in ‘Updated Score’ field in the target Data Extension which I have mentioned below in figure (3.2). Along with join these two Data Extension and save it to the Third Data Extension using Query based on SubscriberKey.

```
Ex: CASE WHEN a.[< Column name >] IS NOT NULL THEN [Initial Score] + <num>
          ELSE [Initial Score]
          END AS [Updated Score] 
For reference: Case Statement : https://www.w3schools.com/sql/sql_case.asp.
</num>
```

**Create an Automation and Run the following Activities:**

[![data](https://www.girikon.com/wp-content/uploads/2019/05/data-2-1024x611.png)](https://www.girikon.com/wp-content/uploads/2019/05/data-2.png)

**After Running these Activities in Automation your records will be updated in Data Extension with updated score:**

[![data](https://www.girikon.com/wp-content/uploads/2019/05/data-3-1024x322.png)](https://www.girikon.com/wp-content/uploads/2019/05/data-3.png)


The post [Girikon’s Salesforce Consultants provide some on their learnings on Lead scoring in Salesforce Marketing Cloud](https://www.girikon.com/blog/girikons-salesforce-consultants-provide-some-on-their-learnings-on-lead-scoring-in-salesforce-marketing-cloud/) appeared first on [Salesforce Consulting Company | United States | Phoenix, Arizona](https://www.girikon.com/).