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:
from W18-49 the spreadsheet continues as follows:
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. “Traffic ID” |
Traffic Rotation or Program Code from Traffic |
alphanumeric |
10 characters |
|
8. “Plays” |
Number of Plays |
numeric |
|
|
7: “RATE” |
30 second rate for this program |
currency |
$922,337,203,685,477.58 |
|
9: “MODEL” |
Distribution Model applied. This indicates which distribution is to be applied to the line. The default setting is CABLEDIST. |
text |
20 characters |
|
10: “HH” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
10: “V2+” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
11: “A18+” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
12: “A18-24” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
13: “A18-49” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
14: “A25+” |
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: “A25-34” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
16: “A25-49” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
17: “A25-54” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
18: “A35+” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
19: “A35-49” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
20: “A35-54” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
21: “A50+” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
22: “A55+” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
23: “W18+” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
24: “W18-24” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
25: “W18-34” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
26: “W18-49” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
27: “W25+” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
28: “W25-34” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
29: “W25-49” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
30: “W25-54” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
31: “W35+” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
32: “W35-49” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
33: “W35-54” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
34: “W50+” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
35: “W55+” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
36: “WKG” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
37: “M18+” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
38: “M18-24” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
39: “M18-34” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
40: “M18-49” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
41: “M25+” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
42: “M25-34” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
43: “M25-49” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
44: “M25-54” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
45: “M35+” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
46: “M35-49” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
47: “M35-54” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
48: “M50+” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
49: “M55+” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
50: “T12-17” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
51: “F12-17” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
52: “M12-17” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
53: “K2-11” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
54: “G2-11” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
55: “B2-11” |
Audience in '000's on first line (this can include one decimal place) |
integer |
32,767 |
|
56: “Source” |
Audience Source (eg., estimates, actuals flight datex13wks) |
text |
20 characters |
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 as 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"