US Admin Office Hours (Tuesday session) - 9/10/19 1 p.m. PST - Pre-session Thread

I had a question about uploading historical usage to an existing table. During our initial implementation we created a usage table that's populated via an S3 ingest job. We recently added a phase 2 for metrics to include in the existing table, which are new columns that have been added to the table. Future data files will map to the new columns, but we are looking to backfill historical data for the new columns as well. In order to backfill historical data for the new metrics, I wanted to check if there is a best way to do this that keeps the existing metrics as is and only updates the new columns with the historical data.



My initial thinking is to create an S3 ingest rule that uses Date and SFDC ID as the unique identifiers, and only map the columns I want to upsert, leaving all other columns I want unchanged as "None." Would this be the best way to accomplish this?

We need help setting up a sister outreach program to cc: CSMs on communications

I am trying to create an outreach master data object that will house all digital outreaches to a customer as well as a snapshot of their scorecard values at that time. I have a question of how to approach merging in the rules engine in an attempt to tie scorecard values (by snapshot date) into the email sent date.

The goal is to have an overview of outreaches that went to customers and the impact on the scorecard that they had over time.

At this time I just merge on Account ID, which grabs the min value for scorecard snapshot (date) and the score at that time gets applied to all outreaches to that account.

Nevermind I think I figured it out.

I used Transformations to grab the 'End of Week' date value from the 'Sent Date' and the 'Scorecard Snapshot Date'. Then merged on the transformed values to assign scores to the outreach dates.

Yes, that's what I would suggest. I actually made a tutorial on something similar if it would help you. https://community.gainsight.com/conversations/how-to-historically-snapshot-data-to-the-mda-5d28eadae4b00474137fe904

I'm looking to build a report that shows any customer who's health score dropped from the last week. I attempted to use the "Trend" field in the company object that seems to be capturing this but it doesn't seem quite right. I attached an example of a customer's healthscore snapshots.

When users remove a relationship contact in the UI, they contacts are still being registered as relating to that R360 when they go to use their email to timeline bcc address. (i.e. they're getting emails that the contact exists on R360s so the email saved to draft.) Is there an additional automation / processing we need to do to get them fully "removed" on the backend? I waited for our overnight processing but was still experiencing the same results.

I replied to a post in the Community re: a feature request. The thread was started Jul 30th, is in 'No Status' presently.

https://community.gainsight.com/conversations/cockpit-export-5d404f04e4b00474137ff57c

My question is who will look at this thread from Gainsight? What if anything can I do to get eyes on it?

Thanks.

JJ

I have 1 additional question now.

I am trying to pull the most recent response of a survey taken by a specific email. It is a yes or no question, but I only want to have the most recent response in my output table. My issue comes if the survey would go out again (through another cycle) it records 2 sets of responses instead of the most recent one.

Hi Jeremy, looping in our Community Manager @lila_meyer for guidance.