Start Processing : 2025-03-15 01:38:52<BR>0 rows affectedupdate wk_existing_opps
set _segment =
case 
    when _campaignName like '%LB-BlackKnight%' then 'Large Bank BK'
    when _campaignName like '%LB-nCino%' then 'Large Bank NC'
    when _campaignName like '%SB%' then 'Small Bank'
    when _campaignName like '%NSLead CPM%' then 'CPM 2022'
    when _campaignName LIKE '%DigitalZone CPM%' THEN 'CPM 2022'
    when _campaignName like '%-CPM' then 'CPM'
    when _campaignName LIKE '%NSLead Banking EBQ' then 'CRA Focus'
    when _campaignName LIKE '%ABM Banking%' then 'CRA Focus'
    when _campaignName LIKE '%Banking CRA 1%' then 'CRA Focus'
    when _campaignName LIKE '%Banking CRA 2%' then 'CRA Focus 2'
    when _campaignName LIKE '%EMEA%' THEN 'EMEA'
    when _campaignName LIKE '%ABM CPM%' THEN 'CPM 2022'
    when _campaignName LIKE '%AM-CS-WC Lien Solar%' THEN 'Solar'
    else ''
end<BR>[5] 0 seconds -> 0 rows affected<BR>update eoriginal.wk_existing_opps
set _accountName = 'BancorpSouth, Inc.', _accountID = '0013800001LmgeX'
where _accountName = 'Cadence Bank' && _accountID = '0015000000qa4Sb'<BR>[7] 0 seconds -> 0 rows affected<BR>update wk_existing_opps
set _accountID = '0015000000qa4iu'
where _accountID = '0015000000qa0Oq'<BR>[10] 0 seconds -> 0 rows affected<BR>update wk_existing_opps
set _accountID = '0013800001LmZtu'
where _accountID = '0013800001LmqDB'<BR>[20] 0 seconds -> 0 rows affected<BR>update wk_accounts a
inner join 
wk_existing_opps b
on a._accountID = b._accountID
set a._currentPipelineStage = b._stage<BR>[30] 2.84 seconds -> 27 rows affected<BR>update wk_accounts
set _currentPipelineStage = '' where _currentPipelineStage is null<BR>[40] 0.01 seconds -> 0 rows affected<BR>update wk_accounts
set _cPS = 
case
when _currentPipelineStage = 'Learn/engage' then 1
when _currentPipelineStage = 'Opportunity Development' then 2
when _currentPipelineStage = 'Proposal' then 3
when _currentPipelineStage = 'Negotiate' then 4
when _currentPipelineStage = 'Contract/Legal Process' then 5
when _currentPipelineStage = 'Closed Won' then 6
when _currentPipelineStage = 'Closed Lost' then 0
when _currentPipelineStage = 'Duplicate' then 0
when _currentPipelineStage = 'Dormant' then 0
else 0
END<BR>[50] 0.03 seconds -> 14 rows affected<BR>update wk_accounts
set _pipelineMovement = _cPS - _iPS<BR>[60] 0.06 seconds -> 14 rows affected<BR>update wk_accounts a
inner join 
wk_existing_opps b
on a._accountID = b._accountID
set a._amount = b._opportunityAmount;<BR>[70] 3.18 seconds -> 25 rows affected<BR>update wk_accounts
set _amount = '' where _amount is null;<BR>[80] 0.03 seconds -> 0 rows affected<BR>