SQARE© Methodology for SQAD Spot Radio
Updated March 2007
This document provides an overview of SQAD's proprietary
spot radio methodology and the SQAD Advertising Rate
Evaluator (SQARE). The SQARE model was developed for
the purposes of analyzing and integrating the various
types and sources of radio cost information received
monthly, and for producing CPP estimates based on this
information. Subscribers can obtain the complete methodological document by calling 914.524.7600.
I. SQARE Objectives
The ultimate objectives of the model are to produce
realistic "street price" CPP estimates for:
A. 5 quarters: the current quarter and the next 4
projected quarters
B. 3 levels: Average, Low and High
C. All markets measured by Arbitron Radio (MSAs -
Metro Survey Areas)
D. 26 demographics (see Table I)
E. 7 dayparts (see Table II)
F. Arbitron-based buys
These estimates must be updated monthly based on the
latest cost information available.
II. Sources of Cost Information
The SQARE model uses real media cost data supplied to
SQAD by contributing advertising agencies and media
services on a monthly basis, along with historical SQAD
data.
III. Methodology Overview
Taking the real media cost data, SQARE performs its
calculations for three levels (average, low and high)
of cost-per-point (CPP - target demographics listed
in Table I) estimates by market, by daypart for five
quarters. The monthly data is edited, then analyzed
for every SQAD market, target, and daypart. Once all
of the input is combined, a CPP estimate is derived
by dividing the total dollars by the total GRPs for
the market/daypart in question.
The data then is quality-checked by all dayparts, creating
a matrix of contributor data for every market and every
daypart for the current quarter, and is then checked
with a separate matrix which uses previous SQAD data.
The 2 matrices are then weight-averaged together to
produce the final radio Adult 25-54 CPP for the current
quarter, this proprietary weight-average methodology
provides cost estimates that move in the appropriate
direction, and that our subscribers can use with confidence.
Table I - SQAD Demographics
| |
Men 12-24 |
Women 12-24 |
Persons 12-24 |
| Adults 18+ |
Men 18+ |
Women 18+ |
Persons 12-34 |
| Adults 18-24 |
Men 18-24 |
Women 18-24 |
|
| Adults 18-34 |
Men 18-34 |
Women 18-34 |
|
| Adults 18-49 |
Men 18-49 |
Women 18-49 |
|
| Adults 25-49 |
Men 25-49 |
Women 25-49 |
|
| Adults 35-54 |
Men 25-54 |
Women 25-54 |
|
| Adults 35-65 |
Men 35-64 |
Women 35-64 |
|
Table II - SQAD Dayparts
| Morning Drive |
Monday-Friday 6-10 AM |
| Daytime (mid-day) |
Monday-Friday 10AM-3PM |
| Afternoon Drive |
Monday-Friday 3-7PM |
| Evening |
Monday-Friday 7PM-Midnight |
| Average (4 Dayparts) |
Monday-Friday 6AM-Midnight |
| Average |
Monday-Friday 6AM-Midnight |
© SQAD Inc. 1994-2007
|