Updating Leads

As well as inserting new leads the lead injector also allows user to update existing leads.

If your external data source returns a column 'njAction' then the contents of that field will be used to control how the lead is applied to the system.

Valid values for njAction are:

  • ADD
  • MODIFY
  • REALLOCATE

njAction: Add

The Add action inserts a fresh lead into an Allocation applying the standard de-duplication of leads based on the leads phone number(s). An njAction of 'Add' has the same affect as providing a lead with no njAction column (e.g. its a fresh lead).

If you want to later modify or reallocate this lead then you must specify a unique value for the column njExternalLeadId.

njAction: Modify

Looks for an existing lead that has matching value for the field 'njExternalLeadId' and updates the lead.

When a lead is updated essentially a new call record is added (accessible from the Call Editor) and a new disposition is applied. 

When modifying a lead you MUST provide the column njDisposition and specify the leads new disposition.

When modifying a lead you MUST provide the column njExternalLeadId and provide the correct value to match the original lead.

If you Modify a phone field de-duplication will NOT be applied. So be careful!

Disposition Actions

Any Dispositon Actions associated with the new Disposition (via the value in njDispositon) WILL be triggered .

njAction: Reallocate

Dispositions the matching lead and copies the lead to a new allocation as a fresh lead.

When the njAction is Reallocated you MUST provide the njAllocationName field.

No Change

When modifying a lead or Reallocating the lead you may not want to update some field values. You can do this by providing the field column in the data source but provide a field value with '<No Change>'. For these fields the current value for that field in the lead will not be changed.

Example Data set returned to the Injector

phone Surname njExternalLeadId NjAction njDisposition njCallBackDate njAllocationName
<No Change>   1 MODIFY SALE    
<No Change> <No Change> 2 MODIFY SALE    
<No Change> sutton 3 REALLOCATE SALE 2016/12/31 14:23:00 a15-2
383208134 <No Change> 4 MODIFY SALE    
383208135 Smith 5 MODIFY SALE    
383208112 <No Change> 6 MODIFY Call Back 2016/12/25 03:15:00  
<No Change> Thomson 7 MODIFY SALE    
<No Change> <No Change> 8 MODIFY busy    
123 Johnston 9 MODIFY SALE    
<No Change> Davies 10 MODIFY SALE