Start Processing : 2024-09-20 02:59:22<BR>0 rows affectedUPDATE db_opportunity SET _ARR = _MRR * 12 WHERE LENGTH(_MRR)>0<BR>[1] 0.27 seconds -> 0 rows affected<BR>UPDATE db_opportunity SET _createTS = STR_TO_DATE(_createdDate, '%m/%d/%Y') , _closeTS= STR_TO_DATE(_closeDate, '%m/%d/%Y')<BR>[3] 0.05 seconds -> 0 rows affected<BR>UPDATE db_opportunity SET _createDT = UNIX_TIMESTAMP(_createTS), _closeDT = UNIX_TIMESTAMP(_closeTS)<BR>[5] 0.08 seconds -> 0 rows affected<BR>UPDATE db_opportunity SET _fiscalPeriod = CONCAT(YEAR(_closeTS),'-','Q',QUARTER(_closeTS))<BR>[10] 0.09 seconds -> 0 rows affected<BR>UPDATE db_opportunity SET _weighted = _ARR * _probability/100, _isActive = 0<BR>[15] 0.17 seconds -> 379 rows affected<BR>UPDATE db_opportunity d INNER JOIN (SELECT _accountID, MIN(_closeDT) '_dt' FROM db_opportunity WHERE _probability = 100 GROUP BY _accountID ) o SET d._firstDeal = 1 WHERE d._accountID = o._accountID AND d._closeDT = o._dt<BR>[20] 0.1 seconds -> 0 rows affected<BR>UPDATE db_opportunity d INNER JOIN (SELECT _accountID, MIN(_closeDT) '_dt' FROM db_opportunity WHERE _probability = 100 GROUP BY _accountID ) o SET d._firstDeal = 0 WHERE d._accountID = o._accountID AND d._closeDT > o._dt<BR>[30] 0.06 seconds -> 0 rows affected<BR>UPDATE db_opportunity o, db_account a SET o._accountIndustry = a._industry, o._accountSubIndustry = a._subIndustry, o._accountDomain = REPLACE(REPLACE(REPLACE(a._website,'www.',''),'https://','http://'),'http://','') WHERE o._accountID = a._accountID<BR>[40] 1.2 seconds -> 0 rows affected<BR>UPDATE db_opportunity SET _isActive = 1 WHERE _stage NOT IN ('Prospect','Contract Won','Closed Lost')<BR>[50] 0.15 seconds -> 379 rows affected<BR>UPDATE db_opportunity SET _bucket = 'Sales' WHERE _primaryCampaignSource LIKE '%Sales%' OR LENGTH(_primaryCampaignSource)=0 OR _primaryCampaignSource LIKE '%BDR%'<BR>[60] 0.24 seconds -> 11 rows affected<BR>UPDATE db_opportunity SET _bucket = 'Marketing' WHERE _primaryCampaignSource = 'Sales Email Inbound' OR _primaryCampaignSource = '2X Content Download'<BR>[70] 0.13 seconds -> 11 rows affected<BR>UPDATE db_opportunity SET _marketingCategory = 'Website' WHERE _bucket = 'Marketing' AND _primaryCampaignSource IN ('Drift','SEO','SEM','Direct','Sales Email Inbound','Marketing Referral','Sponsored Content','Email Marketing')<BR>[80] 0.01 seconds -> 0 rows affected<BR>UPDATE db_opportunity SET _marketingCategory = 'Event' WHERE _bucket = 'Marketing' AND _primaryCampaignSource LIKE '%Event%'<BR>[90] 0.06 seconds -> 0 rows affected<BR>UPDATE db_opportunity SET _marketingCategory = 'Campaign' WHERE _bucket = 'Marketing' AND _primaryCampaignSource IS NULL<BR>[100] 0 seconds -> 0 rows affected<BR>UPDATE db_opportunity SET _primaryCampaignSource = 'Inbound, Drift' WHERE _primaryCampaignSource = 'Drift'<BR>[110] 0 seconds -> 0 rows affected<BR>UPDATE db_opportunity SET _primaryCampaignSource = 'Event - Dotblue 2018' WHERE _primaryCampaignSource = 'Dotblue 2018'<BR>[120] 0 seconds -> 0 rows affected<BR>UPDATE db_opportunity SET _primaryCampaignSource = 'Marketing-Enabled Sales Outreach' WHERE _bucket = 'Sales'<BR>[130] 0.08 seconds -> 0 rows affected<BR>UPDATE db_activity a INNER JOIN (SELECT _opportunityID, _stage, _opportunityName, _primaryCampaignSource,_ARR FROM db_opportunity) o SET a._stage = o._stage, _sfdcName = _opportunityName, _sfdcType = 'Opportunity',_campaignSource = o._primaryCampaignSource, a._ARR = o._ARR WHERE a._sfdcName IS NULL AND a._sfdcID = o._opportunityID<BR>[140] 6.66 seconds -> 0 rows affected<BR>