Data Management & Integrations

Share your questions and best practices on the Gainsight Analyzer, Adoption Explorer, GDM, API, Person model, or anything related to integrations.

  • 346 Posts
  • 958 Replies
S
Rank
shivani
started this topic

A Data Designer Use case

Hello Gainsight Admin Community! Having the option to see percentages across an entire customer base in reports or combining multiple data s...
  • 4
  • 2

What accounting system does your company use for billing?

  • 0
  • 1
spencer_engel
Rank
spencer_engel
started this topic

3 Quick Tips for when to use Gainsight Analyzer

Gainsight's Analyzer tool is a powerful tool that all Gainsight Admins should get familiar with. We have thorough documentation on the...
  • 4
  • 1

346 Posts

andrea_weisz
andrea_weiszRegistered User
asked in Data Management & Integrations

Want ability to view MDA Usage Data in Engagement Tab and "Usage" section of C360

Currently, you can only view SalesForce and Gainsight Data within the "Engagement Tab" and "Usage Section" of c360. We would like to marry this data to our MDA Data. For example, we would like to see if certain CTAs close, does this raise our product adoption. Currently, the Engagement Tab and Usage chicklet in 360 provide little value with our use case.

29
skalle
Gainsight Employee: Rookie
4 years ago
Shilpa Gumnur
Shilpa GumnurGainsight Community Manager
published in Data Management & Integrations

Suggestions for Person Admin

Hello everyone!Hope everyone's safe and doing well.I've recently joined the tribe of Gainsight as a Product Manager for the Person model, Sponsor Tracking and People Maps and I'm super excited to get working on my first project, revamp of the Person Admin section that would entail:- Person Upload config C360-Person Config Sponsor Tracking Config screen Rules Engine: Load to People actions You can guide or nudge me by:- Suggesting enhancements Share pain points UX improvements Technical or functional gaps Any other feedback I'm all in for this project and ready to read every bit of info, so please attach relevant images of screens where you'd like UX improvements/links to support tickets/ customer conversation(that can be shared) or any other artefact supported on this platform. You can even write a song🙂Waiting to hear from you soon and I know you are generous.Thank you,Shilpa

33529
Shilpa Gumnur
1 year ago
K
khadija.kRegistered User
asked in Data Management & Integrations

Gainsight Assist Error

Hello,When I try to use Gainsight Assist in my Outlook app, it shows me an error under the “Log Email to Timeline” option that says “Something went wrong! Please try again.”This is the New Outlook app on Mac. Any ideas?I’ve tried to remove and reinstall the ass in as well as close and reopen the Outlook app.

14
A
Shoshin
1 year ago
manmeet_dosanjh
Shoshin
manmeet_dosanjhShoshin
asked in Data Management & Integrations

Adoption Explorer Setup

Hi! I'm trying to get a project setup with Adoption Explorer tool but have some questions/confusion on the process. First, if we already have usage data from our platform stored in the MDA, what does adoption explorer offer? Is it a more powerful reporting tool with better insights? Reading throught the overview article, it doesn't seem to be much different than reports I've already built out. Secondly, regarding the creation of the project - we have an S3 connection to our platform usage, which is stored in custom MDA tables. Should I be using the S3 bucket as the source or the MDA tables? The biggest issue it seems for this setup is that an 'Account ID' is not provided in the usage datafeed and I have to load that from Salesforce into the MDA which is required by the project setup. Can I get some tips/tricks or recommendations on how to best set up Adoption Explorer? Thanks!

14
skalle
Gainsight Employee: Rookie
4 years ago
kate_green
Team Captain
kate_greenTeam Captain
asked in Data Management & Integrations

How do I populate the Manager field in the User standard object?

What's the best way to populate the Manager field in the User standard MDA object?  It's a GSID field type so I can't just populate it with the manager's SFDC ID. I was thinking of using a bionic rule to merge the manager's GSID with the CSM's GSID... is there a better way?  

