Start Processing : 2026-01-27 19:53:42
0 rows affectedUPDATE db_6sense_3x_campaign_performance_newer
SET _campaignID =
CASE
WHEN _dataType = 'Campaign' THEN _6senseID
ELSE NULL
END;
[20] 0.93 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.6 seconds -> 0 rows affected
UPDATE db_6sense_3x_campaign_performance_newer
SET _campaignID = (@n := COALESCE(_campaignID, @n))
ORDER BY _id;
[60] 5.29 seconds -> 13035 rows affected