Number of properties in marketing / temporal reference
Several examples will explain how to use statistics and how to change them using the configuration. There are several example pages at “Working with Statistics“.
We will start with the template “Number of properties in marketing”, in which the settings for “Temporal reference” are to be clarified.
Thinking through the temporal relation of logic correctly – and then entering it accordingly – is what constitutes art in creating individual statistics.
Template “Number of properties in marketing”
The statistics contain 3 criteria (commercial properties, houses, apartments) for which the key figures for the selected period are displayed. The system filters and checks which property type was published in a portal in the month under review.
Key figure is the number of properties that were visible in a portal in the month in question. So all the ones that have been set in the month are still set from the last month and have been removed from the portals in this or a following month.
Settings for “Time reference” in the example
The time reference is the special and difficult thing about this statistic – and is the point that has to be clarified for creating your own statistics. Especially because it does not simply count the properties that were once in a portal, but a certain period of time can be set. In this example, the specified month is set as the time reference value. But you could also display the quarter, or the previous month. The difficult part is the specification of the required fields and their chronological classification.
In the standard template, the corresponding settings are already stored, which we now want to take a closer look at.
To do this we have to open the statistics settings via the wrench symbol in the widget frame.
At the bottom of the configuration there is the category “Time reference”, which contains two defaults. The first default refers to the date in the “set first” field (the field can be found in the property record on the “Details” tab and there in the “Administration” category).
The other default is the field “offline since” (the field can be found in the property record on the tab “Details” and there in the category “Administration”).
In the example, “set first” > “end of month small” is specified. All properties that were discontinued in or before the month in question are thus recorded. However, this still includes properties that are no longer published in the portal.
For this the second part is needed, namely “offline since” > “bigger beginning of month”. This results in all properties that went offline in the month in question or afterwards – i.e. were removed from all portals.
Whether and how non-existent dates (“offline since” is not yet filled for newly transferred property) are counted must be specified under “Empty values”. In the example, these are excluded for “set first” so that only properties that have been set at all are included. If “offline since” is selected, empty fields are included. This field is empty for a property that has just been added to a portal. These properties must be counted, therefore include “empty values”.
As a result, you get the properties that are online this month.
With “time reference” and the information that the date is smaller or larger “beginning of month/month end”, one can form a kind of “bracket” for the considered month.
Further settings for “Time reference”
A further field can be added for evaluation via the “New date reference” button. The trash can symbol can be used to delete references that are no longer required.
In addition to “start of month/end of month”, another reference can be selected, namely “in the month”. The date of the selected field must then be in the month, the “comparison” is omitted. “Time offset” and “Blank values” can also be specified here.
There is still one setting missing and that is “time shift”. An example of this attitude would be: How many properties were sold two months after they were invested?
To do this, the “created on” date must be two months before the month under consideration and the “sale date” must be in the month under consideration.
The settings (two pieces are necessary) are as follows:
- First we use the field “created on”, reference is “in month”, comparison remains empty, time offset is “month-2” and empty values are set to “exclude”.
- Then the field “Sold on”, reference is “in month”, comparison remains empty, time shift remains empty and empty values are set to “exclude”.
Other standard templates with “Temporal reference” are e.g. “Incomplete addresses”.