Start Processing : 2024-09-20 02:49:04
0 rows affectedDELETE FROM db_ad_google WHERE LENGTH(_adID)=0
[1] 0.02 seconds -> 0 rows affected
UPDATE db_ad_google SET _impressions = REPLACE(_impressions,''','')
[10] 0 seconds -> -1 rows affected
UPDATE db_ad_google SET _impressions = REPLACE(_impressions,',','')
[20] 0 seconds -> 0 rows affected
INSERT INTO db_ad_performance (_adID,_date,_platform,_spent,_impressions,_clicks) SELECT _adID, _day, 'Google',_cost,_impressions,_clicks FROM db_ad_google ON DUPLICATE KEY UPDATE _spent = VALUES(_spent), _impressions = VALUES(_impressions), _clicks = VALUES(_clicks)
[30] 0.37 seconds -> 0 rows affected
UPDATE db_ad_performance p, db_ad_summary s SET p._adType = s._adType, p._source = s._utmsource, p._medium = s._utmmedium, p._campaign = s._utmcampaign, p._content = s._utmcontent WHERE p._adID = s._adID AND p._platform = s._platform
[40] 0.03 seconds -> -1 rows affected