Start Processing : 2024-09-20 02:52:54<BR>0 rows affectedUPDATE db_hubspot_campaign_mql d, db_tam_contacts_list m
SET d._persona = m._persona, d._seniority = m._jobHierarchy, d.`_industry` = m.`_accountIndustry`
WHERE d._email = m._email<BR>[1] 0.04 seconds -> 0 rows affected<BR>UPDATE db_hubspot_campaign_mql SET `_persona` = 'Marketing' 
WHERE `_jobTitle` LIKE '%Marketing%' AND `_persona` IS NULL OR `_persona` = ''<BR>[10] 0 seconds -> 0 rows affected<BR>UPDATE db_hubspot_campaign_mql SET `_persona` = 'Digital' 
WHERE  (`_jobTitle` LIKE '%digital%' OR `_jobTitle` LIKE '%technology%') AND `_persona` IS NULL OR `_persona` = ''<BR>[20] 0 seconds -> 0 rows affected<BR>UPDATE db_hubspot_campaign_mql SET `_persona` = 'Operations' 
WHERE  (`_jobTitle` LIKE '%operations%' OR `_jobTitle` LIKE '%operating%' OR `_jobTitle` LIKE '%operational%')  AND `_persona` IS NULL OR `_persona` = ''<BR>[30] 0 seconds -> 0 rows affected<BR>UPDATE db_hubspot_campaign_mql SET `_persona` = 'Innovation' 
WHERE  (`_jobTitle` LIKE '%Innovation%' OR `_jobTitle` LIKE '%innovations%' OR `_jobTitle` LIKE '%operational%' OR `_jobTitle` LIKE '%innovative%')  AND `_persona` IS NULL OR `_persona` = ''<BR>[40] 0 seconds -> 0 rows affected<BR>UPDATE db_hubspot_campaign_mql SET `_persona` = 'Experience' 
WHERE  (`_jobTitle` LIKE '%experience%' OR `_jobTitle` LIKE '%engagement%' OR `_jobTitle` LIKE '%client%' OR `_jobTitle` LIKE '%customer%') AND `_persona` IS NULL OR `_persona` = ''<BR>[59] 0 seconds -> 0 rows affected<BR>