Modified: 2018/06/06 10:59 by EricCrocker - Uncategorized

Edit

Reports

back

Reports allow you to access your data in multiple ways to track Station performance. You may or may not be able to access all reports depending on the level of package you have purchased from RadioTraffic. If you see a report that is not available in your current package, contact our sales team to discuss how you can upgrade your account to access those reports.

Edit

Concepts

We strive to create a consistent user experience throughout the reports so that you only have to learn how to use features once and be able to apply them to every report. The following concepts are in effect across all of the reports.

Edit

Speed

We strive to reach a goal where each and every report is fast. When designing our reports, this goal is kept at the top of the list and is only deviated from when absolutely necessary.

Edit

WYSIWYG

All of our reports are designed keeping the What You See Is What You Get (WYSIWYG) concept at the forefront. Rather than have you enter some information in a dialog and press "run report," we present you with a report immediately. You can then modify the criteria and have these changes (in most cases) become effective immediately. (Under some circumstances, you need to click on the "Click here to reload the report..." at the top of the report to reflect changes that could be initiated via several potentially conflicting changes.)

Edit

Favorites

Under the View Tab in the Main Menu is the Favorites tab:



With this tab, you can make your own list of favorites. You can go back and forth between your favorites reports page and the regular report page by clicking on the favorites tab.

• To add a report, right click on the report, open up the context menu and left click to add a report to favorites.

• To remove a report from your favorites page, right click on the report, open up the context menu and left click to remove the report from favorites.

The reports you move are still on the main page and this list is per computer.


Edit

MyViews

MyViews allows you to add/remove columns, group by columns, rearrange columns, change the sorting of visible columns (one or more) and filter the information through an easy to use interface.

For more information, review the MyViews documentation.


Edit

Auto Summarization

This feature is extremely powerful and exists across the majority of the reports. Automatic summarization is the process in which the report will automatically recalculate any summed columns based on the non-summed columns that are part of the report. This allows for a wide variety of summary reports that can be generated from a relatively small number of base reports; furthermore, it would be a near impossibility for us to anticipate every possible variation, yet this feature goes a long way to deliver on those. Click here to see this in action.

Edit

Common UI

Edit

Main Menu

• File
  
  • Print
    Prints the report as currently viewed.
  • Print Preview
    Print previews the report as currently viewed.
  • Close
    Closes the window.
• View
  
  • Refresh
    Refreshes the data for the report.
  • Reset
    Resets the layout of the report back to "factory original".
• Options ★
  
  • Insert Page Breaks ★
    When printing, it is possible to automatically insert a page break (new page) for every primary group of the report.

★ Feature not available in Essentials.

Edit

Simple Filters

The left-hand pane of the report hosts several tabbed items. These are referred to as the Simple Filters; for the Advanced Filters, refer to the MyViews documentation.



These tabs usually include Revenue, Sales People, Customers and Stations (see below). These tabs will be available any time the related items are part of the report being executed. On each of these tabs includes a complete list of the related entities. A check mark on each item (the default) allows those items to be included in the report while removing the check mark will filter that item out of the report.

Each list of items allows the usage of the context menu (available by right clicking using the mouse) which includes shortcuts for checking/unchecking the items in bulk.

These simple filters are reset every time you execute (open) the report.

Filter Tabs

• Revenue
  • Revenue Type
    The RevenueType section contains all of the RevenueTypes currently configured.
  • Revenue Source
    The RevenueSource section contains all of the RevenueSources currently configured.
• Sales People
  The Salespeople list contains all the Salespeople who are currently active. Additionally, an entry for None is included to handle circumstances where appropriate.
• Customers
  The Customer filter contains all of the Customers that are active.
• Stations
  The Stations filter contains all of the Stations configured in your database. Additionally, a Station of None is included to handle circumstances where the Station is blank or missing.

Given the number of tabs that could potentially exist, it is likely that not all of the tabs can be displayed at the same time. To accommodate this, you will see two "arrows" to the right-side portion of the tabs that are currently visible. If these are available, this is a hint that there are additional tabs and you can use the left and right "arrows" to "scroll" the list of tabs into view to find/utilize the particular filter that you are interested.

If you right-click on any of these filters, the context menu associated provides several tools to quickly select (or not) the items you wish. All lists contain the following tools:

• Check all
  Places a check mark next to all entries.
• Uncheck all
  Removes the check mark next to all entries.
• Toggle all
  Toggles the check mark next to all entries; those that are checked will now be unchecked and those that were unchecked will now be checked.

The RevenueType list includes an "Uncheck Trade" tool that can be used to filter out all RevenueTypes that are flagged as being Trade. See RevenueType.

Edit

Column Headers

In order to provide the greatest amount of flexibility in the columns available balanced with minimizing the printed size (width) of the column, several columns are using a shorthand notation:

• G - Gross.
• N - Net.
• E - Effective.
• U - Units (spots).
• X - Canceled/Trashed.
• # - Count.
• $ - Amount (money).

The gross (G) number represents the gross number as entered on the Contract before any cancelations.

The net (N) numbers represent the net amount as entered on the Contract before any cancelations.

The canceled/trashed (X) numbers correspond to the activity on a Contract where either spots were canceled/trashed (ie. MakeGoods) and/or the overall Contract was canceled/trashed.

The effective (E) numbers represent the result of the gross (G) or net (N) number minus the canceled/trashed (X) number. In other words, the overall current state of the Contract and what will be the result assuming no further additions/cancelations.

Edit

Index

Edit

A/R

• Aged Receipts/Adjustment ★
• Billing History
• Broadcast Accrual
• Payment History
• Reconciliation
• Unapplied Prepayment

Edit

Administrative

• User Usage ★

Edit

Aging

• Aging
• Aging (by Month)

Edit

Clients

• Agency
• Customer

Edit

Contracts

• Contract
• Invalid Contract/Rotation/Copy
• Make Good
• Spot Rate
• Copy
• CopyAttachment
• RescheduledSpots

Edit

Inventory

• Inventory (CALLS)

Edit

Log

• After Aired
• Bump ★
• Log
• Log Time
• Off Air Revenue

Edit

Sales

• Annual Sales Review
• Commission
• Pacing ★
• Revenue Projection
• Revenue Projection (12 Month Gross)
• Revenue Projection (12 Month Net)
• YearlySalesReview

Edit

Transactions

• Adjustment
• Aged Collections
• Invoice
• Payment
• Projection Vs Actual (Discrepancies) ★

★ Feature not available in Essentials.