- MindTouch GeniusLink for Salesforce must be installed (instructions)
- User with permission to create reports in Salesforce
- Cases with linked articles to verify the reports are working
Understanding The Data Model
MindTouch stores information as Custom Objects in Salesforce.
- Cases are a standard Salesforce Object.
- MindTouch Articles are a Custom Object installed by the MindTouch GeniusLink for Salesforce package. They store information such as the Article Title and URL. If a new article is published from a case, the Parent_Case field shows the case that generated the article. If an existing article is simply linked to a case, the Parent_Case will be empty.
- MindTouch Related Articles is a many-to-many relationship between Cases and MindTouch Articles (one Case can have many Articles, and one Article can be linked to many Cases).
When creating a report, your primary object might be the Case (to find all its associated Articles), a MindTouch Article (to find all its associated Cases), or even a User (to find the MindTouch Related Articles they have created).
For this how-to, we'll create a report showing each Case and its number of MindTouch Related Articles.
Creating The Report
In Service Cloud, click the dropdown to access the Reports tab, and click New Report.
All MindTouch reports are in the "Customer Support Reports" section. Because we want to focus on Cases, select Cases and MindTouch Related Articles.
You are now in the report editor. Make sure the report has the data range you need (this quarter, all time, etc.), and select the Summary View:
We want to group first by Case Number, then the Related Articles underneath. Drag "Case Number" into the summary table as the primary field, with "MindTouch Related Article ID" underneath. If the groups get put in the wrong order you can click the dropdown and select "Move group up".
Click Run Report to verify the data is correct. You will probably want to sort by Record Count, descending:
If this report looks correct, click "Save As" and give the report a name, such as "Cases - Number of Articles"
Add The Report to A Dashboard
Under the Reports tab, click New Dashboard, which opens the dashboard editor. On the left bar, drag the report ("Cases - Number of Articles") onto the Dashboard as a data source.
Switch over to the Components tab and drag the horizontal bar chart onto the data source.
The report will spin and populate with data. Click the wrench icon to change the settings to sort by Value descending.
Save your dashboard, give it a name. You can now run the dashboard to see the results:
That's it! Experiment with other report types:
- Group by User, then number of MindTouch Related Articles (to see usage by agent)
- Group by MindTouch Related Articles, then number of Cases (to see the most popular article)
- Use formula fields to have reports on various KCS metrics being tracked
Example: Article Creation Report
MindTouch GeniusLink for Salesforce allows you to create new articles from within the widget. Similar to the above, a report can be made to measure this activity:
Cases that created articles:
- Create a tabular report
- Group by MindTouch Article: Parent_Case
- Next, drag in the field you'd like to see, such as MindTouch Article: Title
- Add a filter to hide MindTouch Articles without a Parent_Case.
MindTouch Articles created by user:
- Create a tabular report
- First, group by MindTouch Article: Created By: Full Name
- Next, add a filter to hide articles where the Parent Case : Case Number is not empty. (Note: Salesforce reports appears to have bugs with the filter, where blank rows may still appear. Adding the filter does remove some of the blank rows, however.)
Once these reports are added, they can be added as data sources in your dashboard. Create two bar charts, and drag in the data sources above: