Start Processing : 2025-03-15 01:42:28<BR>0 rows affectedUPDATE db_hubspot_form_leads d, w_routables m
SET d._jobFunction = m._function, d._seniority = m._seniority, d._companyName = m._companyName 
WHERE d._email = m._email<BR>[1] 0.3 seconds -> 23 rows affected<BR>UPDATE db_hubspot_form_leads SET `_displaySource` = 'Email' 
WHERE `_leadSource` = '2x Demand Gen' AND `_displaySource` IS NULL<BR>[5] 0 seconds -> 0 rows affected<BR>UPDATE db_hubspot_form_leads SET `_displaySource` = 'Content Syndication' 
WHERE `_recentConversion` LIKE '%Content Syn%'<BR>[6] 0.02 seconds -> 0 rows affected<BR>UPDATE hrsoft.db_hubspot_form_leads SET _jobFunction = 'Human Resource' WHERE (_jobTitle LIKE '%Human Resources%' OR _jobTitle LIKE '%HR%')<BR>[10] 0.02 seconds -> 2 rows affected<BR>UPDATE hrsoft.db_hubspot_form_leads SET _jobFunction = 'Executive' WHERE (_jobTitle LIKE '%Executive Officer%' OR _jobTitle LIKE '%CEO%')<BR>[12] 0.03 seconds -> 1 rows affected<BR>UPDATE hrsoft.db_hubspot_form_leads SET _jobFunction = 'Accounting & Finance' WHERE (_jobTitle LIKE '%Financial%' OR _jobTitle LIKE '%CFO%')<BR>[14] 0 seconds -> 0 rows affected<BR>UPDATE hrsoft.db_hubspot_form_leads SET _seniority = 'C-Level' WHERE (_jobTitle LIKE '%CEO%' OR _jobTitle LIKE '%CFO%' OR _jobTitle LIKE '%Chief%')<BR>[20] 0.02 seconds -> 5 rows affected<BR>UPDATE hrsoft.db_hubspot_form_leads SET _seniority = 'Manager' WHERE _jobTitle LIKE '%Manager%'<BR>[21] 0.02 seconds -> 4 rows affected<BR>UPDATE hrsoft.db_hubspot_form_leads SET _seniority = 'Director' WHERE _jobTitle LIKE '%Director%'<BR>[22] 0.01 seconds -> 6 rows affected<BR>UPDATE hrsoft.db_hubspot_form_leads SET _seniority = 'VP' WHERE (_jobTitle LIKE '%VP%' OR _jobTitle LIKE '%Vice President%')<BR>[23] 0.02 seconds -> 27 rows affected<BR>UPDATE hrsoft.w_lead_downloads SET _persona = 'Others' WHERE LENGTH(_persona) = 0<BR>[25] 0.02 seconds -> 0 rows affected<BR>UPDATE hrsoft.w_lead_downloads SET _seniority = 'Others' WHERE LENGTH(_seniority) = 0<BR>[27] 0.01 seconds -> 0 rows affected<BR>INSERT
	IGNORE
INTO
	hrsoft.w_lead_downloads (_datasource,
	_ld_id,
	_email,
	`_download_title`,
	_routable_status,
	_timestamp)
SELECT
	'Hubspot-MQL-2021',
	_contactID,
	_email,
	_contentDownloaded,
	_displaySource,
	STR_TO_DATE(`_recentConversionDate`, '%Y-%m-%d %H:%i:%s')
FROM
	hrsoft.db_hubspot_form_leads
WHERE 
        `_email` NOT LIKE '%2x.marketing%' 
        AND `_email` NOT LIKE '%hrsoft%'
	AND `_recentConversionDate` > 0
	AND `_displaySource` !='';<BR>[30] 0.08 seconds -> 0 rows affected<BR>INSERT
	IGNORE
INTO
	hrsoft.w_lead_downloads (_datasource,
	_ld_id,
	_email,
	`_download_title`,
	_routable_status,
	_timestamp)
SELECT
	'Hubspot-MQL-2021',
	_contactID,
	_email,
	_recentConversion,
	'Email',
	STR_TO_DATE(`_recentConversionDate`, '%Y-%m-%d %H:%i:%s')
FROM
	hrsoft.db_hubspot_campaign_mql 
WHERE
	`_recentConversionDate` > 0
        AND `_email` NOT LIKE '%2x.marketing%' 
        AND `_email` NOT LIKE '%hrsoft%'<BR>[35] 0.01 seconds -> 0 rows affected<BR>UPDATE
	hrsoft.w_lead_downloads d,
	hrsoft.db_hubspot_form_leads m
SET
	d._first_name = m.`_firstName` ,
	d._last_name = m.`_lastName` ,
	d.`_whyTargeted` = m.`_lifecycleStage`,
	d._email = m.`_email` ,
	d._company = m.`_companyName` ,
	d._job_title = m.`_jobTitle`,
	d.`_persona` = m.`_jobFunction`, 
	d.`_seniority` = m.`_seniority`,
	d.`_city` = m.`_city`,
	d.`_state` = m.`_stateregion`,
	d.`_industry` = m.`_industry`,
	d.`_phone` = m.`_phoneNumber`,
	d.`_utm_medium` = m.`_displaySource`,
	d.`_utm_content` = m.`_leadSource` 
WHERE
	d._datasource = 'Hubspot-MQL-2021'
	AND d._ld_id = m.`_contactID`
	AND d.`_timestamp` = m.`_recentConversionDate`
        AND d._company IS NULL;<BR>[40] 0 seconds -> 0 rows affected<BR>UPDATE
	hrsoft.w_lead_downloads d,
	hrsoft.db_hubspot_campaign_mql m 
SET
	d._first_name = m.`_firstName` ,
	d._last_name = m.`_lastName` ,
	d.`_whyTargeted` = m.`_lifecycleStage`,
	d._company = m.`_companyName` ,
	d._job_title = m.`_jobTitle`,
	d.`_city` = m.`_city`,
	d.`_state` = m.`_stateregion`,
	d.`_industry` = m.`_industry`,
	d.`_utm_campaign` = m.`_contentDownloaded`,
	d.`_utm_content` = m.`_leadSource`
WHERE
	d._datasource = 'Hubspot-MQL-2021'
	AND d.`_first_name` IS NULL
	AND d._ld_id = m.`_contactID` 
	AND d.`_timestamp` = m.`_recentConversionDate`
        AND d._company IS NULL;<BR>[45] 0 seconds -> 0 rows affected<BR>UPDATE hrsoft.w_lead_downloads e, hrsoft.w_routables d
SET 	e._seniority = d._seniority, 
	e._persona = d._function
WHERE e._email = d._email<BR>[50] 0.01 seconds -> 0 rows affected<BR>UPDATE w_lead_downloads p, db_hubspot_campaign_mql e SET p._utm_campaign = e._2X_utm_campaign WHERE p._email = e._email<BR>[55] 0.01 seconds -> 0 rows affected<BR>UPDATE w_lead_downloads p, db_hubspot_form_leads e SET p._utm_campaign = e._2X_utm_campaign WHERE p._email = e._email<BR>[60] 3 seconds -> 0 rows affected<BR>