Start Processing : 2025-05-08 16:14:35
0 rows affectedUPDATE db_6sense_3x_campaign_performance_newer SET _campaignID = CASE WHEN _dataType = 'Campaign' THEN _6senseID ELSE NULL END;
[20] 0.1 seconds -> 0 rows affected
UPDATE db_6sense_3x_campaign_performance_newer SET _adID = CASE WHEN _dataType IN ('Ad group', 'Ad') THEN _6senseID ELSE '-' END;
[40] 0.06 seconds -> 0 rows affected
UPDATE db_6sense_3x_campaign_performance_newer SET _campaignID = (@n := COALESCE(_campaignID, @n)) ORDER BY _id;
[60] 0.35 seconds -> 13035 rows affected