Start Processing : 2025-06-24 11:53:02
0 rows affecteddelete from db_advertising_google where _adID = ''
[1] 0.01 seconds -> 0 rows affected
UPDATE db_advertising_google SET _dateTS = STR_TO_DATE(_day, '%m/%d/%Y') WHERE _dateTS IS NULL
[2] 0.02 seconds -> 0 rows affected
UPDATE db_advertising_google SET _dateTS = STR_TO_DATE(_day, '%e/%c/%Y') WHERE _dateTS IS NULL
[5] 0 seconds -> 0 rows affected
UPDATE IGNORE db_advertising_google SET _dateTS = _day WHERE _dateTS IS NULL
[10] 0 seconds -> 0 rows affected
UPDATE db_advertising_google SET _impressions = REPLACE(_impressions, '\'','')
[20] 0 seconds -> 0 rows affected
UPDATE db_advertising_google SET _impressions = REPLACE(_impressions, ''','')
[22] 0 seconds -> -1 rows affected
UPDATE db_advertising_google SET _impressions = REPLACE(_impressions, ',','')
[25] 0 seconds -> 0 rows affected
UPDATE db_advertising_google SET _cpm = _cost/_impressions*1000 WHERE _cost >0 AND _impressions > 0
[30] 0 seconds -> 0 rows affected
UPDATE db_advertising_google SET _cpc= _cost/_clicks WHERE _cost >0 AND _clicks > 0
[40] 0 seconds -> 0 rows affected
INSERT INTO dashboard_ad_performance (_adID,_date,_platform,_spent,_impressions,_clicks,_cpm,_cpc) SELECT _adID, _dateTS, 'Google' , _cost, _impressions, _clicks, _cpm, _cpc FROM db_advertising_google WHERE LENGTH(_adID)>0 ON DUPLICATE KEY UPDATE _spent = VALUES(_spent),_impressions = VALUES(_impressions),_clicks = VALUES(_clicks),_cpm = VALUES(_cpm),_cpc = VALUES(_cpc)
[60] 0.14 seconds -> 0 rows affected
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
[80] 0.05 seconds -> 0 rows affected