Start Processing : 2024-09-20 02:26:52<BR>0 rows affected<BR>[1] 0.14 seconds -> 0 rows affected<BR>INSERT
	IGNORE
INTO
	db_hubspot_campaign_data (_activityID,
	_email,
	_type,
	_utm_campaign,
	_datetime,
	_source)
SELECT
	_id,
	_recipient,
	'sends',
	_campaignName,
	STR_TO_DATE(_eventCreatedDateYourTimeZone,
	'%m/%d/%Y %H:%i'),
	'Hubspot' AS _source
FROM
	db_hubspot_campaign
WHERE
	_recipient NOT REGEXP '2x.marketing|digitalhands|muneetam|student.curtin|osama.tahir'
	AND `_eventType` = 'DELIVERED'
	AND _campaignName IN (SELECT _code FROM db_airtable_email)
	AND _batchID IN (SELECT _batchID FROM atom_queue WHERE _started >= CURDATE() - INTERVAL 1 DAY);<BR>[10] 0.14 seconds -> -1 rows affected<BR>INSERT
	IGNORE
INTO
	db_hubspot_campaign_data (_activityID,
	_email,
	_type,
	_utm_campaign,
	_datetime,
	_source)
SELECT
	_id,
	_recipient,
	'opens',
	_campaignName,
	STR_TO_DATE(_eventCreatedDateYourTimeZone,
	'%m/%d/%Y %H:%i'),
	'Hubspot' AS _source
FROM
	db_hubspot_campaign
WHERE
	_recipient NOT REGEXP '2x.marketing|digitalhands|muneetam|student.curtin|osama.tahir'
	AND `_eventType` = 'OPEN'
	AND _campaignName IN (SELECT _code FROM db_airtable_email)
	AND _batchID IN (SELECT _batchID FROM atom_queue WHERE _started >= CURDATE() - INTERVAL 1 DAY);<BR>[20] 0 seconds -> -1 rows affected<BR>INSERT
	IGNORE
INTO
	db_hubspot_campaign_data (_activityID,
	_email,
	_type,
	_utm_campaign,
	_datetime,
	_source,
	_url)
SELECT
	_id,
	_recipient,
	'clicks',
	_campaignName,
	STR_TO_DATE(_eventCreatedDateYourTimeZone,
	'%m/%d/%Y %H:%i'),
	'Hubspot' AS _source,
	_clickUrl
FROM
	db_hubspot_campaign
WHERE
	_recipient NOT REGEXP '2x.marketing|digitalhands|muneetam|student.curtin|osama.tahir'
	AND `_eventType` = 'CLICK'
	AND _campaignName IN (SELECT _code FROM db_airtable_email)
	AND _batchID IN (SELECT _batchID FROM atom_queue WHERE _started >= CURDATE() - INTERVAL 1 DAY);<BR>[30] 0 seconds -> -1 rows affected<BR>INSERT
	IGNORE
INTO
	db_hubspot_campaign_data (_activityID,
	_email,
	_type,
	_utm_campaign,
	_datetime,
	_source,
        _bounceReason)
SELECT
	_id,
	_recipient,
	'bounce',
	_campaignName,
	STR_TO_DATE(_eventCreatedDateYourTimeZone,
	'%m/%d/%Y %H:%i'),
	'Hubspot' AS _source,
        _bounceMessage
FROM
	db_hubspot_campaign_
WHERE
	_recipient NOT REGEXP '2x.marketing|digitalhands|muneetam|student.curtin|osama.tahir'
	AND `_eventType` = 'BOUNCE'
	AND _campaignName IN (SELECT _code FROM db_airtable_email)
	AND _batchID IN (SELECT _batchID FROM atom_queue WHERE _started >= CURDATE() - INTERVAL 1 DAY);<BR>[40] 0 seconds -> -1 rows affected<BR>INSERT
	IGNORE
INTO
	db_hubspot_campaign_data(_activityID,
	_email,
	_type,
	_utm_campaign,
	_datetime,
	_source)
SELECT
	_id,
	_recipient,
	'unsubscribes',
	_campaignName,
	STR_TO_DATE(_eventCreatedDateYourTimeZone,
	'%m/%d/%Y %H:%i'),
	'Hubspot' AS _source
FROM
	db_hubspot_campaign
WHERE
	_recipient NOT REGEXP '2x.marketing|digitalhands|muneetam|student.curtin|osama.tahir'
	AND `_eventType` = 'STATUSCHANGE'
	AND _campaignName IN (SELECT _code FROM db_airtable_email)
	AND _batchID IN (SELECT _batchID FROM atom_queue WHERE _started >= CURDATE() - INTERVAL 1 DAY);<BR>[50] 0 seconds -> -1 rows affected<BR>UPDATE IGNORE db_hubspot_campaign_data SET _unixtime = UNIX_TIMESTAMP(_datetime)<BR>[60] 0 seconds -> -1 rows affected<BR>