Im building a report on cases, but the Created Date is pulling in as the import date. I need the original date the support case was opened, any idea how I can get that?
Userlevel 7
+9
- Created Date is a phrase used throughout Gainsight and nearly all of its data objects, and is representative of the day the record was created within Gainsight. You’ll also bump into Modified Date, and that’s the day the record was last modified within Gainsight.
- Most Support systems (including Zendesk, with which I’m most familiar) have a field similar to Created Date at source. This field is more representative of when the Case was generated in the source system, and is not necessarily the date the Case was ingested into Gainsight.
Look for something in your source Support or Case data that represents the creation or open date of each ticket, as you’ll likely be able to ingest that date for a truer date of creation of the Case.
Userlevel 7
+9
If it’s null for all of your Case records, I would next look at your data ingest mechanics, to be sure your instance is configured to populate that field. The common ingest methods are Connectors 2.0, an S3 ingest, or a Bionic Rule. Inspect whichever mechanism is configured in your instance to determine if you’re populating the Create Date at Source field with that ticket creation date.
Reply
Sign up
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 community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.