
Filter | Definition |
Date Type |
|
Fiscal Week (only shows during manual run when utilizing User Selected Date Type) | This will set the below Fiscal Week and Date Range to the first available date range within the year selected |
Date Range | The start date of the media schedule |
Time Range | The start time of the media schedule |
Report Layout | 3-layer filter to display report data (see Grouping below) |
Expand |
|
Format (only shows when setting up a schedule) | This is the format that the report will export in: PDF Excel CSV |
The client of the campaign of the ad copy the media schedule belongs to | |
Show Inactive (Client) | Show in the report: Checked - show active and inactive Clients Unchecked - only show active Clients |
The campaign of the ad copy the media schedule belongs to | |
Show Inactive (Campaign) | Show in the report: Checked - show active and inactive Campaigns Unchecked - only show active Campaigns |
| Media Type | The media type of the ad copy the media schedule belongs to |
| Station | The station of the media schedule |
| Show Inactive (Station) | Show in the report: Checked - show active and inactive Station Unchecked - only show active Station |
| Ad Copy | The ad copy the media schedule belongs to |
The ad type of the ad copy the media schedule belongs to | |
| Show Inactive (Ad Type) | Show in the report: Checked - show active and inactive Ad Type Unchecked - only show active Ad Type |
| |
The media format of the media schedule | |
Show Inactive (Media Format) | Show in the report: Checked - show active and inactive Media Format Unchecked - only show active Media Format |
Grouping | Definition |
The ad copy the media schedule belongs to | |
The ad type of the ad copy the media schedule belongs to | |
The campaign of the ad copy the media schedule belongs to | |
The date of the media schedule start date | |
| Day of Week | The day of week of the media schedule start date |
The media format of the media schedule | |
The media type of the ad copy the media schedule belongs to | |
The hour of the media schedule start time | |
The half hour of the media schedule start time | |
The station of the media schedule | |
Column | Definition |
# IN | (Calls Per K (from Ad Copy or Media/Ad Type relationship if no Ad Copy Calls Per K is defined) * Spend Amt (from Media Schedule)) / 1000 |
# ANS | # IN * Calls Ans Rate (from Campaign Performance Metrics) |
# SHORT | # IN * Calls Short Rate (from Campaign Performance Metrics) |
# DROPPED | # IN * Calls Dropped Rate (from Campaign Performance Metrics) |
AVG TALK TIME | Avg Talk Time (from Ad Copy or Media/Ad Type relationship if no Ad Copy Avg Talk Time is defined) |
TOT TALK TIME | AVG TALK TIME * # IN |
# AGENTS NEEDED | (# ANS * AVG TALK TIME) / (Efficiency Rate (from Campaign Performance Metrics) * 60) |
# ORDS | # ANS * Order Close Rate (from Campaign Performance Metrics) |
# XSELL | # ORDS * Xsell Rate (from Campaign Performance Metrics) |
# UPSELL | # ORDS * Upsell Rate (from Campaign Performance Metrics) |
# ADDON | # ORDS * Addon Rate (from Campaign Performance Metrics) |
# RUSH | # ORDS * Rush Rate (from Campaign Performance Metrics) |
# AUTO/CTY | # ORDS * Continuity Rate (from Campaign Performance Metrics) |
TOT REV | Rev Per Order (from Campaign Performance Metrics) * # ORDS |
AVG TICKET | TOT REV / # ORDS (should = Rev Per Order from Campaign Performance Metrics) |
REV PER CALL | TOT REV / # IN |