How do I use Ebsta Score to track the average for Closed Won & Closed Lost Opportunities?

Ebsta Support -

Ebsta will retrospectively Score Closed Won and Closed Lost Opportunities and retain the value at the point the Opportunity was Closed.

This allows you to then review previous performance and establish an 'average Ebsta Score' for Opportunities when they were either Won or Closed and then recognise a 'benchmark' relevant to your Organisation and individual Users.

 

1. Click Reports.

2. Click New Report.

 

3. Click Opportunities> Opportunities, then click Create.

4. Apply the following Filters to pin-point the Opportunities you wish to Report against.  

Note: Ebsta will only Score Opportunities retrospectively from as far back as your Mailboxes are syncing to give the most accurate possible Score. For example, if your Mailbox is syncing back 3 months, we'll only Score Opportunities created within the last 3 months.

 

5. Drag and drop the following fields from the left-hand column to the main Reporting Table:

Ebsta Score

 

6. Click on Tabular Format and select Summary.

 

7. Click the drop-down arrow next to Ebsta Score field.

 

8. Select Average, then click Apply.

 

9. Drag and drop the Opportunity Owner column header into the "Drop into a field here to create a grouping" section.

Then drag and drop the Stage column header into the "Drop into a field here to create a grouping" section below.

 

10. Click Add Chart.

 

11. Select Vertical Bar Chart.

 

12. Group By Stage, then click OK.

 

13. Click Save.

 

14. Add this Report to your Dashboard in Salesforce by following the steps in the below article:

How do I create an Ebsta Analysis Dashboard in Salesforce?

 

Recommended next reading:

How do I review Ebsta Score history against a record?

How do I create an 'Ebsta Score vs Opportunity Stage Duration' graph?

How do I create an 'Ebsta Score vs Opportunity Stage' graph?

How do I create an Ebsta Score Trending Table?

How do I create a User Email Activity graph?

How do I create a Team Email Activity graph?