Skip to main content
Gainsight Inc.

Email Log V2 Object

This article provides information on the Email Logs V2 object and its data fields.

Overview

Email Log V2 object contains an aggregated entry for a single recipient email as well as for analytics information. This object is used in Journey Orchestrator Programs and Email Assist 2.0.

Data Fields in the Email Log V2

The following table list the data fields available in the Email Log V2 object:

Fields

Description

Address Type

This field stores the type of influencer, either within your Organization (any Company Person) or within the Company (any Gainsight User).

Bounce Type

The type of an automated message from an email system, either Hard or Soft bounce

Bounced

A bounced email is an automated message from an email system, informing the sender of a previous message that the message has not been delivered.

Bounced Date

The date on which the email was bounced.

Bounced Reason

The actual reason why the email has bounced.

Category Ids

IDs of an opt-out page category.

Company Id

Unique GSID of the Company.

Company Person Id

A unique Id from the Company Person object, details of a participant associated with a Company.

Created Date

The date on which the email logs are created.

Email Content Id

A unique identifier of the email.

Email Id

Email address of the participants.

Email Id in Lower Case

Indicates whether the email address of a sender is in lower case.

Email Template Id

A unique identifier of the email template.

Email Template Name

The name of the email template.

Email Template Version Id

A unique identifier of the email template version.

External Company Id

The external Id of a company.

External Company Person Id

A unique Id of a person from the external company.

External Relationship Id

A unique relationship identifier in an external system. It identifies a relationship uniquely apart from Email and Name.

External Relationship Person Id

A unique relationship identifier in a person in an external system.

External Relationship Type Id

An external GSID field in the Relationship Type object.

External User Id

The unique identifier of the external user.

First Opened Date

The date on which the email was first opened.

From Email Id

An email id of a sender.

From Name

The name of a sender.

GSID

A unique GSID.

Latest Open Date

The date on which the email was last opened.

Link Click Date

The date on which the link was last opened.

Link Clicked Count

The total number of clicks used to open the link.

Link Clicked JSON

The linked clicked date in JSON format.

Modified Date

The date on which the email was last modified.

Name

The name of the email recipient.

Number of Opens

The total number of opens recorded for the email.

Opened

Indicates whether the email was opened or not.

Page Id

A unique Id of the page.

Parent Recipient Id

The unique Identifier of the parent user.

Person Id

A unique Id from a Person object.

Person Type

This field helps to join the AO Participants object with either Person object or Person Avatar (User, etc) object.

Recipient Id

A unique Id of a person who received the email.

Record External Id

A unique company identifier record in an external system. It identifies a company uniquely apart from Email and Name.

Record External Name

The  name of the external record.

Record Id

A unique Id of the record.

Rejected

A flag that indicates whether an email is rejected due to an incorrect recipient address

Rejected Date

The date on which an email is rejected by a participant.

Relationship Id

GS Relationship Id from Gainsight.

Relationship Person Id

A unique identifier of the Relationship person.

Relationship Type Id

A unique Relationship Type Id of a participant.

Reply-to Email Id

A unique email Id of a reply-to email address.

Reply-to Name

The name of the person to whom the email was replied.

Request Id

The unique identifier helps to probe the Sumologic logs to figure out what has happened as a part of that request.

Sent

Indicates whether the email is sent.

Sent Date

The date on which the email was sent.

Source

The source from which the CS task is created. Manual = created by a user, Activity = created from a timeline entry, from Rules, Survey, etc.

Source Id

This field helps to join the AO Participants object with a specific record in the MDA standard object. This helps to build reports on the AO Participants object and join the selected fields from the MDA standard object.

Source Name

Name of the participant source.

Spam

Indicates whether the email was spammed.

Spam Marked Date

The date on which the email was marked as spammed.

Triggered Date

The date on which the email was last triggered.

Unsubscribed

A flag that indicates whether an email address is unsubscribed from outreaches/programs

Unsubscribed Date

Date and Time on which an email address is unsubscribed from a program.

User Id

A unique Id that helps to fetch user information (User Name, Email, Company Name, etc.) from the Gainsight object User.

Difference between Email Log V1 and Email Log V2

The following table provides the field mapping difference between Email Log V1 and Email Log V2

Email Log V1

Email Log V2

GS Lookup

Account Name

Company Id > Name 

Lookup gsCompanyId

Company Name

Company Id > Name 

Lookup gsCompanyId

Relationship Name

Relationship ID > Name 

Lookup gsRelationshipId

Relationship Type Name

Relationship Type ID > Name

Lookup gsRelationshipTypeId

User Name

User ID > Name

Lookup gsUserId

ContactName

Name

name

Account Id

External Company Id

externalCompanyId

Contact Id

External Company Person Id

externalCompanyPersonId

Relationship Contact Id

External Relationship Person Id

externalRelationshipPersonId

Relationship Id

External Relationship Id

externalRelationshipId

Relationship Type Id

External Relationship Type Id

externalRelationshipTypeId

Person Id

Person Id

gsPersonId

GS Relationship ID

Relationship Id

gsRelationshipId

GS Relationship Person Id

Relationship Person Id

gsRelationshipPersonId

GS_RELATIONSHIP_TYPE_ID

GS Relationship Type ID

gsRelationshipTypeId

GS User Id

GS User Id

gsUserId

Batch Id

Source Id

sourceId

Batch Name

Source Name

sourceName

Case Insensitive Email Address

Email Id

emailId.toLoweCase()

Clicked

Link Clicked Count

linkClickedCount > 0

Click Count

Link Clicked Count

linkClickedCount

Clicked On

Link Click Date

linkClickedDate

Clicked IP

Link Clicked Json

Extracted from linkClickedJson

Clicked Url

Link Clicked Json

Extracted from linkClickedJson

Opened

Opened

isOpened

Opened On

Latest Open Date

lastOpenedDate

N/A

First Opened Date

firstOpenDate

Open Count

Number of Opens

openedCount

GS_COMPANY_ID

Company Id

gsCompanyId

Created Date

Created Date

createdDate

Email Address

Email Id

emailId

Variant Name

Email Template Version Name

emailTemplateVersionName

Variant Id

Email Template Version Id

emailTemplateVersionId

User Id

User Id

gsUserId

Use Case

Source

source

Unsubscribed On

Unsubscribed Date

unsubscribedDate

Unsubscribed

Unsubscribed

isUnsubscribed

Triggered Date

Triggered Date

executedDate

Template Id

Email Template Id

emailTemplateId

Template Name

Email Template Name

emailTemplateName

N/A

Email Service Provider

emailServiceProvider

Marked Spam On

Spam Marked Date

spamMarkedDate

Marked Spam

Spam

isSpam

External Email ID

Request Id

requestId

N/A

Page Id

pageId

N/A

Category Ids

categoryIds

Soft Bounce On

Bounced Date

bouncedDate, if bounceType == SOFT_BOUNCE

Soft Bounced

Bounced

if bounceType == SOFT_BOUNCE

Hard Bounce On

Bounced Date

bouncedDate, if bounceType == HARD_BOUNCE

Hard Bounced

Bounced

if bounceType == HARD_BOUNCE

Sent

Sent

isSent

Triggered On

Sent Date

sentDate

Rejected On

Rejected Date

rejectedDate

Rejected

Rejected

isRejected

Address Type

Address Type

addressType

Id

Recipient Id

recipientGsId

Parent GsId

Parent Recipient Id

parentRecipientGsId

  • Was this article helpful?