Search Workflow Detailed

Author

Christine Iyer, Office of Marketing and Brand Management

Pre-processing Search names: Tidying Leads for Reuse

newLeads <- newLeads %>% mutate(Primary.Zip.Postal.Code = as.character(normalize_zip(Primary.Zip.Postal.Code)))
Warning in sprintf("%05i", as.numeric(zipcode)): NAs introduced by coercion

  • I and J Move AL and AN to these fields.

  • K Lead Identifier Combines all 3 previous fields.

  • L X_CB If leadseg CB has data, “CB” to get rid of redundancies.

  • M X_NR_ If leadseg NR has data, “NR” to get rid of redundancies.

  • N X_BlahBlah_if recruiting category starts with P, CB, else blank.

  • O X_Blah_if recruiting category starts with N, NR, else blank.

  • P X_CBCB_ Combine both CB Fields and reduce the name

  • Q X_NRNR_ Combine both NR Fields and reduce the name

  • R X_Lead.Code_ Combine 2 previous fields

  • S X_Lead.Code.Final_ Trim the previous Field

Pre-Processing Inquiries and Applications

Inquiries and Applications

Before

Middle

After

Steps:

kable(names(newLeads))
x
Created.Date
First.Name
Last.Name
Email
Primary.City
Primary.State.Province
Primary.Zip.Postal.Code
Student.Stage
Student.Type
Career
Anticipated.Start.Year
Vendor
Class
Achievement 
kable(names(inquiriesApps))
x
Created.Date
First.Name
Last.Name
Email
Primary.City
Primary.State.Province
Primary.Zip.Postal.Code
Student.Stage
Student.Type
Career
Anticipated.Start.Year
Vendor
Class
Achievement
Initial.Referral.Source
Initial.Source.Date
App.Application.Status
App.Application.Date
App.Admit.Date
App.Deposit.Date 
write.csv(newLeads, "C:/Users/christine.iyer/OneDrive - University of Maine System/FY22_Search_Performance_Template/03_FinalData/leadsFinal.csv", row.names = F)

write.csv(inquiriesApps, "C:/Users/christine.iyer/OneDrive - University of Maine System/FY22_Search_Performance_Template/03_FinalData/inquiriesAppsFinal.csv", row.names = F)