Matrix for Media

Working with Projections - Customized Workflow

 To get started, click on the Projections link from the left navigation menu.


 

 

Navigation

  • You will immediately be presented with a view of the current quarter (by default) as well as the option to change to the next 2 quarters.  This option is sticky so if you change it to Q4 and leave it there; then it will display Q4 on the next load of the page.
  • Standard paging (<<   <  >  >>) is included to ensure the load times are optimal and no user waits too long for Projections to return. You can interact with the paging controls above the headers in order to advance to the next, previous, last, and first page of Projections.

 

 

Breaking It Down

 

You will see each of your rows on this page broken out by Outlet, Office, Salesperson, Agency, and Account. Each corresponding column has the ability to be sorted along with a simple search allowing you to find a specific value. The search is a contains style search so that means if you're looking for the Account "20th Century Fox" then you could start typing "20th" or "Fox" and your result will appear in the list. Each of the values also acts as a link to the respective Profile page within Monarch for even more information.

 

Updating your Projections, Market Budget, and Share

Additionally, each row will contain the following fields. Some help you with information to complete your projections while others can accept values that you enter.

  • Booked - The amount of dollars currently within your billing system for the time frame in view.
    • Market Budget – A calculated amount based upon the Booked dollars and Share from your traffic/billing system. (Booked / Share%). 
    • Share – The Share provided from your traffic/billing system. 
  • Pending - The amount of dollars you still hope to receive as summed from Deals within Monarch for the time frame in view.
    • Market Budget – The amount that a buyer wishes to spend within a given market as provided by a proposal system or is manually entered as a deal in Monarch.
    • Share – The amount that a seller has capture, as a percentage, from the buyer’s Market Budget. This is optional, and, today we only receive this from an integration with a proposal system.
  • Forecast - The sum of Booked + Pending as a calculation. This shows your current efforts for the time frame in view and would be your final amount if you did not update pending dollars or import additional revenue.
  • Projection - The amount of dollars you feel you will realistically close out the time frame in view with. It is not dependent on existing deals or booked revenue. This field can be updated by you.
    • Market Budget - The amount of money that an Account has to spend in a single Market for the time frame in view. Note that by changing this for one row it will change other rows if they have Outlets in the same market. This field can be updated by you.
    • Share - The percentage of the Market Budget that you hope to achieve on a single Outlet. It is  typically based upon your share of viewers within a market. This field can be updated by you.


Historical References

Anytime that you click into a Projection, Market Budget, or Share field for editing you will be presented with some historical information over the previous year designed to help you see a trend and make decisions while updating the quarter in view.

  • It is likely that the Pending amount will equal $0 as you do not typically have historical pending, as Monarch attempts to zero out historical pending each month. This is not always the case as you may be entering a projection for a quarter months ahead of time so the historical rows may show a pending amount.
    • Market Budget and Share display for the pending value as historically captured
  • Booked and Forecast dollars will likely be the same due Forecast being a calculation (Booked + Pending). 
    • Market Budget and Share display for the Booked value as historically captured
  • Projection will be the value entered from projections in the previous time frame being viewed.
  • Market Budget will be the value entered from Market Budget in the previous time frame being viewed.
  • Share will be the value entered from Share in the previous time frame being viewed.

 

 

Did you find it helpful? Yes No