Data Management & Integrations

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

  • 357 Posts
  • 974 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

357 Posts

darkknight
Grand Slammer
darkknightGrand Slammer
asked in Data Management & Integrations

Special permissions needed for new MDA Calculated Field (formula) feature?

I was eager to try out the calculated field/formula feature in MDA that was just released, but for some reason when I create a Number field on an object in my sandbox, the Calculated Field appears but it is not selectable and I cannot click Create Formula. Anyone else encounter this or just me?

3
manu_mittal
Gainsight Employee: ACE
7 years ago
jeremy_johnston
Team Captain
jeremy_johnstonTeam Captain
asked in Data Management & Integrations

SnowFlake Connector (Horizion Experience) - Does Scheduled Job Import All Data or only Last Modified?

Within a SCHEDULED job in the SnowFlake connector, is ALL DATA fetched by default?  Or is only data updated since the last job run date fetched?I don’t see anywhere to specify which to retrieve when configuring a SCHEDULED job.That option is only presented if I run a Job On Demand. We’re required to specify the Primary Key and Reference for last modified date when creating the job, so I’m guessing that a scheduled job only fetches modified records, but I’ve not seen this expressly documented one way or another. Thanks!JJ  

3
Ritesh Sharma
Shoshin
1 year ago
hardik_mota
Champion
hardik_motaChampion
asked in Data Management & Integrations

Use "OR" logic instead of "AND" when selecting key fields to identify unique records in connectors 1.0

Hi Team, One of our customer is looking to use Use "OR" instead of "AND" when selecting key fields to identify unique records in connector 1.0 jobs.  Current Behaviour: When setting up an Ingest Job, we have two Unique Identifiers from two different systems. Currently it is erroring out when one or the other is missing. Expectation: Create the Gainsight record with either Unique ID’s. Please see below for which key fields we have selected to identify unique records.  Here’s the SS : https://share.getcloudapp.com/NQuZGGWb Please let us know your thoughts on this requirement. Best, Hardik 

0
hardik_mota
Champion
3 years ago
sdrostgainsightcom
sdrostgainsightcomGainsight Community Manager
asked in Data Management & Integrations

For the S3 Connector, is the ability to ingest compressed files, like GZip, coming?

Interested to know (after talking with some data engineers getting ready to push data to a connected S3 bucket): Does Gainsight have plans to add some common file compression/decompression options? In this case, allowing an encrypted GZIP file to be uncompressed after decrypting? Just passing the question/suggestion from a newer Gainsight customer that I couldn't answer - thanks!

1
sumesh
Shoshin
5 years ago
cristina_postolache
cristina_postolacheRegistered User
asked in Data Management & Integrations

Integrations: Data Load Configuration - how long does the aggregation step take?

I am trying to reload some usage data for our product into an object located in the [b]Data Management[/b] [b]section[/b] (the data loaded before had errors), and then I am running the aggregation step from the [b]Integration section[/b]. But I have noticed really big differences in the time it takes for the integration to end, although I have a similar number of lines that are aggregated. It can take from several minutes to several hours, and I don't understand why.  It's really hindering my work, because I don't know what I can count on.

1
ashok_dugaputi
7 years ago
darkknight
Grand Slammer
darkknightGrand Slammer
asked in Data Management & Integrations

GS Analyzer: Make reports under the Configuration Home drilldowns larger

I love GS Analyzer so much. Could we enlarge the reports on all the Config Home drilldowns so that you can see more records without having to scroll as much? There's a lot of white space there. Thank you! Example - Rules Analyzer; Bionic - Active: [img]https://d1qy7qyune0vt1.cloudfront.net/gainsight-en/attachment/ScreenShot20190809at9-27-57AM-ea9c551d-3cbb-4322-a586-3747e4adc3e1-1375646899.png[/img]

1
phanindra_sambaraju
Gainsight Employee: Rookie
4 years ago
J
Veteran Rookie
jivanovaVeteran Rookie
posted in Data Management & Integrations

