This article was produced by the Ministry of Business, Innovation and Employment (MBIE). The content you find below is exclusive to the Tourism Evidence and Insights Centre.
Monthly Regional Tourism Estimates (MRTE) data is uploaded to the MBIE website every month. Due to the way the database is structured, year-end data is given only for the latest month. This document instructs users how to calculate MRTE year-end for any historic month, from the available data.
The data download section of the MRTEs website contains nine excel spreadsheets. These spreadsheets include all monthly level data back to April 2008 and can be broken down by region, Regional Tourism Organisations (RTO), country, domestic origin and product type. Territorial Authority (TA) level data can only be found at the annual level.
The first spreadsheet provides a summary of the latest month/year-ended figures. The following four spreadsheets provide regional level data and the remaining four provide RTO level data. Below you have links to each one of these files:
Using the data supplied in the data download section, we can calculate any monthly or year-end spend figures. Year-end spend figures for the current month can be found in the annual spreadsheets above. These files only contain year-end figures for one month as, due to accuracy and confidentiality reasons, we only release TA level data at the annual level.
We can calculate year-end figures for all other months by following the five steps below. For example, if we want to calculate the year-ended March 2019 spend figure for the Auckland region, we would:
This method can be applied to any combination of variables e.g. for accommodation spend totals, the product selection at the top will have to be changed to ‘accommodation’.
To find growth in spend from one year to the next, we compare the year-end spend figure, and the same spend figure for the year before.