Transcript View - Ritel Systems AirTnB

is pleased to offer you
the adMinistrator Family of
Traffic & Billing software
your needs / our solutions
AirTnB
Your needs
our solutions
Client Needs
•
•
•
•
•
•
•
Design based on a simple viewable system
Menu Driven.
Minimal Screens.
Data Entry Workflow.
Affordable Price!
Scalability – Single User to Multi User Support.
Support – Keeping your system running.
Our Solution
• AirTnB - Software system
• Graphic Interface – Microsoft Windows.
• Menu Driven, Mouse Active.
• Pervasive SQL v11
• Single Workstation or
• Workgroup for 5 users or
• Client Server installation - 100 users
• Workflow – Data in, traffic, getting paid
• User Interface – same in every screen.
AirTnB
 Traffic & Billing Software Package, Sales Module Option
 Designed to be a productive tool for cable systems ,
broadcasters, and IPTV involved in commercial insertion
 Includes many "time-savers": program, product, priority, and
transaction codes to eliminate repetitious typing
 Provides an automatic commercial scheduler.
 Organizes and catalogs your Spot, Shows, or Longform library
 Organizes contractual, customer, and network information
into one database
 Creation of a Region by combining Zones
AirTnB
 Trafficking
 AutoScheduler® - Schedule from now into the future as long as it is a valid date.
 AutoFill® - fill the empty slots in the break schedule with spots that have been entered
as AutoFill Spots
 MakeGood – Find failed spots and schedule a replacement.
 Reconcilation Process – Check scheduled against AS RUNS
 Prebill Process – Prepare Spot List for Invoicing.
 Reporting




Our Software comes with over 125 reports using Crystal Report Writer.
Financial Reports are offered in Excel Format
Flexibility to add additional reports to satisfy customer’s needs
Custom reports can be provided based on your needs:
•
•
•
•
Standard status reports
Sales data reports
AS Run, Scheduled Spots, Invoices, Affidavits, and Statements
Customer invoicing to paper or EDI files
AirTnB
 Media
 Client Spot Information – Filename, Description, Length, ISIC Code
 Client Copy Information – Spot or Spots assigned for this copy
 Client Shows Information – LongForm Programs
 Invoicing
 Internal invoicing module:





Create paper Invoice
Create Electronic Invoice .
Export Function in CSV format
Export Function to QuickBooks
Custom Interface to an external accounting software
 Prepare for End of Month Billing process via items in Trafficking.
 Internal invoicing system ensures the client is invoiced for spots that ran
 Creates invoice’s statements and affidavits by Contract.
AirTnB
 Interface standards




CCMS Style Interface for schedules and verification
Custom Interface for unique hardware vendors
FTP Interface for Harmonic equipment for schedules and verification
FTP and Telnet Interface for ADtec Soloist HD for multi-segment long form scheduling
and control of Kramer A/V routing switch.
 Interface to various Broadcast Automation Systems – may require Specific Hardware.
 Nielsen Automation




Unique ID embedded in each MPEG file.
Real time monitoring of each network.
FTP Interface to pull the log files for each network from Nielsen.
Reconciliation of Nielsen log files to Traffic files by Zone, Date, Network, and Time
Features
 Menu driven software package .
 System access secured through password protection: users with valid
accounts and passwords. Authorization is down to the module level.
 Online PDF help system.
 Data-entry: dropdowns and easy-to-follow Graphic design.
 Unlimited Copy/Spot library for each Client.
 Network Bundles.
 Manual and automatic spots verification.
 Automatic “make goods” functionality.
 Automatic Prebill Process.
Features
 Pervasive SQL V11 Database – Low Cost, Long History, Unique Tables and
large capacity of file size.
 Customer driven software design
 A Region, ‘Soft Interconnect’ Support, sometimes called ‘RoadBlock’
 Interface to adSails—AE Workflow to create and track orders is provided
via the adSails Connector – a module designed and build to inport sales
orders from adSails including NCC agency orders.
Tools
 The AutoScheduler®, one of the powerful features and productivity tool
that selectively gathers contractual, media, zone, and network information
from the database and uses it to automatically prepare commercial
schedules
 Prepares schedules consisting of Video inputs, Multi-Segment Shows, and Commercial
Insertion
 Time saving benefit: reduces cost associated with contract review, contract
management, and trafficking
 AutoFill®: completes all breaks in schedule by filling with specified spots
 adSails Connector – share orders to our software and shares reconciliation
