If you want the numbers in Manager Analytics to reflect data from previous years, you can use the historical import feature. It allows you to upload daily revenue and occupancy info (sorted by space type and business segment).

Note: You can't import detailed customer and reservation information, just property revenue and occupancy.

Step 1: Get data from your old PMS

You need to get the data that you'll add to the import file. You can import data from the current year and two prior (for example, current=2020, so we can upload from 2018).

  • Run a report in your old PMS to find daily occupancy and revenue info for each space type (within the date range you want to import).
  • If you want specific information on business segments, run the report for each business segment within each space category (for example, if you have 2 segments and 3 space categories, you'll need to run the report 6 times).

Note: Make sure the report includes a daily breakdown of occupancy and revenue information; if you can't see the data for each day, you won't be able to import it.

Step 2: Download the template

  1. Make sure you're in the property in Mews that you want to import historical data to (and not another property in your chain).
  2. Go to Main menu > Analytics > Manager analytics.
  3. Click the Analytics import icon in the top-right.
  4. From the Statistics tab, click the Download empty template icon in the top-right.
  5. Once the download is complete, open the Excel file.

Step 3: Fill in the template

How does it work?

Each row in the spreadsheet holds the statistics for one date/business segment/space type combination. This means that:

  • If you want to import one year of historical information for 3 space types, you'll need (365*3) rows. You'll have a row for each day of the year, for each space type.
  • If you want to import one year of historical information for 3 space types and 2 business segments, you'll need (2*3*365) rows. You'll have a row for each day of the year, for each space type/segment combination.

What do the fields mean?

In the first four columns, specify which date, segment, and space type the statistics are for.

  • Date: Enter the date that you're providing statistics for, in one of the following formats: "dd/mm/yyyy", "d/m/yyyy" or "yyyy/mm/dd".
  • Service (not required): Leave this blank.
  • Business segment (optional): Specify the business segment you're providing statistics for (enter its Name or Short name).
  • Space type: Specify which space type you're providing statistics for.

In the following columns, add the data you want to import for the selected date, segment, and space type.

  • Available spaces: Enter the number of spaces that were available.
  • Occupied spaces: Enter the number of spaces that were occupied.
  • Space revenue: Enter the revenue (in your default currency) generated by night stays.
  • Product revenue: Enter the revenue (in your default currency) generated by products.
  • Additional revenue: Enter the revenue (in your default currency) generated from sources other than stays or products.

Step 4: Upload the template

  1. Make sure you're in the property in Mews that you want to import historical data to (and not another property in your chain).
  2. Go to Main menu > Analytics > Manager analytics.
  3. Click the Analytics import icon in the top-right.
  4. From the Statistics tab, click Choose file, then find the completed template.
  5. Click Import.
Did this answer your question?