12
kunal_bhat
Shoshin
5 years ago
kcsp
Team Captain
kcsp
asked in Data Management & Integrations

Create URL for Timeline Activity for Export

Is there a way to create a custom URL for Timeline activities that can be exported out?The hyperlinks in Gainsight are great, but they do not export out. We have some external reporting, and there are some pieces of data we can’t export (per company policy); it would be helpful to be able to export the Activity hyperlinks so users with permissions can be re-directed to Gainsight to drill into details where necessary.

11
spencer_engel
Golden Ruler
3 months ago
B
Shoshin
badariShoshin
asked in Data Management & Integrations

'Azure Data factory' connector is not available Gainsight

Hi Team,We need 'Azure Data factory' connector for the upcoming requirement to simply our data architecture in Gainsight. Could you please help us when it will be available in Gainsight. Thank you,Badari

11
B
Shoshin
9 months ago
Ester.Memoli
Team Captain
Ester.MemoliTeam Captain
asked in Data Management & Integrations

Pulling data from Power BI into Gainsight NXT

Hello,as far as I know, there’s no connector for Gainsight NXT and Power BI. Is there anything in the roadmap?Or which would be the best way/workaround to pull data from Power BI into NXT? Thanks

11
H
Veteran Rookie
1 year ago
darkknight
Grand Slammer
darkknightGrand Slammer
asked in Data Management & Integrations

Adoption Explorer configuration

I’m trying to get Adoption Explorer setup and working, but so far no luck.One question I have that I cannot seem to find in the documention - what do you do if your Weekly Time Series data has more than one Unique ID? For example, I have a usage data file that contains usage metrics by Company AND Usage Type, so for example if Gainsight were my customer I might have: Company Name        ID             Date                       Usage Type                       TotalGAINSIGHT                33455      11/12/2019          Logins                                365GAINSIGHT                33455      11/12/2019          Punches                            724GAINSIGHT                33455      11/19/2019          Logins                                398GAINSIGHT                33455      11/19/2019          Punches                            772 I want to make sure that I’m upserting on the ID, Date and Usage Type. When importing the data via S3 Connector, I have the option of selecting mul

11
skalle
Gainsight Employee: Rookie
3 years ago
darkknight
Grand Slammer
darkknightGrand Slammer
posted in Data Management & Integrations

Using MDA Picklist values in External Actions

I am in the process of trying to create rules to transfer data to via External API, but running into a challenge when it comes to MDA picklist values. Gainsight Support has already enabled the backend flag that actual values to an S3 file  It does not appear possible to use the actual values in an External API call.The only option is to create a Case Expression, but I have picklists with more than 10 options and GS Support says there is no way to extend that.There is also not a way to identify the corresponding GSID for each option, particularly if any of the options have never been selected before.Does anyone have any suggestions or alternative workarounds?

9
darkknight
Grand Slammer
1 year ago
jbeker
Shoshin
jbekerShoshin
asked in Data Management & Integrations

Zendesk and gainsight

We would like to know if it’s technically possible to build an integration to push data from Gainsight into zendesk. We are trying to keep our team in Gainsight as much as possible and recently rolled out zendesk for some of our internal teams, and would like for our CSM’s to enter data into Gainsight that then creates the tickets in zendesk.  Not Sure if anyone has done this or if it’s possible but curious for thoughts! 

9
anirbandutta
Gainsight Employee: Grand Slammer
1 year ago
brittinie_n_harper
brittinie_n_harperRegistered User
asked in Data Management & Integrations

Are Sandboxes important when working with Gainsight?

Hello, I am reaching out to see if there is any value on getting set up in Sandbox before Production. Just want to see if others utilized the Sandbox after the launch to Production. If you do have Sandbox, have you found it valuable to assist in your Gainsight process? Thank you for your help in advance.

8
brittinie_n_harper
4 years ago
gunjanm
ACE
gunjanmACE
asked in Data Management & Integrations

