NOTE: This blog appears simultaneously on the
Avid Technology community website.
As I mentioned in a previous blog, my first exposure to
media planning and buying was when, due to my focus (minor) on computer science and information
systems at Georgia State University's Robinson School of Business, I was asked to research and purchase a turnkey computer
system for media planning and buying. My college internship had turned into a full-time agency
job and this was one of my first assignments. I ended up purchasing a $30,000 PC based media
planning system from Telmar®.
The system was primarily based on Lotus 123® macros using downloaded
ratings data. Learning the system motivated me to dig deeper into
Lotus® macros and dBase® programming...extensive experience that later
translated to Excel® (it is amazing how quickly Excel® replaced Lotus
123® as the industry standard).
I learned a great deal about media simply by
learning and using
the Telmar® system. I was also very fortunate to receive “on the job
training” via veteran agency media professionals who suffered from
computer phobia. With Telmar®, you could
instantly see how changes in spot selections affect the total cost and
the reach
and frequency of the buy, either for a single TV station or for all
media in the
buy. It was a great negotiating tool. You could instantly
compare CPPs and CPMs between the same daypart on different stations
while you have your station sales representative on
the phone. The media mix capability included additional media such as
radio, print and outdoor. In addition to Telmar®, I later used
Broadcast Management
Plus® and other software for media planning and buying. I also
developed my own spreadsheets and a dBase program for entering and
printing insertion orders.
In addition to turnkey media planning and buying software,
online research databases such as Dialog®, Nexis®, Lexis®, Dow Jones® and Dun &
Bradstreet® are useful for doing media research and preparing media
rationales. Other comprehensive tools are available through media
providers – television/radio stations, media representation firms (media reps) such as Katz®, spot cable reps such as NCC®, and major newspapers. Here is a quick overview of a few media resources, many of which can be accessed via media providers:
Scarborough®
Research:
Developed as a newspaper measurement tool,Scarborough® provides data on lifestyles, shopping patterns,
media behaviors and demographics at local, regional and national levels.
Founded in 1975, its services span 2,000 categories and brands which include
retail shopping, lifestyle characteristics, consumer demographics and media
usage patterns. You can have access to Scarborough via any major newspaper sales rep.
Experian® Simmons® – formerly Simmons Market Research
Bureau:
A leading provider of consumer behavior demographics
information, Simmons® provides detailed brand, service and media usage
information on over 8,000 brands and over 450 product categories. It provides
data for Microsoft® MapPoint® software which can map profiles of consumer data
by state and down to census tracts. Consumer usage of thousands of brands and
services can be profiled via Simmons BrandTract® from any of six levels of
geography – Total US, State, MSA, County, ZIP Code and Census Tract.
ESRI GIS® -- formerly CACI®:
This GIS and mapping software combines
demographic data and mapping software which can be used for market
analysis to determine which products and promotions can match the
lifestyles and buying patterns of potential customers in specific
geographic areas.
STRATA®:
STRATA® Marketing, Inc. develops premiere
software for media planning and buying. They offer Spot TV, Spot Radio,
Print, Outdoor, Local Cable, National Cable and Network TV Media Buying
and agency products which provide in-depth Pre-buy, Buy, Posting,
Reporting, media Billing and qualitative research capabilities. The
agency media buying system, STRATA View handles the entire media
planning and buying process from "A" to "Z." It includes multi-media
Reach and Frequency allowing every combination of TV, Radio and Print
Media -- Reach, Frequency, GRP's, CPP's and more.
TAPSCAN™:
TAPSCAN™ is a suite of software for local
market radio that is used extensively by radio station salespeople. It
provides access to customized demos, geographies, dayparts and
multibook averages. It includes qualitative (80 categories of Retail
Spending) as well as quantitative (Radings, CPP, CPM, etc.) data. You
can enter GRP targets for specific dayparts and demos and the system
will indicate the number of spots required to achieve them.
SRDS®:
Owned by Nielsen®, SRDS® (Standard Rate &
Data Service) is the leading provider of media rates and
data....offering comprehensive coverage of traditional media
(magazines, newspapers, television, direct marketing and radio) as well
as online and out of home. With 95% of advertising agencies served, it
is the largest and most comprehensive database of media rates in the
world. It provides an immediate, single source of rates for agency
media planners for all media.
SQAD®:
An acronym for Spot Quotations And Data,
Inc., SQAD® provides advertising agencies, media buying services,
broadcast and cable stations, etc., instant access to real cost CPMs
and CPPs by network and daypart, unit costs, CPMs and CPPs by program
category and time period. Cost data is based on actual transactions.