Part 2: Estimated Close Date vs. Actual Close Date
Out of the box, pipeline revenue data is not available in the dashboard because, by default, Dynamics has two stock close date fields: Estimated Close Date and Actual Close Date. Marketo Measure can only point to one close date field in the dashboard and it is pointing to the Actual Close Date.
If open opportunities have no data in the Actual Close Date field, there is no data in the dashboard for open opportunities. That being said, a workflow is needed based on opportunity stage to support both date fields.
-
Create Custom Close Date Field on the Opportunity Object (Marketo Measure Custom Close Date).
-
Create a Workflow to update the Marketo Measure Custom Close Date field with the date from either the Estimated Close Date or the Actual Close Date, depending whether the opportunity is open or closed (workflow should be saved to run in real time, but must be run “on demand” at least once to update all current open opps).
-
Test the workflow and confirm it works.
-
Customer to provide the Custom Close Date API name to Marketo Measure.
-
Marketo Measure to update the Marketo Measure app settings to point to the Marketo Measure Custom Close Date field in the Dashboard.
Upon completion of the above steps, run the workflows to update both the Custom Marketo Measure Opp Amount field and the Marketo Measure Custom Close Date field on your historical opportunities to reflect the correct data. This will likely change the modified on/by fields so you should check with your team to see if that presents any issues.
To update the closed opportunities…
- Isolate opportunities that have closed since your Marketo Measure start date up til the workflow is active. This is the group of historical opportunities that you must update via workflow.
- Export all records to Excel.
- Open Excel file, enable content.
- Copy Actual Close Date data to Marketo Measure Custom Close Date.
- Copy Actual Revenue data to Marketo Measure Custom Opportunity Amount and Marketo Measure Opportunity Amount (there are two fields.)
- Save file.
- Import file. Dynamics will recognize this as a file with existing records to update.
- Check for failures on import file.
- If Opp = Open, update custom close date field, custom opp amount field, and Marketo Measure opp amount field to equal Estimated Close Date and Estimated Revenue, respectively.
- If Opp = Closed Won, update custom close date field, custom opp amount field, and Marketo Measure opp amount field to equal Actual Close Date and Actual Revenue, respectively.
Marketo Measure
- Overview
- Introduction to Marketo Measure
- Marketo Measure Tracking
- Configuration and Setup
- Channel Tracking and Setup
- API Connections
- Marketing Spend
- Advanced Marketo Measure Features
- Marketo Measure Discover UI
- Marketo Measure and Adobe
- Marketo Measure and Dynamics
- Marketo Measure and Marketo
- Marketo Measure Salesforce Reporting
- Marketo Measure Data Warehouse
- BI Report Templates
- Security and Compliance
- Marketo Measure Ultimate
- Miscellaneous
- Release Notes