Data Management & Integrations
Share your questions and best practices on the Gainsight Analyzer, Adoption Explorer, GDM, API, Person model, or anything related to integrations.
- 356 Posts
- 973 Replies
Gainsight has now redesigned Snowflake Connector to make it more intuitive and simple, powered by the Gainsight Horizon experience. You can now create Snowflake data jobs from the Jobs List page. Navigate to Administration > Connectors 2.0 to create a Snowflake connection. For more information, refer to the Snowflake Connector article.Note: If you have enabled Connectors 2.0 (Horizon Experience) in your tenant, then you can establish a Snowflake connection directly in the Connectors 2.0 page instead of the Adoption Explorer page.
The multi-select feature is poorly designed throughout. In rules engine/query builder, we have to build overly convoluted queries to be able to track NULL values and combine them with (OR condition) includes/excludes. It is also extremely difficult to leverage in any reporting considering the things we can or can’t do with it (can’t group by). It’s impossible to write to it without convoluted formulas to not override what’s already there. Everything about this feature is terrible. It needs an overhaul to start making sense and to stop requiring convoluted 20 steps approaches to get anywhere with it.
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.
[b]Administration > Connectors > S3 Connector[/b]; [b]+ Data Ingest Job[/b] [b]1) Data Ingest Job Setup[/b] [i][u]Source CSV File[/u] [list] [*]AVOID having file name with leading spaces [*]"Source CSV File" should match exactly with "File name" that will be pushed into S3 bucket[/list] [u][i]File Properties[/u] [list] [*] Ensure source CSV file properties matches with properties defined in Project Setup like Char Encoding, Quote Char, Separator,Header Line, Escape Char [*]Do not send Char Encoding “UTF-8 WITH BOM”[/list] [i][u]Data Load Operation [/u] [list] [*]UPSERT - Ensure you have right keys in place to identify unique records [*]AVOID changing UPSERT KEYS once data loaded into MDA object [*]Utilize "Administration > Operations > Data Management > [i][Click on an existing object] > Update Keys - BETA" feature, to select UPDATE keys at object level. This will allow not to accidentally make changes to the keys in S3 ingest job and en
Gainsight's Analyzer tool is a powerful tool that all Gainsight Admins should get familiar with. We have [url=https://support.gainsight.com/View_More_Categories/Gainsight_Analyzer]thorough documentation[/url] on the ever-expanding capabilities Analyzer provides. What I'm here to do is provide three quick tips for common scenarios that can give you a chance to get your feet wet with Gainsight Analyzer. [video]https://player.vimeo.com/video/361158035[/video] [b]Scenario 1 - [/b][url=https://support.gainsight.com/View_More_Categories/Gainsight_Analyzer/Admin_Guides/01Rules_Analyzer_Admin_Guide][b]Rules Analyzer[/b][/url]: How do I know how many rules are scheduled within my instance? It can be hard to figure this out from just looking in the UI of the Rules Engine. Luckily, the Rule Analyzer makes this easy to find out and also dig deeper into the execution summary if needed. [b]Scenario 2 - [/b][url=https://support.gainsight.com/View_More_Categories/Gainsight_Analyzer/A
Hello Team, Can we give an ability to connect to SFDC Sandbox from NXT?Here is the use case:Customer wants to connect SFDC Sandbox to Gainsight Production. Customer's SFDC Production is undergoing some changes and once the work with respect to that is completed, their SFDC production will be exactly same as their SFDC Sandbox now. Then they will connect their SFDC production to Gainsight Production. Thanks & Regards,Srikanth
I feel like many posts throughout the community have shown a significant interest in having a ‘query library’ in that you could create datasets in a single location and then reference them throughout the platform. This has been highlighted as a need in Program development, having to create all Queries in Rules Engine for troubleshooting, and then building a second time in Programs (which has since been solved for with execution history but it’s duplicative if an existing Rule is exactly what is needed in a Program). It’s been highlighted as a need within Programs and the ability to duplicate a query as a second participant source within a program. It’s been highlighted as a need for reporting. Data Designer -sort of- solves for this - but it’s not in replacement of, it’s in addition to. And now we have Segments. So you can reference Data Spaces, Rules Engine, Data Designs, Query Builder, and Segments. For Programs, data designer present the issue of the design refreshing indepe
Announcing our new instructions to integrate Point of Reference's ReferenceEdge product with Gainsight! Customer Success and Customer Advocacy are closely related and now, through the integration of Gainsight and ReferenceEdge, data interactions and activity management is made seamless. ReferenceEdge provides a single source for customer advocate information and customer content, and automates key customer reference processes such as reference requests. Visit our [url=https://support.gainsight.com/hc/en-us/articles/223439548-ReferenceEdge-Integration-Overview]support article[/url] for more details on the integration overview. The instructions cover four use cases: [url=https://gainsight.zendesk.com/hc/en-us/articles/223349147]Use Case #1: Create a Gainsight Health Score based on the ReferenceEdge Reference Status[/url] [url=https://gainsight.zendesk.com/hc/en-us/articles/223349247]Use Case #2: Update Referenceability based on Renewal Stage[/url] [url=https://ga
I created a Design in Data designer that brings data from the same object (App Usage Trends) but one of them with a date filter. Essentially: Current week and previous week. I then created a calculated field that give me the difference between the current count and previous week's count. Pretty simple. I also created several other "difference fields". The sample data at the bottom shows those calculated fields properly but when used in Analyze or a report, they show up as Zero (second screen shot). I did run the design to create a Dataspace and I get the same results in a report. Has anyone seen this before? My calculated fields are part of a Transform box and all look like this: When I did not have “Treat null as Zero” checked, that field was coming back empty, in the report, but was showing data in the sample. Real mystery. thanks! Lyne
Without a native connector per Zendesk, I'm looking for any help with a light or zero dev solution to getting FD tickets into Gainsight daily, either via API or drop to the S3 connector. It appears that the FD/SDFC integration (which we do have live) is pretty limited, and only shows an iframe type ticket view, so I assume can't be accessed by rules engine. We also just tested flatly.io as a3rd party approach, but it only allows a single datapoint to be scheduled/sent. Any advice or help appreciated!
1. Quicker Loading of Metadata from Salesforce ObjectsGainsight has improved performance of loading metadata from Salesforce objects. The Salesforce metadata will be automatically stored and refreshed every seven days. This enhancement will get the information faster from Salesforce.Admins can manually refresh the Salesforce data by clicking Refresh Metadata from the context menu of Salesforce connection in the Administration > Integrations > Connectors 2.0 (Horizon Experience) > Connections tab.Notes: Admins must manually refresh the metadata to see the new custom Gainsight Object or fields added in Salesforce. This feature will be enabled for all customers in a phased manner after the 6.27 release. To enable this feature in priority, contact Gainsight support.For more information on Salesforce connector, refer to the Salesforce Connector article.2.Out of Box Jobs for Freshdesk and ServiceNowGainsight has added two Out of box Jobs (OOB) to sync important data such as Tickets
Hi all,I deleted a previous JIRA integration to test environment but when I tied to add the connection for the production JIRA i got this error:“Error occurred while saving connection. You have already created maximum number of allowed connections.”Has anyone encountered such on Gainsight, how can it be resolved?Thanks
Hi there Team,I asked this question on the inSpired Community by inSided (see original thread) and was redirected here.Basically, within Zapier, I want to create a Step where Gainsight Checks if a new inSided contact is an actual customer (e.g. within Stage Retention, Onboarding, etc.) See full question here:Hi there everyone,Our inSided community is open for anybody to sign up, but we always assign a “customer” custom role to our customers because there is some gated content that only customers can see.Our moderation team spends up to 1h each day manually checking newly registered customers and manually assigning custom roles.To check if somebody is a customer or not, we look on Gainsight (our customer CRM😎), in order to see if that email address is linked to a customer. Is there any way to automate this with zapier?I envision it like this:Trigger: New member registers on insided Zapier checks if that email can be found on gainsight if it can be found, check if it belongs to a curre
We recently started utilizing People Maps and are super excited about it, though there are a few things I'm hoping to get some feedback/advice on: [list] [*]Delay in updating/adding contacts in Salesforce to create new records in the Person object: [list] [*]Currently, we have a rule set up to pull in new/updated contacts from Salesforce into the Person object [*]We have it running at the highest frequency according to the Rule Scheduling documentation, which is every 2 hours [*]This is fine for most rules, but it becomes problematic when we're trying to update or add contacts into Salesforce so that we can use them immediately in People Maps or to map Timeline entries to a specific contact [*][b]Main ask: [/b]Is there any possibility for rule scheduling to be expanded beyond the current 2 hour limitation? I'm also open to any ideas on how to overcome this limiation in the short-run! [/list] [*]People Maps requires a contact to exist in Person object, which requ
Hi there - I have the zendesk connector set up and syncing fine - but for reporting I’m only able to build reports using the organisation ID which is numeric field. I added a mapping file using the CSV import function on the Zendesk connector page to map the numeric Zendesk organisation value to a name. It doesn’t appear to have worked. When I go to build a report organisation ID and organisation name are both available, but organisation name has no value attached to it. Can any of you offer any suggestions or tips as to where I might be going wrong? many thanks PS:The input csv looks like this, but with more rows. CompanyId CompanyName ZendeskOrganizationId ZendeskOrganizationName 1P05FR1W5RMAH4QPD0GCBSDVOFFAABBCCDD CORP UK 12345678910111213 CORP UK
Has anyone successfully connected their Tableau instance to their Gainsight S3 bucket using the Athena connector? I have searched for the error message I’m receiving and it could be a number of different things including an incorrect domain. I used the same settings that I use to successfully connect via Cyberduck. [Simba][JDBC](10100) Connection Refused: [Simba][JDBC](11640) Required Connection Key(s): AwsRegion; [Simba][JDBC](11480) Optional Connection Key(s): AwsCredentialsProviderArguments, AwsCredentialsProviderClass, BinaryColumnLength, ComplexTypeColumnLength, ConnectTimeout, EndpointOverride, MaxCatalogNameLength, MaxColumnNameLength, MaxErrorRetry, MaxQueryExecutionPollingInterval, MaxSchemaNameLength, MaxStreamErrorRetry, MaxTableNameLength, MinQueryExecutionPollingInterval, ProxyHost, ProxyPort, ProxyPWD, ProxyUID, QueryExecutionPollingIntervalMultiplier, RowsToFetchPerBlock, S3OutputEncOption, S3OutputLocation, Schema, SocketTimeout, StreamingEndpointOverride, StringColumnL
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at email@example.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.