Start Processing : 2025-03-15 01:38:41<BR>0 rows affected<BR>[10] 0.11 seconds -> 0 rows affected<BR>INSERT
	IGNORE
INTO
	db_sib_combined (_activityID,
	_email,
	_type,
	_datetime,
	_campaignID)
SELECT
	MIN(_id),
	_emailID,
	'sends',
	MIN(STR_TO_DATE(`_deliveredDate` , '%d-%m-%Y %H:%i:%s')),
	_campaignID
FROM
	azalea.db_sib_campaign_data 
WHERE
	_deliveredDate !=''
	AND `_softBounceDate` =''
	AND _emailID NOT LIKE '%2x.marketing%'
	AND _emailID NOT LIKE '%test%'
	AND _emailID NOT LIKE '%azalea%'
GROUP BY _campaignID, _emailID<BR>[20] 0.35 seconds -> 0 rows affected<BR>INSERT
	IGNORE
INTO
	db_sib_combined (_activityID,
	_email,
	_type,
	_datetime,
	_campaignID)
SELECT
	MIN(_id),
	_emailID,
	'opens',
	MIN(STR_TO_DATE(`_openDate` , '%d-%m-%Y %H:%i:%s')),
	_campaignID
FROM
	azalea.db_sib_campaign_data 
WHERE
	`_openDate` !=''
	AND `_softBounceDate` =''
	AND _emailID NOT LIKE '%2x.marketing%'
	AND _emailID NOT LIKE '%test%'
	AND _emailID NOT LIKE '%azalea%'
GROUP BY _campaignID,  _emailID<BR>[30] 0.01 seconds -> 0 rows affected<BR>INSERT
	IGNORE
INTO
	db_sib_combined (_activityID,
	_email,
	_type,
	_datetime,
	_campaignID)
SELECT
	MIN(_id),
	_email,
	'clicks',
	MIN(`_dateEvent`),
	_campaignID
FROM
	db_sib_click
WHERE
	_email NOT LIKE '%2x.marketing%'
	AND _email NOT LIKE '%test%'
	AND _email NOT LIKE '%azalea%'
