Start Processing : 2024-09-20 02:59:41<BR>0 rows affected<BR>[1] 0.2 seconds -> 0 rows affected<BR>UPDATE db_ad_facebook SET _uniqueLinkClicks = '0' WHERE LENGTH(_uniqueLinkClicks)=0<BR>[10] 0.58 seconds -> 0 rows affected<BR>INSERT INTO db_ad_performance (_adID,_date,_platform,_spent,_impressions,_clicks) SELECT LEFT(_adID,17), _day, 'Facebook',_amountSpentUsd,_impressions,_uniqueLinkClicks FROM db_ad_facebook ON DUPLICATE KEY UPDATE _spent = VALUES(_spent), _impressions = VALUES(_impressions), _clicks = VALUES(_clicks)<BR>[20] 2.78 seconds -> 812 rows affected<BR>UPDATE
	relaynew.db_ad_performance p,
	relaynew.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>[30] 0.3 seconds -> 0 rows affected<BR>