http://m.getsatisfaction.com/topics/7803894 Tighten the correlation between Email Logs and AO Emails (and other AO tables) 2018-10-12T17:04:43Z 2018-10-12T17:04:43Z 7803894 http://m.getsatisfaction.com/topics/7803894 7803894 Tighten the correlation between Email Logs and AO Emails (and other AO tables) 2018-10-12T17:04:43Z 2018-10-12T17:04:43Z Jeff Kirkpatrick http://m.getsatisfaction.com/people/7657820 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11032177/860950_medium.jpg jeff_kirkpatrick In an effort to try to mitigate <a alt="" href="https://community.gainsight.com/gainsight/topics/journey-orchestrator-log-to-salesforce-should-accommodate-sf-related-contacts-feature" name="" rel="nofollow" target="" title="" type="" value="">this lack of functionality</a>&nbsp;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.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />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).&nbsp; I thought that Email Logs::ID would map to AO Emails::Email ID but that does not appear to be the case.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />I tried merging between the two tables on<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Email Logs::Account ID -&gt; AO Emails::GS Participant ID::SFDC Account ID<br alt="" name="" rel="" target="" title="" type="" value="" />Email Logs::Email Address -&gt; AO Emails::GS Participant ID::Recipient Email Address<br alt="" name="" rel="" target="" title="" type="" value="" />Email Logs::Template ID -&gt; AO Emails::Email Template ID<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />And that seemed to get close - but did not fully produce desired results.&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />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.&nbsp; There needs to be a easy-to-use mapping between unique email sends between both of those (and all AO) tables.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />AND/OR include the Email text body in Email Logs<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />(Incidentally, the Text Body column in AO Emails appears to be completely empty - only the Html Body contains any data)<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><img alt="" name="" rel="" src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1756402/RackMultipart20181012-65872-yyqf5o-Screen_Shot_2018-10-12_at_11.32.02_AM_inline.png?1539361947" target="" title="Image httpsd2r1vs3d9006apcloudfrontnets3_images1756402RackMultipart20181012-65872-yyqf5o-Screen_Shot_2018-10-12_at_113202_AM_inlinepng1539361947" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Also the <a alt="" href="https://support.gainsight.com/Administration_and_Permissions/General_Administration/Gainsight_Object_Glossary" name="" rel="nofollow" target="" title="" type="" value="">Gainsight Object Glossary</a> says the AO Emails::Email ID = Email Address of the participants, which is incorrect.&nbsp; I sent an email to <a alt="" href="mailto:docs@gainsight.com" name="" rel="nofollow" target="" title="" type="" value="">docs@gainsight.com</a> about that.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><img alt="" name="" rel="" src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1756403/RackMultipart20181012-25682-q592ft-Glossary_inline.png?1539363705" target="" title="Image httpsd2r1vs3d9006apcloudfrontnets3_images1756403RackMultipart20181012-25682-q592ft-Glossary_inlinepng1539363705" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />PS - I'm adding this to "Data Spaces" category because there doesn't seem to be one for Data Platform/MDA anymore...<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /> idea 0 1 1 create