Range values structures a column with numerical values “Amount” for different ranges of numbers.
How to discover consumers needs and behavior better?
NeoNeuro pivot table has the function "Range values" that allows performing a detailed analysis of the data. This module shows, for example, how many liters of gasoline people buy at gas stations, which price category is the most popular with customers. It helps to identify not the obvious needs of your customers.
Let’s check!
Open table "Sales.xls" and find "Sum" parameter:
Right-click on this column. The list of actions will be opened, select "Range values".
Now menu "Value ranges" is available. Sort data in ranges that are interesting and valuable for your analysis.
We can change the sorting options in two ways:
1. Move sliders with values near the scale in the left part of the window, holding the left mouse button. Click near the scale will create a new value. Delete an extra value by clicking on the red X.
2. We can enter range limits manually in the right part of the window. Just enter required numerical values.
To save changes, click "Apply" button.
To reset changes and return to the automatically created range limits, click "Default" button.
Close this module by clicking "OK" or "Cancel" depending on your task.
For example, sort the products according to price category. Ranges are selected from 14 (min) to 100, from 100 to 150, from 150 to 300, from 300 to 500, from 500 to 579 (max).
You can construct various hypotheses about the behavior of clients based on this information. For example, people often make purchases within the limits of 150-300 rubles, this range has the best trend. You can build a hypothesis that people buy mostly food for 1-2 days or for cooking a particular dish. Think of sales and create special deals for these products.
This table does not create a marketing strategy from scratch, but the "Range values" module helps to build assumptions based on real data.
Find out what is in demand for your audience.
