Report on most recent timeline activities for all accounts
None
We would like to add visibility to our leadership on when was the last time a Customer was engaged. Timeline would be the perfect feature to report this from, however there isn't a way to report on that. I can pull reports with timeline activities and summarize them by Max Date. That would give me the Last Entry, however there isn't much I can do from here.
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.
What additional data would you want to display in the report?
I would recommend creating an MDA Object to hold that last timeline entry information - something like Account ID (with lookup to Company), Activity ID, Subject, Entry Author, Activity Date, etc..
Seed the object with every active account ID. Then create a new rule that pulls all timeline activity entries (can time box this after the first run). Next, perform a transformation step to group by Account ID and show Activity Date (MAX). Finally, use this Max Activity Date to Merge back to the original timeline entry dataset and pull out the needed information on the specific Max Activity (Subject, Author, Activity ID, etc.). You can set to run this per your specifications.
Finally, create a dashboard off this new MDA object with global filters to allow for targeting of individual accounts and/or last activity within a certain time frame (e.g. over 30 days ago).
Let me know if you have any queestions? Thanks!
Tim