Articles in this section

Connecting Sumo with Einstein Analytics

Simon Wheeldon
  • Updated
Follow

Goal

The goal is to drive an increase in revenue around understanding the behaviours of your sales team and identifying areas for improvement.

The behaviours are captured by the Cloudapps Sumo solution and can be analysed using Einstein Analytics.

This document is split into 2 main sections:

  1. Extracting the data into Einstein Analytics

  2. Building Einstein Dashboards on the Sumo Data


Extracting the Data into Einstein Analytics

Assign Permissions to Analytics Cloud Integration User

  • Assign a Sumo License to your Analytics Cloud Integration User
  • Setup a new Permission Set - Sumo Analytics

2020-09-10_11-37-48.png

  • Add read permission on all the fields (except for DEPRECATED fields) of the following objects:
    • Insights

    • Base Behaviours

    • Graphics

    • Rewards (make sure this is the Reward object that is part of the Sumo package)

    • Behaviours

    • Members

    • Collectives

    • Observations
  • Assign this Permission Set to your Analytics Cloud Integration User

Create the Sumo Analytics App

  • Select the Analytics Studio App from your salesforce app icon

2020-09-10_10-45-00.png

First, we are going to create a new App as a container for our datasets and dashboards. 

  • Press the Create button in the top right-hand side of the page and select App

2020-09-10_14-52-43.png

  • Press the Create a Blank App button

2020-09-10_15-05-57.png

  • Press the Continue button

2020-09-10_15-07-08.png

  • Give the App a Name e.g. Sumo Analytics and press the Create button

2020-09-10_15-00-42.png


Create Sumo Analytics Dataflow

  • Select Data Manager from the Setup button on the top right of your navigation bar

2020-09-10_11-00-28.png

  • Select Dataflows & Recipes from the left-hand menu

2020-09-10_11-12-35.png

  • Press the Create Dataflow button in the top right-hand part of the page

2020-09-10_16-27-40.png

  • Give the Dataflow a Name e.g. Sumo Dataflow and press the Create button

We recommend building 3 Dataset for your analysis:

  1. Sumo Insights

  2. Sumo Rewards

  3. Sumo Observations
  4. Sumo Opportunities

Create Sumo Insights Dataset

  • Select the datasetBuilder button.  This provides a wizard to select the objects and fields we need from salesforce in our dataset

2020-09-10_11-15-49.png

  • Give the Dataset a Name - e.g. Sumo Insights and press the Continue button

2020-09-10_11-18-53.png

You will be presented with a list of all the objects the Analytics Cloud Integration User can see. 

  • Select Insight from this list

2020-09-10_11-55-24.png

  • Hover over the Insights blue bar and a + button will appear to the right of the bar.  Press this + button

2020-09-10_11-58-29.png

  • Select the following fields:
    • Category

    • Occurrence Date

    • Related Record ID

    • Test Record

    • Type

  • Choose the Relationships tab

2020-09-10_12-03-13.png

  • Click on JOIN next to the Base Behaviour

2020-09-10_12-18-08.png

  • Click on Join on User
  • Hover over the Base Behaviour blue bar and a + button will appear to the right of the bar.  Press this + button

2020-09-10_12-20-03.png

  • Then choose the following fields:
    • Behaviour Name

    • Business Area

    • Object

    • Undesirable

    • Value

  • Hover over the User blue bar and a + button will appear to the right of the bar.  Press this + button
  • Then choose the following fields:
    • Full Name

    • Recommended:
      • Country

      • Department

      • Division

  • Then add any useful custom user fields
  • Choose the Relationships tab
  • Click on JOIN next to the Manager

2020-09-10_13-28-53.png

  • Hover over the second User blue bar and a + button will appear to the right of the bar.  Press this + button
  • Then choose the following fields:
    • Full Name

  • Then press the Next button at the bottom of the page


Einstein Analytics will then build the process to extract the fields from the objects you have identified and then join the data into a single dataset.
It should look like this:2020-09-10_13-36-35.png

 

  • Press the Update Dataflow and give the version a name and then press the Update Dataflow button

2020-09-10_13-39-47.png

  • Press the Run Dataflow button

2020-09-10_13-40-47.png

  • Press the Go to Data Monitor

2020-09-10_13-41-43.png

  • Refresh the page and monitor to make sure it completes successfully

Create the Sumo Insight Recipe

Now we are going to build a Recipe to hide certain fields and also rename certain fields.

  • Select Data from the left-hand menu

2020-09-10_14-12-32.png

  • Click on the Sumo Insights record and give the Recipe a Name - e.g. Sumo Insights

