Start Processing : 2024-09-20 03:03:05<BR>0 rows affectedUPDATE db_ad_linkedin SET _linkClicks= '0' WHERE LENGTH(_linkClicks)=0<BR>[1] 0.21 seconds -> 0 rows affected<BR>INSERT INTO db_ad_performance (_adID,_date,_platform,_spent,_impressions,_clicks) SELECT _adID, STR_TO_DATE(_startDate, '%m/%d/%Y'), 'LinkedIn',_totalSpent,_impressions,_clicks FROM db_ad_linkedin ON DUPLICATE KEY UPDATE _spent = VALUES(_spent), _impressions = VALUES(_impressions), _clicks = VALUES(_clicks)<BR>[20] 0.48 seconds -> 0 rows affected<BR>UPDATE
	db_ad_performance p,
	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.27 seconds -> 0 rows affected<BR>UPDATE db_ad_performance SET _cpm = _spent/_impressions*1000 WHERE _impressions > 0<BR>[40] 0.01 seconds -> 0 rows affected<BR>UPDATE db_ad_performance SET _cpc= _spent/_clicks WHERE _clicks > 0<BR>[50] 0.01 seconds -> 0 rows affected<BR>INSERT INTO relaynew.lookup_campaigndownloads (_date, _campaign,_sourcemedium, _uniqueDownloads)
SELECT
	DATE_FORMAT(a.`_timestamp`, '%Y-%m-%d'),
	b.`_campaign` AS '_campaign',
	a.`_utm_medium` AS '_sourcemedium',
	COUNT(DISTINCT(_email)) '_ct'
FROM
	relaynew.w_lead_downloads a, relaynew.db_airtable_ads b
WHERE
	a.`_download_url`  = b.`_landingPageURL`
	AND _email NOT LIKE '%test%'
	AND _email NOT LIKE '%2x.marketing%'
	AND _email NOT LIKE '%relaynetwork%'
	AND `_routable_status` LIKE '%paid%'
GROUP BY
	DATE_FORMAT(_timestamp, '%Y-%m-%d') DESC,
	_campaign, _sourcemedium
ON DUPLICATE KEY UPDATE _uniqueDownloads = VALUES(_uniqueDownloads)<BR>[60] 1.46 seconds -> 0 rows affected<BR>UPDATE relaynew.lookup_campaigndownloads a, relaynew.w_lead_downloads b
SET a.`_source` = LOWER(SUBSTR(b.`_routable_status`,12)),
	a.`_medium` = 'paidsocial'
WHERE a.`_date` = DATE_FORMAT(b.`_timestamp`, '%Y-%m-%d')  AND a.`_sourcemedium` = b.`_routable_status`<BR>[70] 2.06 seconds -> 0 rows affected<BR>UPDATE
	relaynew.db_ad_performance d
INNER JOIN (
	SELECT
		_date,
		_source,
		_medium,
		_campaign,
		_uniqueDownloads
	FROM
		relaynew.lookup_campaigndownloads) z SET
	d._downloads = z._uniqueDownloads
WHERE
	d._date = z._date
	AND d._campaign = z._campaign
	AND d._source = z._source
	AND d._medium = z._medium<BR>[80] 0.11 seconds -> 0 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>[100] 0.13 seconds -> 0 rows affected<BR>