US Admin Office Hours (Tuesday session) - 05/09/23 - 1 pm PT / 2pm MT / 3pm CT / 4pm ET - Pre-session Thread

1. Account Scorecard History object. How to query for "accounts [a] currently in red status but [b] were not red yesterday"? We believe we have [a] covered in the below filter screen print (Company Id → Current Score -> Label = Red), we're struggling with [b].
2. Options for getting Gainsight data into Power BI (Data Designer > S3, what else is available?)
3. Sending XLSX reports as email attachments via JO has a 1K record limit per file. According to online docs there is a CSV option with unlimited records but we can't find how to choose CSV instead of XLSX.
4. How to add content from multiple Company records into the body of a JO email? For example, if a CSM is to receive the same notification regarding 10 accounts, I’d rather send one email with the 10 account names in the body, rather than 10 separate emails to the same CSM.

1. Creating scorecard rule for whether a Success Plan has been created in the past 365 days. We have something similar for a meeting type but that pulls from timeline so slightly different when trying to mimic rule setup and actions.
2. Creating a calculated field on the Company level to determine how far out from go-live and how close to renewal date a customer is.

Hi @sdrostgainsightcom  - Were you able to find the documentation on creating a Rich Text hyperlink field? Also, have a question on Success Plans.

Hi Scott,

I have a question about participants in an JO.  I am using a segment for my participants.  This same email will be sent every 6 months.  I want to be able to stop a participant from getting the email again in 6 months if they clicked a link in the email previously.  I’m not sure how to do that. 

Thanks,

Rhonda

And a follow-up note for our Turned to Red discussion @justo.casablanca -- you would filter the Scorecard History object for:

Snapshot Date greater or equal  last week   AND

Snapshot Date less than current week.

Should yield only 1 row per customer (remember to filter for Active = True as well)

@sdrostgainsightcom - how are you today? I missed the office hours unfortunately, however I had a question. We are trying to automate the Gainsight user deprovisioning as part of our offboarding process. In order to make progress with it, we need help from you or another team member to confirm if Gainsight supports SCIM or has an Open API endpoint for managing user status/ deactivating users. Is this something you can help us with?

@sdrostgainsightcom , thank you so much for your time today! As the meeting was coming to a close I tried to unmute but couldn’t get there in time. Do you have any recommendations on solution options for my question # 2 in my original post? We want Power BI to be able to consume multiple of our Gainsight objects, what are the potential solution options that we should be researching on our end?

Hello @justo.casablanca  -- glad we were able to cover so much during the session!

On pushing data to Power BI, yes, the drop-to-S3 is the best way to push data there for daily or weekly large dataloads.  If you are needing to push, say, survey results as they come in, you can use External Actions to allow the Rules Engine to call the PowerBI API directly, but that’s for a handful of records at a time.

And although building it in Data Designer is fine, I’d recommend NOT publishing the Data Designer, but instead saving it as a template and then fetching that same design into a Horizon Rule, which basically runs form the DD engine -- and you can now save designs when it makes sense and then copy them into new rules or DDs and tweak as needed.

When you do it that way, you don’t end up with the DD creating another object in your instance -the rule just runs and then drops the file to S3.

Hello @ralucagorbanescu -- yes, you can use the GS User REST API to set up to 50 user statuses to Inactive at a time in each call.

Link is below to the documentation.  Note that you need to have the User GSID (the Gainsight native “row ID” in the GS User table) to update the user -- however, if you scroll down one more section in the same document, it has the API documentation for fetching User info from the table.

Hope that helps!

https://support.gainsight.com/Gainsight_NXT/API_and_Developer_Docs/User_Management_APIs/User_Management_APIs#Update_Users_Status