Mailchimp 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 mone__.
You can also see each field's help text in Setup > Object Manager > [object] > Fields & Relationships.
Mailchimp Member
One record per email address on each audience.
• Mailchimp List: the audience the member belongs to
• Email and Full Name: as stored in Mailchimp
• Status: Subscribed, Unsubscribed, Cleaned, Pending, Transactional or Archived
• Active: formula, checked when the status is Subscribed, Pending or Transactional
• Contact, Lead / Account: the matched Salesforce record (Account is used for person accounts)
• Object Id: the ID of the linked Salesforce record
• Member Rating: Mailchimp's 1 to 5 star engagement rating
• Avg Open Rate and Avg Click Rate: Mailchimp's averages for this member
• Tags, Tags Count, Groups and Group Ids: the member's tags and interest groups
• Timestamp Signup, Timestamp Opt, Ip Signup, Ip Opt: when and from which IP address the member signed up and confirmed their opt-in
• Last Changed: when Mailchimp last changed the member
• Source: how the member was added in Mailchimp
• Last Import Source, Last Import, Last Import Error: details of the last update sent from Salesforce, and any error Mailchimp returned
• Email Type (html or text), Email Client, Language, Location, Vip, Consents To One To One Messaging: member details from Mailchimp
• Member Id, Unique Email Id, Contact Id, Web Id: Mailchimp identifiers
• List Id, Audit, Job Id, Merge Fields Primary: internal fields
Mailchimp Email Activity
One record per email event. These records are only created when stored activity history is turned on.
• Action: open, click, bounce, hard, soft, complaint, unsubscribed, abuse or sent
• Timestamp: when the event happened
• Email, Mailchimp Member, Mailchimp Campaign, Mailchimp List: who, which campaign and which audience
• Opens and Clicks: formulas that return 1 for an open or click and 0 otherwise, so you can sum them in reports. See reporting on opens and clicks per person
• Link Clicked and Activity URL: the link clicked. See the difference between the two
• Bounce Type and Bounce Has Open Activity: hard or soft, and whether the same campaign was also opened
• Unsubscribe Reason and Is Admin Unsubscribed: why the member left, and whether an admin unsubscribed them
• IP Address: where the interaction came from
• Campaign Id, List Id, Email Id: Mailchimp identifiers
• Message Text, Note Text, Order Id, Order Total, Order Url, Store Name, Survey Title, Outreach Title, Marketing Permission Opted In and similar: details for conversation, note, ecommerce, survey, outreach and marketing permission events, where Mailchimp provides them
• Mailchimp Account Id: internal field
Mailchimp Campaign
One record per email campaign synced from Mailchimp.
Campaign details:
• The Settings fields (title, subject line, preview text, from name, reply to and so on), type, status, Send Time, Create Time, Archive Url and Segment Text
• Mailchimp List: the audience the campaign was sent to
• Salesforce Campaign: optional lookup to a Salesforce Campaign, see linking campaigns
• Parent Campaign, Is Variate Child, Winning Campaign Id: used for A/B and multivariate tests
• The Tracking fields: whether open, click, ecommerce and Google Analytics tracking were on
Results (best for reporting, taken from Mailchimp's campaign report):
• Emails Sent, Recipient Count, and the Report Summary fields: Opens, Unique Opens, Open Rate, Clicks, Subscriber Clicks, Click Rate, Total Orders, Total Revenue, Total Spent
Sync fields (used internally):
• Job Id, Last Sync Campaign, Last Sync Activity, and the Last Open/Click, Last Sent and Last Unsubscribed offset and page size fields. The sync uses these to track how far it has downloaded activity.
Mailchimp List (Audience)
One record per Mailchimp audience.
• Name and Mailchimp Account
• The Stats fields: member, unsubscribe and cleaned counts, open and click rates, and last subscribe, unsubscribe and campaign dates, from Mailchimp's audience stats
• The Campaign Defaults fields: default from name, from email, subject and language
• The Contact fields: the audience's postal address and company, used in email footers
• Double Optin, Marketing Permissions, Has Welcome, Permission Reminder, Subscribe Url Long / Short: audience settings
• Date Created, List Rating, Visibility, List Id, Web Id: from Mailchimp
• Last Synced List and Last Synced Audience: when the audience settings and members last synced
• Status: Active, or Deleting while the audience is being removed from Salesforce
• Mappings Mailchimp and Mappings Salesforce: internal fields that store your field mappings
Groups and audience history
• Mailchimp Group Category: an interest category on an audience, with Title, Type (checkboxes, dropdown, radio or hidden) and Display Order
• Mailchimp Group: an interest group inside a category, with Group Name, Member Count and Display Order
• Mailchimp List History: one record per audience per month, with Subscribed, Unsubscribed, Cleaned, Pending, Imports, Optins, Reconfirm, Transactional, Deleted and Existing counts, and Metric Timestamp for the month
Mailchimp Account
One record per connected Mailchimp account, with Account Name, Login Name, Login Email, Data Center Prefix, Salesforce User (who connected it), Status (Active or Disconnecting) and Last Sync.
Note: Mailchimp Queue Items are internal records used to send changes to Mailchimp in the background, and are not intended for reporting. See What are Mailchimp Queue Items?
