Opportunity amounts by Company Account Revenue Explorer

[Anonymous]

We record opportunities in Salesforce under contacts for business accounts. 

How would you create a report that provided the Amounts of Won Opportunities for each company account we have usintg Revenue Explorer?

[Anonymous]

This will work if your Salesforce-Marketo mapping is set up appropriately.

1. In RCE, create New Report of type "Opportunity Analysis"
2. Add Measure "Opportunity Amount (Won)"
3. Add Row "Company Name"
4. Add Filter "Opportunity Won" = Yes

This report will show a list of all Companies with amount of opportunities won.  You may want to additionally filter the date to get a specific timeframe.