Start Processing : 2024-09-20 02:43:02<BR>0 rows affectedUPDATE db_advertising_linkedin SET _dateTS = STR_TO_DATE(_startDateInUtc, '%m/%d/%Y') WHERE _dateTS IS NULL<BR>[10] 0.1 seconds -> 0 rows affected<BR>UPDATE db_advertising_linkedin SET _impressions = REPLACE(_impressions, '\'','')<BR>[20] 0 seconds -> 0 rows affected<BR>UPDATE db_advertising_linkedin SET _impressions = REPLACE(_impressions, ',','')<BR>[30] 0 seconds -> 0 rows affected<BR>UPDATE db_advertising_linkedin SET _cpm = _totalSpent/_impressions*1000 WHERE _totalSpent>0 AND _impressions > 0<BR>[40] 0.04 seconds -> 0 rows affected<BR>UPDATE db_advertising_linkedin SET _cpc= _totalSpent/_clicks WHERE _totalSpent>0 AND _clicks > 0<BR>[50] 0 seconds -> 0 rows affected<BR>INSERT INTO dashboard_ad_performance (_adID,_date,_platform,_spent,_impressions,_clicks,_cpm,_cpc) SELECT _adID, _dateTS, 'LinkedIn' , _totalSpent, _impressions, _clicks, _cpm, _cpc FROM db_advertising_linkedin WHERE LENGTH(_adID)>0 ON DUPLICATE KEY UPDATE _spent = VALUES(_spent),_impressions = VALUES(_impressions),_clicks = VALUES(_clicks),_cpm = VALUES(_cpm),_cpc = VALUES(_cpc)<BR>[60] 0.16 seconds -> 0 rows affected<BR>UPDATE dashboard_ad_performance p, db_airtable_ads s SET p._adType = s._adType, p._source = s._source, p._medium = s._medium, p._campaign = s._campaign, p._content = s._content WHERE p._adID = s._adID AND p._platform = s._platform<BR>[80] 0.09 seconds -> 0 rows affected<BR>INSERT INTO lookup_campaigndownloads (_date,_campaign, _uniqueDownloads) SELECT DATE_FORMAT(_timestamp,'%Y-%m-%d') '_date',_utm_campaign AS '_campaign', COUNT(DISTINCT(_email)) '_ct' FROM w_lead_downloads WHERE DATE_FORMAT(_timestamp,'%Y-%m-%d') != '0000-00-00' AND _email NOT LIKE '%test%' AND _email NOT LIKE '%2x.marketing%' AND _email NOT LIKE '%phoenix%' GROUP BY DATE_FORMAT(_timestamp,'%Y-%m-%d'),_utm_campaign ON DUPLICATE KEY UPDATE _uniqueDownloads = VALUES(_uniqueDownloads);<BR>[90] 0.28 seconds -> -1 rows affected<BR><BR>[100] 0.43 seconds -> 0 rows affected<BR>