With Broadcasters moving towards Guaranteed Audience, trading CPTs and CPMs are offered based on Fixed Potential Audience for the demographic.
Rating predictions may be based on a date period where the Potential is different from the Fixed Potential which has been specified by the broadcaster. i.e. if STLY or Mixed source weeks are selected.
This template allows you to quickly convert columns of 000s or TARPs to show the TARPs/000s calculated using a different Potential.
By default, the template will compare the current year Potentials with Prior Year, however this can be updated to match the source weeks used.
000s or TARP data from TVmap Buying/PrePost or Campaign manager can be copied and pasted into the template replacing the 000s or TARPs values.
The sheet will automatically calculate the equivalent TARPs or 000s based on the new potential.
All Guaranteed Audience demographics should be using fixed potential demographics. The demographic potentials are updated annually by Nielsen.
If a non-fixed demographic is chosen or the selected date range covers the period where the demographic potential is changing a warning is presented to show that the potential is changing.
It is recommended to select an alternate trading demographic or adjust dates to avoid using a period where the potential is varying.
* Excel® is a registered trademark of Microsoft Corporation
Have more questions? E-mail us: support@tvmap.com or call us: +64 9 304 0762
|
|
©2025 Broadcast M.A.P. Limited. All Rights Reserved.
|