Bring back inline search in Data Management Horizon

In Data Management HA everything requires more clicks. Searching for objects and fields within an object is now behind filters. Some default filters are propped in the banner, but not all. It is so much easier to search for objects and fields in the non HA version with inline search for all data attributes. In addition, data editability and schema editability are not even attributes you can see about a field or object in the new version. In the new version, how do you find what actions are allowed on a particular field? At a glance, how do you know if you can delete a field or which fields are editable in an object? Finding dependencies is really difficult in the new version. In the old version, I can start typing a field name and possible results will appear. In the new version you have to type the exact field name to get results. I wish there is an option to permanently disable the banner. Edit object/fields are displayed even for system objects where nothing can be edited or deleted

1
sakumar
Team Captain
1 year ago
jeffrey_coleman
Shoshin
jeffrey_colemanShoshin
asked in Data Management & Integrations

The week starts on different days between Usage/Rules Engine and MDA

I just came across an odd situation. I was loading some data into MDA ([url=https://community.gainsight.com/gainsight/topics/a-date-axis-should-show-all-marks-not-just-those-when-data-exists]creating zeros so the time series charts look right[/url]) and selected "first day of last week" as the date value. When I checked the file, the "first day of last week" according to the rules engine was 2/27/16, which is right because my Time Granularity under Usage Configuration is set so the week starts on Saturday. (Why Saturday? No idea... That's just what we did back when! :-) But when I group the data by week in the MDA report I get the week starting on 2/29/16. It's easy enough to fix in this use case, but it could through some people off so I thought it'd be worth highlighting.

1
steve_davis
Gainsight Employee: MVP
7 years ago
keith_mattes
All Star
keith_mattesAll Star
asked in Data Management & Integrations

Gainsight Analyzer: Hours of execution widget not working properly, zero value

When reviewing our rule execution & Audit section in Gainsight Analyzer, as an Admin I am quickly trying to provide an update on our processing time but the "meter" indicator is Zero while the report metrics are present. Is this something possibly introduced with the recent release? We can still use the value from the chart, but wanted to let you know that (for at least my instance) this is no longer working as expected. I was hoping to post a screen shot of the "zero" green, yellow, red indicator but it seems I am not allowed to upload picture or they are being rejected.

2
lakshmi_chaitanya
4 years ago
darkknight
Grand Slammer
darkknightGrand Slammer
asked in Data Management & Integrations

Gainsight connect shows "Success" when records failed

This seems like a problem.   Thousands of records failed, yet the job status shows it completed successfully. I'm on the 5.17 release. [img]https://d2r1vs3d9006ap.cloudfront.net/s3_images/1748406/RackMultipart20180827-24207-jdwooy-Screen_Shot_2018-08-27_at_1.03.51_PM_inline.png?1535393273[/img]

2
darkknight
Grand Slammer
5 years ago
samantha_braastad
Shoshin
samantha_braastadShoshin
asked in Data Management & Integrations

How much data can be housed in MDA?

We are currently receiving some of our data on a weekly basis that is summarized due to the size/amount of data that would be included if we received it on a daily basis. However, there would be a lot of benefit to having it on a daily basis as we would be able to more proactively engage with our customers. Is there a volume restriction on what can be loaded into the MDA? 

3
dstokowski
Gainsight Employee: ACE
6 years ago
ricardo
ricardoRegistered User
asked in Data Management & Integrations

Can ́t "fetch mappings" of a data job which insert data into a MDA Object from a CSV file with semic

When i ́m creating a job i have two options of separator: Comma and semicolon, but i can only fetch the mappings with a CSV file using comma. [img]https://d1qy7qyune0vt1.cloudfront.net/gainsight-en/attachment/RackMultipart20180627-8065-nx4ay1-comma_inline.jpg[/img] If i try to use a CSV file with semicolon that ́s what happens: [img]https://d1qy7qyune0vt1.cloudfront.net/gainsight-en/attachment/RackMultipart20180627-27341-eulsdf-result_inline.jpg[/img] Here ́s my CSV file with semicolon [img]https://d1qy7qyune0vt1.cloudfront.net/gainsight-en/attachment/RackMultipart20180627-53118-tou7ui-csv_file_inline.jpg[/img] If i replace the semicolons with comma it Works fine  That ́s really a bug or i ́m doing something wrong?

1
kunal_bhat
Shoshin
5 years ago
dan_ahrens
ACE
dan_ahrensACE
asked in Data Management & Integrations

User Management filters do not work correctly

When searching for users in the Slack configuration screen, filters for searching for users in the table headers do not work correctly. See video example here: [url=https://cl.ly/2G3l2U2c2Z0B]https://cl.ly/2G3l2U2c2Z0B[/url]

2
dan_ahrens
ACE
5 years ago
sagan_sherlin
Champion
sagan_sherlinChampion
asked in Data Management & Integrations

Idea. Change the Quick Filter (Search) Section in the S3 Connector to Default to Contains, rather than Equals.

In other areas when you're doing a quick search using the area in the red box (in the image), it defaults to a 'Contains' search. But in the S3 it defaults to an 'Equals' search. Is it possible to change this search to a 'Contains' to match the other areas? [img]https://d1qy7qyune0vt1.cloudfront.net/gainsight-en/attachment/S3ConnectorSearchFeature-6bd776a8-e898-4112-899e-c115b19b1264-2096334340.png[/img]

2
sagan_sherlin
Champion
4 years ago
kate_green
Team Captain
kate_greenTeam Captain
asked in Data Management & Integrations

Gainsight Connect For Contacts

We are beginning to move over our Account Master Join table to the Company (standard) table that can be populated by Gainsight Connect.  We were wondering if there are any plans to add a Contact standard table to the list, so that we can align our contact records in Gainsight without using a rule to populate our custom Contact MDA.  

3
kate_green
Team Captain
6 years ago
james_whitehead
james_whiteheadRegistered User
asked in Data Management & Integrations

Is it possible to view when a specific field was updated?

Good Morning- This is a related question from another thread I have running ([url=https://community.gainsight.com/gainsight/topics/rules-engine-struggle-issues-writing-to-sfdc]https://community.gainsight.com/gainsight/topics/rules-engine-struggle-issues-writing-to-sfdc[/url]), however the information I'm seeking is different enough that it may warrant a different thread. I've traced the issue in the above link to a missing/inactive/broken data ingest.  We're not updating our Opportunity Close Date with the close date from the newest/future open opportunity.   Before I dive into adding this ingest, is it possible to see when this specific field was last ingested into Gainsight (i.e. when the Opportunity Close Date cell in the MDA for, example, client "Company X" was last updated)? I want to confirm that this field [b][i][u]is not currently being updated[/u][/b][i][u][/u][u][/u] before adding the ingest. Also, our CCO mentioned that last time the previous a

1
lila_meyer
Gainsight Employee: Grand Slammer
5 years ago
andreammelde
ACE
andreammeldeACE
asked in Data Management & Integrations

Upsert from timeline entry to richtext field?

We are wanting to aggregate timeline entries associated with a CTA to an aggregated richtext field. Is there a way to combine or append without overriding the previous data?

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

Gainsight Analyzer - Rule Dates not sorting chronologically

Gainsight Analyzer appears to be doing similar to [url=https://community.gainsight.com/conversations/s3-execution-history-is-sorting-as-if-it-is-a-number-not-appreciating-time-5bc73e16e4b04588aaf868b8]this[/url] when sorting rule execution dates: [img]https://d1qy7qyune0vt1.cloudfront.net/gainsight-en/attachment/ScreenShot20190121at11-59-32AM-abda48af-4584-40cf-a435-2b7e99190e77-1883082175.png[/img] Is sorting chronologically something we have to ask for as an enhancement every time or can we just assume moving forward that any date/time sorting should be chronological when the feature is developed?

2
anil_v_k_babu
4 years ago
B
billasrikanthRegistered User
posted in Data Management & Integrations

ServiceNow integration with Airflow

Can we integrate ServiceNow with Airflow ? I mean if there is any DAG failure, can we rerun the failed DAG/tasks by submitting a ServiceNow request ? Also can we submit an adhoc job to run using ServiceNow. Thanks in advance.

0
B
8 months ago
aalok_shah
aalok_shahRegistered User
asked in Data Management & Integrations

Clearing and Reloading Data without triggering CTAs or removing visualizations

Hi.  I am a new admin wanting to clean out the data in our gainsight platform.  How do I clear and reload data while not triggering CTAs or ruining any existing visualizations?

3
lila_meyer
Gainsight Employee: Grand Slammer
5 years ago
J
Shoshin
Janine MarlattShoshin
asked in Data Management & Integrations

business intelligence universe for gainsight aws specification data

Hello Gainsight Community,We are building a universe (business intelligence/business objects) from the export of the Gainsight AWS bucket files as per the Gainsight AWS specification online.I seek your knowledge on the architectural design of the universe.  The simple joins by account id, identifier id, as well as also in master data engagement id and master data feature id… is not enough.That design gets us one path to list the account, user, ..engagements, or list the features, or list the external events for a product.In one universe, I am looking for pulling all tenant, all product, engagements, features, events, surveys, etc. into one business objects report.  Or even if I go into Power BI, the same thing. or even if I go into Access.  Has anyone combined data in one universe, etc. to allow overall reporting of Gainsight data for the company?Thanks for your help.Janine

4
J
Shoshin
2 years ago
simonechen
Shoshin
simonechenShoshin
asked in Data Management & Integrations

How to deactivate Gainsight Users based on deactivation in SFDC?

Hi all - hoping to get some ideas on how to best automate / streamline license management.Currently, our User sync (via the Integration) is setup to ingest any SFDC users where Active = TRUE.However, we don’t have a mechanism for detecting and disassociating GS licenses when a User becomes inactive in SFDC. Wondering how people have set this up.Thanks!

4
simonechen
Shoshin
10 months ago
marie
Gainsight Employee: Champion
marieGainsight Employee: Champion
asked in Data Management & Integrations

Users of Recurly

Anyone a current user of Recurly? Looking for joint customers for a potential integration. Thanks!

1
ian_turner
6 years ago
S
Swati guptaRegistered User
asked in Data Management & Integrations

Global filters on dashboard

Hi,I have made a report using data designer and need to add global filter to the dashboard it is being added to.Though I have fetched the fields on which i need filter and that too of the same data type as that of the reference field mapped to but still i am not able to see my field while mapping in global filter for that report.Any one has idea about it how to solve this thing 

2
anirbandutta
Gainsight Employee: Grand Slammer
2 years ago
cristina_postolache
cristina_postolacheRegistered User
asked in Data Management & Integrations

Where is the Generate cURL button from Data Load Configuration?

I have created a new table to store a file with some daily usage data, and I would like for the file to be uploaded automatically to this table. When Gainsight was implemented in my company a cURL was given to the Product Analytics department to be able upload data automatically into MDA. But now I don't know where the cURL is. Has something changed? Before: [img]https://d1qy7qyune0vt1.cloudfront.net/gainsight-en/attachment/RackMultipart20161017-12445-alqhve-before_inline.jpg[/img] After: [img]https://d1qy7qyune0vt1.cloudfront.net/gainsight-en/attachment/RackMultipart20161017-100367-1554xv8-After_inline.jpg[/img]

2
cristina_postolache
7 years ago

Register for Pulse Europe 2023

Terms & ConditionsCookie settings