Data Collection: Run this Salesforce Report and export and save the csv to C:/Users/christine.iyer/Box/FY21 Weekly Admissions Reports Summary to Inform Agency Campaigns/Reports/DAA_mm-dd-yyyy.csv
Tidying: “C:/Users/christine.iyer/Box/FY21 Weekly Admissions Reports Summary to Inform Agency Campaigns/TrialReport/DataTidyingScript.Rmd”
This report tidies and aggregates into the product/audience group that correspond to the University’s agency campaigns.
It renders a report called “C:/Users/christine.iyer/Box/FY21 Weekly Admissions Reports Summary to Inform Agency Campaigns/FinalDatatoAppend/AllGood.csv” that shows how many new inquiries and applicants each aggregate has reviewed over the past week. This report was started in Fall 2020, so we could have an accurate count. The newest numbers are appended to the weekly csv.
Visual Reporting
This is updated weekly.
Filepath: "C:/Users/christine.iyer/Box/FY21 Weekly Admissions Reports Summary to Inform Agency Campaigns/YearOverYearTrend/FY21_YoY_Enrollment_Cycle_Trend.Rmd
In addition to running the script, it has to be republished for Rinck. They can be cc’d in Wrike.
Notes from Rinck Meeting Refer to notes before proceeding.
There are many moving parts to the multi-channel search campaign projects. The purchase of lead names for is primarily managed by the Marketing Data Analyst and overseen by the Director of Marketing and Brand Management.
Preparation:
Determine budget. This is typically determined annually, and money is allocated for each upcoming purchase of College Board names. Each purchase has its own PO, and there are usually 2 PO with each purchase, one for instate names and the other for out of state. The reason for this is because we use different criteria for each audience.
Although the budget is pre-determined, it will always be subject to change based on the dynamic nature of enrollment needs.