Contact Production (rep_con_production with REP_CON_PRODUCTION.FMX)

The Contact Production report identifies the most producing contacts throughout the property or chain based on Room Nights, Room Revenues, F&B Revenues, Other Revenues, and Total Revenues produced for a specified time period.

Note: When printing this Report help topic, we recommend printing with Landscape page orientation.

Note: This report requires that the user be granted the ACCOUNT PRINT permission in the selected property to run the report. Also, the Property LOV in this report is further limited by the properties to which the user has the appropriate access granted.

Selection Criteria

Property. Available when the OPS_MHT2 license is active. Multi-select LOV to choose the property, or properties, for which the report should be printed.

Production Date Range From/To. Select the From and To dates for which the statistics should be calculated.

Contact Name. Use the down arrow to initiate the Contact Search screen. From here the user can search for contacts by account name, contact ID, and any number of the other search features available from the Contact Search screen.

Contact Owner. Select the down arrow to display a multi-select LOV to choose the Contact Owner(s) whose contacts to include in the report.

Influence. Select the down arrow to choose the influence(s) codes to include in the report output.

Contact Country. Select the down arrow to choose the country or countries in which the contact is from to include.

Postal From/To. Enter the Postal From and To when the need to narrow down the report results occurs for the contacts location.

Min Rmnts. Enter the minimum number of room nights a contact needs to have produced to qualify to be included in the report.

Min Rev. Enter the minimum amount of revenue a contact needs to have produced to qualify to be included in the report.

Print Options. Select to print the report by:

• By Month - Prints grouped by only calendar month without any further split of the statistical data into property.
• By Property - Prints grouped by only property without any further split of the statistical data into calendar months.
• By Property By Month - Prints within each contact, the statistical data is grouped by property first and within each property by calendar month. See example below.
• By Month By Property - Prints within each contact, the statistical data is grouped by calendar month and within each calendar month the statistics are grouped by property. See example below.
• By Total Only - Prints only the total statistical data for all of the selected properties for the full production period for each contact without any further splitting. See example below.

Sort By. Sort the results of the report by:

• Alphabetical
• Room Nights (Displays Highest Producing Contact to the Lowest Producing Contact)
• Room Revenue (Displays Highest Producing Contact to the Lowest Producing Contact)
• F&B Revenue (Displays Highest Producing Contact to the Lowest Producing Contact)
• Total Revenue (Displays Highest Producing Contact to the Lowest Producing Contact)

Booked. Select the radio button to only consider the reservations where the contact is the actual Reservation Contact on record to include in the report. This will include reservations where the contact is the Staying Guest and the Reservation Contact. When the Booked radio button is selected, only the Booked line will be displayed in the report output as the Stayed line and Total line will NOT be displayed.

Note: Reservations where the contact is the Staying Guest and the Reservation Contact is a different profile will NOT be included here.

Stayed. Select the radio button to only consider the reservations where the contact is the Staying Guest. This will include where the contact is the Staying Guest and the Reservations Contact. When the Stayed radio button is selected, only the Stayed line will be displayed in the report output as the Booked line and Total line will NOT be displayed.

Note: Reservations where the contact is the Reservations Contact and the Staying Guest is a different profile will NOT be included here.

Both. Select the radio button to consider both the reservations where the contact is the Reservation Contact and the Staying Guest. Reservations where the appropriate contact is both, reservation contact and staying guest, will be included only once, in the STAYED line. When the Both radio button is selected, the Booked line, Stayed line, and the Total line will be displayed in the report.

Page Break after each Contact. Use this option to insert a page break with the start of a new Contact.

Include Legacy/Manual Statistics. Select this check box to generate this report including any revenues that were migrated from a Legacy System or that were manually added.

Net. Select the radio button to generate the report in the net revenue for the contact.

Gross. Select the radio button to generate the report in the gross revenue for the contact.

Copies. Determines the number of copies of the report that will print when the Print button is selected.

Currency. Available when the Rates>Multi Currency application parameter is set to Y, select the currency in which the revenues will be displayed in on the report.

Button Functions

Preview. Use the preview option to view the generated output of this report in PDF format.

Print. Use the Print button to print the report to the selected output.

File. Prints the generated report output to an *.rtf file.

Close. Closes this report screen.

Report Output

Based on if the SFA>USE RESERVATION_STAT_DAILY FOR STATISTICS application parameter is set to Y or N for the property running the report, will determine where the statistical data is collected from that is displayed in the report. When the application parameter is set to Y for the property running the report, then the calculation of the data will be calculated from the RESERVATION_STAT_DAILY data table. But if the application parameter is set to N for the property running the report, then the calculation for the data is calculated from the STAY_RECORDS and STAY_PROFILES data tables.

Contact Production Report with Total Only Print Option Selected Example

Contact Production Report with By Property By Month Print Option Selected Example

Contact Production Report with By Month by Property Print Option Selected Example