Load Opportunity Attachments from SFDC to Gainsight

Hi folks, has anyone ever brought in Opportunity attachments (specifically PDF contracts) into Gainsight for CSMs to easily reference? The object I have narrowed it down to in SFDC is Attached Content Document; however, the Rules Engine a) does not actually let me query anything on it, and b) shows only Account and Customer Info as lookup objects, even though the attachments actually sit on the Opportunity.  I’d like this to either easily live on the Opportunity related list as a link to download the PDF or create a separate related list with all attachments from SFDC (narrowing down by Type would be nice but can be dealt with). 

8
jean.nairon
All Star
2 years ago
ml2019
Veteran Rookie
ml2019Veteran Rookie
asked in Data Management & Integrations

Marketo Connector

We’d like to integrate Marketo data, I see that in the old connectors menu there’s an option to set up Marketo connector but it’s not in the new connectors 2.0 menu - can we still use the old one or should it be set up differently in the 2.0 menu?

8
T
10 months ago
seth
Gainsight Employee: ACE
sethGainsight Employee: ACE
asked in Data Management & Integrations

Google Analytics Foreign Key / corresponding ID is unfortunately & surprisingly case-sensitive

When setting up a Google Analytics integration, you pull in a field from Google Analytics that indicates the customer. In our case, it's called "abbreviation". Screenshot: [url=http://cl.ly/1X1J1Y1S2h08]http://cl.ly/1X1J1Y1S2h08[/url] You then indicate which Salesforce Account field corresponds to that Google Analytics field. In our case, it's called "Account Number". Screenshot: [url=http://cl.ly/3g272c0O1T0f]http://cl.ly/3g272c0O1T0f[/url] Unfortunately, when Gainsight aggregates the raw data into the "Day Agg" table, it performs a [i]case-sensitive match between our "abbreviation" and "Account Number". Some Accounts, therefore, have ended up without any aggregated Google Analytics data. I didn't realize that behavior when we were setting it up (it's not noted in the documentation [url=http://cl.ly/0x0F2u2q3E3H]http://cl.ly/0x0F2u2q3E3H[/url], and I did this setup live with our Project Manager, who either didn't know or think to mention it), and n

8
seth
Gainsight Employee: ACE
6 years ago
jnoble100
Veteran Rookie
jnoble100Veteran Rookie
asked in Data Management & Integrations

Looking for some insights into how people are using Google Analytics with Gainsight

We use Google Analytics for our high level product analytics and had this set up to come into Gainsight. It stopped working some time back and I understand that there were some wider issues with Google that Gainsight we’re working on (that are still in progress). Was looking to see from the community how other people are using Google Analytics with Gainsight and what insights and tips etc they could share.

8
jnoble100
Veteran Rookie
2 years ago
S
swadgeRegistered User
asked in Data Management & Integrations

Unable to see MDA object in rule engine

I am not able to see Matrix Data custom objects while creating rule action.I did go to ‘Rule Settings”, but it only gives me an option to see Salesforce objects, but not custom Gainsight objects. 

8
sdrostgainsightcom
1 month ago
shiv_kumar_katiyar
Gainsight Employee: Team Captain
shiv_kumar_katiyarGainsight Employee: Team Captain
asked in Data Management & Integrations

Do we have a good workaround or direct connector like G- Connector?

Hi There, Is there a way to move data from Gainsight into either a Google Sheet or Excel? I'm imagining something like what G-Connector does in Google Sheets where it automatically updates Google Sheets based off of a report in SFDC

8
ankitify
Shoshin
1 month ago
jnoble100
Veteran Rookie
jnoble100Veteran Rookie
asked in Data Management & Integrations

Unable to see new Dropdown category

Evening.We’ve set up a new dropdown list category in the company object and I’m trying to add it now to the activity types, as a new field. When I go into adding a new field, and the category selector I can’t see the new dropdown list I’ve added. This is using the “Configure for” Global setting.For the “Configure for” Company or Relationship setting I can see the new dropdown list in the category list but can’t edit existing activities.Any clues as to what I’m missing in the setup?Thanks in advance.    

8
sai_ram
Grand Slammer
3 years ago
darkknight
Grand Slammer
darkknightGrand Slammer
asked in Data Management & Integrations

Problem with Copilot and Data Spaces

I was trying to create a CoPilot power list using Data Spaces, but but it gives me an error "No account reference found in 'OPS: Tasks and Actions'.Create a account lookup to Salesforce Account object to proceed." [img]https://d1qy7qyune0vt1.cloudfront.net/gainsight-en/attachment/RackMultipart20161102-49902-1by3nnz-image_inline.png[/img] I opened a support ticket and was told "This is already a known issue. Our Product team has prioritized this issue and plan to make the fix available in the December Patch release."

7
Ravinder Singh
Gainsight Employee: Rookie
2 years ago
jahnavi
Shoshin
jahnaviShoshin
asked in Data Management & Integrations

Importing decimal values

When I import ARR for my customers and if the values are in decimal it would then truncate the decimal values  Eg: 0.876 is rounded to 0 Note I am trying manual import and not from S3 How do I import decimal values?

7
jahnavi
Shoshin
6 years ago
darkknight
Grand Slammer
darkknightGrand Slammer
asked in Data Management & Integrations

Enable MDA Joins

I raised this issue to support, but figured I'd come to the community as well in case I get a quicker response. I want to enable an MDA table to use joins, but do not seem to have the capability on a particular table. This document [url=https://support.gainsight.com/Product_Documentation/Data_Management_and_Integrations/Managing_Data_In_Gainsight/MDA_Joins]https://support.gainsight.com/Product_Documentation/Data_Management_and_Integrations/Managing_Data_I...[/url] says "Note: Currently, we support creation of lookup relation only on MDA objects for which joins are allowed." But it does not tell me how to enable joins on an MDA table where Allow Joins is set to false.  I cannot seem to find this explained anywhere else either.  Hopefully I have just overlooked it. See attached image.  Support Health Scorecard table shows Joins Allowed = true, but Predictive Health Scorecard shows Joins Allowed = false.  Any guidance? [img]https://d1qy7qyune0vt1.cloudfront.ne

7
darkknight
Grand Slammer
7 years ago
katie_sexton
katie_sextonRegistered User
posted in Data Management & Integrations

Is looker a supported integration?

Hi - Interested in Looker as an integration. Is this currently supported? If so, anyone have experience they can share? Thanks!

7
M
3 months ago
darkknight
Grand Slammer
darkknightGrand Slammer
asked in Data Management & Integrations

Data Management Beta: "Please wait while we are loading the schema"

I know Data Management is in beta, but does anyone else have this problem? When I click on one of the object names, i.e. Email Logs (which only has a little over 2000 records) I get the "Please wait while we are loading the schema..." message - and nothing ever loads.  Ever.  It just stays on that spinner indefinitely and doesn't even time out. Until I finally get irritated and kill Chrome. We have not rolled in the January 7th release yes, so still running on the last update.  Maybe this issue will go away once we update?

7
giri_babu_golla
Gainsight Employee: Shoshin
7 years ago
A
andrea.milaniRegistered User
asked in Data Management & Integrations

Merge 2 dataset without join condition

Hi,I have one dataset with my company data and the standard deviation of one of these fields. I want to merge it with another dataset where I have only one record with the Average for the same field but for the whole population.If I merge them keeping the record with both dataset, I get one line with the average of the population but all the other fields blank and the other lines with all the fields filled in but the average of the population.Now, what I am trying to achieve, is to compare the average of the whole population with the value of the field per line. So what I need to do is to have that value repeated for each line.Any idea how can I achieve it?

7
keith_mattes
All Star
3 years ago

Register for Pulse Encore 2023

Terms & ConditionsCookie settings