Using Salesforce's Reporting tools combined with the SchoolKeep Salesforce integration, you can include Enrollment data in your reports.
In the example below, you will create an Account-level report that includes progress data on each of the Contacts associated with that account.
Note: Your Salesforce interface may differ depending on the customizations that have been made in your instance.
Part 1: Creating a custom report type
Click here to learn more about managing custom report types.
Within Salesforce, click Setup.
Type Report Types into the quick search box on the left-hand side of the page. Click Report Types.
Click New Custom Report Type.
Fill out the information in the custom report type.
- Primary object: Contacts.
- Report type label: Enter a label that will remind you what this report is for. In the example, we’ve used the label Enrollment Report.
- Report type name will auto-populate. There is no need to change it.
- Description: Enter a description that will remind you about what the report type provides.
- Store in category: Accounts and Contacts.
- Deployment Status: Choose Deployed to start using this new custom report type.
You will see a screen to set up the object relationships. Click where it says Click to relate another object.
Select Enrollments from the dropdown, and choose “A” records may or may not have “B” records. This enables you to see contacts who may not have any enrollment objects yet.
Review your custom report type. From here, you can edit, delete, or clone this custom report type.
Part 2: Building a report
Additional reports can be created using this data to meet your organization’s needs. Click here for more information on Salesforce report capabilities.
In Salesforce, click the Reports tab.
Click New Report.
Expand the Accounts & Contacts folder and locate the Enrollment Report. This is the folder where we stored the custom report type from the field Store in category from step 3 of the section above.
Locate the Enrollments fields available to you. Drag any of the fields to the report. For this example, use Course Name.
Choose additional fields that you’d like to see on this report. For this example, add the account name, course progress, and additional fields to help identify the contact.
Click Run Report to see the report with all data.
View finished report.