Skip to content
ROI Calculator Template: The magic solution to disagreements between marketing and product teams
Share
Explore

Prioritize the right product features with this ROI calculator template

Copy this template certified by Product School to figure out which initiatives to prioritize using a voting-based system from your product and marketing teams
This exercise helps you visualize which initiatives should be prioritized based on their feasibility and importance, in effect, which ones will yield the greatest return on investment. Traditional ROI calculator templates rely on quantitative inputs. This ROI calculator template utilizes your team to vote on the initiatives they value the most to figure out which initiatives to prioritize.

Use this ROI calculator template

How to use this ROI calculator template

Step 1: List initiatives

Start by listing the set of initiatives that you want to prioritize. It is best to start with the list of items that do not have dependencies, otherwise you might prioritize an initiative above its dependency. If you do want to include items with dependencies, it’s best to consolidate the initiative and its dependencies as one item on your list.

Step 2: Allocate importance and feasibility “votes”

Then, assign each initiative a feasibility and importance rating. Typically, product management assigns the feasibility values with support from development; they know whether the idea can be built and what it would take. The “importance” column represents ratings that marketing and product management agree on.

The values you assign to each of the two criteria are based on a total budget of points. You can set any total budget; the more you allot, the higher fidelity the results will be. Of course, you would never distribute points evenly because the whole point is to show relative importance and feasibility. Remember, if you consolidate an initiative (to include a dependency) you must factor it into the cost of the initiative; so if the primary initiative costs 10 points and its dependency initiative costs 2, you must assign 12 points to its feasibility rating.

Step 3: Plot votes on a chart

Once you’ve plugged ratings into the table, you then plot the initiatives’ values on a chart. This exercise will give your teams a much better shared understanding of the initiatives and how they relate to each other. With these insights in hand, they’ll be better equipped to articulate a strategy that both product development and marketing can own and support.

In this exercise, it’s useful to have each participant come up with his or her own rating of feasibility or importance before sharing with the team. By concealing the results in this way, you avoid introducing the form of cognitive bias known as anchoring, in which the first number spoken aloud sets a precedent for subsequent estimates.

Get started:

Copy this doc and share this template with your team members by clicking
Share
in the top-right
Each team member adds initiatives in Step 1
In Step 2, enter the number of total “votes” each person gets and have everyone allocate their Feasibility and Importance votes
Review the ROI score, Avg. Feasibility, and Avg. Importance in Step 3
Delete the intro text (everything above the line below)

ROI Calculator

Step 1: Add initiatives

Step 2: Vote privately

Step 3: Review results

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.