Combine the power of Donorbox's fundraising tools with Salesforce's industry-leading CRM! Read on to learn which Donorbox campaign fields get mapped to Salesforce so you can customize this integration to fit your needs.
Donorbox provides extensive integration with Salesforce for nonprofits, including both Nonprofit Success Pack and Nonprofit Cloud.
In order to fully utilize the features of this integration, it is important to understand how your Donorbox form fields are mapped to your Salesforce account when you enable this integration. We briefly touched upon this data mapping in our Salesforce integration guide.
In this data mapping guide, we’ll cover all aspects of Donorbox-to-Salesforce field mapping. We designed our Salesforce integration to handle auto-mapping of the essential fields and give you the ability to configure your custom and optional fields as needed.
With that in mind, our field mapping can be divided into three sections:
One thing before we begin with the field mapping – Donorbox pushes a new campaign to Salesforce only when a donation arrives. So if you have created a campaign on Donorbox and are wondering why it’s not showing up in your Salesforce account just yet, don’t worry – your data will appear shortly after you receive your first donation.
Donorbox uses these four Salesforce objects in our integration:
This guide will use the following campaign to help you understand our field mappings:
When the first donation to this campaign is made, Donorbox pushes the data to the connected Salesforce account.
First, the integration checks if that particular campaign is present in Salesforce. If it’s not present, a new campaign is created in Salesforce and the donation is pushed after that.
The integration checks whether any campaign fields have been updated once it locates your campaign. If the campaign fields have been updated, the corresponding Salesforce campaign is updated before the donation data is pushed to Salesforce.
Our integration uses the following fields in the Salesforce campaign object:
Note: The above fields are the ones that are visible to you on your campaign details page on Salesforce. In the background, our integration also uses other standard Salesforce fields like ID.
These fields are essential for maintaining the identity and synchronization between Salesforce and Donorbox. When the campaign is pushed to Salesforce, the above fields are populated based on the values that are present in your Donorbox campaign.
The Campaign Currency field in Salesforce is a managed picklist. It contains the Currency ISO codes for the currencies that you have enabled for your organization. By default, every Salesforce Org has one currency.
If your Donorbox campaign uses the same currency, there is no need for multiple currencies in Salesforce. If this is not the case, then you need to enable multiple currencies in your org. Here is an article to help you set it up in your Salesforce account.
In Salesforce Nonprofit Success Pack, there are two standard record types: “Organization” and “Household Account”. In Nonprofit Cloud, there is an additional “Person” record type.
When a new account is created in Salesforce for a contact through the Donorbox sync, the “Household Account” record type is selected. Most of the account management in Salesforce is done based on contact information.
To learn more about how we manage accounts and contacts and avoid duplicates, check out our integration blog post.
All the contact information collected from your Donorbox donation form is used to create a new contact and the corresponding account for that donor. We also check if a donor already exists in Salesforce with the provided contact information – if so, we use that instead.
Donorbox uses the following Salesforce contact fields:
| Donorbox Donor Field | Salesforce Contact Field | |
|---|---|---|
| First Name | First Name | |
| Last Name | Last Name | |
| Address 1 + Address 2 | Mailing Street | |
| City | Mailing City | |
| Zip Code | Mailing Postal Code | |
| Phone | Phone | |
| State | Mailing State Code | |
| Country | Mailing Country Code |
When a new donation arrives, this is what a Donorbox-created contact looks like in Salesforce:
Donorbox donations go into the Opportunity object in Salesforce.
An Opportunity record is created at the end when the campaign, account, and contact records needed for this opportunity record have all been created or have been identified.
Our default donation push uses the following Salesforce opportunity record fields:
| Donorbox Donation Field | Salesforce Opportunity Field | |
|---|---|---|
| Amount | Amount | |
| Donation Date | CloseDate | |
| Comment | Description | |
| Opportunity Name | Opportunity Name | |
| Account Name | Account Name | |
| Primary Contact | Primary Contact | |
| Stage | Stage | |
| Currency | CurrencyIsoCode | |
| SF Campaign ID | Primary Campaign Source |
From all of the above fields, the Stage field can be configured in Donorbox from the Salesforce Data Mapping page. By default, the value for the stage field is “Closed Won”. Using all this information from the Donorbox form, this Opportunity is created inside Salesforce:
The following table explains what value is contained in each of the fields that you see on the Salesforce Data Mapping page in Donorbox. All of these fields can be mapped to any of the standard and custom fields that are present in the Account, Contact, and Opportunity objects in your Salesforce org.
| Donation Field | Signifies | |||
|---|---|---|---|---|
| Donation ID | Unique ID for this donation. It can also be found on the receipt and donation details page on Donorbox | |||
| Employer | The employer of the person who is making the donation. Note: This is different from the field "Donating Company" |
|||
| Occupation | Occupation of the person who is working with the Employer | |||
| Designation | What the donation is meant to support. You can set these in your campaign editor. | |||
| Anonymous Donor | This is a checkbox field and has to be mapped to the same data type in Salesforce | |||
| Gift Aid | This is a checkbox field and has to be mapped to the same data type in Salesforce. Note: This is only for UK based organizations |
|||
| Is Recurring Donation | This is also a checkbox field and can only be mapped to a checkbox field in Salesforce | |||
| Recurring Interval | If the donation is a recurring donation then this will contain the recurring interval duration i.e. weekly, monthly, quarterly or annually | |||
| Recurring Start Date | If the donation being exported is part of a recurring plan, this field will contain the recurring plan's start date | |||
| Is First Recurring Donation | If the donation is the first donation of a recurring plan, then this field will be yes. If the donation is a subsequent donation of a recurring plan, then it will be no. If the donation is a one-time donation, this field will be set to Not Applicable | |||
| Net Donation Amount | The net amount that you will receive after deducting the processing fees of the payment method that was selected for this donation | |||
| Thank You Comment | The thank you note that the donor writes in the comment field on the donation form | |||
| Stripe Charge ID | The unique Stripe ID that was generated for the transaction | |||
| Join Mailing List | This is a checkbox field that records the donor's preference for subscribing to the mailing list | |||
| Donation Type | The payment method used for processing the donation. The donation type can be Stripe, ACH, PayPal, SEPA, iDEAL or PayPal_Express. For manually added donations, the donation type can be check, cash, credit_card, external_bank_transfer, Apple_Pay, Google_Pay or cryptocurrency | |||
| Donation Date | The date on which the donation was made | |||
| Phone | The contact number that was added on the donation form | |||
| Donating Company | If the "This donation is on behalf of a company" checkbox is selected. This includes the name of the donating company | |||
| Donor Type | If the donating company is present then it says "company" otherwise it outputs "individual" | |||
| Is Donor Company | If donor is a company then this boolean field is true otherwise it is false | |||
| Is Donor Individual | If donor is an individual then this boolean field is true otherwise it is false. Note: This field is similar to the "Is Donor Company" field. It is advisable to use one of these two fields based on how you would like to map it to Salesforce |
|||
| Dedication Type | This field is populated when the donor checks the "dedicate my donation" checkbox. This field can have two values: "In honor of" and "In memory of" | |||
| Honoree Name | The name of the person in whose honor/memory the donation was made | |||
| Recipient Name | The name of the person to be notified for this dedicated donation | |||
| Recipient Email | Email address of the recipient. This field is available if the "Notify this person by email" option is selected | |||
| Recipient Address | Mailing address of the recipient. This field is available if the "Notify this person by postal mail" option is selected | |||
| Recipient Message | This is an optional message field which is used to notify the recipient | |||
| UTM Source | Tracks whether your audience is coming from social media, email newsletters, or other sources. Note:The utm_source parameter must be present for the other UTM parameters to be recorded |
|||
| UTM Medium | This identifies the medium or method of communication | |||
| UTM Campaign | This will indicate the specific campaign or initiative | |||
| UTM Term | This signifies paid search campaigns to track specific keywords | |||
| UTM Content | This is used to distinguish between different versions of an ad or content, such as A/B testing or multiple links in the same email or post | |||
| Fair Market Value | The estimated value of any goods or services that the donor receives in exchange for their contribution | |||
| Tax Deductible Amount | Represents the portion of the donation that is tax-deductible, based on the Fair Market Value | |||
| Fair Market Value Description | A description of the Fair Market Value of the goods or services the donor received in exchange for their gift | |||
| GDPR Consent | This is a checkbox field and has to be mapped to the same data type in Salesforce | |||
| Stage | The Opportunity stage with which the donation is pushed to your Salesforce org |
We also ensure that the fields that you see in the dropdowns on the mapping page are up-to-date. So whenever you add a new field in any of these three objects in your Salesforce org, we update our dropdowns accordingly too.
Donorbox has a powerful form builder that allows you to add custom questions to your campaign form. Along with the standard fields, Donorbox gives you the capability to map these additional questions to your Salesforce fields.
A more detailed look at how you can map these campaign-specific additional questions to Salesforce can be found in our integration blog post. Note that the ability to map additional questions will only appear if you’ve added additional questions to your form.
The Donorbox + Salesforce integration combines two powerful tools to help nonprofits of all sizes fundraise, forecast, and grow! We hope this article’s detailed look at these data mappings helps your organization customize your Salesforce integration to streamline your workflow as much as possible.
If you still have any questions, please feel free to reach out to us at .
Product Manager - Integrations @ Donorbox
Subscribe to our e-newsletter to receive the latest blogs, news, and more in your inbox.
Zarq
