Start Processing : 2024-09-20 02:58:38<BR>0 rows affectedUPDATE azalea.db_hubspot_form_leads d, azalea.w_routables m
SET d._jobFunction = m._function, d._seniority = m._seniority, d._companyName = m._companyName 
WHERE d._email = m._email<BR>[1] 0.36 seconds -> 39 rows affected<BR>UPDATE azalea.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 azalea.db_hubspot_form_leads SET `_displaySource` = 'Content Syndication' 
WHERE `_recentConversion` LIKE '%Content Syn%'<BR>[6] 0.01 seconds -> 0 rows affected<BR>UPDATE azalea.db_hubspot_form_leads SET _jobFunction = 'Executive' WHERE (_jobTitle LIKE '%Executive Officer%' OR _jobTitle LIKE '%CEO%')<BR>[10] 0.04 seconds -> 7 rows affected<BR>UPDATE azalea.db_hubspot_form_leads SET _seniority = 'C-Level' WHERE (_jobTitle LIKE '%CEO%' OR _jobTitle LIKE '%CFO%' OR _jobTitle LIKE '%Chief%')<BR>[12] 0.04 seconds -> 21 rows affected<BR>UPDATE azalea.db_hubspot_form_leads SET _seniority = 'Manager' WHERE _jobTitle LIKE '%Manager%'<BR>[14] 0.02 seconds -> 25 rows affected<BR>UPDATE azalea.db_hubspot_form_leads SET _seniority = 'Director' WHERE _jobTitle LIKE '%Director%'<BR>[20] 0.03 seconds -> 15 rows affected<BR>UPDATE azalea.db_hubspot_form_leads SET _seniority = 'VP' WHERE (_jobTitle LIKE '%VP%' OR _jobTitle LIKE '%Vice President%')<BR>[22] 0.03 seconds -> 26 rows affected<BR>UPDATE azalea.w_lead_downloads SET _seniority = 'Others' WHERE LENGTH(_seniority) = 0<BR>[26] 0.26 seconds -> 395 rows affected<BR>INSERT
	IGNORE
INTO
	azalea.w_lead_downloads (_datasource,
	_ld_id,
	_email,
	`_download_title`,
	_routable_status,
	_timestamp)
SELECT
	'Hubspot-MQL-2021',
	_contactID,
	_email,
	_recentConversion,
	_displaySource,
	STR_TO_DATE(`_recentConversionDate`, '%Y-%m-%d %H:%i:%s')
FROM
	azalea.db_hubspot_form_leads
WHERE 
        `_email` NOT LIKE '%2x.marketing%' 
        AND `_email` NOT LIKE '%azalea%'
	AND `_recentConversionDate` > 0
	AND `_displaySource` !='';<BR>[29] 0.34 seconds -> 0 rows affected<BR>INSERT
	IGNORE
INTO
	azalea.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
	azalea.db_hubspot_campaign_mql 
WHERE
	`_recentConversionDate` > 0
        AND `_email` NOT LIKE '%2x.marketing%' 
        AND `_email` NOT LIKE '%azalea%'<BR>[33] 0.44 seconds -> 0 rows affected<BR>UPDATE
	azalea.w_lead_downloads d,
	azalea.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 = NULL;<BR>[39] 0 seconds -> 0 rows affected<BR>UPDATE
	azalea.w_lead_downloads d,
	azalea.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 = NULL;<BR>[45] 0 seconds -> 0 rows affected<BR>UPDATE azalea.w_lead_downloads e, azalea.w_routables d
SET 	e._seniority = d._seniority, 
	e._persona = d._function
WHERE e._email = d._email<BR>[50] 0.25 seconds -> 405 rows affected<BR>UPDATE w_lead_downloads p, db_hubspot_campaign_mql e 
SET p._utm_campaign = e._contentDownloaded 
WHERE p._email = e._email<BR>[55] 0.02 seconds -> 0 rows affected<BR>