← Back to Reports

[Mogli] June 1 23 BAM Reminder Text

Folder: BAM 2023 Text Messages/Emails | Scope: org | Modified: 2023-05-31T21:33:35.000Z | Id: 00O5x000007qrpsEAA

Filters

Filter Logic: 1 AND 2 AND 3

#	Field	Operator	Value
1	`CAMPAIGN_NAME`	contains	`BAM Orientation`
2	`START_DATE`	equals	`2023-06-01`
3	`MEMBER_STATUS`	equals	`Registered`

Columns

CONTACT_ID
Contact.hed__Social_Security_Number__c
FIRST_NAME
LAST_NAME
Contact.BAM_Date__c
MEMBER_STATUS
MEMBER_LAST_UPDATE
MEMBER_FIRST_RESPONDED_DATE
EMAIL
CampaignMember.Career_Option_1__c
CampaignMember.Career_Option_2__c
CampaignMember.Career_Option_3__c
CampaignMember.Collegiate_Sports__c
CampaignMember.Performance_Groups_and_Other_Campus_Acti__c
CampaignMember.Campus_Activities__c
CampaignMember.Other_Activities__c
CampaignMember.Housing__c
CampaignMember.Residence_Hall__c
CampaignMember.Concurrent_Dual_Credit_1__c
CampaignMember.Concurrent_Dual_Credit_2__c
CampaignMember.Concurrent_Dual_Credit_3__c
CampaignMember.Advanced_Placement__c
Contact.Scholarship_Type__c
Contact.Scholarship_Term__c
Contact.Official_Scholarship_Confirmation__c
ADDRESS1_LINE1
ADDRESS1_LINE2
ADDRESS1_CITY
Contact.OtherStateProvince__c
ADDRESS1_ZIP
PHONE3
CampaignMember.Parent_Email__c
CampaignMember.Parent_Cell_Phone__c
CampaignMember.Parent_Phone__c
CampaignMember.Guest_1_Name__c
CampaignMember.Guest_2_Name__c
CampaignMember.Shirt_Size__c

Raw JSON