View Source

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:

S-360 Release Notes > Extend information on visits available in reports > Product revenue.png

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.

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".

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).

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.