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 CTRL 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 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: “Traffic ID” |
This number is determined by Traffic and is the link between the systems that will ensure lines are booked properly. |
Alphanumeric |
25 characters |
|
8: “RATE” |
30 second rate for this program |
currency |
$922,337,203,685,477.58 |
|
9: “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 |
|
|
10: “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 |
26 characters |
|
11: 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 |
|
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 |
|
35: 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 |
Program
For Program name, obtain a current list of Program and Rotation names for the Sales Inventory. With eBroadcast, go into SDS Traffic and run the Skim Avails report for all programs and rotations. From the program/rotation names listed in this report provide audience estimates for all the programs that are available as Sales Inventory.
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"
Start Time / End Time
The start time and end time of a program are defined by traffic. If you are unclear on when a program starts and ends, this information should be confirmed with Traffic.
Start Week / End Week
The start week and end week for a program are defined by traffic. The definition entered into Sales may be a subset of Traffic and there may be multiple subset definitions for a program with different start and end weeks. There is no problem with having multiple definitions so long as they do not extend beyond the Program Start and End Week definition from Traffic.
Traffic ID
Traffic IDs are required for all programs and rotations otherwise all lines will be immediately rejected by Traffic through the electronic processing.
Markets
The Markets (up to 26 characters) available for Numeris are:
|
Market ID |
Market Name |
|
8
9 10 19 20 40 49 50 60 70 1020
|
St John’s/C’Brook
St. John’s CTRL CD 1 Carbonear CTRL CD2/Marystown CTRL CD 4/Stphnvil CTRL Corner Brook CTRL CD 5 CD 6/Gander GF CTRL CD 7/Clarnbile CTRL Queens/Chan CTRL |
|
1021 |
Charlottetown EM |
|
1032 |
Maritimes EM |
|
2008 2010 2025 2045 2055 |
Sydney/G Bay EM Cape Bret/Sydny CTRL Invrn/Rch/Vic Antig-PT Hawk CTRL Antigonish/Guys |
|
2078 2080 2090 2170 3008 3009
|
Halifax EM Halifax CTRL Bridgewater CTRL Col/Truro CTRL Shediac CTRL Moncton CA |
|
3010 3015 3029 3035 3079 3080 3090 3110 |
St. John-Moncton EM Albert/Westmld Saint John CTRL Kings/St J/Char Fredericton CTRL York/Sun/Queens Kent Gloucester |
|
3111 3120 3150 4000 4010 4029 4040 |
Carleton Restigouche Edmundston CTRL Nord-Du-Quebec Avign-Bonavnt CTRL Gaspe CTRL Matane/Matane CTRL |
|
4050 |
Amqui CTRL |
|
4061 4070 |
Rim-Mat-Sept-Iles EM Rimouski CTRL |
|
4080 4081 |
Sept-Riv/Ming/Man S Iles/Pt Cart CTRL |
|
4093 |
Baie Comeau CTRL |
|
4101 |
Riviere-du-Loup EM |
|
4118 4120 4130 4142 4145 4150 4160 |
Saguenay EM Saguenay CTRL Alma CTRL Dom-Roy/Maria Chap Roberval CTRL Charlevoix CTRL Kamouraska/L’Islet |
|
4197 4199 4200 4201 4215 4259 4260 4268 4270 4279 4280 4339 4340 4350 |
Quebec EM Quebec CTRL Quebec Et Co N Donnacona CTRL Quebec CO S Thet Mine CTRL L’Amiante/L’Erable Ste-Marie CTRL Beauce/Rob Cliche Victoriaville CTRL Arthabaska Sherbrooke CTRL Coaticook/Memp Sherbrooke CMA |
|
4351 4360 4369 4370 4410 4449 4450 |
Sherbrooke EM Granby CTRL Drummondville CTRL Drummond H-Rich/St Jean CTRL St Hyancin CTRL Acton/Maskout |
|
4479 4480 4481 |
Montreal CTRL Montreal Anglo Montreal Franc |
|
|
|
|
4590 4591 4595 4609 4620 4629 4659 4660 |
St-Jerome CTRL Rivn/Arg/P Haut/LR Lachute CTRL Joliette CTRL Aut/Jol/Mont/Mat St-Gabril CTRL Trois-Rivieres CTRL Mek/Maur/Franch |
|
4671 4679 4680 4700 4710 |
La Tuque CTRL Maniwaki CTRL Gatineau/Pap/Pont Mont-Laurier CTRL Rouyn CTRL
|
|
4723 4724 4732 5008 5010 |
Rouyn EM Val-D’Or CTRL Temisc/Vle-Marie C Cornwall CTRL Stormt/Dun/Glen |
|
5068 5069 5071 5072 |
Ottawa-Gatineau EM Ottawa-Gat CTRL Ottawa-Gat CTRLA Ottawa-Gat CTRLF |
|
5073 |
Ottawa-Gat EM Anglo |
|
5074 5075 5076 5077 5078 5079 5080 5090 5099 |
Ottawa-Gat EM Franco Ottawa-Gat EM Ont Ottawa Gat EM Que Ottawa-Gat CTRL On Ottawa-Gat CTRL QC Brockville CTRL Leeds-Grenville Lanark Pembrooke CTRL |
|
5100 |
Renfrew (Pembrooke CM) |
|
5108 5109 5110 5139 5140 |
Kingston EM Kingston CTRL Front/Lennx-Add Bell-Trnt CTRL Hastings/Pr Edward |
|
5145 5150 |
East Ctrl Ont Cobourg Ctrl |
|
5158 5159 5160 5170 5187 5190 |
Peterborough EM Peterborough CTRL Peterborough County Lindsay CTRL Oshawa-Whitby CTRL Durham |
|
5197 5199 5200 5210 5220 5237 5238 5239 5240 5241 5242 |
Tor/Ham Toronto CTRL York Toronto Peel Midland CTRL Orillia CTRL Barrie CTRL Simcoe County Simcoe Co NE Simcoe Co SW |
|
5243 5245 5255 5269 5270 5280 5299 5300 5320 5330 |
Barrie EM Collingwood/Wa Bch CTRL Haliburton/Musk Hamilton CTRL Halton Hamilton St Cath-Niag CTRL Niagara Brant/Brantfod/CTRL Simcoe CTRL |
|
5336 |
Kitchener-London EM |
|
5338 5339 5340 5348 5349 5350 5358 5360 |
Kitchener EM Kit-Waterloo CTRL Waterloo Tillsonberg CTRL Woodstock CTRL Oxford Guelph CTRL Wellington |
|
5369 5370 5390 5400 5407 |
London CTRL Middlesex/Elgin Sarnia CTRL Chatham CTRL Leamington CTRL |
|
5408 5409 5410 5420 5429 5430 5440 5449 5450 5469 |
Windsor EM (Essex) Windsor CTRL Essex Perth Wingham CTRL Huron Bruce Owen Sound CTRL Grey North Bay CTRL |
|
5479 5480 |
Sudbury CTRL Sudbury DT |
|
5510 5515 5519 |
Sud-Tim-NB-SSM EM Algoma/Manit Sault Ste Marie CTRL |
|
5539 |
Thunder Bay CTRL |
|
5540 5560 |
Thunder Bay EM (Dist) Kenora District |
|
5565 |
Kenora EM |
|
6061 6070 6110 |
Brandon EM Brandon CTRL CD 11 |
|
6117 6119 6120 |
Winnipeg EM Winnipeg CTRL CD 2N/10/12-14 |
|
7011 |
Yorkton EM |
|
7069 7070 |
Regina CTRL CD 6 |
|
7072 7079 7080 7090 |
Regina-Moose Jaw EM Moose Jaw CTRL CD 3/CD 7 Yorkton CTRL |
|
7108 7109 7110 |
Saskatoon EM Saskatoon CTRL CD 11/CD 12 PT |
|
7153 7170 |
Prince Albert EM/ME CD 17 |
|
8010 8015 8019 8020 8059 8069 8071 8079 8080 8091 8101 8111 8118 8119 8120 8140 8150 9070 9071 9080 9090 9095 9100 9102 9104 9109 9119 9149 9209 9211 9230 9239 9240 9300 9301 9341 9349 9350 9363 9711 9712 9716 9718 9721 9724 9725 9726 9727 9728 9732 9733 9736 9737 9740 9741 9762 9770 9800 9801 9802 9803 9804 9805 9806 9807 9808 9809 9900 |
Medicine Hat EM Taber CTRL Lethbridge CTRL CD 2 High River CTRL Calgary CTRL CD 6 Red Deer CTRL CD 8/CD 9 Lloyminster EM CD 10 East Camrose CTRL Edmonton EM Edmonton CTRL CD 11 CD 13/Whitecrt CTRL Edson CTRL Penticton CTRL Okan-Kamloops EM Fr Val/Chllwk CTRL Fras/Abbtsfrd CTRL Vreater Van S Greater Van N SH Van City/Burnaby Greater Van E Vancouver CTRL Victoria CTRL Naniamo CTRL Kamloops CTRL Thomp-Nic NOR Kelowna CTRL Vernon CTRL North Okanagan Skeena-Qq Char/K-S Terrace-Kitimat EM Pr George-Ter-Kit EM Prince George CTRL Fras-Ft George Dawson Creek EM Bonaventure SG Montreal SG Barrie SG Kitchener SG Red Deer SG Edmonton Rural SG Edmonton SG Saint John SG Haliburt/Musk SG St. Catherines SG Okanag Valley SG All NFLD SG St. Jn’s/Cbrk SG London SG Abitibi SG Prince George SG Alberta South SG Fraser Valley SG Nfld/Labrador PEI Nova Scotia New Brunswick Quebec Ontario Manitoba Saskatchewan Alberta BC Total Canada |
Demographics
For Columns 10-56, only include the demographics that are required by Sales. If a demo is not required, just leave it out.
The demo names to be applied in the table are as follows:
The following demographics are available when audiences are imported using the Numeris importing method:
|
Demo No |
Demo Name |
|
DEMO_01 |
A2+ |
|
DEMO_02 |
C2-6 |
|
DEMO_03 |
C2-11 |
|
DEMO_04 |
C7+ |
|
DEMO_05 |
C7-11 |
|
DEMO_06 |
A12+ |
|
DEMO_07 |
A12-17 |
|
DEMO_08 |
A12-24 |
|
DEMO_09 |
A12-34 |
|
DEMO_10 |
A12-44 |
|
DEMO_11 |
A12-49 |
|
DEMO_12 |
A12-54 |
|
DEMO_13 |
A12-64 |
|
DEMO_14 |
A18+ |
|
DEMO_15 |
A18-24 |
|
DEMO_16 |
A18-34 |
|
DEMO_17 |
A18-44 |
|
DEMO_18 |
A18-49 |
|
DEMO_19 |
A18-54 |
|
DEMO_20 |
A18-64 |
|
DEMO_21 |
A25+ |
|
DEMO_22 |
A25-34 |
|
DEMO_23 |
A25-44 |
|
DEMO_24 |
A25-49 |
|
DEMO_25 |
A25-54 |
|
DEMO_26 |
A25-64 |
|
DEMO_27 |
A35+ |
|
DEMO_28 |
A35-44 |
|
DEMO_29 |
A35-49 |
|
DEMO_30 |
A35-54 |
|
DEMO_31 |
A35-64 |
|
DEMO_32 |
A45+ |
|
DEMO_33 |
A45-49 |
|
DEMO_34 |
A45-54 |
|
DEMO_35 |
A45-64 |
|
DEMO_36 |
A50+ |
|
DEMO_37 |
A50-54 |
|
DEMO_38 |
A50-64 |
|
DEMO_39 |
A55+ |
|
DEMO_40 |
A55-59 |
|
DEMO_41 |
A55-64 |
|
DEMO_42 |
A60-64 |
|
DEMO_43 |
A65+ |
|
DEMO_44 |
F2-11 |
|
DEMO_45 |
F12+ |
|
DEMO_46 |
F12-17 |
|
DEMO_47 |
F12-24 |
|
DEMO_48 |
F12-34 |
|
DEMO_49 |
F12-44 |
|
DEMO_50 |
F12-49 |
|
DEMO_51 |
F12-54 |
|
DEMO_52 |
F12-64 |
|
DEMO_53 |
F18+ |
|
DEMO_54 |
F18-24 |
|
DEMO_55 |
F18-34 |
|
DEMO_56 |
F18-44 |
|
DEMO_57 |
F18-49 |
|
DEMO_58 |
F18-54 |
|
DEMO_59 |
F18-64 |
|
DEMO_60 |
F25+ |
|
DEMO_61 |
F25-34 |
|
DEMO_62 |
F25-44 |
|
DEMO_63 |
F25-49 |
|
DEMO_64 |
F25-54 |
|
DEMO_65 |
F25-64 |
|
DEMO_66 |
F35+ |
|
DEMO_67 |
F35-44 |
|
DEMO_68 |
F35-49 |
|
DEMO_69 |
F35-54 |
|
DEMO_70 |
F35-64 |
|
DEMO_71 |
F45+ |
|
DEMO_72 |
F45-49 |
|
DEMO_73 |
F45-54 |
|
DEMO_74 |
F45-64 |
|
DEMO_75 |
F50+ |
|
DEMO_76 |
F50-54 |
|
DEMO_77 |
F50-64 |
|
DEMO_78 |
F55+ |
|
DEMO_79 |
F55-59 |
|
DEMO_80 |
F55-64 |
|
DEMO_81 |
F60-64 |
|
DEMO_82 |
F65+ |
|
DEMO_83 |
M2-11 |
|
DEMO_84 |
M12+ |
|
DEMO_85 |
M12-17 |
|
DEMO_86 |
M12-24 |
|
DEMO_87 |
M12-34 |
|
DEMO_88 |
M12-44 |
|
DEMO_89 |
M12-49 |
|
DEMO_90 |
M12-54 |
|
DEMO_91 |
M12-64 |
|
DEMO_92 |
M18+ |
|
DEMO_93 |
M18-24 |
|
DEMO_94 |
M18-34 |
|
DEMO_95 |
M18-44 |
|
DEMO_96 |
M18-49 |
|
DEMO_97 |
M18-54 |
|
DEMO_98 |
M18-64 |
|
DEMO_99 |
M25+ |
|
DEMO_100 |
M25-34 |
|
DEMO_101 |
M25-44 |
|
DEMO_102 |
M25-49 |
|
DEMO_103 |
M25-54 |
|
DEMO_104 |
M25-64 |
|
DEMO_105 |
M35+ |
|
DEMO_106 |
M35-44 |
|
DEMO_107 |
M35-49 |
|
DEMO_108 |
M35-54 |
|
DEMO_109 |
M35-64 |
|
DEMO_110 |
M45+ |
|
DEMO_111 |
M45-49 |
|
DEMO_112 |
M45-54 |
|
DEMO_113 |
M45-64 |
|
DEMO_114 |
M50+ |
|
DEMO_115 |
M50-54 |
|
DEMO_116 |
M50-64 |
|
DEMO_117 |
M55+ |
|
DEMO_118 |
M55-59 |
|
DEMO_119 |
M55-64 |
|
DEMO_120 |
M60-64 |
|
DEMO_121 |
M65+ |
|
DEMO_122 |
OMP |
|
DEMO_123 |
WW |
|
DEMO_124 |
WHC |