header

A Data Designer Use case

  • 7 May 2020
  • 1 reply
  • 163 views

Userlevel 3
  • Gainsight Employee: Shoshin
  • 1 reply

Hello Gainsight Admin Community!

Having the option to see percentages across an entire customer base in reports or combining multiple data sources is one of the most frequently asked requirements we hear from customers.
We are going to calculate the % of customers flagged with risk grouped by segment/industry and CTA type.

dUVGIHWbWGRsEL6NVniLUXoYGH8MswP9cOyF6SeY8_ZsLKA5RkAs7mTEBHtI50SpJGf4DB_ZUPxioXAmVVErlH23TSeDKbvEQoHUF9mwgrP2t9pkqrOttTsyJ6dajbZ_XcGc-uoq

To achieve this we often need to combine several data objects from both MDA and Salesforce.

This can be done by designing a simple data designer task and leveraging the dataspace created in the reports. Data Designer gives you the tools to do this, helping you merge and transform data from these disparate data sources to create a Dataset for your further analysis. 

For more information, I suggest reviewing this document: Data Designer Overview

---------------------------------------------------------------------------------------------------------------------------

To start building your task, navigate to Administration -> Data Designer ->

Click “New Design”.

----------------------------------------------------------------------------------------------------------------------------

DETAILS:

Enter the Details:

Note: The name of the design will become the name of the data space created in Data Management in step 4..

 

H4eo4ru45mTPSJpM4J9R6KOqlXPwrgchBJ1IkfcuvcS-qwjB4LaMOZyjwZS-SZAmdCIcvw-7ZWJNiI8AZKlVUn1QSn6swgn16yx0odh3Ya4R4VrsEgih6OFYstvvpI7UT9Ve2__vOnce you’ve added details, click to the “Preparation” step. 

 

oQNKWIWv00ki3jfyHeRHVFq1ja5GlKoSaLmGY6y39FozojZNM1n3sK1E21WfTeQUw9Sjkm0DuMYcHAXMwhnZjXpN1UIWRK0w3uWzY9NGTSDtnXQdlcbfbQXKdKtH-iYU1C9cvYQ9PREPARATION:

In the preparation step, you can merge two (or more) different objects to create a new Dataset. If required, you can Transform a dataset and apply Filters, Formulas, Case Expressions, and more! 

Let us now go step by step  to pull our data sources together! 

STEP 1:

Select data source as Matrix data and object as Activity Timeline. Drag and drop the Activity Timeline object from the list to the canvas screen. Select the required fields you want to add and modify the Display name of the field to draw insights. 

Include the filter Context Id as CTA since we are interested in merging the CTA’s Timeline activities to the CTA object in our next coming steps

gca_2_wz9HUDu3I8e9WuZMpJPXVGJrC765oUZaydUmsg1norAsBf1K-Uh3B1xCwEHPnvtv9805WbfQALyLZWr9Q0naBTMVkTvqM-jxNAPCierjJl330tna9mBoEpuxvhvDh7mc-p


 

STEP 2:

Fetch the recent CTA timeline entry - Group by Context Id and aggregate Maximum of the Activity Date.

 

tc0ZOLQTNtFZvsCRUlFBsPe0HLgNfOdaQ8U5zreTEngIfdoxBd4CR4G6eQ4irZHEeDAH_zle_6wNypop-5TfiU3FkC10-j-goISQjL2bhtJMxJF_E9vuV9xoaUMyk1ppPG__QQxV

STEP 3 :

Merge the above two data sets 

Perform an inner join of both Activity Timeline and Find Max Activity date datasets which will retain the common data of both datasets. This way we are able to bring in the most recent activity update of CTA type.

After the merge the flow diagram should look something like this

7ovEegmEv1cJcJ9vFY8RkwuLrE2_zbdRrEK_Njt-N8kEgIvZ6zjoboELMvrH8bv66oeqf_Q9tDZ00madPv6XZySsLDm5uox6O1R6tdNhZ_4Y3OLMyeIyqTX7DbOUxdC7njk3TzIr

 

STEP 4:

Drag and drop Call To Action object. Select all the required fields and save the dataset.

 

7QtM2WP8w45-xgnVrji2SIYbiM4Kv75jTbx-mciteMaOqUyzNGQ_YMIAVV6l5FvJS852ER01VIJfs1PsjB5tPr6v5xzSqHzZ3ADkVW9xpBV_ICLFPyQwKKYNQD8mhbd8W6Wb0L2S

Now combining all CTA level timeline activities with corresponding CTA details.

 

STEP 4:

