Re: Lead Scoring / Formula Fields

Nicole_Woodley
Level 2

Lead Scoring / Formula Fields

I need to create a Logic as follows: Example: Field: CCVE Behaviour Score Field: CCVE Demographic Score Field: CCVE Lead Score I want to do the following: IF CCVE Behaviour Score greater than 100 AND IF CCVE Demographic Score greater than 100 Give the CCVE Lead Score Field the Value: B3

3 REPLIES 3
Matt_Tonkin-RP
Level 2

Re: Lead Scoring / Formula Fields

One way you could accomplish this if the LetterNumber rank is likely to change often is using a segment and then a smart campaign to adjust the field value.

So you apply the correct scores for each segment rank (assuming A-D and 1-4 or something like this) then have a trigger smart campaign on the segment change that populates the Lead Score.

Nicole_Woodley
Level 2

Re: Lead Scoring / Formula Fields

Thank you for that Idea I will try this.

 

 

SanfordWhiteman
Level 10 - Community Moderator

Re: Lead Scoring / Formula Fields

As written, this simply sounds like 2 AND filters in a Smart List. Wouldn't appear to need a segmentation.  If anything, the filters available in a segment's Smart List are more restrictive than the filters you get in a standard batch campaign.