← Back to Reports

2023 Indicated housing no housing

Folder: BAM 2023 Text Messages/Emails | Scope: org | Modified: 2023-05-24T12:25:01.000Z | Id: 00O5x000005J5UoEAK

Filters

Filter Logic: 1 AND 2 AND 3 AND (4 OR 5) AND 6

#	Field	Operator	Value
1	`CAMPAIGN_NAME`	contains	`BAM Orientation`
2	`MEMBER_STATUS`	equals	`Registered`
3	`CampaignMember.Housing__c`	equals	`Live on campus`
4	`Contact.Housing_Room_Number__c`	equals
5	`Contact.Housing_Application_Date__c`	equals
6	`Contact.BAM_Date__c`	greaterThan	`05/15/2023`

Columns

Contact.hed__Social_Security_Number__c
FIRST_NAME
LAST_NAME
Contact.BAM_Date__c
MEMBER_STATUS
MEMBER_LAST_UPDATE
EMAIL
PHONE3
CampaignMember.Parent_Phone__c
CampaignMember.Parent_Email__c
CampaignMember.Parent_Cell_Phone__c
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
Contact.Housing_Application_Date__c
Contact.Housing_Residence_Hall__c
Contact.Housing_Room_Number__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
CampaignMember.Guest_1_Name__c
CampaignMember.Guest_2_Name__c
CampaignMember.Shirt_Size__c

Raw JSON