Re: Lead Scoring / Formula Fields

Nicole_Woodley
Level 2

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
SanfordWhiteman
Level 10 - Community Moderator

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.

Matt_Tonkin-RP
Level 2

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

Thank you for that Idea I will try this.