To import buys from a spreadsheet, download the spreadsheet format shown below and see Import Rules for Buys for additional requirements.
Column |
Required |
#of Characters |
Alpha (A) / Numeric (N) |
Value - Column Name indicated in Bold Letters |
Example(s) |
A |
Y |
1 character |
A |
Record Type must be B (Broadcast). |
B |
B** |
Y |
1-2 characters |
A |
Media Code must be T (TV), R (Radio), or N (Network). |
T=TV or R=RADIO |
C** |
Y |
1-5 characters |
A/N |
Client Code |
ABCDE |
D** |
Y |
1-4 characters |
A/N |
Product Code |
JKLM |
E** |
Y |
1-6 characters |
A/N |
Estimate Code |
2Q2003 |
F** |
Y |
1-5 characters |
A/N |
Station Call Letters or Cable Syscode |
WABC |
G** |
Y |
1 character |
A |
Station's Band Code must be T (TV), C (Local Cable), N (Network), A (AM), or F (FM). |
T, C, N, A OR F |
H** |
Y |
1-3 characters |
A |
Daypart Code for that buy line. |
ACC |
I** |
Y |
1-7 num |
N |
Buy Line Day(s) represented by numbers (1=Monday; 2=Tuesday; 3=Wednesday; 4=Thursday; 5=Friday; 6=Saturday; 7=Sunday). |
12345 = M-F; 3456712=W-TU |
J** |
Y |
4 num (Military time) |
N |
Buy Line Start Time in military time. Blank is not allowed. No colon allowed. No leading zeroes, ex. 700 = 7:00 AM. |
700=7:00 AM 1900=7:00 PM |
K** |
N |
4 num (Military time) |
N |
Buy Line End Time in military time. Blank is allowed. No colon allowed. Do not need leading zeroes, ex. 700 = 7:00 AM. |
700=7:00 AM. 1900=7:00 PM |
L** |
N |
0-20 characters |
A/N |
Buy Line Program Name, blank is allowed. |
FRIENDS |
M** |
N |
Up to 5 characters |
A/N |
Network Code used ONLY when buying local cable systems. When buying local cable systems, leave blank unless grouping by cable network. |
ESPN |
N** |
Y |
1-4 num |
N |
Buy Line Spot Length, in seconds. No colon allowed. No leading zeros, ex. :30 should be 30. |
30 |
O** |
N |
Up to 11 num |
N |
Buy Line Spot Cost, include the decimal but do not include commas, blank is allowed when the cost is 0. |
1500 |
P** |
Y |
1 character |
A |
Spot Cost Qualifier must be one of the following: G (Gross cost), N (Net cost), or F (cost that is Free from Commission). |
G |
Q** |
N |
Up to 6 num |
N |
Demo 1 statistic, include the decimal but do not include commas, blank is allowed. |
14.7 |
R** |
N |
Up to 6 num |
N |
Demo 2 statistic, include the decimal but do not include commas, blank is allowed. |
14.7 |
S** |
N |
Up to 6 num |
N |
Demo 3 statistic, include the decimal but do not include commas, blank is allowed. |
14.7 |
T** |
N |
Up to 6 num |
N |
Demo 4 statistic, include the decimal but do not include commas, blank is allowed. |
14.7 |
U** |
N |
Up to 6 num |
N |
Demo 5 statistic, include the decimal but do not include commas, blank is allowed. |
14.7 |
V** |
N |
Up to 6 num |
N |
Demo 6 statistic, include the decimal but do not include commas, blank is allowed. |
14.7 |
W** |
N |
Up to 6 num |
N |
Demo 7 statistic, include the decimal but do not include commas, blank is allowed. |
14.7 |
X** |
N |
Up to 6 num |
N |
Demo 8 statistic, include the decimal but do not include commas, blank is allowed. |
14.7 |
Y** |
N |
Up to 6 num |
N |
Demo 9 statistic, include the decimal but do not include commas, blank is allowed. |
14.7 |
Z** |
N |
Up to 6 num |
N |
Demo 10 statistic, include the decimal but do not include commas, blank is allowed. |
14.7 |
AA |
N |
Up to 3 num |
N |
Week 1 spots, no commas, blank is allowed. |
3 |
AB |
N |
Up to 3 num |
N |
Week 2 spots, no commas, blank is allowed. |
3 |
AC |
N |
Up to 3 num |
N |
Week 3 spots, no commas, blank is allowed. |
3 |
AD |
N |
Up to 3 num |
N |
Week 4 spots, no commas, blank is allowed. |
3 |
AE |
N |
Up to 3 num |
N |
Week 5 spots, no commas, blank is allowed. |
3 |
AF |
N |
Up to 3 num |
N |
Week 6 spots, no commas, blank is allowed. |
3 |
AG |
N |
Up to 3 num |
N |
Week 7 spots, no commas, blank is allowed. |
3 |
AH |
N |
Up to 3 num |
N |
Week 8 spots, no commas, blank is allowed. |
3 |
AI |
N |
Up to 3 num |
N |
Week 9 spots, no commas, blank is allowed. |
3 |
AJ |
N |
Up to 3 num |
N |
Week 10 spots, no commas, blank is allowed. |
3 |
AK |
N |
Up to 3 num |
N |
Week 11 spots, no commas, blank is allowed. |
3 |
AL |
N |
Up to 3 num |
N |
Week 12 spots, no commas, blank is allowed. |
3 |
AM |
N |
Up to 3 num |
N |
Week 13 spots, no commas, blank is allowed. |
3 |
AN |
N |
Up to 3 num |
N |
Week 14 spots, no commas, blank is allowed. |
3 |
AO |
N |
Up to 3 num |
N |
Week 15 spots, no commas, blank is allowed. |
3 |
AP |
N |
Up to 3 num |
N |
Week 16 spots, no commas, blank is allowed. |
3 |
AQ |
N |
Up to 3 num |
N |
Week 17 spots, no commas, blank is allowed. |
3 |
AR |
N |
Up to 3 num |
N |
Week 18 spots, no commas, blank is allowed. |
3 |
AS |
N |
Up to 3 num |
N |
Week 19 spots, no commas, blank is allowed. |
3 |
AT |
N |
Up to 3 num |
N |
Week 20 spots, no commas, blank is allowed. |
3 |
AU |
N |
Up to 3 num |
N |
Week 21 spots, no commas, blank is allowed. |
3 |
AV |
N |
Up to 3 num |
N |
Week 22 spots, no commas, blank is allowed. |
3 |
AW |
N |
Up to 3 num |
N |
Week 23 spots, no commas, blank is allowed. |
3 |
AX |
N |
Up to 3 num |
N |
Week 24 spots, no commas, blank is allowed. |
3 |
AY |
N |
Up to 3 num |
N |
Week 25 spots, no commas, blank is allowed. |
3 |
AZ |
N |
Up to 3 num |
N |
Week 26 spots, no commas, blank is allowed. |
3 |
BA |
N |
Up to 3 num |
N |
Week 27 spots, no commas, blank is allowed. |
3 |
BB |
N |
Up to 3 num |
N |
Week 28 spots, no commas, blank is allowed. |
3 |
BC |
N |
Up to 3 num |
N |
Week 29 spots, no commas, blank is allowed. |
3 |
BD |
N |
Up to 3 num |
N |
Week 30 spots, no commas, blank is allowed. |
3 |
BE |
N |
Up to 3 num |
N |
Week 31 spots, no commas, blank is allowed. |
3 |
BF |
N |
Up to 3 num |
N |
Week 32 spots, no commas, blank is allowed. |
3 |
BG |
N |
Up to 3 num |
N |
Week 33 spots, no commas, blank is allowed. |
3 |
BH |
N |
Up to 3 num |
N |
Week 34 spots, no commas, blank is allowed. |
3 |
BI |
N |
Up to 3 num |
N |
Week 35 spots, no commas, blank is allowed. |
3 |
BJ |
N |
Up to 3 num |
N |
Week 36 spots, no commas, blank is allowed. |
3 |
BK |
N |
Up to 3 num |
N |
Week 37 spots, no commas, blank is allowed. |
3 |
BL |
N |
Up to 3 num |
N |
Week 38 spots, no commas, blank is allowed. |
3 |
BM |
N |
Up to 3 num |
N |
Week 39 spots, no commas, blank is allowed. |
3 |
BN |
N |
Up to 3 num |
N |
Week 40 spots, no commas, blank is allowed. |
3 |
BO |
N |
Up to 3 num |
N |
Week 41 spots, no commas, blank is allowed. |
3 |
BP |
N |
Up to 3 num |
N |
Week 42 spots, no commas, blank is allowed. |
3 |
BQ |
N |
Up to 3 num |
N |
Week 43 spots, no commas, blank is allowed. |
3 |
BR |
N |
Up to 3 num |
N |
Week 44 spots, no commas, blank is allowed. |
3 |
BS |
N |
Up to 3 num |
N |
Week 45 spots, no commas, blank is allowed. |
3 |
BT |
N |
Up to 3 num |
N |
Week 46 spots, no commas, blank is allowed. |
3 |
BU |
N |
Up to 3 num |
N |
Week 47 spots, no commas, blank is allowed. |
3 |
BV |
N |
Up to 3 num |
N |
Week 48 spots, no commas, blank is allowed. |
3 |
BW |
N |
Up to 3 num |
N |
Week 49 spots, no commas, blank is allowed. |
3 |
BX |
N |
Up to 3 num |
N |
Week 50 spots, no commas, blank is allowed. |
3 |
BY |
N |
Up to 3 num |
N |
Week 51 spots, no commas, blank is allowed. |
3 |
BZ |
N |
Up to 3 num |
N |
Week 52 spots, no commas, blank is allowed. |
3 |
CA |
N |
Up to 3 num |
N |
Week 53 spots, no commas, blank is allowed. |
3 |
CB** |
N |
Up to 3 num |
A/N |
Payee Rep Code for that buy line (if dfferent than station - normally left blank), blank is allowed. |
JEFP |