NEW V3.15 Information on the number of participants of group visits were missing in different reporting domains, especially in case of group tickets. The product revenue and attendance domains have been extended in order to provide you more information about the number of participants.
Solution
Product revenue domain
The product revenue domain provides 6 additional fields about the number of participants who have reserved or purchased a visit:
| Field name | Explanation |
|---|---|
| Nb of part. - Net res C | Net number of participants having reserved a free (complimentary) visit |
| Nb of part. - Net res P | Net number of participants having reserved a paid visit |
| Nb of part. - Net res T | Total net number of participants having reserved a visit |
| Nb of part. - Net sold C | Net number of participants having purchased a free (complimentary) visit |
| Nb of part. - Net sold P | Net number of participants having purchased a paid visit |
| Nb of part. - Net sold T | Total net number of participants having purchased a visit |
The naming convention is exactly the same as for the other fields belonging to the product revenue domain.
An example of a report using these new columns is displayed below:
- The visit Bespoke tours uses group tickets. A total of 9 tickets have been sold representing in total 110 participants.
- The visit Visit conférence exposition uses also group tickets. A total of 3 tickets have been reserved representing 30 participants.
- Since the visit Visit guidée Christo et Jeanne-Claude uses individual tickets, the number of participants is equal to the number of tickets.
TED (The Executive Dashboard)
The dashboard displayed in TED already takes into account the number of participants and, therefore, was kept unchanged.
Attendance domain
The attendance domain was already providing the number of participants. This domain has been improved in order to display (if requested) the detail per tariff in case of group tickets with individual prices. Before this improvement, it was just displaying one line assigned to a fake tariff called "computed price".
Group tickets with individual price
This improvement has only been implemented in the attendance domain. The other domains, like the product revenue domain, still display the "computed price" tariff in case of group tickets with individual price.
Getting started
Product revenue
You don't have anything to do to use these additional columns in the product revenue domain. However, your reports, no matter if they are standard reports or custom reports, haven't been adapted to use these new columns. You can modify your reports in the following way:
- Selecting the report you want to modify in the list of reports. The report has to belong to the sub-topic product revenue.
- Click on Modify
- Go to the bottom of the screen and change the list of columns to display
- Click on Save
Attendance
You don't have anything to do to get the detail per real tariff. If you want to keep the old behaviour, you can create a service request. Our service team will set the institution parameter Analytics Attend New Ver to false.
Please be aware that the detail per tariff will only be available after the first complete rebuild of the domains following the feature delivery (22.11.2021). Complete rebuilds (occurring once per week) should not be confused with incremental refreshes (occurring every 5 minutes).
Important notice for our customers using their own BI tool
SecuTix provides temporarily 2 versions of the attendance domain.
- D_ANALYTICS_ATTEND_V1_0 is the old domain on which your BI tool is based (if you are using attendance information)
- D_ANALYTICS_ATTEND_V2_0 is the new domain providing the detail per tariff
Since SecuTix will only maintain D_ANALYTICS_ATTEND_V2_0 in the long term, you are kindly invited to migrate to this new domain until the 01.07.2022.
