Create advanced formulas to calculate scores or identify key metrics for each idea.

Using a formula helps you better understand the data you’re sending to Canny. They can take a data point you’re passing to Canny and put it into context, while filtering out noise.

A formula takes a number being sent to Canny for each user via Canny Identify, (for example, MRR [Monthly Recurring Revenue], insight count, or a custom figure like employee count) and shows the total, count, average, minimum, or maximum:

In the above example image (using MRR) there is a post that has votes from 212 accounts. On average, those accounts pay $151.064 per month. The total sum of all accounts’ MRR is $32,025.67 with the highest MRR for a single account at $4,000 and the lowest MRR for an account at $0.

That integer can also be filtered by user segments. This way, you can create formulas focused on a single key segment of your user base. For example, number of accounts on your enterprise plan. Formulas can also be used when creating a score.

Insights represent interest in a particular idea from individual users or companies. In a formula field, you can filter insights. Insight counts capture insights either in their entirety or filtered by priority or limited to the number of company insights rather than individual user insights. This way, if you have one company with many employees who are adding insights, it is only counted once.

Insights with their corresponding priority level:

Create a new field from the Fields button at the top of your ideas page. This opens a drawer with all available fields. You’ll see an option to “Create a new field” at the bottom. Simply select “Formula” from the Type dropdown:

From the Post and Idea fields page in your Canny Data settings, you can also create fields:

Score fields aim to help you prioritize ideas based on objective metrics. The formula is essentially weighted impact divided by the effort required. This way, your team can identify high-impact, low-effort tasks and deploy resources with maximum efficiency.

Create a new field from the Fields button at the top of your ideas page. That will deploy a drawer with all fields. You’ll see an option to “Create a new field” at the bottom. Simply select “Score” from the Type dropdown:

From the Post and Idea fields page in your Canny Data settings, you can also create fields:

Impact factors are meant to quantify the effects and results of this post. It can be anything your team wants to consider when prioritizing:

Examples of impact factors:

Effort factors quantify the difficulty of the steps and the extent of investments required to complete the post:

Examples of effort factors:

Scores and formulas will appear as a column in your ideas. Simply enable that field and sort your ideas by score.

The highest score means that idea will have the highest impact for the least amount of effort. High-scoring ideas should likely be prioritized for development.