Creating a Conversion Rate Indicator is much simpler in jestor than in Excel. After all, in Excel it takes longer to build and the chances of error are bigger if someone messes with the table, columns, etc. Also, Excel becomes visually tiring as it shows many formulas, auxiliary columns and other things that had to be created for the analysis to be done. This can make Excel heavy and harder to navigate.
On jestor, the results are more reliable, updates happen at the same time and all information is saved in the database jestor provides.
Walkthrough: How to create a Conversion Rate Indicator in jestor
1º) The first step is to create a Dashboard. Go to the “+” icon on the left menu, choose the option “Dashboard”, name it “Conversion rate” and click on “create”.
2º) Click on “Add Component”, choose “Complex Indicator” and name it “Conversion rate”.
In item “1. Define the operation of the indicator”, select the option “Ratio % (x/y)”;
In item “2. Define ‘x’”, select the following options:
- In “Select the table it is in”: Choose the table that contains the information you want to pull;
- In “Select the operation for ‘x’”: Choose “Number of records in the interval”;
- In “Choose the period analyzed”: Choose the period you want to analyze, like the “last 7 days”, “all time”.
- In “Select a filter for ‘x’ (optional)”, filter the results to the desired status (such as “Won” deals).
3º) Do the exact same process for “y” minus the filter, and click on “Create”.Did you see how easy it is? jestor ends up being a very simple BI and Analytics tool that allows deep analysis, always up-to-date data, and without having to code.