information back to adSails.
Workflow
Traffic files
Our Client
Data Entry
AirTnB
adSails
Data Entry
Import
adSails data
Reconciliation
Files
Adtec
Digital
Server HW
Spots/Shows/
Video air
User Interface
• Menu Driven software package designed to be a productive tool to aid cable
systems and broadcasters involved in commercial insertion.
• Data-entry uses dropdowns and easy to follow WINDOW design
• Online PDF help system.
• Password protection assures that only users with valid accounts and
passwords may enter the system. Authorization is down to the module level.
• Unlimited Copy/Spot library for each CLIENT
• Internal invoicing module with an interface to external accounting software.
• Unlimited reports based on Crystal Report Writer. Standard status reports,
sales data reports, affidavits, and customer invoicing.
User Interface
•
Unlimited reports based on Crystal Report Writer and Excel. Standard status
reports, sales data reports, affidavits, and customer invoicing.
•
AutoScheduler®, Schedules created automatically from contract information
and completes all breaks by filling with specified spots, AutoFill®.
•
Pervasive SQL V11 Database - unlimited file size.
•
Customer driven software design.
•
Soft Interconnect Support
•
Network Bundles
•
Interface to adSails—AE Workflow to create and track orders.
Main Screen
• The Main Screen of the AirTnB displays the Menu Bar and
your main work screen.
•
•
•
•
•
•
•
•
Client Search
Client Contract Search.
Client Contract Line Search
Client List Tree
Client Detail
Contract Header or Contract Line Detail
List of Lines for the selected Contract
Copy Media – Change Copy
Main Screen
Client Search - Client Tree - Client Detail
Contract Search
Line Search
Contract Header
Line Detail
Main Screen – Line Detail
Client Search - Client Tree - Client Detail
Contract Search
Line Search
Line Detail
Line List
Main Screen- Reports
Setup Screen - Company
Setup Screen – Master Network
Setup Screen – Network at Zone
Setup Screen - List
Setup Screen - User
Setup Screen Zone List
Setup Screen Zone List Report
Setup Screen Sales Person
Setup Screen – Region Setup
Setup Screen – Region Networks
Setup Screen Revenue
Setup Screen Bundles
Media Screen - Spots
Media Screen - Copy
Media Screen - Reports
Media Screen - Shows
Traffic Screen - Menu
Traffic Screen - AutoSchedule
Traffic Screen – View Log
Traffic Screen - Verification
Traffic Screen – Make Good
•
•
•
•
•
Select Begin Date
Select End Date
Select type of Make Good
Select ‘One Zone’ or ‘My Zones’ or ‘All Zones’
Click on ‘Collect’
Traffic Screen – Make Good
•
•
•
•
The process collects all of your ‘FAILS’ and displays them on the screen.
You have a choice of printing them by clicking on ‘Print’
Click on ‘Make Good All’ for the make good process to run.
Included in this process is the updating of the traffic files for this date range.
Traffic Screen – Create BillWho
On the Traffic Screen click on ‘BillWho Report’
•
•
•
•
Select the Month and Year to Create the Report.
Select ‘Create Report’
Click on down arrow beside ‘Report’
Click on ‘Create Report’
Traffic Screen – View BillWho
• Select the Month and Year to view the
report
• Select type of report
• ‘Print By Zone’ or ‘Print By Client’
• Select a single ‘Zone’ or ‘My Zones’ or
‘All Zones’ for the report.
• Click on down arrow beside ‘Report’
• Click on Print Report.
Traffic Screen – BillWho Report
Accounting
The functions of the accounting module are displayed in the menu on the screen.
As shown in the following slides there are other options on each menu.
The pre-bill screen will show you each day what spots ran for the client, the times, networks
and rates line by line. It’s this screen you will use to compare the Contract Client
Confirmation Report.
Accounting
You can create an invoice or view an existing one, statements with aging or without.
Accounting
The reports in this module
continue to be added to,
different clients want to see the
data a different way and we
continue putting them on the
menu.
Accounting - Aging
Accounting – Payments
Reports
Our reporting system is based on a standard, Crystal Reports. We have over 125 reports using Crystal, 10 new reports
are provided as part of our package. We have reports that go directly into Excel so you can work the data the way you
want. I have a PDF file with a listing of reports.
1400 Leitersburg Road
Waynesboro, PA 17268 USA
Office 717-597-0771
SKYPE RTS_PHONE
[email protected]
Thank you, Don Rice