To use Revenue Attribution in Outreach, there are specific configurations that are required for your organization.
Prerequisites:
- Your Dynamics CRM is integrated with Outreach
- Opportunities are syncing from the CRM to Outreach, and all minimum required fields are mapped
- Opportunity Stakeholder Roles are syncing from the CRM to Outreach
- Opportunity Stage values will need to sync in through the Opportunity Stage object and have a 1:1 Record Mapping with values that represent Open, Closed Won & Closed Lost
CRM Integration Configuration Guide:
Opportunity Object Configuration:
- Polling set to Automatically
- Set object syncing: Create & Update enabled to Sync into Outreach
Example Sync Configuration:
Ensure the following fields are mapped at a minimum within the Opportunity Object:
Dynamics Field (Labels may vary in your CRM) | Outreach Field | Field Type |
Requires Advanced Field Settings? |
Topic | Name | String | No |
Est. revenue | Estimated Sales Amount | Money | No |
Est. close date | Expected Close Date | DateOnly | No |
Type | Opportunity Type | Picklist | No |
Sales Stage or Status (statecode) | Stage | Lookup |
Yes **In the advanced settings, enable Mapped Field and select opportunitystage in the object drop down menu (Screenshot below) |
Created On | External Created Date | DateTime | No |
**Field mappings that have a Gear Icon indicate there are Advanced Field settings needed.
- Native Outreach Field: If you are mapping a CRM lookup field to a Native Outreach lookup field, you need to indicate that it is a Mapped Field and which object it is a Lookup to in the Advanced field settings.
-
Custom Outreach Field: If you are mapping a CRM lookup field to a Custom Outreach field, you need to enable Display name instead of record ID in Advanced field settings.
Example Configuration of Field Mappings:
Stage Configuration Details:
- Click More Actions on Stage field mapping (Select the 3 dots on the right)
- Select Advanced settings
- Enable Mapped field
- Select opportunitystage in the Microsoft Dynamics Object that field maps to drop down menu
Stage Considerations:
- It is common to use various types of Stage/Status picklists in Dynamics. Consider using the following options as long as they can represent Open, Closed Won & Closed Lost
- Status (statecode): We commonly see that Status represents values of 0,1,2 which can translate to Open, Closed Lost & Closed Won
- Sales Stage
- Sales Process Stage
- Custom Dynamics stage picklists
- Once the Stage/Status values have synced to Outreach and the record mappings have been established, review the stages in the Records>Opportunities>Stages section to determine which stages should remain as Open and which ones should be modified to reflect Closed Won or Closed Lost
- Only one Stage/Status value can be mapped natively to the Outreach Stage field. If there are other values that are important to reflect on Opportunities in Outreach, you can map them to custom fields and label them in your settings. From there, you can use column customization to prioritize other values in the Opportunity List view. Customizing List View Columns in Outreach
Opportunity Stakeholder Role Object Configuration:
- Polling set to Automatically
- Set object syncing: Create & Update enabled to Sync into Outreach
Example Configuration of Field Mappings:
Fields should be mapped already by default with the applicable advanced settings already applied.
Opportunity Stage Object:
- Polling set to Automatically
- Set object syncing: Create & Update enabled to Sync into Outreach
Example Configuration of Field Mappings:
Fields should be mapped already by default with the applicable advanced settings already applied.
The Stages will sync in automatically and establish the record mapping which you can view in the Record Mappings section.
Once the Stage picklist values have all been created and mapped from Dynamics, go to Records>Opportunity Stages in the Outreach Opportunity Settings. Each Stage will need to have a Type assigned (Open, Closed Won, Closed Lost). Example:
Considerations:
- The Opportunity Stage/Status picklist field that maps to Outreach's native Stage field can vary in your CRM. Examples include: Sales Stage, Status, Stage. It is important that the picklist field that is selected represents values of Open, Closed Won & Closed Lost. If those values are not represented in the Opportunity Stage values in the Outreach Opportunity settings, the Revenue Attribution logic cannot be applied to the reporting because there won't be an indication of which Opportunities should technically reflect closed revenue or current pipeline.
- The Opportunity Object & Opportunity Stakeholder Role should have a Polling Frequency of once a day at a minimum (every 10 minutes is the default)
- Advanced Setting on Opportunity Object: When Create associated contacts when syncing into Outreach is enabled:
- If the related Stakeholder in Dynamics is technically a duplicate record and one of the duplicates with the same email address has already been created in Outreach as a prospect, this advanced object setting being enabled could potentially prevent the Opportunity record from being created as a whole because it can't create the duplicate Stakeholder as a new prospect.
- The Opportunity Stakeholder Role object being enabled to Poll automatically and create new contact roles will allow Outreach to pull in the related Contact roles independently when they are added to the Opportunity in Dynamics as a Stakeholder and/or modified.
- Resource: Salesforce Record Merge & Delete FAQs
Loading in Opportunity Data Retroactively:
If you have configured Opportunities with Outreach for the first time, mapped new fields or enabled the automatic sync for the Opportunity or Opportunity Stakeholder objects, the records or updates to records will begin to populate automatically as records are created or updated in the CRM. In order to have a complete view of the data in the the new Revenue Attribution Reporting and to load in data retroactively, it is important to run a Historical Sync Job.
- How to Load Historical Data Into Outreach
-
Walk through "How-to" video - Example only - determine the right Last Modified date range for your org on the
Additional Resources:
Sales Execution Report Overview