Import Goals Spreadsheet Format

Column

Required

Type

Alpha (A) / Numeric (N)

Value - Column Name Indicated in Bold Letters

Example

A

Y

1 character

A

Record Type must be G (Goal)

G

B

Y

1-2 characters

A

Media Code must be T (TV), R (Radio), or N (Network)

T or R

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-4 characters

A/N

Market Code - Demographic Market Area (DMA)

LA or 151

G

Y

1-3 characters

A

Daypart Code

ACC

H

Y

1-4 num

N

Spot Length must be 5, 15, 30, 60 with no colon

30

I

*

Up to 4 num

N

Weekly GRPs, do not include commas, blank is allowed, whole numbers (decimal not allowed), up to 3 decimal positions allowed

35

J

*

Up to 7.2 num

N

Weekly CPP, include the decimal but do not include commas, blank is allowed

275

K

*

Up to 7.2 num

N

Weekly Dollars, include the decimal but do not include commas, blank is allowed

300

L

N

1 character

A

Week 1 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 1 of the estimate

X

M

N

1 character

A

Week 2 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 2 of the estimate

X

N

N

1 character

A

Week 3 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 3 of the estimate

X

O

N

1 character

A

Week 4 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 4 of the estimate

X

P

N

1 character

A

Week 5 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 5 of the estimate

X

Q

N

1 character

A

Week 6 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 6 of the estimate

X

R

N

1 character

A

Week 7 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 7 of the estimate

X

S

N

1 character

A

Week 8 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 8 of the estimate

X

T

N

1 character

A

Week 9 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 9 of the estimate

X

U

N

1 character

A

Week 10 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 10 of the estimate

X

V

N

1 character

A

Week 11 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 11 of the estimate

X

W

N

1 character

A

Week 12 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 12 of the estimate

X

X

N

1 character

A

Week 13 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 13 of the estimate

X

Y

N

1 character

A

Week 14 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 14 of the estimate

X

Z

N

1 character

A

Week 15 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 15 of the estimate

X

AA

N

1 character

A

Week 16 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 16 of the estimate

X

AB

N

1 character

A

Week 17 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 17 of the estimate

X

AC

N

1 character

A

Week 18 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 18 of the estimate

X

AD

N

1 character

A

Week 19 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 19 of the estimate

X

AE

N

1 character

A

Week 20 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 20 of the estimate

X

AF

N

1 character

A

Week 21 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 21 of the estimate

X

AG

N

1 character

A

Week 22 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 22 of the estimate

X

AH

N

1 character

A

Week 23 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 23 of the estimate

X

AI

N

1 character

A

Week 24 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 24 of the estimate

X

AJ

N

1 character

A

Week 25 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 25 of the estimate

X

AK

N

1 character

A

Week 26 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 26 of the estimate

X

AL

N

1 character

A

Week 27 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 27 of the estimate

X

AM

N

1 character

A

Week 28 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 28 of the estimate

X

AN

N

1 character

A

Week 29 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 29 of the estimate

X

AO

N

1 character

A

Week 30 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 30 of the estimate

X

AP

N

1 character

A

Week 31 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 31 of the estimate

X

AQ

N

1 character

A

Week 32 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 32 of the estimate

X

AR

N

1 character

A

Week 33 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 33 of the estimate

X

AS

N

1 character

A

Week 34 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 34 of the estimate

X

AT

N

1 character

A

Week 35 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 35 of the estimate

X

AU

N

1 character

A

Week 36 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 36 of the estimate

X

AV

N

1 character

A

Week 37 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 37 of the estimate

X

AW

N

1 character

A

Week 38 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 38 of the estimate

X

AX

N

1 character

A

Week 39 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 39 of the estimate

X

AY

N

1 character

A

Week 40 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 40 of the estimate

X

AZ

N

1 character

A

Week 41 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 41 of the estimate

X

BA

N

1 character

A

Week 42 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 42 of the estimate

X

BB

N

1 character

A

Week 43 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 43 of the estimate

X

BC

N

1 character

A

Week 44 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 44 of the estimate

X

BD

N

1 character

A

Week 45 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 45 of the estimate

X

BE

N

1 character

A

Week 46 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 46 of the estimate

X

BF

N

1 character

A

Week 47 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 47 of the estimate

X

BG

N

1 character

A

Week 48 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 48 of the estimate

X

BH

N

1 character

A

Week 49 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 49 of the estimate

X

BI

N

1 character

A

Week 50 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 50 of the estimate

X

BJ

N

1 character

A

Week 51 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 51 of the estimate

X

BK

N

1 character

A

Week 52 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 52 of the estimate

X

BL

N

1 character

A

Week 53 of the estimate, send an 'X' if the Daypart, Length, GRPs, CPP, Dollars for that row are valid for week 53 of the estimate

X