GROUP BY _campaignID, _email<BR>[35] 0.35 seconds -> 0 rows affected<BR>UPDATE db_sib_combined c 
INNER JOIN (SELECT _emailID, _email FROM map_download) o 
SET c._isBot = 0 WHERE c._campaignID = o._emailID AND c._email = o._email AND _type IN ('clicks', 'opens')<BR>[50] 0.05 seconds -> 0 rows affected<BR>INSERT IGNORE INTO db_bots_identifier (_email, _campaignCode, _deliveredDate)
SELECT _emailID, _campaignID, STR_TO_DATE(_deliveredDate, '%d-%m-%Y %H:%i:%s')
from db_sib_campaign_data;<BR>[55] 0.25 seconds -> 2480 rows affected<BR>UPDATE db_bots_identifier a
inner join db_sib_click b
on a._email = b._email AND a._campaignCode = b._campaignID
set a._clickDate = b._dateEvent;<BR>[60] 0.27 seconds -> 203 rows affected<BR>UPDATE db_bots_identifier a
inner join db_sib_open b
on a._email = b._email AND a._campaignCode = b._campaignID
set a._openDate = b._dateEvent;<BR>[65] 0.37 seconds -> 253 rows affected<BR>UPDATE db_bots_identifier SET _clickTimeDiff = _clickDate - _openDate where _clickDate is not null;<BR>[70] 0.1 seconds -> 203 rows affected<BR>UPDATE db_bots_identifier SET _timeDiff = _openDate - _deliveredDate<BR>[75] 0.02 seconds -> -1 rows affected<BR>UPDATE db_sib_combined SET `_isBot` = 1
WHERE `_type` IN ('opens', 'clicks') 
AND (`_email`, `_campaignCode`) IN (SELECT `_email`, `_campaignCode` FROM db_bots_identifier WHERE _clickTimeDiff <= 10)
AND `_isBot` != 1<BR>[83] 0 seconds -> -1 rows affected<BR>UPDATE db_sib_combined SET `_isBot` = 1
WHERE `_type` IN ('opens', 'clicks') 
AND (`_email`, `_campaignCode`) IN (SELECT `_email`, `_campaignCode` FROM db_bots_identifier WHERE _timeDiff <= 2)
AND `_isBot` != 1<BR>[87] 0 seconds -> -1 rows affected<BR>UPDATE db_sib_combined c INNER JOIN (SELECT _campaignID, _email, COUNT(DISTINCT _url)
FROM db_sib_click 
GROUP BY _campaignID,  _email
HAVING COUNT(DISTINCT _url) > 4) o SET c._isBot = 1 WHERE c._campaignID = o._campaignID and c._email = o._email<BR>[105] 0.09 seconds -> 0 rows affected<BR>INSERT INTO map_download (_prospectID, _downloadID, _datetime, _download_url, _url_param, _persona, _seniority,_download_title,_email,_utm_campaign, _utm_medium,_utm_source) SELECT _prospectNativeID, _id, _timestamp, _download_url,_url_param, _persona, _seniority, _download_title,_email, _utm_campaign, _utm_medium,_utm_source FROM w_lead_downloads WHERE _email NOT LIKE '%2x.marketing%' AND _email NOT LIKE '%test%' AND _email NOT LIKE '%kemberton%' AND _utm_source = 'email' AND LENGTH(_url_param)>0 ON DUPLICATE KEY UPDATE _prospectID = VALUES(_prospectID), _datetime = VALUES(_datetime), _download_url = VALUES(_download_url), _url_param = VALUES(_url_param), _persona = VALUES(_persona), _seniority = VALUES(_seniority), _download_title = VALUES(_download_title), _email = VALUES(_email),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source)<BR>[130] 0.01 seconds -> 0 rows affected<BR>UPDATE map_download m, w_routables r SET m._persona = r._persona, m._prospectID = r._token, m._classification = r._classification WHERE m._email = r._email<BR>[140] 0 seconds -> -1 rows affected<BR>UPDATE w_lead_downloads d, map_download m SET d._persona = m._persona WHERE d._id = m._downloadID<BR>[150] 0.01 seconds -> 125 rows affected<BR>UPDATE map_download SET _trimCode = REPLACE(REPLACE(REPLACE(REPLACE(_utm_campaign,'-',''),'_',''),'(',''),')','')<BR>[155] 0 seconds -> 0 rows affected<BR>UPDATE map_download m, db_airtable_email e SET m._emailID = e._pardotID WHERE m._trimCode = e._trimCode<BR>[160] 0 seconds -> -1 rows affected<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Board of Directors', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'Board of Directors'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Board of Directors'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Board of Directors', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'Board of Directors'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Board of Directors'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Board of Directors', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'Board of Directors'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Board of Directors'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'C-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'C-Level'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'C-Level'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'C-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'C-Level'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'C-Level'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'C-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'C-Level'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'C-Level'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'Director'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Director'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'Director'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Director'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'Director'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Director'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'Manager'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Manager'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'Manager'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Manager'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'Manager'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Manager'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Manager/Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'Manager/Director'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Manager/Director'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Manager/Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'Manager/Director'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Manager/Director'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Manager/Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'Manager/Director'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Manager/Director'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Non-Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'Non-Manager'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Non-Manager'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Non-Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'Non-Manager'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Non-Manager'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Non-Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'Non-Manager'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Non-Manager'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Other', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'Other'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Other'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Other', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'Other'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Other'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Other', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'Other'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Other'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Various', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'Various'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Various'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Various', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'Various'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Various'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Various', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'Various'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Various'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Vice President', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'Vice President'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Vice President'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Vice President', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'Vice President'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Vice President'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Vice President', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'Vice President'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'Vice President'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'VP', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'VP'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'VP'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'VP', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'VP'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'VP'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'VP', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'VP'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'VP'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'VP-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'VP-Level'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'VP-Level'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'VP-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'VP-Level'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'VP-Level'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'VP-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Chief Executive/President/Administrator'
			AND r._seniority = 'VP-Level'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Chief Executive/President/Administrator', 'VP-Level'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Board of Directors', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'Board of Directors'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Board of Directors'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Board of Directors', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'Board of Directors'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Board of Directors'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Board of Directors', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'Board of Directors'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Board of Directors'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'C-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'C-Level'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'C-Level'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'C-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'C-Level'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'C-Level'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'C-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'C-Level'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'C-Level'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'Director'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Director'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'Director'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Director'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'Director'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Director'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'Manager'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Manager'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'Manager'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Manager'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'Manager'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Manager'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Manager/Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'Manager/Director'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Manager/Director'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Manager/Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'Manager/Director'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Manager/Director'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Manager/Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'Manager/Director'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Manager/Director'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Non-Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'Non-Manager'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Non-Manager'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Non-Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'Non-Manager'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Non-Manager'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Non-Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'Non-Manager'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Non-Manager'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Other', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'Other'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Other'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Other', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'Other'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Other'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Other', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'Other'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Other'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Various', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'Various'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Various'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Various', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'Various'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Various'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Various', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'Various'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Various'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Vice President', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'Vice President'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Vice President'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Vice President', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'Vice President'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Vice President'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Vice President', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'Vice President'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'Vice President'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'VP', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'VP'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'VP'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'VP', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'VP'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'VP'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'VP', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'VP'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'VP'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'VP-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'VP-Level'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'VP-Level'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'VP-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'VP-Level'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'VP-Level'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'VP-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Other'
			AND r._seniority = 'VP-Level'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Other', 'VP-Level'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Board of Directors', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'Board of Directors'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Board of Directors'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Board of Directors', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'Board of Directors'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Board of Directors'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Board of Directors', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'Board of Directors'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Board of Directors'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'C-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'C-Level'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'C-Level'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'C-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'C-Level'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'C-Level'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'C-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'C-Level'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'C-Level'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'Director'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Director'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'Director'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Director'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'Director'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Director'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'Manager'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Manager'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'Manager'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Manager'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'Manager'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Manager'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Manager/Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'Manager/Director'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Manager/Director'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Manager/Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'Manager/Director'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Manager/Director'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Manager/Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'Manager/Director'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Manager/Director'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Non-Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'Non-Manager'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Non-Manager'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Non-Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'Non-Manager'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Non-Manager'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Non-Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'Non-Manager'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Non-Manager'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Other', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'Other'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Other'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Other', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'Other'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Other'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Other', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'Other'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Other'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Various', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'Various'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Various'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Various', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'Various'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Various'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Various', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'Various'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Various'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Vice President', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'Vice President'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Vice President'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Vice President', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'Vice President'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Vice President'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Vice President', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'Vice President'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'Vice President'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'VP', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'VP'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'VP'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'VP', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'VP'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'VP'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'VP', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'VP'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'VP'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'VP-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'VP-Level'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'VP-Level'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'VP-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'VP-Level'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'VP-Level'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'VP-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical/Quality/Care Management'
			AND r._seniority = 'VP-Level'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical/Quality/Care Management', 'VP-Level'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Board of Directors', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'Board of Directors'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Board of Directors'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Board of Directors', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'Board of Directors'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Board of Directors'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Board of Directors', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'Board of Directors'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Board of Directors'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'C-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'C-Level'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'C-Level'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'C-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'C-Level'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'C-Level'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'C-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'C-Level'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'C-Level'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'Director'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Director'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'Director'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Director'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'Director'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Director'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'Manager'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Manager'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'Manager'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Manager'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'Manager'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Manager'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Manager/Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'Manager/Director'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Manager/Director'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Manager/Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'Manager/Director'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Manager/Director'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Manager/Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'Manager/Director'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Manager/Director'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Non-Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'Non-Manager'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Non-Manager'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Non-Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'Non-Manager'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Non-Manager'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Non-Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'Non-Manager'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Non-Manager'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Other', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'Other'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Other'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Other', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'Other'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Other'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Other', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'Other'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Other'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Various', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'Various'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Various'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Various', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'Various'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Various'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Various', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'Various'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Various'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Vice President', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'Vice President'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Vice President'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Vice President', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'Vice President'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Vice President'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Vice President', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'Vice President'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'Vice President'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'VP', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'VP'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'VP'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'VP', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'VP'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'VP'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'VP', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'VP'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'VP'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'VP-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'VP-Level'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'VP-Level'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'VP-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'VP-Level'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'VP-Level'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'VP-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Medical (Doctor/Nurse/Physician)'
			AND r._seniority = 'VP-Level'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Medical (Doctor/Nurse/Physician)', 'VP-Level'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Board of Directors', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'Board of Directors'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Board of Directors'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Board of Directors', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'Board of Directors'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Board of Directors'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Board of Directors', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'Board of Directors'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Board of Directors'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'C-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'C-Level'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'C-Level'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'C-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'C-Level'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'C-Level'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'C-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'C-Level'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'C-Level'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'Director'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Director'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'Director'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Director'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'Director'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Director'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'Manager'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Manager'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'Manager'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Manager'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'Manager'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Manager'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Manager/Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'Manager/Director'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Manager/Director'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Manager/Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'Manager/Director'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Manager/Director'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Manager/Director', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'Manager/Director'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Manager/Director'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Non-Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'Non-Manager'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Non-Manager'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Non-Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'Non-Manager'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Non-Manager'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Non-Manager', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'Non-Manager'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Non-Manager'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Other', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'Other'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Other'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Other', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'Other'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Other'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Other', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'Other'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Other'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Various', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'Various'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Various'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Various', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'Various'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Various'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Various', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'Various'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Various'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Vice President', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'Vice President'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Vice President'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Vice President', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'Vice President'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Vice President'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Vice President', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'Vice President'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Vice President'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'VP', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'VP'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'VP'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'VP', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'VP'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'VP'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'VP', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'VP'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'VP'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'VP-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'VP-Level'
			AND _type IN ('sends')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'VP-Level'
			ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'VP-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'VP-Level'
			AND _type IN ('opens')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'VP-Level'
			ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
			SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'VP-Level', COUNT(DISTINCT(s._email))
			FROM db_sib_combined s, w_routables r 
			WHERE s._email = r._email
			AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
			AND r._function = 'Operations'
			AND r._seniority = 'VP-Level'
			AND _type IN ('clicks')
                        AND s._email NOT LIKE '%2x.marketing%'
                        AND s._email NOT LIKE '%azalea%'
			AND s._isBot = 0
			GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'VP-Level'
			ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','Board of Directors', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('Board of Directors')
		AND _type IN ('sends')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Board of Directors'
		ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','Board of Directors', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('Board of Directors')
		AND _type IN ('opens')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Board of Directors'
		ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','Board of Directors', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('Board of Directors')
		AND _type IN ('clicks')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Board of Directors'
		ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','C-Level', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('C-Level')
		AND _type IN ('sends')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'C-Level'
		ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','C-Level', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('C-Level')
		AND _type IN ('opens')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'C-Level'
		ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','C-Level', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('C-Level')
		AND _type IN ('clicks')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'C-Level'
		ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','Director', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('Director')
		AND _type IN ('sends')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Director'
		ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','Director', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('Director')
		AND _type IN ('opens')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Director'
		ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','Director', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('Director')
		AND _type IN ('clicks')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Director'
		ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','Manager', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('Manager')
		AND _type IN ('sends')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Manager'
		ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','Manager', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('Manager')
		AND _type IN ('opens')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Manager'
		ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','Manager', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('Manager')
		AND _type IN ('clicks')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Manager'
		ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','Manager/Director', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('Manager/Director')
		AND _type IN ('sends')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Manager/Director'
		ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','Manager/Director', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('Manager/Director')
		AND _type IN ('opens')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Manager/Director'
		ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','Manager/Director', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('Manager/Director')
		AND _type IN ('clicks')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Manager/Director'
		ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','Non-Manager', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('Non-Manager')
		AND _type IN ('sends')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Non-Manager'
		ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','Non-Manager', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('Non-Manager')
		AND _type IN ('opens')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Non-Manager'
		ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','Non-Manager', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('Non-Manager')
		AND _type IN ('clicks')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Non-Manager'
		ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','Other', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('Other')
		AND _type IN ('sends')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Other'
		ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','Other', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('Other')
		AND _type IN ('opens')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Other'
		ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','Other', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('Other')
		AND _type IN ('clicks')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Other'
		ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','Various', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('Various')
		AND _type IN ('sends')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Various'
		ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','Various', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('Various')
		AND _type IN ('opens')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Various'
		ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','Various', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('Various')
		AND _type IN ('clicks')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Various'
		ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','Vice President', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('Vice President')
		AND _type IN ('sends')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Vice President'
		ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','Vice President', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('Vice President')
		AND _type IN ('opens')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Vice President'
		ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','Vice President', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('Vice President')
		AND _type IN ('clicks')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'Vice President'
		ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','VP', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('VP')
		AND _type IN ('sends')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'VP'
		ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','VP', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('VP')
		AND _type IN ('opens')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'VP'
		ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','VP', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('VP')
		AND _type IN ('clicks')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'VP'
		ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _sends) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','VP-Level', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('VP-Level')
		AND _type IN ('sends')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'VP-Level'
		ON DUPLICATE KEY UPDATE _sends = VALUES(_sends)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _opens) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','VP-Level', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('VP-Level')
		AND _type IN ('opens')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'VP-Level'
		ON DUPLICATE KEY UPDATE _opens = VALUES(_opens)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _clicks) 
		SELECT DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Others','VP-Level', COUNT(DISTINCT(s._email))
		FROM db_sib_combined s, w_routables r 
		WHERE s._email = r._email
		AND DATE_FORMAT(_datetime, '%Y-%m-%d') >= '2025-02-12'
		AND r._function NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations')
		AND r._seniority IN ('VP-Level')
		AND _type IN ('clicks')
		AND s._isBot = 0
		GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _campaignID, 'Operations', 'VP-Level'
		ON DUPLICATE KEY UPDATE _clicks = VALUES(_clicks)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _downloads)  
