Configuring Advanced Analytics

Objectives

After completing this lesson, you will be able to:
  • Complete the initial settings to enable the daily sync job
  • Create test candidates to populate each of the applicant statuses
  • Map the statuses in Recruiting Advanced Analytics
  • Customize field labels for reports
  • Purge data if necessary to change status mappings or reload previous data
  • Set permissions for Recruiting Advanced Analytics users
  • Update the initial settings to ensure that the customer is notified when Applicant Workbench statuses are updated in the future

Recruiting Advanced Analytics Admin Interface

Use the quick links in Command Center to access Advanced Analytics Admin or to open Advanced Analytics for the site.

The Recruiting Advanced Analytics and Recruiting Advanced Analytics Admin links are highlighted.

Integration Settings

Because Advanced Analytics integrates data across SAP SuccessFactors Recruiting, a data integration must be configured. Set up the oData integration, the default integration type for Advanced Analytics.

We recommend running the sync daily, especially for very large customers, as monthly ATS loads can bog down the system.

Integration Settings page is displayed. Enter the required details.
  • In the Notify field enter the email address of the person to notify if there are unmapped statuses. This is required. (Note that this field is fully functional in the production environment.)

    Note

    Use your email address while you are configuring Advanced Analytics. Switch it to a customer admin email address when you finish the implementation. Or enter both, for example: consultant@email.com; admin@email.com; hris@email.com (distribution list).
  • Enable Get Data.

  • Enable Process Data. (However, if the Status Mappings have not yet been completed, to prevent a daily email reminder going out to the Notify person, you can wait to select this option.)

  • Note the Last ATS Data File Import Date. After doing an ATS Purge (discussed later), Advanced Analytics will reload any status activity since this date.

  • Checking the Get Data One Time box enables a one time oData pull for a specified date period. This is useful when something happens during the data import so you don’t have to wait for the next sync date. Both a Begin date and an End date are required to use this option.

Timing of Syncs

Important: You must configure the Integration Settings at least one day before mapping candidate statuses.

  • Candidate application data is retrieved at 12PM (the cutoff time), and is processed at 1AM in the data center’s local time on the scheduled date. For example, if you save the Integration Settings on a Monday before 12PM (noon), the sync will be performed at 1AM that night. But if you save the Integration Settings after noon on a Monday, the sync won’t be performed until 1AM the following night, on Tuesday.

Timeline graph representing timing of syncs.

Configure Odata Integration Settings

Business Example

Note

This exercise must be completed one day before Mapping Statuses.

Configure the Integration Settings page in Analytics Admin.

Steps

  1. Log in to Command Center, locate your site, and use the Recruiting Advanced Analytics Admin quick link.

  2. Do not change the settings for Integration Type (oData).

  3. In the Notify field, enter your email address.

  4. For Frequency, select Day.

  5. Check Get Data.

  6. Check Process Data.

  7. Choose Save.

Test Candidates

Status mappings only can be done when there is candidate data associated with each status on the Applicant Workbench (except for the exception statuses, which are discussed in the next section).

A candidate does not currently have to be in a status in order to map it. You can move candidates on more than one talent pipeline; they do not all have to apply to the same requisition.

Some consultants wait for the hiring cycle to complete on Production for a couple of positions, so that every status will have had a candidate in it. That requires remaining on the project in order to finish configuring status mapping for your customer. The instructions provided in this lesson assume that the consultant is using test candidates in the Production system to complete the mapping. Test candidates may be deleted, depending on your customer's data retention rules.

To ensure you have sufficient data prior to completing the required mapping for Advanced Analytics, the following should be completed:

  • Apply as a candidate in the customer’s career site and move the application through every status, from New Application to Hired to create the necessary status data for Advanced Analytics.
  • Create several additional candidate applications to ensure that there will be an application in each disqualification status.
  • Have one candidate apply to multiple positions to ensure that there is data for the "Hired on Other Requisition" disqualification status.
  • Use standard Recruiting settings, such as disqualifying pre-screening questions and automatic closing of requisitions to automatically disposition applications into the "Automatic Disqualified" and "Requisition Closed" disqualification statuses.
  • Manually withdraw a candidate’s application to populate the "Withdrawn Candidate" status.
