Start Processing : 2025-03-15 11:53:18<BR>0 rows affectedUPDATE db_hubspot_form_leads SET _contentDownloaded = SUBSTRING_INDEX(SUBSTRING_INDEX(_formFillUrl,'utm_campaign=',-1),'&',1) 
WHERE _formFillCampaign LIKE '%linkedin%'
		AND _contentDownloaded IS NULL<BR>[1] 0.01 seconds -> 0 rows affected<BR>UPDATE db_hubspot_form_leads SET _contentDownloaded = SUBSTRING_INDEX(_formFillUrl,'Downloaded: ',-1)
WHERE _formFillCampaign LIKE '%cs%'
		AND _contentDownloaded IS NULL<BR>[10] 0 seconds -> 0 rows affected<BR>UPDATE 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>[20] 0.07 seconds -> 44 rows affected<BR>UPDATE db_hubspot_form_leads SET _displaySource =
CASE WHEN _formFillCampaign LIKE '%mail%' THEN 'email'
	  WHEN _formFillCampaign LIKE '%linked%' THEN 'LinkedIn'
	  WHEN _formFillCampaign LIKE '%cs%' THEN 'Content Syndication' 
	  ELSE NULL END
WHERE _displaySource IS NULL<BR>[30] 0 seconds -> 0 rows affected<BR>UPDATE db_hubspot_form_leads SET _jobFunction = 'Executive' WHERE _jobTitle REGEXP 'Executive Officer|CEO'<BR>[40] 0 seconds -> 0 rows affected<BR>UPDATE db_hubspot_form_leads SET _seniority = 
CASE WHEN _jobTitle REGEXP 'CEO|CFO|Chief' THEN 'C-Level'
	  WHEN _jobTitle LIKE '%Manager%' THEN 'Manager'
	  WHEN _jobTitle LIKE '%Director%' THEN 'Director'
	  WHEN _jobTitle REGEXP 'VP|Vice President' THEN 'VP'
	  ELSE 'Others' END<BR>[50] 0.02 seconds -> 44 rows affected<BR>UPDATE db_hubspot_form_leads SET _utm_param = SUBSTRING_INDEX(_formFillUrl,'?',-1) WHERE _displaySource IS NOT NULL AND _displaySource != 'Content Syndication'<BR>[55] 0.01 seconds -> -1 rows affected<BR>INSERT
	IGNORE
INTO
	w_lead_downloads (_datasource,
	_ld_id,
	_email,
	_download_title,
	_routable_status,
        _utm_campaign,
	_timestamp)
SELECT
	'Hubspot-MQL-2021',
	_contactID,
	_email,
	_recentConversion,
	_displaySource,
        _contentDownloaded,
	STR_TO_DATE(`_recentConversionDate`, '%Y-%m-%d %H:%i:%s')
FROM
	db_hubspot_form_leads
WHERE 
        `_email` NOT REGEXP '2x.marketing|digitalhands|osama|student.curtin|ziyant'
	AND `_recentConversionDate` > 0
	AND `_displaySource` IS NOT NULL AND _displaySource != 'Content Syndication'<BR>[60] 0.02 seconds -> 0 rows affected<BR>INSERT
	IGNORE
INTO
	w_lead_downloads (_datasource,
	_ld_id,
	_email,
	_utm_source,
	_routable_status,
        _download_title,
	_timestamp)
SELECT
	'Hubspot-MQL-2021',
	_contactID,
	_email,
	_formFillCampaign,
	_displaySource,
        _contentDownloaded,
	STR_TO_DATE(`_recentConversionDate`, '%Y-%m-%d %H:%i:%s')
FROM
	db_hubspot_form_leads
WHERE 
        `_email` NOT REGEXP '2x.marketing|digitalhands|osama|student.curtin|ziyant'
	AND `_recentConversionDate` > 0
	AND `_displaySource` IS NOT NULL AND _displaySource = 'Content Syndication'<BR>[65] 0.02 seconds -> 0 rows affected<BR>UPDATE
	w_lead_downloads d,
	db_hubspot_form_leads m
SET
	d._first_name = m.`_firstName` ,
	d._last_name = m.`_lastName` ,
	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.`_phone` = m.`_phoneNumber`,
	d.`_utm_source` = 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
        AND m._displaySource != 'Content Syndication';<BR>[70] 0 seconds -> 0 rows affected<BR>UPDATE
	w_lead_downloads d,
	db_hubspot_form_leads m
SET
	d._first_name = m.`_firstName` ,
	d._last_name = m.`_lastName` ,
	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.`_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
        AND m._displaySource = 'Content Syndication';<BR>[75] 0 seconds -> 0 rows affected<BR>UPDATE w_lead_downloads e, w_routables d
SET 	e._seniority = d._seniority, 
	e._persona = d._function,
        e._industry = d._industry,
        e._job_title = d._title,
        e._phone = d._phone
WHERE e._email = d._email;<BR>[80] 0.22 seconds -> 17 rows affected<BR>UPDATE
	w_lead_downloads d,
	w_lead_downloads m
SET
	d._timestamp = m._timestamp
WHERE
	d._datasource = 'Hubspot-MQL-2021' AND 
	m._datasource = 'deposit' AND 
	d._email = m.`_email`AND 
	d._routable_status ='Content Syndication';<BR>[90] 0.03 seconds -> -1 rows affected<BR>UPDATE w_lead_downloads SET _download_title ='Are Your Web Apps Secure? Why Healthcare Organizations Need More Than Just Web Application Firewalls.' WHERE _download_title ='Are Your Web Apps Secure? Why Healthcare Organizations Need More Than Just Web Application Firewalls';<BR>[100] 0.01 seconds -> 0 rows affected<BR>