Merge the dataset  Find Most Recent Activity Update  with the Call To Action dataset

An inner join again which results in mapping the CTA details

 

Q4TWoObxu5PtEF7LFOOGFLTDg7LM5frabD6flEq7G2BE-V85YocBYwOiCz3t5g2w4cG9Ji8VuExJo6awIfy67Rd7iZdIGhCsXHbcAVSkuz-egxnzF02MfLmchB9RgjQp4G2PPLtd



STEP 5 :

Now make the data source to  Matrix data then drag and drop Company object from the list. We are pulling this dataset so that we have the company specific fields like ARR,Segment,Industry, Renewal date in our final dataset.

Select all the fields you want to have in the final dataset.

IJ8QiZ_ondzcQmtFw-hwyt6P0BcfBvs5SyuQh99rtj0pkcG-BnHZbdhrV9zATQxv8Jm0RbY-Qg_dCXkdMsnNkzL6OLGtaeqYU4gtnizw7svSw76XN9roHPWRHwnzAoqbLR2Nw4S-


Now merge the company dataset with the CTA details data set.

Perform an inner join with account id

PynRxXkCyZ0cVSbWtcdprO7HWnxhhHAc7ESu1huze87EIzXUlWzDF9yMGZjsqLO7lXqhRc9RJKVMdExyYz0ZhY90t8M0eM_mpFm0ow3Y-tFCAbCSApkTrx5vUVPDEWoT3uKS-WAl

 

We are done with the preparation step!

The final datasets should look something like this6Ann7ABlOV3o-ufyms9yDtzuFlGvT6JZd7eovydojNnX3PD8-q1MEt78-jKAe7IzZLGRHOLKO1tSxpe6eYfnIB8CJZ4zvkFSaK2p5W4duVKXt7owr6XxbQGN6LQenNNUQ8UvC2Z3

 

ANALYSIS:

 Once you prepare an output dataset in the Preparation tab, and navigate to the Analysis tab, you can see the following image. Click Run Now to associate a dataset with the design, and you can see that the Dataset is being prepared for analysis.

But this step will not let the dataspace to be available across Gainsight.So for now skip this step and move to the next step.

 

CONFIGURE:

 Check the option to make the resultant dataspace permanent across Gainsight.

O18meAikiCT241Vh1inG8S_bxGy0p7u7e9dSXvriGftpxpinaKlF6RL3d-cSskgfRTuNriUfYd5LvE8LJYX-jQC9PQJ5giJN6D2TXEL2QlqKkk0_ROMYF5pk_m_-GD8uWQTDXYgX

 

Now come back to the list and click on run now on the data designer task you have just created.


 

TKEw4_MbFLDgnA-uiN6UaAY36URFYNK09IyXgDKHlzpth_ylI-V9LYY-hrHzgB_5e9DUtghxkw3EkS4AnlG54T0sAYfbutXyAWdsZx4b37rdf5VmG_3FAjzAm1MjVQsG0xrjAB4t

 

Once the Refresh is completed, you will receive an execution status email. And, the dataset with the name “Risk Status of Customers” (Data designer task name) is now available across gainsight and you can pull this dataspace in Rules and Reports.

 

FINAL STEP :

 

Now pull this dataspace into a report and If everything looks good, you can schedule the data designer task (You can find that in the CONFIGURE step). We recommend running this task daily.

We can build reports on the object that has been created as part of the data designer configuration.

Here I have built a report to show % of flagged risk customers.

sy8_6WkPoHHbok9RcZ5Kaqpw3zUOPyOi8Mcd8N2_HxIl-0ocIiZSvUJDhQzavyZ4u8TZW5PKIITLkqSRqYFOrAWCat-_ewY18svBuFhPSwepvSVotOtmPLqMhEfxu2bE85SdRWU1

 

And pull out the fields to show me and group by section.

Keep appropriate filters like flagged = true , segments you want to include and other filters.

Here in this report I’m counting the number of sfdc accounts and grouping them by Segment and CTA type which will give me percentage of Risk and No Risk customers segment wise.

Choose a stacked column view of data and save the report.

Woah! You are done.

m9wHVlPqKUk8l4hRizxWQjeJmffQN_o7rWIP4JTB1vSjRkaS7FgdwRLMbMorX3fb-zblbRnbaaShZbuVtz9P0pl4-2L5y5BHkwqALWsw5kP1WLNQPG6FowjKHYKotFp9OKBsnKs2



 

Hope this post is helpful!

Happy Gainsighting :)


1 reply

Userlevel 7
Badge

@shivani Thanks for sharing this here!

Reply