To manually withdraw a candidate’s application, choose the Withdraw Application button and populate the “Withdrawn Candidate” status.

Three statuses are predefined when Data Privacy Consent Statement 2.0 is enabled from

ProvisioningManaging RecruitingEdit Candidate Privacy Options:

  • "Delete don Demand by Candidate"
  • "Delete don Demand by Admin"
  • "Declined DPCS"
Edit Candidate Privacy Options in Provisioning.

To ensure you have enough data for Advanced Analytics, complete the following:

  • Delete a candidate’s profile to populate "Deleted on Demand by Candidate" from Candidate ProfileOptionsSettings.
  • To populate "Deleted on Demand by Admin", delete the candidate’s profile from Admin CenterDelete Candidate.
  • To populate "Declined DPCS", after applying, access the candidate’s profile and from Search Options and Privacy, revoke their acceptance of the Data Privacy Consent Statement.
Example of a Data Privacy Statement with a Revoke button highlighted.

Populate Statuses in SAP SuccessFactors Recruiting

Business Case

Apply to one or more jobs from the CSB career site as multiple external candidates, and then move those candidates through the various statuses in Recruiting Management.

Steps

  1. From the new CSB career site, apply to a position as an external candidate.

  2. Log in to SAP SuccessFactors Recruiting (or proxy) as a recruiter, and move the candidate through each candidate status, through Hired. This allows you to map all of the In Progress statuses.

  3. You need to use as several external candidates, depending on how many disqualification statuses the customer has, for example, More Qualified Candidate or Hired on Other Requisition.

  4. To populate the Hired on Other Requisition status, have the candidate apply to two requisitions, and move the candidate to Hired for one of them.

  5. To be able to populate the Automatic Disqualified and Requisition Closed statuses, enable those options under Admin CenterManage Recruiting SettingsApplicant Profile Settings.

  6. To populate the Requisition Closed status, create a new job requisition and route it through approval. Run Real Time Job Sync, and have a candidate apply. Then close the application.

  7. To populate the Automatic Disqualified status, add a disqualifying pre-screening question to the requisition, and ensure that the applying candidate selects the incorrect response.

  8. To populate the Withdrawn by Candidate status, after the candidate applies return to the profile, select the job from Jobs Applied, and choose Withdrawn Application.

  9. To be able to populate the Deleted on Demand and Declined DPCS statuses, ensure that the Data Privacy Consent Statement 2.0 is enabled from ProvisioningManaging RecruitingEdit Candidate Privacy Options.

  10. To populate Deleted on Demand by Candidate, the candidate must delete their profile from Candidate ProfileOptionsSettings.

  11. To populate Deleted on Demand by Admin, the admin deletes the candidate’s profile from Admin CenterDelete Candidate.

  12. To populate Declined DPCS, after applying, make a change to the Data Privacy Consent Statement. The candidate visits their profile and revokes their acceptance of the Data Privacy Consent Statement.

    Note

    Remember that you do not need to route candidates through the Forwarded or Invited to Apply statuses, nor any of the fields defined as RMK Statuses, such as Not Qualified or Hired. See the course content for the complete list.

App Status Audit Trail Report

Using the App Status Audit Trail provides direct insight to whether or not a status within a talent pipeline is ready to be mapped in Advanced Analytics. While creating this report is not necessary, it can help save time.

When creating this report, ensure the following settings are selected:

  • Create the report as a Single Domain, Recruiting V2 report.
  • Ensure the Application Status, Job Req ID, and Candidate ID columns are enabled, at minimum.
  • Sort the columns by Application Status.
  • Add a Filter for the field Is Internal.In the Define Is Internal Filter dialog box, on the By My Selection tab, select the By My Selection dialog box and select the No checkbox.
  • From By My Selection, choose No.

    Example of an App Status Audit Trail Report.

Run the report to ensure that all statuses are available to be mapped (except for the Exception statuses listed earlier). If any of the applicant statuses are not listed, refer to the steps listed previously to move a candidate through the status.

Run the App Status Audit Trail Report

Business Example

Log in to SAP SuccessFactors Recruiting to generate this report.

