Start Processing : 2024-09-20 03:01:26<BR>0 rows affected<BR>[10] 0.33 seconds -> 0 rows affected<BR>UPDATE db_linkedin_ads_performance_2 SET _startDate = IF(_startDateInUTC LIKE '%/%', STR_TO_DATE(_startDateInUTC,'%m/%d/%Y'), STR_TO_DATE(_startDateInUTC,'%m-%d-%Y'))
 WHERE _startDate IS NULL;<BR>[20] 0.72 seconds -> 0 rows affected<BR>UPDATE db_linkedin_ads_performance_2 SET _spent = _totalSpent<BR>[30] 0.17 seconds -> 0 rows affected<BR>INSERT INTO dashboard_ads_performance (_adID, _startDate, _campaignName, _reach, _uniqueReach, _spent, _impressions, _clicks) 
SELECT _adID, _startDate , _campaignName, _reach, _uniqueReach , _spent, _impressions, _clicks 
  FROM db_linkedin_ads_performance_2 
 WHERE LENGTH(_adID)>0 ON DUPLICATE KEY 
UPDATE _spent = VALUES(_spent),_impressions = VALUES(_impressions),_clicks = VALUES(_clicks), _reach = VALUES(_reach),_uniqueReach = VALUES(_uniqueReach)<BR>[35] 1 seconds -> 0 rows affected<BR>UPDATE dashboard_ads_performance p, db_airtable_ads s 
        SET p._platform = s._platform, 
	       p._source = s._source,  
	       p._medium = s._medium, 
	       p._reportingGroup = s._reportingGroup, 
	       p._landingPageURL = s._landingPageURL,
	       p._adVariation =s._adVariation, 
	       p._screenshot = s._screenshot , 
	       p._liveDate = s._liveDate , 
	       p._status = s._status
 WHERE p._adID = s._adID<BR>[40] 0.2 seconds -> 0 rows affected<BR>