What is the date field in MDA for when an email was sent to a participate from the AO?

  • 2
  • Problem
  • Updated 7 months ago
  • Solved
I am trying to setup my own reporting for Response Rates and am hitting some struggles. I can see if an email was sent, when it was responded, etc. Unfortunately, I am struggling to find the exact field for the date the email was sent via the AO. 

Any guidance?

Thanks!
Photo of Ben

Ben, Champion

  • 7,932 Points 5k badge 2x thumb
  • frustrated

Posted 7 months ago

  • 2
Photo of Britton Walker

Britton Walker, Alum

  • 2,644 Points 2k badge 2x thumb
I believe you have to use the AO Emails object for that information. The Created At field is the date the AO sent the email, while the Email Send Time is the time the email was successfully delivered. If the email bounced then you'll want to look at the Bounce Date field for when that happened.
Photo of Dan Ahrens

Dan Ahrens, Official Rep

  • 24,642 Points 20k badge 2x thumb
Hi Ben,

You can get this from the Email Logs object. Filter on Use Case = Advanced Outreach and the Triggered On field will have the date/time the email was sent.
Photo of Britton Walker

Britton Walker, Alum

  • 2,644 Points 2k badge 2x thumb
Well that rocked my world! Thanks Dan.
Photo of Ben

Ben, Champion

  • 7,932 Points 5k badge 2x thumb
Thanks guys. 

@Dan: Is that a new field? I have never used the "Use Case" field, but I like it!
Photo of Dan Ahrens

Dan Ahrens, Official Rep

  • 24,642 Points 20k badge 2x thumb
I think it's been there, just one of the "lesser known" fields.

Related to this - we recently created an object glossary for some of the more commonly used Gainsight objects to help admins and power users create reports and rules using all of the available data (which is actually pretty extensive). 
Photo of Ben

Ben, Champion

  • 7,932 Points 5k badge 2x thumb
That is super helpful. Bookmark added.