Start Processing : 2024-09-20 02:41:44<BR>0 rows affectedINSERT
	IGNORE
INTO
db_mailchimp_combined (_activityID,
	_email,
	_type,
	_campaignCode,
	_datetime,
	_logo)
SELECT
	_id,
	_emailAddress,
	'sends',
	_campaignID,
	STR_TO_DATE(_sendTime,
	'%Y-%m-%d %H:%i:%s'),
	_logo
FROM
	db_mailchimp_email_sent
WHERE
	_emailAddress NOT REGEXP '2x.marketing|sunfig|terrasmart'
	AND `_status` = 'sent'
	AND _campaignID IN (SELECT _pardotID FROM db_airtable_email);<BR>[5] 0.02 seconds -> -1 rows affected<BR>INSERT
	IGNORE
INTO
db_mailchimp_combined (_activityID,
	_email,
	_type,
	_campaignCode,
	_datetime,
	_logo)
SELECT
	_id,
	_emailAddress,
	'opens',
	_campaignID,
	STR_TO_DATE(_timestamp,
	'%Y-%m-%dT%H:%i:%s'),
	_logo
FROM
	db_mailchimp_email_activity
WHERE
	_emailAddress NOT REGEXP '2x.marketing|sunfig|terrasmart'
	AND `_action` = 'open'
	AND _campaignID IN (SELECT _pardotID FROM db_airtable_email);<BR>[10] 0 seconds -> -1 rows affected<BR>INSERT
	IGNORE
INTO
db_mailchimp_combined (_activityID,
	_email,
	_type,
	_campaignCode,
	_url,
	_datetime,
	_logo)
SELECT
	_id,
	_emailAddress,
	'clicks',
	_campaignID,
	_url,
	STR_TO_DATE(_timestamp,
	'%Y-%m-%dT%H:%i:%s'),
	_logo
FROM
	db_mailchimp_email_activity
WHERE
	_emailAddress NOT REGEXP '2x.marketing|sunfig|terrasmart'
	AND `_action` = 'click'	
	AND _campaignID IN (SELECT _pardotID FROM db_airtable_email);<BR>[20] 0 seconds -> -1 rows affected<BR>INSERT
	IGNORE
INTO
db_mailchimp_combined (_activityID,
	_email,
	_type,
	_campaignCode,
	_bounceType,
	_datetime,
	_logo)
SELECT
	_id,
	_emailAddress,
	'bounce',
	_campaignID,
	_type,
	STR_TO_DATE(_timestamp,
	'%Y-%m-%dT%H:%i:%s'),
	_logo
FROM
	db_mailchimp_email_activity
WHERE
	_emailAddress NOT REGEXP '2x.marketing|sunfig|terrasmart'
	AND `_action` = 'bounce'
	AND _campaignID IN (SELECT _pardotID FROM db_airtable_email);<BR>[30] 0 seconds -> -1 rows affected<BR>INSERT
	IGNORE
INTO
db_mailchimp_combined (_activityID,
	_email,
	_type,
	_campaignCode,
	_unsubscribesReason,
	_datetime,
	_logo)
SELECT
	_id,
	_emailAddress,
	'unsubscribes',
	_campaignID,
	_reason,
	STR_TO_DATE(_timestamp,
	'%Y-%m-%dT%H:%i:%s'),
	_logo
FROM
	db_mailchimp_email_unsubscribes
WHERE
	_emailAddress NOT REGEXP '2x.marketing|sunfig|terrasmart'
	AND _campaignID IN (SELECT _pardotID FROM db_airtable_email);<BR>[40] 0 seconds -> -1 rows affected<BR>UPDATE IGNORE db_mailchimp_combined SET _unixtime = UNIX_TIMESTAMP(_datetime)<BR>[45] 0.06 seconds -> 0 rows affected<BR>INSERT
	INTO
	w_lead_downloads
SELECT NULL, _datasource, _ld_id, _lead_id, _prospectNativeID, _first_name, _last_name, _email, _company,
	_job_title, _persona, _classification, _address, _city, _state, _zip, _country, _website, _salesRep,
	_seniority, _industry, _revenue, _revenueClass, _employee, _phone, _download, _download_title,
	_download_url, _url_param, _utm_source, _utm_medium, _utm_campaign, _utm_content, _lead_ip, _timestamp,
	_routable_status, _routable_updated, _is_first_dl, _is_sent, 'Sunfig' AS _logo
FROM w_lead_downloads_sunfig;<BR>[50] 0.06 seconds -> -1 rows affected<BR>