Tighten the correlation between Email Logs and AO Emails (and other AO tables)

  • 1
  • Idea
  • Updated 4 days ago
  • (Edited)
In an effort to try to mitigate this lack of functionality I tried to create a Bionic Rule that will pull all the values together I need in order to create a SF Activity on the account record.

I have run into a challenge because there doesn't appear to be a solid way to map entries in Email Logs to entries in AO Emails (where the email body is stored).  I thought that Email Logs::ID would map to AO Emails::Email ID but that does not appear to be the case.

I tried merging between the two tables on

Email Logs::Account ID -> AO Emails::GS Participant ID::SFDC Account ID
Email Logs::Email Address -> AO Emails::GS Participant ID::Recipient Email Address
Email Logs::Template ID -> AO Emails::Email Template ID

And that seemed to get close - but did not fully produce desired results. 

I tried to find an ID field that correlates the entries in Email Logs to entries in AO Emails and cannot seem to produce one.  There needs to be a easy-to-use mapping between unique email sends between both of those (and all AO) tables.

AND/OR include the Email text body in Email Logs

(Incidentally, the Text Body column in AO Emails appears to be completely empty - only the Html Body contains any data)

Also the Gainsight Object Glossary says the AO Emails::Email ID = Email Address of the participants, which is incorrect.  I sent an email to docs@gainsight.com about that.

PS - I'm adding this to "Data Spaces" category because there doesn't seem to be one for Data Platform/MDA anymore...

Photo of Jeff Kirkpatrick

Jeff Kirkpatrick, Champion

  • 26,596 Points 20k badge 2x thumb

Posted 4 days ago

  • 1

Be the first to post a reply!