(SELECT DATE_FORMAT(_datetime, '%Y-%m-%d') '_date', _emailID, _persona, _seniority, COUNT(DISTINCT(_email)) '_ct' FROM map_download WHERE _emailID > 0 AND _persona IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations') GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _emailID, _persona,_seniority) ON DUPLICATE KEY UPDATE _downloads = VALUES(_downloads)<BR>INSERT INTO dashboard_email_performance (_date, _emailID, _persona, _seniority, _downloads)  
(SELECT DATE_FORMAT(_datetime, '%Y-%m-%d') '_date', _emailID, 'Others', _seniority, COUNT(DISTINCT(_email)) '_ct' FROM map_download WHERE _emailID > 0 AND _persona NOT IN ('Chief Executive/President/Administrator','Other','Medical/Quality/Care Management','Medical (Doctor/Nurse/Physician)','Operations') GROUP BY DATE_FORMAT(_datetime, '%Y-%m-%d'), _emailID, 'Others',_seniority) ON DUPLICATE KEY UPDATE _downloads = VALUES(_downloads)<BR><BR>[170] 2.75 seconds -> 0 rows affected<BR>UPDATE dashboard_email_performance p, db_airtable_email e SET p._url = e._landingPage, p._subject = e._subject, p._screenshot = e._screenshot, p._title = e._code WHERE p._emailID = e._pardotID<BR>[178] 2.78 seconds -> 189 rows affected<BR>UPDATE dashboard_email_performance p, db_airtable_email s SET p._subject = s._subject, p._screenshot = s._screenshot, p._title = s._code, p._url = s._download_url WHERE p._emailID = s._pardotID<BR>[185] 0.02 seconds -> 189 rows affected<BR><BR>[195] 0.11 seconds -> 0 rows affected<BR>UPDATE dashboard_engagement_export e, w_routables r 
SET e._name = r._name, 
       e._whyTargeted = r._employees, 
       e._industry = r._industry, 
       e._companyName = r._companyName, 
       e._jobTitle = r._title, 
       e._revenue = r._revenueRange, 
       e._seniority = r._seniority, 
       e._persona = r._function, 
       e._metroArea = r._state, 
       e._phone = r._phone, 
       e._prospectID = r._token 
WHERE e._email = r._email<BR>[200] 0.24 seconds -> 0 rows affected<BR>UPDATE dashboard_engagement_export e, db_airtable_email s SET e._campaign = s._code, e._screenshot = s._screenshot WHERE  e._emailID = s._pardotID<BR>[205] 0.3 seconds -> 0 rows affected<BR>