You will be presented with a spreadsheet view of your dataset. 

  • Hide the following column:
    • User

    • Base Behaviour

    • success__User__c.ManagerId

    • RecordId

  • Rename the following fields (select the Attributes tab on the right-hand pain and change the Field Label field:
Current Label New Label
success__Base_Behaviour__c.success__Functional_Area__c Business Area
success__Base_Behaviour__c.success__IsNegative__c Undesirable
success__Base_Behaviour__c.Name Base Behaviour
success__User__c.Country Country
success__User__c.Name User
success__User__c.Department Department
success__Base_Behaviour__c.success__Object__c Object
success__Base_Behaviour__c.success__Priority__c Value
success__User__c.ManagerId.Name Manager
success__User__c.Division Division
  • Press the Save button
  • Then press the Create Dataset button

2020-09-10_14-44-18.png

  • Select the Sumo Analytics App and then press the Continue button

2020-09-10_15-09-18.png

  • Select Yes when prompted if you wish to run the recipe periodically, and then press the Schedule Recipe button

2020-09-10_14-47-57.png

  • Suggest the follow scheduling parameters

2020-09-10_14-49-52.png

The Sumo Insights dataset is now ready to be used to create your dashboards.

Create Sumo Rewards Dataset

We now need to repeat thisprocess to create the Sumo Rewards dataset

  • Edit the Sumo Analytics Dataflow
  • Select the datasetBuilder button
  • Give the Dataset a Name - e.g. Sumo Rewards and press the Continue button
  • Choose the Reward Object and pick the following fields:
    • Badge

    • Hidden

    • Last Modified Date

    • Points

    • Related Record Id

    • Reward Type

    • Status

    • Test Record

    • Relationships -> Badge Type

      • Graphic Name

    • Relationships -> Base Behaviour

      • Behaviour Name

      • Business Area

      • Object

      • Undesirable

      • Value

    • Relationships -> Behaviour

      • Relationships - Collective

        • Name
    • Relationships -> Member

      • Grouping
      • Member Role

    • Relationships -> User

      • Full Name

      • Country

      • Department

      • Division

      • Relationships - Manager ID

        • FullName


2020-09-10_17-09-05.png

  • Press the Update Dataflow and give the version a name e.g. Added Sumo Rewards, and then press the Update Dataflow button
  • Press the Run Dataflow button
  • Press the Go to Data Monitor button
  • Refresh the page and monitor to make sure it completes successfully

Create the Sumo Rewards Recipe

Now we are going to build a Recipe to hide certain fields and also rename certain fields.

  • Select Data from the left-hand menu

2020-09-10_14-12-32.png

Click on the Sumo Rewards record and give the Recipe a Name - e.g. Sumo Rewards

You will be presented with a spreadsheet view of your dataset. 

  • Hide the following column:
    • User

    • Base Behaviour

    • success__User__c.ManagerId

    • RecordId

    • Badge Type

    • Behaviour

    • success__Team_Achievement__c.success__Team__c

    • Member

  • Rename the following fields (select the Attributes tab on the right hand pain and change the Field Label field:
Current Label New Label
success__Achievement__c.success__Functional_Area__c Business Area
success__Achievement__c.success__IsNegative__c Undesirable
success__Achievement__c.Name Base Behaviour
success__User__c.Country Country
success__User__c.Name User
success__User__c.Department Department
success__Achievement__c.success__Object__c Object
success__Achievement__c.success__Priority__c Value
success__User__c.ManagerId.Name Manager
success__User__c.Division Division
Last Modified Date Occurrence Date
success__Team_Member__c.success__Role_Name__c Member Role
success__Badge_Type__c.Name Type
success__Team_Member__c.success__Grouping__c Group
success__Team_Achievement__c.success__Team__c.Name Collective
  • Press the Save button
  • Then press the Create Dataset button, select the Sumo Analytics App and then press the Continue button
  • Select Yes when prompted if you wish to run the recipe periodically, and then press the Schedule Recipe button
  • Suggest running every day at 04:00

The Sumo Rewards dataset is now ready to be used to create your dashboards

Create Sumo Observation Dataset

We now need to repeat this process to create the Sumo Observation dataset

  • Edit the Sumo Analytics Dataflow
  • Select the datasetBuilder button
  • Give the Dataset a Name - e.g. Sumo Observations and press the Continue button
  • Choose the Observation Object and pick the following fields:
    • Last Modified Date

    • Related Record Id

    • Test Record

    • Tracked Field Value
    • Relationships -> Base Behaviour

      • Behaviour Name

      • Business Area

      • Category
      • Object

      • Undesirable

      • Value

      • Relationships -> Type

        • Graphic Name

    • Relationships -> User

        • Full Name

        • Country

        • Department

        • Division

        • Relationships - Manager ID

          • FullName

  • Press the Update Dataflow and give the version a name e.g. Added Sumo Observations, and then press the Update Dataflow button
  • Press the Run Dataflow button
  • Press the Go to Data Monitor button
  • Refresh the page and monitor to make sure it completes successfully

Create the Sumo Observations Recipe

Now we are going to build a Recipe to hide certain fields and also rename certain fields.

  • Select Data from the left-hand menu

2020-09-10_14-12-32.png

Click on the Sumo Observations record and give the Recipe a Name - e.g. Sumo Observations

You will be presented with a spreadsheet view of your dataset. 

  • Hide the following column:
    • User

    • Base Behaviour

    • success__User__c.ManagerId

    • RecordId

    • success__Base_Behaviour__c.success__Badge_Type__c

  • Rename the following fields (select the Attributes tab on the right hand pain and change the Field Label field:
Current Label New Label
Last Modified Date Occurrence Date
success__Base_Behaviour__c.success__Badge_Type__c.Name Type
success__User__c.Country Country
success__User__c.Name User
success__User__c.Department Department
success__Base_Behaviour__c.success__Functional_Area__c Business Area
success__Base_Behaviour__c.success__Object__c Object
success__Base_Behaviour__c.success__Category__c Category
success__Base_Behaviour__c.success__Priority__c Value
success__User__c.ManagerId.Name Manager
success__User__c.Division Division
success__Base_Behaviour__c.success__IsNegative__c Undesirable
success__Base_Behaviour__c.Name Base Behaviour
  • Press the Save button
  • Then press the Create Dataset button, select the Sumo Analytics App and then press the Continue button
  • Select Yes when prompted if you wish to run the recipe periodically, and then press the Schedule Recipe button
  • Run every day at 04:30

The Sumo Observations dataset is now ready to be used to create your dashboards

Create Sumo Opportunities Dataset

We now need to repeat this process to create the Sumo Opportunities dataset

  • Edit the Sumo Analytics Dataflow
  • Select the datasetBuilder button
  • Give the Dataset a Name - e.g. Sumo Opportunities and press the Continue button
  • Choose the Opportunity Object and pick the following fields:
    • Amount
    • CloseDate

    • Name

    • Won

    • Relationships -> Owner ID

      • FullName

    • Relationships -> Account ID

      • Account Name

  • Press the Update Dataflow and give the version a name e.g. Added Sumo Opportunities, and then press the Update Dataflow button
  • Press the Run Dataflow button
  • Press the Go to Data Monitor
  • Refresh the page and monitor to make sure it completes successfully

Create the Sumo Opportunities Recipe

Now we are going to build a Recipe to hide certain fields and also rename certain fields.

  • Select Data from the left-hand menu

2020-09-10_14-12-32.png

  • Click on the Sumo Opportunities record and give the Recipe a Name - e.g. Sumo Opportunities

You will be presented with a spreadsheet view of your dataset. 

  • Hide the following column:
    • Account ID

    • Owner ID

  • Rename the following fields (select the Attributes tab on the right-hand pain and change the Field Label field:
Current Label New Label
AccountId.Name Account Name
OwnerId.Name Owner
Name Opportunity Name
  • Press the Save button
  • Then press the Create Dataset button, select the Sumo Analytics App and then press the Continue button
  • Select Yes when prompted if you wish to run the recipe periodically, and then press the Schedule Recipe button
  • Suggest the follow scheduling parameters

2020-09-11_09-51-48.png

The Sumo Rewards dataset is now ready to be used to create your dashboards.


Building Einstein Dashboards on the Sumo Data

  • Select the Analytics Studio App from your salesforce app icon
  • Press the Create button and select Dashboard from the drop down menu

2020-09-10_17-42-20.png

  • Press Create Blank Dashboard button 
  • Drag and drop the Chart icon onto the canvas, place and then resize

2020-09-10_17-59-40.png

  • Press the Chart button in the center of the panel and choose the Sumo Insights dataset
  • Press the + button under the Bars section and select Occurrence Date -> Year-Month-Day
  • Press the + button under the Bars section and select Type, then press the Done button
  • Change the Chart Type to Stacked Column
  • Drag and drop the Filter icon onto the canvas
  • Press the Filter button in the center of the panel and choose the Sumo Insights dataset -> Manager
  • Press the Eye icon on the top right-hand side to put your dashboard in a viewing mode.
  • Choose different Managers and see the effect on the chart
  • Press the Pencil icon on the top right-hand side to put your dashboard back into edit mode.
  • Press the Save icon on the top right-hand side to save your work.
  • Give your dashboard a name - e.g. Sumo Insights and place in the Sumo Analytics App, then press the Save button
  • Continue adding charts and filters to build the dashboard of your dreams!

Salesforce has a number of courses on Trailhead on building Einstein dashboards - this is a good starting one - https://trailhead.salesforce.com/content/learn/modules/wave_dashboard_designer_basics?trail_id=wave_analytics_enable_and_produce 

 

Comments

0 comments

Please sign in to leave a comment.