Audience Tables - Nielsen Format

The audience file to be imported is created using Microsoft Excel.

The file name must conform to 8.3 format naming convention eg "12345678.xls". Names that are longer will need to be shortened before importing. (Note: This is a Microsoft issue. SDS allows you to attach a longer, more descriptive name during the importing process, if you desire.)

Quick Tips

In the Microsoft Excel Spreadsheet, ensure that the worksheet name is “Sheet1”. Only data contained within Sheet 1 will be imported into SDS Saless.

Audience estimates and market ratings need only be entered for the demographics that you wish to use. If a demo is not required by sales, just omit it from the demos included in the spreadsheet.

Once the table has been created, press the CONTROL key and hit the END key. Ensure that this cell is the last column where data has been entered and that it is the last row where rating data has been entered. If there are blank rows or columns in the spreadsheet delete them (or cut and paste data into a new workbook and save) before attempting to import the audience table.

Always ensure that there are no blank lines in the audience table. Blank lines denote the end of the audience table to the system while importing the table.

Always ensure that the audience table name is eight characters or less. This can be extended during the importing process.

When complete, it will look something like the following:

The columns are defined as follows:

Field Name	Description	Data Type	Length (if text) or max value
1: "PROGRAM”	Name of Program	text	20 characters
2: "DAY"	Days on Air: in any of following forms**	text	7 characters
3: "START TIME"	Start time of Program	time, in any format	n/a
4: "END TIME"	End time of Program	time, in any format	n/a
5: "StartWeek"	The Monday date of the start week	date, in any format	n/a
6: "EndWeek"	The Monday date of the end week	date, in any format	n/a
7: “RATE”	30 second rate for this program	currency	$922,337,203,685,477.58
8: “Type”	The entries in this column are: FCA (full coverage audience) then followed by Rtg (Ratings) If multiple markets are used each is listed on its own line	text
9: “MKT ID”	Market Ids. If more than one market is applicable for a program list each of the markets directly under FCA. Enter the appropriate values from the Market ID list	integer

