Skip to main content
Video

Reporting: tracking Opportunity value changes [video]


Natalie from Copper
Copper Employee
Forum|alt.badge.img

Note: As of March 2022, Opportunities in the Copper left-hand menu is changing to Pipelines. Click here for more information.

 

As Opportunities move along the Pipeline it is common that the terms of the commitment adjust along the way. To have a better understanding of those changes and your sales forecast, you will want to track Opportunity value changes. 

 

Within the Opportunity, each one of them has a defaulted value field. This field is used throughout your Copper account for the Opportunity cards, stage sums, and pipeline sum, and this is the value used in the sales forecasting reports. As the value changes during negotiations, you will want to make sure that this field is always the true value and the most up-to-date. (It’s a best practice to make a note in the Opportunity activity feed as to why this was changed and upload any pertinent documents to the files section.)

 

However, how much has this value changed over time? My solution is to create a custom field to track the original value. In this demo, it is suggested to create a custom field in the currency format that is named “Original Value” so we can use this field to show what the initial value was before negotiations.

 

To hone in on these changes we will track them in the new Copper Reporting tool by adding a new Insight. Note: Make sure to add the custom field Original Value to the reports and allow for the data refresh to take effect.

  1. For the measures, we will want to track both values:

    1. Sum of Opp Value 

    2. Sum of Opp CF Original Value

  2. The Rows will be

    1. Opp Pipeline

    2. Opp Name

 

 

Once this Insight is saved into your Reporting Dashboard you have the ability to drill down further by selecting specific date ranges or Pipelines. 

 

Let me know in the comments below if you have found alternative solutions to track Opportunity value changes over time or if you have any questions. 

4 replies

  • Engaged User
  • 6 replies
  • October 19, 2021

Hi @Natalie from Copper !

Do you think this same setup would work for Won Opportunities to track the value of upgrades/downgrades?


Natalie from Copper
Copper Employee
Forum|alt.badge.img

Hi @jlodge 

Yes, you would be able to track Won Opportunities as well! I would recommend adding the Opportunity Status into your report to identify those that are “won”.  There are two easy ways to do this: 

  1. Add “Opportunity Status” as a Row so you can see every status:

 

  1. Add a filter to your report by “Opp Status” so you are only viewing “Won” values: 

 

Please let me know if you have any further questions, I’m here to help!

 


  • New Participant
  • 4 replies
  • October 20, 2021

Awesome to see such a custom need fulfilled within Copper. Granted, we are not yet ready to track things like this, but it will happen soon.

 

Is it possible to ask for help with a very specific use case? We want to be able to track the following and we have tried to create our own insights with no luck.

 

  • Amount of leads received per month (a total)
  • Breakdown of leads by source per month
  • Breakdown of leads converted to opportunities per month per source (to track ROI on advertising)
  • Breakdown of leads converted to opportunities per month which are then converted to won opportunities 

Thanks!


Natalie from Copper
Copper Employee
Forum|alt.badge.img

Hi @Alext 

Certainly! I plan to do a full Report series soon with other videos so please be on the lookout for them. Until they are released let’s dive into your specific reports. Below I have screenshots and Loom videos on how I would approach your reports but please let me know if you have additional questions or need further information. 

 

Amount of leads received per month (a total)

Please note if you have a monthly report you could pull in a lead KPI at the top of your report too if you’re only looking at one month at a time. However, for a full monthly breakdown:

 

Breakdown of leads by source per month

 

Breakdown of leads converted to opportunities per month per source (to track ROI on advertising)

 

Breakdown of leads converted to opportunities per month which are then converted to won opportunities 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings