https://api.airtable.com/v0/app8rwMuBWhGWFqN7/tblaT124MCIJhqy9W?view=viwRnBbYzj7ZxeRS9&filterByFormula={Ticker}%3C1440<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Participant-Education-Series_EM_2024-09-19_PCS_PESC_Early_EM-2-5PM','','','','','ParticipantEducationSeriesEM20240919PCSPESCEarlyEM25PM','','','','','','','') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Participant-Education-Series_EM_2024-09-19_PCS_PESC_Early_EM-2-5PM','','','','','ParticipantEducationSeriesEM20240919PCSPESCEarlyEM25PM','','','','','','','') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_23-11-14_PCS_EM-1','https://PCSRetirement.accountsvc.com/PSDG_VA','','','2023-11-14','PlanSponsorVirginiaLeadGen231114PCSEM1','','','','','226204','Form Submission','Plan Sponsor Demand Gen') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_23-12-12_PCS_EM-2A','https://pcsretirement.accountsvc.com/PSDG_VA_E2','','','2023-12-12','PlanSponsorVirginiaLeadGen231212PCSEM2A','','','','','233353','Form Submission','Plan Sponsor Demand Gen') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-01-04_PCS_EM-2B','https://pcsretirement.accountsvc.com/PSDG_VA_E2','','','2024-01-04','PlanSponsorVirginiaLeadGen240104PCSEM2B','','','','','237795','Form Submission','Plan Sponsor Demand Gen') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-01-09_PCS_EM-3A','https://pcsretirement.accountsvc.com/PSDG_VA_E3','','','2024-01-09','PlanSponsorVirginiaLeadGen240109PCSEM3A','','','','','238740','Form Submission','Plan Sponsor Demand Gen') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-01-23_PCS_EM-3B','https://pcsretirement.accountsvc.com/PSDG_VA_E3','','','2024-01-23','PlanSponsorVirginiaLeadGen240123PCSEM3B','','','','','241556','Form Submission','Plan Sponsor Demand Gen') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-02-06_PCS_EM-4A','https://PCSRetirement.accountsvc.com/PSDG_VA_E4','','','2024-02-06','PlanSponsorVirginiaLeadGen240206PCSEM4A','','','','','244550','Form Submission','Plan Sponsor Demand Gen') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-02-06_PCS_EM-4A','https://pcsretirement.accountsvc.com/PSDG_VA_E4','','','2024-02-06','PlanSponsorVirginiaLeadGen240206PCSEM4A','','','','','244550','Form Submission','Plan Sponsor Demand Gen') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-02-20_PCS_EM-4B','https://pcsretirement.accountsvc.com/PSDG_VA_E4','','','2024-02-20','PlanSponsorVirginiaLeadGen240220PCSEM4B','','','','','247444','Form Submission','Plan Sponsor Demand Gen') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-03-12_PCS_EM-1A ','https://pcsretirement.accountsvc.com/PSDG_VA','','','2024-03-12','PlanSponsorVirginiaLeadGen240312PCSEM1A ','','','','','251631','Form Submission','Plan Sponsor Demand Gen') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-03-19_PCS_EM-1B ','https://pcsretirement.accountsvc.com/PSDG_VA','','','2024-03-19','PlanSponsorVirginiaLeadGen240319PCSEM1B ','','','','','252701','Form Submission','Plan Sponsor Demand Gen') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-03-26_PCS_EM-2A ','https://pcsretirement.accountsvc.com/PSDG_VA_E2','','','2024-03-26','PlanSponsorVirginiaLeadGen240326PCSEM2A ','','','','','253752','Form Submission','Plan Sponsor Demand Gen') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-04-02_PCS_EM-2B ','https://pcsretirement.accountsvc.com/PSDG_VA_E2','','','2024-04-02','PlanSponsorVirginiaLeadGen240402PCSEM2B ','','','','','254985','Form Submission','Plan Sponsor Demand Gen') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-04-09_PCS_EM-3A ','https://pcsretirement.accountsvc.com/PSDG_VA_E3','','','2024-04-09','PlanSponsorVirginiaLeadGen240409PCSEM3A ','','','','','256379','Form Submission','Plan Sponsor Demand Gen') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-04-16_PCS_EM-3B ','https://pcsretirement.accountsvc.com/PSDG_VA_E3','','','2024-04-16','PlanSponsorVirginiaLeadGen240416PCSEM3B ','','','','','257875','Form Submission','Plan Sponsor Demand Gen') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-04-23_PCS_EM-4A','https://pcsretirement.accountsvc.com/PSDG_VA_E4','','','2024-04-23','PlanSponsorVirginiaLeadGen240423PCSEM4A','','','','','259063','Form Submission','Plan Sponsor Demand Gen') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-04-30_PCS_EM-4B','','','','2024-04-30','PlanSponsorVirginiaLeadGen240430PCSEM4B','','','','','260955','Form Submission','Plan Sponsor Demand Gen') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Plan_Sponsor_UT-CO_Lead_Gen_24-08-08_ABGC_EM-1','https://pcsretirement.accountsvc.com/PSDG_UT-CO','','','2024-08-08','PlanSponsorUTCOLeadGen240808ABGCEM1','','','','','280852','Form Submission','Plan Sponsor Demand Gen') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Plan_Sponsor_UT-CO_Lead_Gen_24-08-22_ABGC_EM-2','https://pcsretirement.accountsvc.com/PSDG_UT-CO','','','2024-08-22','PlanSponsorUTCOLeadGen240822ABGCEM2','','','','','282277','Form Submission','Plan Sponsor Demand Gen') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Plan_Sponsor_No-Advisor_Lead_Gen_24-08-29_PCS_EM-1','https://pcsretirement.accountsvc.com/Plan-Sponsor_Streamline-Your-Fiduciary-Obligations?','','','2024-08-29','PlanSponsorNoAdvisorLeadGen240829PCSEM1','','','','','283376','Form Submission\n','Plan Sponsor Demand Gen') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Plan_Sponsor_No-Advisor_Lead_Gen_24-09-10_PCS_EM-2','','','','2024-09-10','PlanSponsorNoAdvisorLeadGen240910PCSEM2','','','','','284774','Form Submission','Plan Sponsor Demand Gen') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Plan_Sponsor_UT-CO_Lead_Gen_24-09-12_ABGC_EM-3','https://pcsretirement.accountsvc.com/PSDG_UT-CO','','','2024-09-12','PlanSponsorUTCOLeadGen240912ABGCEM3','','','','','284974','Form Submission','Plan Sponsor Demand Gen') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('DG-Advisor-Warm-20240918_E4A','https://pcsretirement.accountsvc.com/take-your-client-to-new-height?','','','2024-09-18','DGAdvisorWarm20240918E4A','','','','','285760','Form Submission','Demand Generation') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('PEPC3_EM-10-Early_20240919','','','','2024-09-19','PEPC3EM10Early20240919','','','','','','','Participant Engagement') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('PEPC3_EM-10-Mid_20240919','','','','2024-09-19','PEPC3EM10Mid20240919','','','','','','','Participant Engagement') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('PEPC3_EM-10-End_20240919','','','','2024-09-19','PEPC3EM10End20240919','','','','','','','Participant Engagement') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('DG-Advisor-Warm-20240925_E4B','https://pcsretirement.accountsvc.com/take-your-client-to-new-height?','','','2024-09-25','DGAdvisorWarm20240925E4B','','','','','','Form Submission','Demand Generation') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Plan_Sponsor_UT-CO_Lead_Gen_24-09-26_ABGC_EM-4','https://pcsretirement.accountsvc.com/PSDG_UT-CO','','','2024-09-26','PlanSponsorUTCOLeadGen240926ABGCEM4','','','','','','Form Submission','Plan Sponsor Demand Gen') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Selling-Season-Series_EM_2024-10-03_EM-05','https://www.pcsretirement.com/about-us/sales-team#team=employer','','','2024-10-03','SellingSeasonSeriesEM20241003EM05','','','','','','','Selling Season') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('PEPC3_EM-11-Early_20241003','','','','2024-10-03','PEPC3EM11Early20241003','','','','','','','Participant Engagement') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('PEPC3_EM-11-Mid_20241003','','','','2024-10-03','PEPC3EM11Mid20241003','','','','','','','Participant Engagement') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('PEPC3_EM-11-End_20241003','','','','2024-10-03','PEPC3EM11End20241003','','','','','','','Participant Engagement') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('DG-Advisor-Warm-20241016_E5A','https://pcsretirement.accountsvc.com/take-your-client-to-new-height?','','','2024-10-16','DGAdvisorWarm20241016E5A','','','','','','Form Submission','Demand Generation') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Selling-Season-Series_EM_2024-10-17_EM-06','https://www.pcsretirement.com/about-us/sales-team#team=employer','','','2024-10-17','SellingSeasonSeriesEM20241017EM06','','','','','','','Selling Season') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('DG-Advisor-Warm-20241023_E5B','https://pcsretirement.accountsvc.com/take-your-client-to-new-height?','','','2024-10-23','DGAdvisorWarm20241023E5B','','','','','','Form Submission','Demand Generation') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('DG-Advisor-Warm-20241113_E6A','https://pcsretirement.accountsvc.com/take-your-client-to-new-height?','','','2024-11-13','DGAdvisorWarm20241113E6A','','','','','','Form Submission','Demand Generation') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('DG-Advisor-Warm-20241120_E6B','https://pcsretirement.accountsvc.com/take-your-client-to-new-height?','','','2024-11-20','DGAdvisorWarm20241120E6B','','','','','','Form Submission','Demand Generation') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Participant-Education-Series_EM_2024-09-19_PCS_PESC_Early_EM-2-5PM','','','','2024-09-19','ParticipantEducationSeriesEM20240919PCSPESCEarlyEM25PM','','','','','','','Participant Education Series') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Participant-Education-Series_EM_2024-09-19_PCS_PESC_Early_EM-2-8PM','','','','2024-09-19','ParticipantEducationSeriesEM20240919PCSPESCEarlyEM28PM','','','','','','','Participant Education Series') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Participant-Education-Series_EM_2024-09-19_PCS_PESC_Mid_EM-2-5PM','','','','2024-09-19','ParticipantEducationSeriesEM20240919PCSPESCMidEM25PM','','','','','','','Participant Education Series') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Participant-Education-Series_EM_2024-09-19_PCS_PESC_Mid_EM-2-8PM','','','','2024-09-19','ParticipantEducationSeriesEM20240919PCSPESCMidEM28PM','','','','','','','Participant Education Series') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Participant-Education-Series_EM_2024-09-19_PCS_PESC_End_EM-2-5PM','','','','2024-09-19','ParticipantEducationSeriesEM20240919PCSPESCEndEM25PM','','','','','','','Participant Education Series') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('Participant-Education-Series_EM_2024-09-19_PCS_PESC_End_EM-2-8PM','','','','2024-09-19','ParticipantEducationSeriesEM20240919PCSPESCEndEM28PM','','','','','','','Participant Education Series') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('PEPC3_EM-12-Early_20241017','','','','2024-10-17','PEPC3EM12Early20241017','','','','','','','Participant Engagement') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('PEPC3_EM-12-Mid_20241017','','','','2024-10-17','PEPC3EM12Mid20241017','','','','','','','Participant Engagement') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>INSERT INTO db_airtable_email (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_pardotID,_assetTitle,_rootCampaign) VALUES ('PEPC3_EM-12-End_20241017','','','','2024-10-17','PEPC3EM12End20241017','','','','','','','Participant Engagement') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_pardotID = VALUES(_pardotID),_assetTitle = VALUES(_assetTitle),_rootCampaign = VALUES(_rootCampaign)<BR>https://api.airtable.com/v0/app8rwMuBWhGWFqN7/tbllL7tTEj98nIvbh?view=viwez46ttbEKgZ6g7&filterByFormula={Ticker}%3C1440<BR>https://api.airtable.com/v0/app8rwMuBWhGWFqN7/tblM2GXmr193CPlnN?view=viwtwg6geIyjSDE60&filterByFormula={Ticker}%3C1440<BR>https://api.airtable.com/v0/app8rwMuBWhGWFqN7/tblaT124MCIJhqy9W?view=viwRnBbYzj7ZxeRS9&filterByFormula={Ticker}%3C1440<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Participant-Education-Series_EM_2024-09-19_PCS_PESC_Early_EM-2-5PM','','','','','ParticipantEducationSeriesEM20240919PCSPESCEarlyEM25PM','','','','','','','','','','','','','','','','','','','') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Participant-Education-Series_EM_2024-09-19_PCS_PESC_Early_EM-2-5PM','','','','','ParticipantEducationSeriesEM20240919PCSPESCEarlyEM25PM','','','','','','','','','','','','','','','','','','','') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_23-11-14_PCS_EM-1','https://PCSRetirement.accountsvc.com/PSDG_VA','Compliance notice: State-mandated retirement plans in Virginia','','2023-11-14','PlanSponsorVirginiaLeadGen231114PCSEM1','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-18]___Screenshot-2023-11-14-112939.png','','','','226204','Form Submission','','','','Is your business affected by these new requirements?','Plan Sponsor Lead Gen Virginia','','','','DG Plan Sponsor Virginia - Email 1','Plan Sponsor Demand Gen','18625','https://view.accountsvc.com/?qs=03f7de7db8cf24133e620ac5e78ee9c4d0486c88cd91bc688ba3f2027648253718aaef15512c16a5f996d7f7cdbc63a0fb3acff25394162f8283e0c7e3d53121b59bdef8068b0606b9c7caae3e6d82b1','Virginia PS DG') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_23-12-12_PCS_EM-2A','https://pcsretirement.accountsvc.com/PSDG_VA_E2','Can you offer better than the state mandate?','','2023-12-12','PlanSponsorVirginiaLeadGen231212PCSEM2A','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-18]___Screenshot-2023-11-14-113505.png','','','','233353','Form Submission','','','','The short answer: Yes. Find out inside','Plan Sponsor Lead Gen Virginia','','','','DG Plan Sponsor Virginia - Email 2A','Plan Sponsor Demand Gen','18626','https://view.accountsvc.com/?qs=02a0d51da3034e63d2c2eb2aded05d03fa0ea5db32c9a98035a11b7207927de242bdc3b205a6fbc27eb802bf592956176891baf4c721401a81c1222e1e0fa7117606e7e8023e75fcfe2912b39f602fbc','Virginia PS DG') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-01-04_PCS_EM-2B','https://pcsretirement.accountsvc.com/PSDG_VA_E2','Virginia employers: Can you beat the state mandate?','','2024-01-04','PlanSponsorVirginiaLeadGen240104PCSEM2B','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-18]___image.png','','','','237795','Form Submission','','','','The short answer: Yes. Find out inside','Plan Sponsor Lead Gen Virginia','','','','DG Plan Sponsor Virginia - Email 2B','Plan Sponsor Demand Gen','19339','https://view.accountsvc.com/?qs=6e21df899bf231eae237384e433580e80faea131ba104dad1f231910349420d25d7acc9c20fc0b01d7f045608799a4b138db8379e2250c7eec304611a10284dd140062fab13fd686','Virginia PS DG') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-01-09_PCS_EM-3A','https://pcsretirement.accountsvc.com/PSDG_VA_E3','Looking to recoup retirement plan costs?','','2024-01-09','PlanSponsorVirginiaLeadGen240109PCSEM3A','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-18]___Screenshot-2023-11-14-114006.png','','','','238740','Form Submission','','','','It’s a win-win if you partner with us','Plan Sponsor Lead Gen Virginia','','','','DG Plan Sponsor Virginia - Email 3A','Plan Sponsor Demand Gen','18627','https://view.accountsvc.com/?qs=558d5f2d29720130786840c14592183597c3fd25355e153ba7626089102a6416f627b1d44613b0d43f522e8c2bfa44c47dd9dc79c2cc15ba90ef1341f53128c45f8be27e4ef9b96375b5b9cfc27b8c30','Virginia PS DG') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-01-23_PCS_EM-3B','https://pcsretirement.accountsvc.com/PSDG_VA_E3','Employee retirement plans: Get more for less?','','2024-01-23','PlanSponsorVirginiaLeadGen240123PCSEM3B','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-18]___Plan_Sponsor_Virginia_Lead_Gen_24-01-23_PCS_EM-3B.jpeg','','','','241556','Form Submission','','','','It’s a win-win if you partner with us','Plan Sponsor Lead Gen Virginia','','','','DG Plan Sponsor Virginia - Email 3B','Plan Sponsor Demand Gen','19340','https://view.accountsvc.com/?qs=558d5f2d29720130786840c14592183597c3fd25355e153ba7626089102a6416f627b1d44613b0d43f522e8c2bfa44c47dd9dc79c2cc15ba90ef1341f53128c45f8be27e4ef9b96375b5b9cfc27b8c30','Virginia PS DG') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-02-06_PCS_EM-4A','https://PCSRetirement.accountsvc.com/PSDG_VA_E4','How can you stand out to jobseekers?','','2024-02-06','PlanSponsorVirginiaLeadGen240206PCSEM4A','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-18]___Screenshot-2023-11-14-114648.png','','','','244550','Form Submission','','','','Simple: Offer a better retirement plan','Plan Sponsor Lead Gen Virginia','','','','DG Plan Sponsor Virginia - Email 4A','Plan Sponsor Demand Gen','18628','https://view.accountsvc.com/?qs=786071f985633aa71be106247f3b7a7ac1fb82ada7770bcdae9bfe5b4bc8cb659937f50e4decfdedb3e32397108f3ba324904b218db5bb40b83165bb3b99f68b92e6f2d83d879030ce8d0226f08af218','Virginia PS DG') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-02-06_PCS_EM-4A','https://pcsretirement.accountsvc.com/PSDG_VA_E4','How can you stand out to jobseekers?','','2024-02-06','PlanSponsorVirginiaLeadGen240206PCSEM4A','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-18]___Plan_Sponsor_Virginia_Lead_Gen_24-02-06_PCS_EM-4A.jpeg','','','','244550','Form Submission','','','','Simple: Offer a better retirement plan','Plan Sponsor Lead Gen Virginia','','','','DG Plan Sponsor Virginia - Email 4A','Plan Sponsor Demand Gen','19341','https://view.accountsvc.com/?qs=9e837dcd2a08c872cca4011437d276b6ea39bcea171cb707d82f46bd0fd5e7a9a3bbc84a857823e9436cd5f12c83247c4826cee84bae34d90affc97222ef4dfb3694913a33bdceb9','Virginia PS DG') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-02-20_PCS_EM-4B','https://pcsretirement.accountsvc.com/PSDG_VA_E4','Attract jobseekers by doing this one thing','','2024-02-20','PlanSponsorVirginiaLeadGen240220PCSEM4B','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-19]___Plan_Sponsor_Virginia_Lead_Gen_24-02-20_PCS_EM-4B.jpeg','','','','247444','Form Submission','','','','Simple: Offer a better retirement plan','Plan Sponsor Lead Gen Virginia','','','','DG Plan Sponsor Virginia - Email 4B','Plan Sponsor Demand Gen','18628','https://view.accountsvc.com/?qs=9bd90810aa2cb1d2b94b8f42fbf14a7fd9f9895871df279918d8dd1bd27c7ef26d874a06c659d8ca1506824d77a37fd5f454f80c190688198340b0c4b8dd88b02b634c86250aabdd','Virginia PS DG') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-03-12_PCS_EM-1A ','https://pcsretirement.accountsvc.com/PSDG_VA','VA businesses: State mandated retirement plans are here','','2024-03-12','PlanSponsorVirginiaLeadGen240312PCSEM1A ','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-19]___image.png','','','','251631','Form Submission','','','','Where to start with government-mandated retirement plans','Plan Sponsor Lead Gen Virginia','','','','DG Plan Sponsor Virginia C2 - Email 1A','Plan Sponsor Demand Gen','20442','https://view.accountsvc.com/?qs=1f03b7b2f3127ee3ae84051fdeb50b4c364d7dc833478637908e0f3df8dd8159d785d2b47a6e3ee1cedebd13e66fa9b50af412609080cd3a8582411a3767c5a41c106583ef56cd7a','Virginia PS DG Cycle 2') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-03-19_PCS_EM-1B ','https://pcsretirement.accountsvc.com/PSDG_VA','VA businesses: Urgent compliance required for new retirement mandate','','2024-03-19','PlanSponsorVirginiaLeadGen240319PCSEM1B ','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-19]___image.png','','','','252701','Form Submission','','','','Where to start with government-mandated retirement plans','Plan Sponsor Lead Gen Virginia','','','','DG Plan Sponsor Virginia C2 - Email 1B','Plan Sponsor Demand Gen','20462','https://view.accountsvc.com/?qs=1f03b7b2f3127ee3ae84051fdeb50b4c364d7dc833478637908e0f3df8dd8159d785d2b47a6e3ee1cedebd13e66fa9b50af412609080cd3a8582411a3767c5a41c106583ef56cd7a','Virginia PS DG Cycle 2') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-03-26_PCS_EM-2A ','https://pcsretirement.accountsvc.com/PSDG_VA_E2','Have you caught up to new state mandates for retirement plans?','','2024-03-26','PlanSponsorVirginiaLeadGen240326PCSEM2A ','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-19]___image.png','','','','253752','Form Submission','','','','If you’re still searching, here’s what you can do','Plan Sponsor Lead Gen Virginia','','','','DG Plan Sponsor Virginia C2 - Email 2A','Plan Sponsor Demand Gen','20444','https://view.accountsvc.com/?qs=886fb9d66c3717b66259cedb9e8d22c3b1ead2d167807c0cc0a1911c9aeb4e71517a6d468a0c378c22f0b5ecc5faf3c6791de04fd9e1a5cdb46795bcb93a0c4d136e5da5bbc0a332d3b5fc027f6984db','Virginia PS DG Cycle 2') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-04-02_PCS_EM-2B ','https://pcsretirement.accountsvc.com/PSDG_VA_E2','Avoid non-compliance penalty: New state mandates for retirement plans','','2024-04-02','PlanSponsorVirginiaLeadGen240402PCSEM2B ','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-19]___Plan_Sponsor_Virginia_Lead_Gen_24-04-02_PCS_EM-2B .jpeg','','','','254985','Form Submission','','','','If you’re still searching, here’s what you can do','Plan Sponsor Lead Gen Virginia','','','','DG Plan Sponsor Virginia C2 - Email 2B','Plan Sponsor Demand Gen','20463','https://view.accountsvc.com/?qs=815567546cbd189fb21b9d8a1c84020f6f85837dcc80e1ac4d401a51e76b868f337c587665e644ace7e496d438400668d7e643521fe2a9270b73764ee59c7781ad9b76a08236161ea2917b0de278931a','Virginia PS DG Cycle 2') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-04-09_PCS_EM-3A ','https://pcsretirement.accountsvc.com/PSDG_VA_E3','Offset high startup cost for retirement plans','','2024-04-09','PlanSponsorVirginiaLeadGen240409PCSEM3A ','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-19]___Plan_Sponsor_Virginia_Lead_Gen_24-04-09_PCS_EM-3A .jpeg','','','','256379','Form Submission','','','','PCS Retirement can show you how','Plan Sponsor Lead Gen Virginia','','','','DG Plan Sponsor Virginia C2 - Email 3A','Plan Sponsor Demand Gen','20446','https://view.accountsvc.com/?qs=68d80a3042f007b2fd3661b3a021f4ea3f02056df840158dd0bf08fd5e0a07c0e28b95a27eca3217b5e831b0b987e3ee03edc785c7525785f04571224060a689a80b34d6dec7a0a34a21746fa48a0e51','Virginia PS DG Cycle 2') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-04-16_PCS_EM-3B ','https://pcsretirement.accountsvc.com/PSDG_VA_E3','Slash startup costs for mandatory retirement plans—act now','','2024-04-16','PlanSponsorVirginiaLeadGen240416PCSEM3B ','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-19]___Plan_Sponsor_Virginia_Lead_Gen_24-04-16_PCS_EM-3B .jpeg','','','','257875','Form Submission','','','','PCS Retirement can show you how','Plan Sponsor Lead Gen Virginia','','','','DG Plan Sponsor Virginia C2 - Email 3B','Plan Sponsor Demand Gen','20464','https://view.accountsvc.com/?qs=26b332286d3f6aeb4588d2111b6b6df2484e1c8ef40c975512071bc22aa3aaeef2b79d324877fd9db366328c22073689c21b4f89c74e09e3c3ec1d40956e8aecf0538bc6dec58400f7b674c35d4adb18','Virginia PS DG Cycle 2') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-04-23_PCS_EM-4A','https://pcsretirement.accountsvc.com/PSDG_VA_E4','Stand out to jobseekers by offering a competitive retirement plan','','2024-04-23','PlanSponsorVirginiaLeadGen240423PCSEM4A','','','','','259063','Form Submission','','','','Employee retirement plans for VA-based businesses','Plan Sponsor Lead Gen Virginia','','','','DG Plan Sponsor Virginia C2 - Email 4A','Plan Sponsor Demand Gen','20448','https://view.accountsvc.com/?qs=7ba0903393276cd037cc221bd67e4776fb5f827213cb6153c4ddca6855e649559a7ae72da7f1f6394a8b2170d8f5ffce2014a96c855a2b1ac04b43d8fc3eb5b488e59cfeb5cee128','Virginia PS DG Cycle 2') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Plan_Sponsor_Virginia_Lead_Gen_24-04-30_PCS_EM-4B','','Boost your appeal to jobseekers: Competitive employee retirement plans','','2024-04-30','PlanSponsorVirginiaLeadGen240430PCSEM4B','','','','','260955','Form Submission','','','','Employee retirement plans for VA-based businesses','Plan Sponsor Lead Gen Virginia','','','','DG Plan Sponsor Virginia C2 - Email 4B','Plan Sponsor Demand Gen','20465','','Virginia PS DG Cycle 2') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Plan_Sponsor_UT-CO_Lead_Gen_24-08-08_ABGC_EM-1','https://pcsretirement.accountsvc.com/PSDG_UT-CO','Need Help Juggling Fiduciary and Business Responsibilities?','','2024-08-08','PlanSponsorUTCOLeadGen240808ABGCEM1','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-19]___plan_sponsor_utco_em1.png','','','','280852','Form Submission','','','','Limit your fiduciary liability by engaging our team today','Plan Sponsor Lead Gen','','','','DG Plan Sponsor Utah/Colorado - Email 1','Plan Sponsor Demand Gen','22477','https://view.accountsvc.com/?qs=1a572d226208211f7bb0c3f444b8edfab524c08e4831cde6cce1f629fdfa33b11f0be1ecc6436e37aa655c3f3fe202462df96a22f771fbe5dea7001e64ac255c9dcf57c3f56ea3a0','Utah/Colorado PS DG') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Plan_Sponsor_UT-CO_Lead_Gen_24-08-22_ABGC_EM-2','https://pcsretirement.accountsvc.com/PSDG_UT-CO','Maximizing Retirement Plan Benefits for Your Team','','2024-08-22','PlanSponsorUTCOLeadGen240822ABGCEM2','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-20]___plan_sponsor_utco_em2.png','','','','282277','Form Submission','','','','When was your last retirement plan review?','Plan Sponsor Lead Gen','','','','DG Plan Sponsor Utah/Colorado - Email 2','Plan Sponsor Demand Gen','22504','https://view.accountsvc.com/?qs=afc360fd6832e13498b770877c3049260d2110562bba00ad94086e5caab807082ffa6a79f0f4c6847831a18e348e50022622873d19d5edb0de836e03d1618fa3d2b869fed17333b9','Utah/Colorado PS DG') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Plan_Sponsor_No-Advisor_Lead_Gen_24-08-29_PCS_EM-1','https://pcsretirement.accountsvc.com/Plan-Sponsor_Streamline-Your-Fiduciary-Obligations?','Minimize Your Fiduciary Liability as a Retirement Plan Sponsor','','2024-08-29','PlanSponsorNoAdvisorLeadGen240829PCSEM1','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-20]___Plan_Sponsor_No-Advisor_Lead_Gen_24-08-29_PCS_EM-1.jpeg','','','','283376','Form Submission\n','','','','A plan sponsor is legally responsible for all plan investments, benchmarks, and reports','Plan Sponsor Lead Gen','','','','Additional Plan Sponsor Q3 (No Advisor) - Email 1','Plan Sponsor Demand Gen','22885','https://view.accountsvc.com/?qs=9b4cfabf429bbf6777efd9aa66db7c7370aff009de756d9f2e517ad89bc2c70755958ebf9382302bd2cf623749fd470775c57df0cb8037323561356eaf1f6d0928d1a88a5980fd4722cd42fbfc856952','Additional for Q3 Plan Sponsor (No Advisor)') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Plan_Sponsor_No-Advisor_Lead_Gen_24-09-10_PCS_EM-2','','3% More Returns at No Extra Cost for Employee Retirement Plans','','2024-09-10','PlanSponsorNoAdvisorLeadGen240910PCSEM2','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-20]___Plan_Sponsor_No-Advisor_Lead_Gen_24-09-10_PCS_EM-2.jpeg','','','','284774','Form Submission','','','','Unlock Higher Returns for Employees: The PCS Retirement Advantage','Plan Sponsor Lead Gen','','','','Additional Plan Sponsor Q3 (No Advisor) - Email 2','Plan Sponsor Demand Gen','22886','https://view.accountsvc.com/?qs=2056976f18f068722a3785f419eb312f5c95b0676bd34fb3e23da18238fa4b48e7bd4a2289b5e7e5092790a0ab25ff86cf1ca5154dfe1493d838b36b2ec7977cbc371d56eb5b183fac1bbc967b795dd5','Additional for Q3 Plan Sponsor (No Advisor)') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Plan_Sponsor_UT-CO_Lead_Gen_24-09-12_ABGC_EM-3','https://pcsretirement.accountsvc.com/PSDG_UT-CO','Enhance Your Organization’s Retirement Plan Efficiency','','2024-09-12','PlanSponsorUTCOLeadGen240912ABGCEM3','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-20]___Plan_Sponsor_UT-CO_Lead_Gen_24-09-12_ABGC_EM-3.jpeg','','','','284974','Form Submission','','','','Bogged down by 401(k) management? We got your back','Plan Sponsor Lead Gen','','','','DG Plan Sponsor Utah/Colorado - Email 3','Plan Sponsor Demand Gen','22505','https://view.accountsvc.com/?qs=68560a43a5e549ef37bbd1ef6cd9b9c00956b48a6b075777ee04d2d84b24ae33792bc8d3f1350fd7b1acd04cb11e38a9fdaffa27a86d67693053df2a6189a4f5f39fc3cad64b025b44e301d88bc0bf30','Utah/Colorado PS DG') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('DG-Advisor-Warm-20240918_E4A','https://pcsretirement.accountsvc.com/take-your-client-to-new-height?','PCS: Retirement Planning Solutions for Advisors','','2024-09-18','DGAdvisorWarm20240918E4A','','','','','285760','Form Submission','','','','Discover unseen opportunities for retirement plan growth','DG Nurture Q1 2024','','','','DG Extension Warm - Email 4A','Demand Generation','23255','','DG Extension Warm - Email 4') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('PEPC3_EM-10-Early_20240919','','How to Start Saving without a Budget','','2024-09-19','PEPC3EM10Early20240919','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-20]___PEPC3_EM-10-Early_20240919.png','','','','','','','','','2 tips for start saving today','','','','','PEPC 2024 Email 10 (Early)','Participant Engagement','23109','https://view.accountsvc.com/?qs=2d3f1520575daeaa28f1d86c75045835adae13d11df758182218050652c9d043efb19b28d9403fe39604c4fc5d727cb8b1419ded2e817bb086243890981383dd6f143aa244fb347c','PEPC 2024 Email 10') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('PEPC3_EM-10-Mid_20240919','','Time to Fall into Smart Retirement Prep Strategies','','2024-09-19','PEPC3EM10Mid20240919','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-20]___PEPC3_EM-10-Mid_20240919.png','','','','','','','','','3 key considerations for retirement savers','','','','','PEPC 2024 Email 10 (Mid)','Participant Engagement','23132','https://view.accountsvc.com/?qs=00adacf68a127582b4bd9298e2930c62473518746b124ab76c892da37e5ac80574f6678014f9c686a1f0c5628fce48497d31f4d5a07bc6edd0ef55abe808b8f4d35cdd6581eba3ad','PEPC 2024 Email 10') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('PEPC3_EM-10-End_20240919','','Retirement Prep Made Simple','','2024-09-19','PEPC3EM10End20240919','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-20]___PEPC3_EM-10-End_20240919.png','','','','','','','','','Here’s a 4-point checklist to get you on track','','','','','PEPC 2024 Email 10 (End)','Participant Engagement','23144','https://view.accountsvc.com/?qs=d23e6351338f707439d9013f2494e99d9e803a9c8bb074ec0de5b251c82bb521a7763739296d1782a4cd8e1787b05720f36e2fb26f5c1d4d5549992e68d5156a4fafb56e52ab443f','PEPC 2024 Email 10') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('DG-Advisor-Warm-20240925_E4B','https://pcsretirement.accountsvc.com/take-your-client-to-new-height?','Maximize Your Client Engagement with The Advisor Lab®','','2024-09-25','DGAdvisorWarm20240925E4B','','','','','','Form Submission','','','','Discover unseen opportunities for retirement plan growth','DG Nurture Q1 2024','','','','DG Extension Warm - Email 4B','Demand Generation','23316','','DG Extension Warm - Email 4') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Plan_Sponsor_UT-CO_Lead_Gen_24-09-26_ABGC_EM-4','https://pcsretirement.accountsvc.com/PSDG_UT-CO','Review and Reduce Your Retirement Plan Costs Today','','2024-09-26','PlanSponsorUTCOLeadGen240926ABGCEM4','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-20]___plan_sponsor_utco_em4.png','','','','','Form Submission','','','','Transparency matters: Full fee disclosure made simple','','','','','DG Plan Sponsor Utah/Colorado - Email 4','Plan Sponsor Demand Gen','22506','https://view.accountsvc.com/?qs=7d0eecaea37aa6eba6999f3e3be39ea084350e9297f98467ffec923dc347502b0d6971a03926f250c79ac396f5a423ce7ddcd9bd726406a984de41c0be67f33e3598c38b79be526f','Utah/Colorado PS DG') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Selling-Season-Series_EM_2024-10-03_EM-05','https://www.pcsretirement.com/about-us/sales-team#team=employer','Crafting the Perfect Selling Season Presentation','','2024-10-03','SellingSeasonSeriesEM20241003EM05','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-21]___ssec_em5.png','','','','','','','','','Tips for putting your best foot forward every time','','','','','Selling Season 3.0 Email 5','Selling Season','22565','https://view.accountsvc.com/?qs=36ffdfc019733b26bcd90de874c917de1e1966d8128508a1e3473be10c09a0d6499ee309712b5969789dc0e8aea1e60db12b5683b5c19fe8c8b0a4f2575ab2328d315dcb01dd9596','Selling Season 3.0') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('PEPC3_EM-11-Early_20241003','','Our Money-saving Technique that Fits Any Lifestyle','','2024-10-03','PEPC3EM11Early20241003','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-21]___PEPC3_EM-11-Early_20241003.png','','','','','','','','','How to save without stretching your budget','','','','','PEPC 2024 Email 11 (Early)','Participant Engagement','23110','https://view.accountsvc.com/?qs=31b9e01cc9e030836c21ed023060fc990a6f8aa7b0726049c6aef0d6ee6e1135d008efae21d30d7e921ba6b68ebf64000e742e5ce6391a22821791ae518bfe7f3bde64ff1a819cb2','PEPC 2024 Email 11') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('PEPC3_EM-11-Mid_20241003','','Jumpstart Your Retirement Savings Today','','2024-10-03','PEPC3EM11Mid20241003','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-21]___PEPC3_EM-11-Mid_20241003.png','','','','','','','','','Build a solid financial future and end the year with a strong savings plan','','','','','PEPC 2024 Email 11 (Mid)','Participant Engagement','23133','https://view.accountsvc.com/?qs=9eb2ceb539357078608c6ede5f059dd27599cab054d602fc730813a62583f5aaad9d0aa762d74fed2406eb5723f89b40e57b105481c1a7a885a8f93fdc8d77833ce017ed01e491f1','PEPC 2024 Email 11') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('PEPC3_EM-11-End_20241003','','Smoothing the Transition into Retirement','','2024-10-03','PEPC3EM11End20241003','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-21]___PEPC3_EM-11-End_20241003.png','','','','','','','','','Strategies for building a solid retirement plan','','','','','PEPC 2024 Email 11 (End)','Participant Engagement','23145','https://view.accountsvc.com/?qs=8b26c1ddc418c0763beb1a830f0898d5c3b58cf9945331c9676805cd505c52bbe11009561ca169ed2ec3542ba5c8fd873d27566bb32d5b9cdc4dadc9a82e50eea3f0d23decb1cfe3','PEPC 2024 Email 11') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('DG-Advisor-Warm-20241016_E5A','https://pcsretirement.accountsvc.com/take-your-client-to-new-height?','Here’s How to Build Lasting Client Relationships','','2024-10-16','DGAdvisorWarm20241016E5A','','','','','','Form Submission','','','','Reimagine your conversion strategy with one platform','DG Nurture Q1 2024','','','','DG Extension Warm - Email 5A','Demand Generation','23256','','DG Extension Warm - Email 5') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Selling-Season-Series_EM_2024-10-17_EM-06','https://www.pcsretirement.com/about-us/sales-team#team=employer','Finishing Retirement Plan Selling Season 2024 Strong','','2024-10-17','SellingSeasonSeriesEM20241017EM06','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-21]___ssec_em6.png','','','','','','','','','Recounting our key tips to a successful Selling Season','','','','','Selling Season 3.0 Email 6','Selling Season','22566','https://view.accountsvc.com/?qs=08d94af80910d78612b9d550edd1f69704458c03dc0d8a60306c88cf41d3f12505b885b5594c9db452108bef0376edb099389d29a7ab01ab570cd450770599f1a22ed15da41a26f4','Selling Season 3.0') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('DG-Advisor-Warm-20241023_E5B','https://pcsretirement.accountsvc.com/take-your-client-to-new-height?','The Advisor Lab®: Effortlessly Turn Prospects into Clients','','2024-10-23','DGAdvisorWarm20241023E5B','','','','','','Form Submission','','','','Reimagine your conversion strategy with one platform','DG Nurture Q1 2024','','','','DG Extension Warm - Email 5B','Demand Generation','23317','','DG Extension Warm - Email 5') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('DG-Advisor-Warm-20241113_E6A','https://pcsretirement.accountsvc.com/take-your-client-to-new-height?','Retirement Plan Management Made Better, Simpler—with PCS','','2024-11-13','DGAdvisorWarm20241113E6A','','','','','','Form Submission','','','','The ultimate management platform for financial advisors','DG Nurture Q1 2024','','','','DG Extension Warm - Email 6A','Demand Generation','23257','','DG Extension Warm - Email 6') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('DG-Advisor-Warm-20241120_E6B','https://pcsretirement.accountsvc.com/take-your-client-to-new-height?','The Advisor Lab®: Superior Client Management in One Place','','2024-11-20','DGAdvisorWarm20241120E6B','','','','','','Form Submission','','','','The ultimate management platform for financial advisors','DG Nurture Q1 2024','','','','DG Extension Warm - Email 6B','Demand Generation','23318','','DG Extension Warm - Email 6') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Participant-Education-Series_EM_2024-09-19_PCS_PESC_Early_EM-2-5PM','','Guilty of Impulse-Buying on Amazon or TikTok Shop?','','2024-09-19','ParticipantEducationSeriesEM20240919PCSPESCEarlyEM25PM','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-21]___Participant-Education-Series_EM_2024-09-19_PCS_PESC_Early_EM-2.jpeg','','','','','','','','','When ‘add to cart’ quickly becomes ‘clutter’','','','','','PESC 3.0 Email 2 (Early - 5PM)','Participant Education Series','22709','https://view.accountsvc.com/?qs=9f8c66836dee0da696b7d01dbec9d02262f974e3d1c108a7f6a4cf7e991a8e77acedd43b8c6e907c5ffe93209352022cd2a4d3139fe0597106244b34bd9585b8b37206b69719a810','PESC 3.0 Email 2') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Participant-Education-Series_EM_2024-09-19_PCS_PESC_Early_EM-2-8PM','','Guilty of Impulse-Buying on Amazon or TikTok Shop?','','2024-09-19','ParticipantEducationSeriesEM20240919PCSPESCEarlyEM28PM','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-21]___Participant-Education-Series_EM_2024-09-19_PCS_PESC_Early_EM-2.jpeg','','','','','','','','','When ‘add to cart’ quickly becomes ‘clutter’','','','','','PESC 3.0 Email 2 (Early - 8PM)','Participant Education Series','22709','https://view.accountsvc.com/?qs=9f8c66836dee0da696b7d01dbec9d02262f974e3d1c108a7f6a4cf7e991a8e77acedd43b8c6e907c5ffe93209352022cd2a4d3139fe0597106244b34bd9585b8b37206b69719a810','PESC 3.0 Email 2') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Participant-Education-Series_EM_2024-09-19_PCS_PESC_Mid_EM-2-5PM','','Investment Strategies for Weathering Political Storms','','2024-09-19','ParticipantEducationSeriesEM20240919PCSPESCMidEM25PM','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-21]___Participant-Education-Series_EM_2024-09-19_PCS_PESC_Mid_EM-2.jpeg','','','','','','','','','Why long-term investments take precedence over short-term changes','','','','','PESC 3.0 Email 2 (Mid - 5PM)','Participant Education Series','22710','https://view.accountsvc.com/?qs=ece094eb39feaf428be3e9c88de785cc6c29267f05ce4c71de59dc9a244ad5d76b34dc24978800faad3d8f3a5bb7f992c66306dcfa141a3159661d55985c3cd94274fc308b0b7494','PESC 3.0 Email 2') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Participant-Education-Series_EM_2024-09-19_PCS_PESC_Mid_EM-2-8PM','','Investment Strategies for Weathering Political Storms','','2024-09-19','ParticipantEducationSeriesEM20240919PCSPESCMidEM28PM','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-22]___Participant-Education-Series_EM_2024-09-19_PCS_PESC_Mid_EM-2.jpeg','','','','','','','','','Why long-term investments take precedence over short-term changes','','','','','PESC 3.0 Email 2 (Mid - 8PM)','Participant Education Series','22710','https://view.accountsvc.com/?qs=ece094eb39feaf428be3e9c88de785cc6c29267f05ce4c71de59dc9a244ad5d76b34dc24978800faad3d8f3a5bb7f992c66306dcfa141a3159661d55985c3cd94274fc308b0b7494','PESC 3.0 Email 2') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Participant-Education-Series_EM_2024-09-19_PCS_PESC_End_EM-2-5PM','','Debt-Free Dreams: Crafting a Long-Term Mortgage Strategy','','2024-09-19','ParticipantEducationSeriesEM20240919PCSPESCEndEM25PM','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-22]___Participant-Education-Series_EM_2024-09-19_PCS_PESC_End_EM-2.jpeg','','','','','','','','','Key considerations when paying off your mortgage early','','','','','PESC 3.0 Email 2 (End - 5PM)','Participant Education Series','22711','https://view.accountsvc.com/?qs=9536418fd50d5cf31c96d338a36b8912d6cc915c3d954368186fdbf635abcf5eb2f658f73a38bbfd2d5d90ef2665b1fd35b8bcd2107357210fe3d6c472d847fbc6b0599f92eb925f','PESC 3.0 Email 2') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('Participant-Education-Series_EM_2024-09-19_PCS_PESC_End_EM-2-8PM','','Debt-Free Dreams: Crafting a Long-Term Mortgage Strategy','','2024-09-19','ParticipantEducationSeriesEM20240919PCSPESCEndEM28PM','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-22]___Participant-Education-Series_EM_2024-09-19_PCS_PESC_End_EM-2.jpeg','','','','','','','','','Key considerations when paying off your mortgage early','','','','','PESC 3.0 Email 2 (End - 8PM)','Participant Education Series','22711','https://view.accountsvc.com/?qs=9536418fd50d5cf31c96d338a36b8912d6cc915c3d954368186fdbf635abcf5eb2f658f73a38bbfd2d5d90ef2665b1fd35b8bcd2107357210fe3d6c472d847fbc6b0599f92eb925f','PESC 3.0 Email 2') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('PEPC3_EM-12-Early_20241017','','Don’t let financial fears haunt you','','2024-10-17','PEPC3EM12Early20241017','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-22]___PEPC3_EM-12-Early_20241017.png','','','','','','','','','Treat yourself to peace of mind with early contributions','','','','','PEPC 2024 Email 12 (Early)','Participant Engagement','23131','https://view.accountsvc.com/?qs=b284337e8b3452ac963e159271863dea0cad71d63d4f35f42bb1e7bca7c5645d9126224ad6981b90f20932ee29cd60292717793f2daf241fff801f559ef93725437acb5e7b7ad3e6','PEPC 2024 Email 12') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('PEPC3_EM-12-Mid_20241017','','Here’s a “Trick” for Growing Your Savings…','','2024-10-17','PEPC3EM12Mid20241017','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-22]___PEPC3_EM-12-Mid_20241017.png','','','','','','','','','…so you can “Treat” yourself to a comfortable retirement','','','','','PEPC 2024 Email 12 (Mid)','Participant Engagement','23134','https://view.accountsvc.com/?qs=2a0d29b7e19f0b3fd7df5f19432ddbab43f7d014bb8fe4511cd42f9b80afb9d46da3134543cb96af5506c2111db060798f3435a52005d75a7c933737c756a911ec2b0faafb214507','PEPC 2024 Email 12') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>INSERT INTO db_airtable_email_participant_engagement (_code,_landingPage,_subject,_whatWeDo,_liveDate,_trimCode,_screenshot,_utm_campaign, _utm_medium,_utm_source,_campaignID,_assetTitle,_campaignName,_emailName,_journeyName,_preview,_formSubmission,_notes,_assignee,_status,_emailSequence,_rootCampaign,_emailID,_link,_emailSegment) VALUES ('PEPC3_EM-12-End_20241017','','Here’s a “Trick” for Growing Your Savings…','','2024-10-17','PEPC3EM12End20241017','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-48-22]___PEPC3_EM-12-End_20241017.png','','','','','','','','','…so you can “Treat” yourself to a comfortable retirement','','','','','PEPC 2024 Email 12 (End)','Participant Engagement','23146','https://view.accountsvc.com/?qs=fd66db77dac5606ee73e1639390dccf119773cd14199564743c9696229f9abaf1d97153eb06527eb39596b8b7f506df8272af434db385b59ed2888de9e2c4f5fbd6eba72c3d79181','PEPC 2024 Email 12') ON DUPLICATE KEY UPDATE _landingPage = VALUES(_landingPage),_subject = VALUES(_subject),_whatWeDo = VALUES(_whatWeDo),_liveDate = VALUES(_liveDate),_trimCode = VALUES(_trimCode),_screenshot = VALUES(_screenshot),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source),_campaignID = VALUES(_campaignID),_assetTitle = VALUES(_assetTitle),_campaignName = VALUES(_campaignName),_emailName = VALUES(_emailName),_journeyName = VALUES(_journeyName),_preview = VALUES(_preview),_formSubmission = VALUES(_formSubmission),_notes = VALUES(_notes),_assignee = VALUES(_assignee),_status = VALUES(_status),_emailSequence = VALUES(_emailSequence),_rootCampaign = VALUES(_rootCampaign),_emailID = VALUES(_emailID),_link = VALUES(_link),_emailSegment = VALUES(_emailSegment)<BR>https://api.airtable.com/v0/app8rwMuBWhGWFqN7/tblk9JR56tF4Dpil6?view=viwdJDvGUSb7fAz1E&filterByFormula={Ticker}%3C1440<BR>