Start Processing : 2025-03-15 01:46:17<BR>0 rows affectedinsert ignore into wk_responder_table_interim (_campaignName, _leadID, _firstName, _lastName, _email, _companyAccount, _accountID, _leadStatus, _leadOwner, _createdDate, _lastModifiedBy, _lastModifiedDate, _webNotes)
select _campaignName, _contactID, _firstName, _lastName, _email, _accountName, _accountID, 'Contact' as _leadStatus, _contactOwner, _contactCreatedDate, _lastModifiedBy, _contactLastModifiedDate, _webNotes from wk_contacts_generated_abm<BR>[10] 6.75 seconds -> 0 rows affected<BR>update wk_responder_table_interim
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 '22.02%CPM%' then 'CPM 2022'
    when _campaignName LIKE '22.04%CPM%' then 'CPM 2022'
    when _campaignName LIKE '22.05%CPM%' then 'CPM 2022'
    when _campaignName LIKE '22.07-%CPM%' then 'CPM 2022'
    when _campaignName LIKE '22.09-%CPM%' then 'CPM 2022'
    when _campaignName LIKE '22.10-%CPM%' then 'CPM 2022'
    when _campaignName like '%-CPM' then 'CPM'
    when _campaignName like '%22.02-%Banking%' then 'CRA Focus'
    when _campaignName like '%EMEA%' then 'EMEA'
    when _campaignName like '%22.07-%Banking%' then 'CRA Focus 2'
    when _campaignName LIKE '22.08-%CRA 2%' then 'CRA Focus 2'
    when _campaignName LIKE '22.09-%CRA 2%' then 'CRA Focus 2'
    when _campaignName LIKE '22.09-%CRA 1%' then 'CRA Focus'
    when _campaignName LIKE '22.08-%CRA 1%' then 'CRA Focus'
    else ''
END<BR>[20] 1 seconds -> 0 rows affected<BR>