Tutorial: Create Report to Track Status of Success Plan Over Time
This tutorial explains how an administrator can create a report to track the status of a success plan over time. In this tutorial, we will create a success plan report using a data space. We will create a data space on the Call to Action object that can eventually be used to generate a report to track the status of a success plan. The report can be used to view the number of objectives that are being met by each customer.
Create the Data Space
- Navigate to Administration > Operations > Data Spaces.
- Click +DATA SPACE.
- From the Select Object drop-down list, select Call to Action.
- Add fields to the dataspace as specified in the table below by clicking the
icon corresponding to the required field:
From Object |
|
---|---|
Calls to Action |
Call to Action Name (Objective Name), Comments, Created Date, Account, Due Date, Assignee |
From Fields |
|
CTA Group |
Action Plan, Plan Description, CTA Group Name, Closed Task Count, Success Plan Type, Status |
CTA Group > Template |
Name |
Account |
Account Name |
Objective Category |
Meta Info Name |
Assignee |
Full Name, Manager ID |
Assignee > Manager ID |
Full Name |
Status |
Picklist Name (Objective Status) |
- Add the following filter by clicking the
icon corresponding to the required field.
Call to Action > Assignee > Manager ID (current user)
-
Enter the required name and description in the Name and Description fields respectively, and click SAVE.
Note: Gainsight recommends you enter a meaningful name and description for the data space, as this name will appear in the Report Builder and other consumption areas while accessing the data space.
Create the Report
- Navigate to Administration > Analytics > Report Builder and select the data space you just created.
- Click the + icon in the Show me field to view all the fields that you have added while creating the data space.
- In the Show me field, select Objective Name (Call to Action Name). Set the aggregation method to count.
- In the By field, select Account Name and Objective Status (Picklist Name).
Note: Objective Name and Objective Status are the display names for the Call to Action Name and Picklist Name fields respectively.
- Add a date filter to view the success plans for a specific time-period (as required).
- Add a filter to view the success plans by its owner (as required).
- Select the required visualization type.
- Click Run. The required report is generated.
- You can view this report in the following ways:
- Apply the “current user” filter and view the user’s dashboard.
OR
- Type-in any name (using the name filter) and view the status of the particular user.
You can also drill down the report by clicking on a specific data point. Additionally, the manager filter that was added while creating the data space gives you the option to view all of your team’s objectives and progress across customers.