Publishers should be able to see the per-industry sales goals for their tier.
-
If the publisher has more than one magazine, a magazine selection will be displayed to allow them to switch between magazines.
-
Sales Funnel Summary will display counts for each of the active account types (statuses)
-
The goal will be displayed beneath the count.
-
The counts will be color-coded as follows: 1. If the count is under 50% of the Account Type goal it will be red. 2. If the count is greater than 50% of the goal and less than the goal it will be colored orange. 3. If the count is greater than the goal and less than the max it will be green. 4. If the count is greater than the max, it will be red.
-
Below the Sales Funnel count, the number of accounts missing a primary contact will be displayed.
-
Below the Out for Signature, the monthly revenue of the contracts that are out for signature will be displayed.
-
The Up for Renewal number will always be colored black.
-
For each sales goal, display the following data:
-
Name of the category
-
Sales Goal
-
Current Sales
-
A bar will be displayed displaying their progress towards the goal.
-
It will be filled in proportion to their sales vs the goal
-
It will be color-coded to indicate 1. No sales: Gray bar 2. Some sales: Yellow bar 3. Goal met: Green bar, green check mark
-
The goals should be sorted by the amount needed to reach the goal, the highest first.
-
Clicking the bar or name of the business category will open the Sales Funnel with that business category selected.
-
Clicking a business name should open the Account details.
-
Agreements, terms, months left, and rev/mo will be displayed
-
Agreements: Name of the account
-
Terms: Minimum Agreement term (12 MO., 36 MO., etc.)
-
Months left: Number of full months remaining based on agreement term 1. A red circle will be shown around the number if <=2 2. The number will reflect the number of issues remaining on their contract from the current issue. If the current sales issue is May 2022 (i.e. it is between April ), and the contract’s last month is July 2022, then it should say 3.
-
Rev/Mo: total revenue/ # of months in the contract
-
There will be a summary pod labeled “Other” that will display all accounts with contracts not specifically matched by one of the industry pods. The Account must match both the Industry and Sub Category to show in the Book of Business Industry pod. Otherwise, it will show in the Other pod
-
The total monthly revenue shall be displayed
-
The same columns as the other industry pods will be shown