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