Content Comparison

...

• Save as RPT_MKT_WEB_TRAFFIC.xlsx file on H:
• DELETE THE TOP TWO ROWS FROM THE FILE (Filter details)
• Remove the filters
• Rename the tab to Export
• File is automatically processed by the EBIS team every Tuesday morning at 6am
  • If the data needs to be manually processed:
    • Execute the RPT_MKT_WEB_TRAFFIC import script on the terminal server to update the table

Recruitment

https://docs.google.com/spreadsheets/d/1DO7lHVFddj9TpAtGJxSmRsS6HcveCZG8lJ7MnZ-tD1s/edit#gid=358248905

• Copy data from the link above into the RPT_MKT_PAID_RECRUITMENT.xlsx file on H:
• File is automatically processed by the EBIS team every Tuesday morning at 6am
  • If the data needs to be manually processed:
    • Execute the RPT_MKT_PAID_RECRUITMENT import script on the terminal server to update the table

Paid Marketing

Excel files sent via email from Situation [vendor] for weekly marketing metrics

• The source files must be normalized into the existing spreadsheet format (Marketing_Normalized_*.xlsx)
• Copy the normalized data into the RPT_MKT_PAID_MEDIA.xlsx file on H:
• File is automatically processed by the EBIS team every Tuesday morning at 6am
  • If the data needs to be manually processed:
    • Execute the RPT_MKT_PAID_MEDIA import script on the terminal server to update the table

Business = SPBCAR, College Edge = SPNDGH, Graduate Foundations = SPGFNS, “INT’L” = SPUNST

The date for each file should be the Monday of the week the ads cover

Recruitment (DEPRECATED)

https://docs.google.com/spreadsheets/d/1DO7lHVFddj9TpAtGJxSmRsS6HcveCZG8lJ7MnZ-tD1s/edit#gid=358248905

• Copy data from the link above into the RPT_MKT_PAID_RECRUITMENT.xlsx file on H:
• File is automatically processed by the EBIS team every Tuesday morning at 6am
  • If the data needs to be manually processed:
    • Execute the RPT_MKT_PAID_RECRUITMENT import script on the terminal server to update the table

Step 2: Slate Sources

...