Configure Coach reporting in Salesforce

See how it's done on Salesforce Lightning

• Install and configure the Showpad Coach Reporting for Salesforce App
• Schedule automatic data retrievals from Showpad to Salesforce
• View your Coach Reporting data in Salesforce

Do this step by step

Install and configure the Showpad Coach Reporting for Salesforce App

1. In Salesforce Lightning, navigate to set up and search for Deliverability in the quick search.
2. Click the Access Level drop down and select All Email. Click Save.
3. Install the Showpad Coach Reporting package here, and follow the installation setup. Select the Install for All Users option. 
4. In Showpad, generate your personal API token. Navigate to Admin Settings, then select API.
5. Click API Tokens. To create a new one, add a name, leave Expiry Date unchecked, and then click Add. Copy the token, as you will need it later, then click Done.
6. In Salesforce, click Setup. In the left side menu, search and select Custom Metadata Types.
7. Find Showpad Coach Authorization and click Manage Records. 
8. Click New to create a new record. Fill in the Label, Showpad Coach Reporting Authorization Name, and Legacy LearnCore Token fields with showpad_coach_api.
9. In the Showpad Coach Reporting API Org field, input your Showpad subdomain.
10. In the Showpad Coach Reporting API auth, paste the API token you generated in step 5.
11. Click Save. 
12. Using the quick search menu, find Remote Site Settings. Click New Remote Site. 
13. Name the site, for example showpad_coach_api. Add your Showpad URL as the website, for example, https://myorganization.showpad.biz. Click Save. 
14. At this point, you can do an initial data sync between Showpad and Salesforce. To do so, open the app launcher and select the Showpad Coach App. 
15. Select the Showpad Coach Sync Test tab.
16. Click Sync reporting data now. This will initiate a sync of users, course, and path data to your Salesforce instance. Data will populate in the Showpad Coach Users, Showpad Coach Courses, etc tabs in the top menu. 
17. Click any of the tabs in your Showpad Coach app to populate and view the reports.

Schedule automatic data retrievals 

1. With Coach reporting in Salesforce, you can also schedule automatic retrieval of data from Showpad. To do so search for Apex Classes in Salesforce setup. Select Apex Classes.
2. Click Schedule Apex.
3. Give the scheduled job a name, such as Daily Coach Reporting Sync: Users.
4. In the Apex Class field, input the type of report that you would like to pull from Showpad. The options are:
   ScheduledLearnCoreUserMerge
   ScheduledLearnCoreCourseUserMerge
   ScheduledLearnCoreAdminManagerMerge
   ScheduledLearnCoreChecklistItemUserMerge
   ScheduledLearnCorePathUserMerge
   Clicking the search icon to the right of the Apex Class field will populate these items.
5. Next, specify the frequency you wish for the reporting data to be pulled from the Showpad Coach reporting API. Select Weekly or Monthly, then by days of the week or days of the month. We recommend scheduling the job late every evening when traffic is minimal.
6. Click Save. 
7. Repeat this process for each of the reporting types you wish to import into Salesforce. 
8. To manage any scheduled jobs, navigate to Setup and search Scheduled Jobs. Select the Apex Class you wish to edit, then click Manage.

Viewing your reporting data in Salesforce

Once your scheduled job runs or you manually sync using the Showpad Coach Sync Test tab, you will be able to view the Coach Reporting data in Salesforce. There are multiple ways to navigate to and view this data in Salesforce.

To view the individual data records, select from the various tabs created by the Showpad Coach app. Each can be toggled in the list view to populate recently viewed items, or all items.

The Showpad Course and Users report covers the courses a user is assigned to and their completion data. The Showpad Coach Users report shows an overview of the number of assignments users have in Coach and their status. The Showpad Coach Admin Manager report covers data based on admins and managers pertaining to their grading, such as the number of reviews they have given, and their review averages for pitches and tests. Showpad Coach Path and User report tracks user progress through their assigned paths. Finally, the Showpad Coach Path Items and Users report shows more detail on each path item and user progress for each path.  

To view various reports at once, navigate to the Dashboard tab and select Showpad Coach. Here you will find reports and leaderboards that relate a user's Coach statistics with opportunities related to that user to display how their coursework relates to their sales numbers. 

The Current Fiscal Year Revenue by Manager vs Pitch IQ graph, for example, compares the Salesforce users who are managers (using the Salesforce role hierarchy) and the courses completed by their team with how much expected revenue is in open opportunities within the team. 

Lastly, you can find your Showpad Coach reports in a list or create new reports by clicking the Reports Tab. Under all folders, select Showpad Coach. Select a report to view from the list, or click New Report.