Why is the Mailchimp campaign statistics modal blank for some users?
If the Mailchimp Campaign Detail modal opens but shows no data, Sent reads Never Sent, Open Rate and Click Rate show % Ind. %, and the Statistics, Segment and Email Preview tabs are empty, while a System Administrator viewing the same campaign sees everything populated, the cause is almost always the affected user's access to the standard Campaign object.
Our Mailchimp Campaign record carries a Salesforce Campaign lookup field pointing at the standard Campaign object. Salesforce hides a lookup field from any user who cannot read the object it points at, even when field level security on the lookup itself is granted. The query behind the modal then cannot run, and the modal renders its shell with no data in it.
How to confirm it
- Open the same campaign as a System Administrator. If it populates for them, this is permissions, not missing data.
- In Setup, open the affected user's profile and check Object Settings for Campaigns. No Read access confirms the cause.
- A debug log for the affected user shows No such column 'Salesforce_Campaign__c' on entity 'mone__Mailchimp_Campaign__c'.
Note: this is not the Marketing User checkbox. Marketing User is a capability flag for creating and editing campaigns, and grants no object level read on its own.
How to fix it
Grant Read on the standard Campaign object to the affected users. Read on its own is enough, you do not need Create, Edit, or Marketing User.
Add it through a small permission set included in the users' existing permission set group rather than by editing the profile directly, so the change is easy to audit and reuse.
Our packaged permission sets deliberately grant no access to standard Salesforce objects like Campaign, Contact, or Lead. Which of your users should see campaign records is your decision as the subscriber admin, so that access always comes from your own profiles and permission sets.
If those users also need to link a Salesforce Campaign
Campaign Read fixes the statistics. Linking a Mailchimp campaign to a Salesforce Campaign is a separate requirement: the user needs Mailchimp Standard or Mailchimp Admin. Mailchimp Limited grants Read only on the Mailchimp Campaign object and cannot write the Salesforce Campaign lookup, so Link with Campaign will still fail for a Limited user even after you grant Campaign Read.
The same applies to the data wizard when you choose Salesforce Campaigns as the source. The user building the import, and the Run As user for scheduled runs, both need Read on Campaign and Campaign Member.