Steps

  1. Within Recruiting, navigate to ReportingReport Center.

  2. Choose New and select Report-Table. Choose Select.

  3. Create a Single Domain, Recruiting V2 report. Choose Select.

  4. For Report Name, enter App Status Audit Trail.

  5. Choose Columns and then Select Columns. Include the Application Status, Job Req ID, and Candidate ID.

  6. Add a filter for the field Is Internal. From By My Selection, chooseNo.

  7. Choose Preview at the bottom right.

    Result

    Notice the Application Statuses column.
  8. Save the report.

  9. Run the report to ensure that all statuses are available to be mapped (except for the Exception statuses listed earlier).

  10. If any of the candidate statuses are not listed, refer to the previous exercise to move a candidate through the status.

Status Mapping

All applicant statuses on the Application Workbench must be mapped. For example, if the customer has multiple disqualification statuses on their talent pipeline, ensure that each is mapped to an Advanced Analytics status, usually "ATS Capture" (which will not display on the reporting). If a status is not mapped when the integration is run, the sync will fail.

Customers can improve their recruiting processes by viewing the candidate progression from visit to apply to hire. They want to know: How long did it take to get through the statuses? Where are the hold-ups in the candidate process?

To assist with this, it’s helpful to map for reporting the minimum number of statuses that will help customers track candidate history. Map the most accurate and initial status that the customer would like to track to. For example, if there are multiple screening statuses (such as "Recruiter Review", "Hiring Manager Review", and so on) map the first one to "Qualified" and the others to "ATS Capture".

Do not include internal logistical steps in the reporting. For example, if the customer has "ScheduleInterview" and "Prepare Offer" statuses, map those statuses to "ATS Capture".

Lastly, be mindful of how the Talent Pipeline is configured. For example, if statuses are grouped together, ensure to map all statuses within the grouping.

Status Mapping Exceptions

Some statuses will not be presented to be mapped for Advanced Analytics. This is expected behavior. The "pre-application" statuses are not mapped, and do not need to have candidates moved into them:

  • Forwarded
  • Invited to Apply

In addition, there are several fields defined internally as "RMK Statuses". Statuses with exactly these names are also not mapped:

  • Unknown
  • Visit
  • Subscribe
  • Apply Started
  • ATS Capture
  • Apply Completed
  • Not Qualified
  • Qualified
  • Qualified: Recruiter Screen
  • Qualified: Business Screen
  • Qualified: Technical Screen
  • Recruiter Interviewed
  • HM Interviewed
  • Interviewed
  • Offer Made
  • Hired
  • Not Hired

Status Mappings in the Advanced Analytics Admin Interface

After setting up the integration, if there are statuses that are not mapped a notification will be triggered. After the data is processed, an Unmapped Statuses email will be sent to the person(s) with the Notify email address on the Integration Settings page. The email contains a spreadsheet listing the statuses that need to be mapped.

Map any statuses that are available to map. Otherwise, the system will be "on hold" and data will not be captured.

If a new status is added to the customer’s applicant status set, the synchronizations will continue to happen, but that ATS data is not loaded. It is critical to map all statuses.

Once mapped, statuses cannot be easily changed. If you make an error during mapping, you will need to do a data purge and reload all of the status data. This is discussed under Data Purge in this lesson.

Status Mappings consist of Customer Status and RMK Status.

Map Statuses

This video demonstrates how to map statuses in Advanced Analytics.

Note

There is no audio in this video.

Business Example

Map all of the candidate statuses from the SAP SuccessFactors ATS to Career Site Builder.

Note

Remember that if statuses are populated by noon in the time zone of the data center where the instance is hosted, you will be able to map the statuses after 1:00AM the following day.

Steps

  1. Log in to Command Center and use the Recruiting Advanced Analytics Admin quick link.

  2. Navigate to Status Mappings.

  3. For the first candidate status listed in the Unmapped Statuses column, select the corresponding value from the Recruiting Marketing Status column. The unmapped statuses displayed depend on which statuses contain candidates in your instance.

    Use the following suggestions:

    Table displaying Status Mappings.
  4. Choose Save, and then OK at the confirmation window.

Field Label Customization

Customers may want to change field labels in Advanced Analytics reports. For example, when a job requisition field is mapped to a field with a different name, such as Custom Field 1, this is where you will make the change.

