Emma for Salesforce stores your data in several custom objects, all of which you can use in Salesforce reports. Below is what each field holds. API names are shown without the namespace; in your org they start with em4sf__.

You can also see each field's help text in Setup > Object Manager > [object] > Fields & Relationships.

Emma Audience

One membership record per email address in each connected Emma account.

• Email, First Name, Last Name

• Display Name: formula, the Contact's name, otherwise the Lead's name, otherwise First and Last Name

• State: Active, Unconfirmed, Pending, Unsubscribed, Bounced, Suppressed, Deleted or Import Error

• Confirmed Opt In: Confirmed or Unconfirmed

• Emma Account and Account (formula showing the Emma account name)

• Contact / Lead: the matched Salesforce record, see how records are linked

• Date Subscribed, Date Modified, Deleted At: dates from Emma

• Sent, Opened, Clicked, Bounced: counts calculated from the Emma Mailing History stored in Salesforce, so they reflect only the history you keep

• Open Rate: Opened ÷ Sent. Click Rate: Clicked ÷ Sent

• Bounce Count and Email Error: from Emma

• Plaintext Preferred: whether the member prefers plain text emails

• Preference: the member's Emma custom field values, stored as JSON

• Import Source: how the member was added to Emma from Salesforce

• IP Address: the IP address used when signing up, where available

• Member Id: the Emma member ID

• Subscriber Id, Compound Key, Member Status Id, List Id, Internal, Job Id: internal fields. Subscriber Id holds the matched Contact or Lead ID

• View Member: formula link to the record

Emma Mailing

One record per Emma mailing.

Mailing details:

• Emma Mailing Name, Subject, From Name, From Email, Reply To, Sent Date, Archived Date

• Mailing Type: Standard, Test, Trigger, Subject Line Split Test or Content Split Test

• Client / Client Name: the Emma account the mailing belongs to

Engagement totals (best for reporting, taken from Emma's mailing stats):

• Total Recipients, Sent, Delivered, Opened, Clicked, Clicked Unique, Bounced, Opted Out, Forwarded, Shared, Share Clicked, Signed Up, In Progress, Webview, Webview Share Clicked, Count Purchased, Sum Purchased

• Open Rate: formula, Opened ÷ Sent

• Stats Last Updated: when the totals were last refreshed

Sync fields (used internally):

• Emma Mailing Id, Compound Key, Job Id, Last Synced, the Last Sync Count fields, Last Opened Page and Page. The sync uses these to track how far it has downloaded history.

Emma Mailing History

One record per subscriber interaction with a mailing. See Mailing History for how much is kept.

• Campaign Name (Name): the mailing name

• Activity: Sent, Opened, Clicked, Bounced or Unsubscribed

• Activity Date: when the interaction happened

• Email Address, Contact, Lead: who it was

• Emma Mailing: lookup to the mailing record

• Emma Mailing Link and URL Clicked: the link clicked, for Clicked activity

• Member Id, Emma Mailing Id, Emma Account Id: Emma identifiers

• Compound Key, Job Id: internal fields

Other Emma objects

• Emma Mailing Link: one per link in a mailing, with Link Name, Link Target, Link Order, Plaintext, Total Clicks and Unique Clicks

• Emma Group: one per Emma group, with Group Name, Emma Account, Total Active Subscribers, Total Unsubscribes, Last Synced and Prevent Member Sync. Group membership itself is read live from Emma, not stored in Salesforce

• Emma Account: one per connected account, with Account Name, Status (Active, Disconnected or Deleted), Salesforce User, Create Rule, Last Sync, Last Sync Count and Total Audience

• Subscriber Import: your import wizard jobs, with Import Title, Import Type, Status, Schedule Type, Last Run, Next Run and Results

• Field Mapping and Emma Account User: configuration records for field mappings and account access

Note: Queue Items are internal records used to send changes to Emma in the background, and are not intended for reporting.

Related Articles

• Mailing History [Full Guide]

• How can I work with Salesforce reports?

• How can I better filter my Emma Salesforce reports?