Monarch - Revenue Summary Report Overview

The Revenue Summary Report provides a way for you to see how you, your team, or your entire enterprise are offsetting Lost dollars with New and Returning business to continue growing.

To create the Revenue Summary Report, please follow the below instructions:

1. Please navigate to Reports on the menu bar.
2. Click the Revenue tab.
3. Click the Revenue Summary Report link.

On the Options screen, you will be presented with the below options to build your report.

1. Hierarchy Selection - in this drop-down you may select the attribute(s) that are to be on the report.
2. Calendar Selection - in this drop-down you may select what calendar type the report will utilize.
3. For Time Frame Selection - in this drop-down you may pick the time frame for the results of the report.
4. Roll-Up Results By Selection - in this drop-down you may select the way that the results are reported in a lump sum or by month.
5. Run Button - once all options have been selected, clicking the Run button will run the report.

Clicking the Filters tab will allow you to select or not select various data points or groups within the report.

Once the report is run, the screen will display the report based on the Options and Filters selected. A view like the one below will appear.

1. Show Option-clicking this button will show the Options and Filters dialog to edit the report and allow you to re-run the report.
2. Hide Chart - clicking this button will remove the chart from the view.
3. Chart Field - the report will display a line chart showing the trending over the time frame that was selected.
4. Favorite Icon - clicking the Star icon will allow you to save the report as a favorite. Once saved as a favorite, the report can be shared with other users.
5. Download - in the drop-down a user can select to export the data in either a .csv format or Microsoft Excel format. Clicking the icon next to the drop-down will download the report in the selected format.
6. Report Data - the table at the bottom of the screen is the data from the report. The Revenue Summary Report is formatted so that the hierarchy is on the far left, followed by columns for:
   1. $ Lost - Booked dollars that we're spending with you 1 year before the time frame selected but are no longer spending on the same Outlet(s) in the time frame selected.
   2. Billed LY - The number of dollars booked 1 year before the time frame selected.
   3. LY $ Returning - Booked dollars that were spent with you 2 years before the time frame selected and are also spent with you again 1 year before the time frame selected on the same Outlet(s).
   4. Billed TY - The amount of dollars booked for the time frame selected.
   5. TY $ Returning - Booked dollars that were spent with you 1 year before the time frame selected and are also spent with you again during the time frame selected on the same Outlet(s).
   6. $ Var Returning - Calculation of ((TY $ Returning) – (LY $ Returning)).
   7. %$ Var Returning - Calculation of ((TY $ Returning) / (LY $ Returning)-1).
   8. $ New by Definition - Booked dollars that are new to the period based upon the Matrix New Business Definition.
   9. %$ New by Definition - Calculation of (($ New by Definition) / (Billed TY)).
   10. $ Brand New - Booked dollars that have never been spent with you before on any Outlet.
   11. %$ Brand New - Calculation of (($ Brand New) / (Billed TY)).
   12. $ New to Period - Booked dollars that are new to the selected time frame, but may have been spent with you in other periods before.
   13. %$ New to Period - Calculation of (($ New to Period) / (Billed TY)).