The Field Label Customization Options page with the Facility, Custom 1, Custom 2, Custom 3, and Custom 4 fields highlighted.

Customize Advanced Analytics Field Labels

This video provides a demonstration of how to customize advanced analytics field labels.

Note

There is no audio in this video.

Business Example

Update any field labels as required for Advanced Analytics reporting.

Steps

  1. Log in to Command Center and use the Recruiting Advanced Analytics Admin quick link.

  2. Navigate to Field Label Customization.

  3. For Custom 1, enter Legal Entity.

  4. For Custom 2, enter Business Unit.

  5. For Custom 3, enter Onsite or Remote.

  6. For Custom 4, enter Req ID.

  7. Choose Save.

Data Purge

Data Purge is used to correct errors. It removes existing information so it can be corrected. All purged data must be completely reloaded.

An ATS Data Purge is used when the customer would like to change their status mappings. You can choose to purge all data, or you can select a starting date from which to purge the data.

Note that you do not need to purge data because existing statuses need to be mapped, only when statuses were mapped incorrectly.

When you run a purge, all statuses will be pulled in the next day (or the day after, depending on cutoff time), regardless of the frequency that is set.

The status activity will be reloaded since the date at the bottom of the Integration Settings page.

ATS and Job Patch Data Purge page with a Purge all data radio button selected.

Purge Data

Follow these instructions if your customer's mapping needs to be reloaded.

Note

Important! If there are multiple years of data, contact Support; do not do a full purge on your own. The data loads in bulk and may load out of order.

Steps

  1. Run a report to determine when the Career Site Builder site went live. Change the time period to Custom and enter a date well before go-live. Filter the report by quarter. In the example shown here, the CSB site went live in Q1 of 2020.

    Data Purge Process
  2. From the Data Purge page, run a full purge of ATS data.

  3. After the next sync is scheduled to run (typically one to two days), look at the Advanced Analytics report to confirm that all data has been purged.

  4. From the Integration Settings page, run Get Data One Time, using a begin date one month before the Career Site Builder site went live. For this example, enter December 1, 2019. Enter today’s date for the end date.

    Get Data One Time checkbox is selected.
  5. After the next sync runs, remap the statuses from the Status Mappings page. (Remember that if your email address is entered for the Notify field, you will receive an email notification that statuses need to be mapped.)

Role-Based Permissions

Functional consultants will complete the setup by granting permission to generate reports. Customers also have the ability to enable their own users.

Users must be set up in Recruiter SSO. There are two levels of permissions:

  • Ability to access reporting in Advanced Analytics
  • Ability to drill into the details (international customers will want to limit this permission if recruiters in one country shouldn't be able to view candidates for jobs in a different country)
Set up Rold-Based Permissions. On the Permission settings page, select the Recruiter RMK SSO Permission, Recruiting Marketing Advanced Analytics Permission, and Access Advanced Analytics with Details checkboxes.

Set Role-Based Permissions for Advanced Analytics

Business Example

In this exercise, provide permission for members of the Staffing Department to access reporting in Advanced Analytics, and permission Admins to be able to drill into the details.

Steps

  1. Navigate to Admin CenterManage Permission Roles, select the Administrators role, and then click the Permission button.

    • In the User Permissions section, select Recruiting Permissions on the left, and on the right, select both Recruiting Marketing Advanced Analytics Permission and Access Advanced Analytics with Details.

    • Choose Done and Save Changes.

  2. Repeat these steps for the Staffing role, except do not grant the permission to Access Advanced Analytics with Details.

Customer Handoff

Remember that when you configured the Integration Settings page, in the Notify field, you entered your email address so that after the nightly data sync runs, you will receive an email notification if statuses need to be mapped. After all statuses have been successfully mapped to Advanced Analytics, you will remove your email address from this field and enter the email address(es) for the customer administrator who is to be responsible for monitoring this. Multiple emails and/or email distribution lists can be entered in the Notify field, separated by a semicolon. For example: admin@email.com, hris@email.com (distribution list).

Remind your customer that they do not have access to the backend Recruiting Command Center application. If they change or add statuses to the applicant status set and receive an email about the change, they will need to contact Support to map the new status(es) in Advanced Analytics.

Log in to track your progress & complete quizzes