10: Demo (1 of your selection see below for the required demo names)	Audience in '000's on first line (this can include one decimal place) then followed by Ratings on the second and subsequent lines for each market	integer	32,767
11: Demo (1 of your selection see below for the required demo	Audience in '000's on first line (this can include one decimal place) then followed by Ratings on the second and subsequent lines for each market	integer	32,767
12: Demo (1 of your selection see below for the required demo	Audience in '000's on first line (this can include one decimal place) then followed by Ratings on the second and subsequent lines for each market	integer	32,767
13: Demo (1 of your selection see below for the required demo	Audience in '000's on first line (this can include one decimal place) then followed by Ratings on the second and subsequent lines for each market	integer	32,767
14: Demo (1 of your selection see below for the required demo	Audience in '000's on first line (this can include one decimal place) then followed by Ratings on the second and subsequent lines for each market	integer	32,767
15: Demo (1 of your selection see below for the required demo	Audience in '000's on first line (this can include one decimal place) then followed by Ratings on the second and subsequent lines for each market	integer	32,767
16: Demo (1 of your selection see below for the required demo	Audience in '000's on first line (this can include one decimal place) then followed by Ratings on the second and subsequent lines for each market	integer	32,767
17: Demo (1 of your selection see below for the required demo	Audience in '000's on first line (this can include one decimal place) then followed by Ratings on the second and subsequent lines for each market	integer	32,767
18: Demo (1 of your selection see below for the required demo	Audience in '000's on first line (this can include one decimal place) then followed by Ratings on the second and subsequent lines for each market	integer	32,767
19: Demo (1 of your selection see below for the required demo	Audience in '000's on first line (this can include one decimal place) then followed by Ratings on the second and subsequent lines for each market	integer	32,767
20: Demo (1 of your selection see below for the required demo	Audience in '000's on first line (this can include one decimal place) then followed by Ratings on the second and subsequent lines for each market	integer	32,767
21: Demo (1 of your selection see below for the required demo	Audience in '000's on first line (this can include one decimal place) then followed by Ratings on the second and subsequent lines for each market	integer	32,767
22: Demo (1 of your selection see below for the required demo	Audience in '000's on first line (this can include one decimal place) then followed by Ratings on the second and subsequent lines for each market	integer	32,767
23: Demo (1 of your selection see below for the required demo	Audience in '000's on first line (this can include one decimal place) then followed by Ratings on the second and subsequent lines for each market	integer	32,767

24: Demo (1 of your selection see below for the required demo	Audience in '000's on first line (this can include one decimal place) then followed by Ratings on the second and subsequent lines for each market	integer	32,767
25: Demo (1 of your selection see below for the required demo	Audience in '000's on first line (this can include one decimal place) then followed by Ratings on the second and subsequent lines for each market	integer	32,767
26: Demo (1 of your selection see below for the required demo	Audience in '000's on first line (this can include one decimal place) then followed by Ratings on the second and subsequent lines for each market	integer	32,767
27: Demo (1 of your selection see below for the required demo	Audience in '000's on first line (this can include one decimal place) then followed by Ratings on the second and subsequent lines for each market	integer	32,767
28: Demo (1 of your selection see below for the required demo	Audience in '000's on first line (this can include one decimal place) then followed by Ratings on the second and subsequent lines for each market	integer	32,767
29: Demo (1 of your selection see below for the required demo	Audience in '000's on first line (this can include one decimal place) then followed by Ratings on the second and subsequent lines for each market	integer	32,767
30: Demo (1 of your selection see below for the required demo	Audience in '000's on first line (this can include one decimal place) then followed by Ratings on the second and subsequent lines for each market	integer	32,767
31: Demo (1 of your selection see below for the required demo	Audience in '000's on first line (this can include one decimal place) then followed by Ratings on the second and subsequent lines for each market	integer	32,767
32: Demo (1 of your selection see below for the required demo	Audience in '000's on first line (this can include one decimal place) then followed by Ratings on the second and subsequent lines for each market	integer	32,767
33: Demo (1 of your selection see below for the required demo	Audience in '000's on first line (this can include one decimal place) then followed by Ratings on the second and subsequent lines for each market	integer	32,767
34: Demo (1 of your selection see below for the required demo	Audience in '000's on first line (this can include one decimal place) then followed by Ratings on the second and subsequent lines for each market	integer	32,767

For Columns 10-57, only include the demographics that are required by Sales. If a demo is not required, just leave it out.

For the Market Ids (holds up to 26 characters), consult the following table to obtain the market code:

The Markets available for Nielsen Media Advisor are:

Market ID	Market Name
1	Nfld./St John’s
2	Charlottetown
3	Halifax
4	St John/Moncton
5	Sydney/Glace Bay
6	Carleton
7	Chicoutimi/Jonquiere
8	Montreal
9	Montreal-Anglo
10	Montreal-Franco
11	Quebec City
12	Rimouski/Matane/Sept
13	Riviere Du Loup
14	Rouyn/Noranda
15	Sherbrooke
16	Trois Rivières
17	Barrie
18	Kenora
19	Kingston
20	Kitchener/London
21	Kitchener
22	London
23	Ottawa/Hull
24	Ottawa/Hull-Anglo
25	Ottawa/Hull-Franco
26	Pembroke
27	Peterborough
28	Sault Ste Marie
29	Sud/Timmins/N Bay
30	Sud/Tim/Nbay/SSM
31	Thunder Bay
32	Toronto/Hamilton
33	Windsor
34	Winnipeg/Brandon
35	Lloydminster
36	Prince Albert
37	Regina/Moose Jaw
38	Saskatoon
39	Swift Current
40	Yorkton
41	Calgary/Lethbridge
42	Edmonton
43	Red Deer
44	Medicine Hat
45	Dawson Creek
46	Kelowna/Kamloops
47	Prince George
48	Terrace/Kitimat
49	Vancouver

United States

Market ID	Market Name
1	Abilene-Sweetwater
2	Albany, GA
3	Albany-Schenectady-Troy
4	Albuquerque-Santa Fe
5	Alexandria, LA
6	Alpena
7	Amarillo
8	Anchorage
9	Atlanta
10	Augusta
11	Austin
12	Bakersfield
13	Baltimore
14	Bangor
15	Baton Rouge
16	Beaumont-Port Arthur
17	Bend, OR
18	Billings
19	Biloxi-Gulfport
20	Binghamton
21	Birmingham (Ann and Tusc)
22	Bluefield-Beckley-Oak Hill
23	Boise
24	Boston (Manchester)
25	Bowling Green
26	Buffalo
27	Burlington-Plattsburgh
28	Butte-Bozeman, MT
29	Casper-Riverton
30	Cedar Rapids-Wtrlo-IWC&Dub
31	Champaign&Sprngfld-Decatur
32	Charleston, SC
33	Charleston-Huntington
34	Charlotte
35	Charlottesville
36	Chattanooga
37	Cheyenne, WY-Scottsbluff
38	Chicago
39	Chico-Redding
40	Cincinnati
41	Clarksburg-Weston
42	Cleveland-Akron (Canton)
43	Colorado Springs-Pueblo
44	Columbi, SC
45	Columbia-Jefferson City
46	Columbus, GA
47	Columbus, OH
48	Columbus-Tupelo-West Point
49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210	Corpus Christi Dallas-Ft.Worth Davenport-R.Island-Moline Dayton Denver Des Moines-Ames Detroit Dothan Duluth-Superior El Paso Elmira Erie Eugene Eureka Evansville Fairbanks Fargo-Valley City Flint-Saginaw-Bay City Florence-Myrtle Beach Fresno-Visalia Ft. Myers-Naples Ft. Smith-Fay-Sprngld-Rgrs Ft.Wayne Gainesville Glendive Grand Junction-Montrose Grand Rapids-Kalmzoo-B.Crk Great Falls Green Bay-Appleton Greensboro-H.Point-W.Salem Greenville-N.Bern-Washngtn Greenvll-Spart-Ashevll-And Greenwood-Greenville Harlingen-Wslco-Brnsvl-McA Harrisburg-Lncstr-Leb-York Harrisonburg Hartford & New Haven Hattiesburg-Laurel Helena Honolulu Houston Huntsville-Decatur (Flor) Idaho Falls-Pocatello Indianapolis Jackson, MS Jackson, TN Jacksonville, Brunskwick Johnstown-Altoona Jonesboro Joplin-Pittsburg Juneau, AK Kansas City Knoxville La Crosse-Eau Claire Lafayette, IN Lafayette, LA Lake Charles Lansing Laredo Las Vegas Lexington Lima Lincoln & Hstngs-Krny Plus Little Rock-Pine Bluff Los Angeles Louisville Lubbock Macon Madison Mankato Marquette Medford-Klamath Falls Memphis Meridian Miami-Ft.Lauderdale Milwaukee Minneapolis-St.Paul Minot-Bismarck-Dickinson Missoula Mobile-Pensacola (Ft Walt) Monroe-El Dorado Monterey-Salinas Montgomery (Selma) Nashville New Orleans New York Norfolk-Portsmth-Newpt Nws North Platte Odessa-Midland Oklahoma City Omaha Orlando-Daytona Bch-Melbrn Ottumwa-Kirksville Paducah-C.Gird-Harbg-Mt VN Palm Springs Panama City Parkersburg Peoria-Bloomington Philadelphia Phoenix Pittsburg Portland, OR Portland-Auburn Presque Isle Providence-New Bedford Quincy-Hannibal-Keokuk Raleigh-Durham (Fayetvlle) Rapid City Reno Richmond-Petersburg Roanoke-Lynchburg Rochester, NY Rochester-Mason City-Austin Rockford Sacramnto-Stktn-Modesto Salisbury Salt Lake City San Angelo San Antonio San Diego San Francisco-Aok-San Jose SantaBarbra-SanMar-SanLuOb Savannah Seattle-Tacoma Sherman, TX-Ada, OK Shreveport Sioux City Sioux Falls (Mitchell) South Ben-Elkhart Spokane Springfield, MO Springfield-Holyoke St. Joseph St. Louis Syracuse Tallahassee-Thomasville Tampa-St.Pete (Sarasota) Terre Haute Toldeo Topeka Traverse City-Cadillac Tri-Cities, TN-VA Tucson (Sierra Vista) Tulsa Twin Falls Tyler-Longview (Lfkn&Ncgd) Utica Victoria Waco-Temple-Bryan Washington, DC (Hagrstwn) Watertown Wausau-Rhinelander West Palm Beach-Ft. Pierce Wheeling-Steubenville Wichita Falls & Lawton Wichita-Hutchinson Plus Wilkes Barre-Scranton Wilmington Yakima-Pasco-Rchlnd-Knnwck Youngstown Yuma-El Centro Zanesville

The following demographics are available when audiences are imported using the Nielsen Media Research Import method:

Demo No	Demo Name
DEMO_01	HH
DEMO_02	V2+
DEMO_03	A18+
DEMO_04	A18-24
DEMO_05	A18-34
DEMO_06	A18-49
DEMO_07	A25+
DEMO_08	A25-34
DEMO_09	A25-49
DEMO_10	A25-54
DEMO_11	A35+
DEMO_12	A35-49
DEMO_13	A35-54
DEMO_14	A50+
DEMO_15	A55+
DEMO_16	W18+
DEMO_17	W18-24
DEMO_18	W18-34
DEMO_19	W18-49
DEMO_20	W25+
DEMO_21	W25-34
DEMO_22	W25-49
DEMO_23	W25-54
DEMO_24	W35+
DEMO_25	W35-49
DEMO_26	W35-54
DEMO_27	W50+
DEMO_28	W55+
DEMO_29	WKG
DEMO_30	M18+
DEMO_31	M18-24
DEMO_32	M18-34
DEMO_33	M18-49
DEMO_34	M258+
DEMO_35	M25-34
DEMO_36	M25-49
DEMO_37	M25-54
DEMO_38	M35+
DEMO_39	M35-49
DEMO_40	M35-54
DEMO_41	M50+
DEMO_42	M5+
DEMO_43	T12-17
DEMO_44	F12-17
DEMO_45	M12-17
DEMO_46 DEMO_47 DEMO_48	K2-11 G2-11 B2-11

Notes regarding Microsoft Excel Spreadsheets:

Ensure there are no extra, blank columns in the sheet by pressing CTRL + End to check the bottom right extent of the range. If there are unused blank rows or columns, then delete them and save the spreadsheet before attempting to import it.

** "Days on Air"

In your audience table, the "Days on Air" can be in any of many forms. SDS recommends that you select one of the first four forms and, for consistency, stick with it. The fifth form, "Jargon Style" is not recommended and is provided for backward compatibility only. "Jargon Style" is prone to typing errors and does not provide for all combinations of days, in all the various ways that such combinations may be expressed.

No matter which form you choose, the Days on Air will be displayed throughout the system in a user friendly style. For example if you were to use the first form example of "MTW….", it would be displayed as "M-W".

Do not worry about upper and lower case, the system ignores case.

Here are the different forms that you may use:

• "Nielsen Style": A 7 character text string representing the 7 days of week, either the first char of day if on air, otherwise a decimal point eg: "MTW…."

• "Numeris Style": A 7 character text string representing the 7 days of week, either the first char of day if on air, otherwise a hyphen eg: "MTW----"

• "SDS7CodeChar": A 7 character text string representing the 7 days of week, either the first char of day if on air, otherwise an "x"eg: "MTWxxxx"

• "SDS7CodeNum": A 7 character text string representing the 7 days of week, either the nominal position of day if on air, otherwise an "x"eg: "123xxxx"

Enter audience estimates and market ratings for the demographics that you wish to use. Only include the desired demos. If a demo is not required just leave it off the list.