Start Processing : 2025-03-15 11:53:17<BR>0 rows affectedUPDATE db_advertising_facebook SET _dateTS = _day WHERE _dateTS IS NULL<BR>[10] 0.01 seconds -> 0 rows affected<BR>UPDATE db_advertising_facebook SET _linkClicks = '0' WHERE LENGTH(_linkClicks)=0<BR>[15] 0 seconds -> 0 rows affected<BR>UPDATE db_advertising_facebook SET _cpm = _amountSpentUsd/_impressions*1000 WHERE _amountSpentUsd>0 AND _impressions > 0<BR>[40] 0 seconds -> 0 rows affected<BR>UPDATE db_advertising_facebook SET _cpc= _amountSpentUsd/_linkClicks WHERE _amountSpentUsd>0 AND _linkClicks > 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, 'Facebook' , _amountSpentUsd, _impressions, _linkClicks, _cpm, _cpc FROM db_advertising_facebook 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.01 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>[70] 0.02 seconds -> 0 rows affected<BR>