Multi-Market Goal Worksheet

Once the Goal Setup is complete and you click the Next icon, the Multi-Market Goal Worksheet displays.

Multi-Market Goal Worksheet

The worksheet screen is divided into three sections.

Left Section

The left section of the worksheet shows the totals where the planned Gross Budget, Total GRPs and Gross CPP columns display totals for each market's dayparts and spot lengths. Net Budget and Net CPP columns display net figures.  

Budgeted GRPs and Budget Dollars that were entered on the previous screen appear in green.  If goal dollars, GRPs or CPP entered on this screen exceed the numbers listed in green, they will display as red, warning you that they have exceeded their budget target.  

Totals for each market as well as dayparts that contain multiple spot lengths are shaded using a dark gray color background.

Right Section

The right section of the worksheet shows each week or day (depending on the estimate) as a column.  Choose a statistic type (GRPs, cost or CPP) to determine the statistic you wish to enter for each week or day. You may toggle back and forth to enter or view weekly/daily values for CPP, GRPs or cost.

The Multi-Market Goal Entry option employs a drag and drop copy feature, which enables you to copy values from one column or row to another.  As values are entered, their totals adjust on the left side of the screen.  A splitter bar is enables you to increase or decrease width size on either side; you may also drag and drop columns.

Hiatus weeks are shaded using a light blue color background.

Bottom Section

The Client Guidelines appear at the bottom of the worksheet. Use the scroll bar to view the text.

 

Across the top of the worksheet screen you'll find a series of icons and buttons that will allow you to perform related tasks.