Open topic with navigation
Marketing Sales Analysis
Make the following selections from the menu to display
this page:
Reports—Retail Reports—Marketing Sales Analysis
The Marketing Sales Analysis Report
shows sales amounts in relation to a tenant's rent for commercial
properties (property type 6-Standard Commercial).
Tenants are sorted by sales category and suite number. In addition to
the property total, a total by sales category is also provided.
Selection Criteria
Select Properties
Click to select properties from the Select
Properties tab. The report runs for all selected properties.
Include Previous Tenant
Click the check box to include previous tenants
on the report. (The label for this field may differ based on field names
assigned.)
Ranking Groups
If ranking groups are used, the report calls for
which ranking groups to include. Make your selections from the grid.
Ranking
The ranking group code.
Ranking Group
The description of the ranking group.
Ranking Period
The period in which the group was last ranked.
Selected?
Click the box to select a single ranking group.
Or, click the header to select all ranking groups at once.
Report Details
Note
This topic provides report details for
commercial properties only; that is, properties with the property type
set to 6-Standard Commercial.
Suite
The building + suite number. For instance, 0001-101.
Name
The tenant's name or business name. For instance,
Susan Smith or Smith Shoes.
Monthly Rent
The monthly rent amount. The sum of all charges
for the month.
Square Footage
Property default square footage for this suite.
Percent of GLA
System-calculated amount.
Calculation: Tenant property default square footage from the suite file
/ the total property default square footage of the property / ranking
group X 100
Sales MM-YYYY
Sales amount reported in month equal to the as
of date.
Sales MM-YYYY
Sales amount reported in month equal to the as
of date.
% Diff
System-calculated amount.
Calculation: (Total sales amount reported in the as of month - total sales
amount reported 12 months prior to the month the report is being run as
of) divided by the total sales amount reported 12 months prior to the
month the report is being run as of.
Rent Sales
System-calculated amount.
Calculation: Monthly rent / Current month's sales X 100
% of Sales
System-calculated amount.
Calculation: Tenant's current month sales / the property or ranking group's
current month sales X 100
Sales Eff Ratio
System-calculated amount.
Calculation: Percent of Sales / Percent of GLA
YTD Sales YYYY
Sum of tenant's sales for each of the months in
the prior year, up to the month that is equal to the month the report
is being run as of.
YTD Sales YYYY
Sum of tenant's sales for each of the month in
the current year, up to the month that is equal to the month the report
is being run as of.
YTD % Diff
System-calculated amount.
Calculation: Tenant's YTD sales / the property or ranking group's YTD sales
X 100
YTD Rent/Sales
System-calculated amount.
Calculation: Tenant's monthly rent amount X number of months that have
elapsed in the year for which the report is being run as of / the YTD
sales for the current year.
YTD % of Sales
System-calculated amount.
Calculation: Tenant's YTD sales for current year / the property or ranking
group's YTD sales for current year X 100
YTD Sales Eff Ration
System-calculated amount.
Calculation: YTD percent of Sales / Percent of GLA
To Display the Marketing Sales Analysis
- From the eSite menu,
select Reports—Retail
Reports—Marketing
Sales Analysis.
- Click Select
Properties. Select the properties for which you want to print the
report and click Done.
- If you want to include
previous tenants on the report, check the Include Previous
Tenants check box.
- Select the information
you want to see on the report (refer to the Selection Criteria for this
report).
- Select a Report
Format option: Acrobat
Reader (default), Crystal Viewer, Excel.
- Click Display. If you selected the printing option, Excel,
you are prompted to open or save the report Excel file. Otherwise, the
report opens in your preferred format.
See Also
Retail
Reports Overview
Reports
Overview
Report Printing Options
Select Properties