Post Analysis

<< Click to Display Table of Contents >>

Navigation:  TVmap > TVmap in Excel > TVmap Templates >

Post Analysis

 

Post Analysis uses data from Nielsen Television Audience Measurement to obtain a post air spot list for a category, product or advertiser, for a specific date range and demographic. Reach and Frequency reports can be generated against spots returned.

 

The report includes the Position, Spots in Break, First/Last in Break, Top Programmes and Rank for aired spots.

PostAnalysisMain

 

 

Edit Parameters as required:

Start Date

End Date

 

PostAnalysisDateSet

 

Set Auto Dates allows dates to be automatically set to the most recent weeks or days.

Excel.Post.Analysis.Set.Auto.Dates.Button

 

Select preferred date range.

Excel.Post.Analysis.Set.Auto.Dates.Window

 

Click the Select Products window to open the TVmap Product Selection window. Select the category, product or advertiser to run the report against.

Excel.Post.Analysis.Select.Products.Button

 

Use first tab to add an entire Section,Category or Product.

Excel.Post.Analysis.Select.Product.First.Tab

 

Alternatively, search for the category/product/advertiser using the Search tab.

Excel.Post.Analysis.Category.Search.Enter.Search

 

Once selections have been added click Close.

The added category/product/advertiser will now display on the main screen.

TVmap.Excel.Post.Top.Progs.Selected

 

Click Run

Excel.Post.Analysis.Run.Button

 

Once the report has run it will automatically switch to the Spots tab displaying the results.

TVmap.Exl.Post.Top.Progs.Results

 

Can filter Top Programmes to show what was in Top 20.

TVmap.Exl.Filter.Top.Progs

 

TVmap.Exl.Top.Progs.Filter.Results

 

 

Rank is the Top Programme ranking. If you use top 200 and your programme doesn't appear in the top 200 then 201 will appear. If you changed it to top 50 then it would show the ranking for spots which fall in the top 50 and for anything outside this is the template would show 51.

 

To run an R&F click on Subtotals and R&F

TVmap.Excel.Post.Analysis.RF.Button

 

Choose from the Output Summary Options and click OK.

TVmap.Excel.Post.Analysis.Ouputs

 

R&F results will appear on the right side of the report.

TVmap.Exl.RF.Post.Top.Progs

 

 

The Spot Analysis tab provides a pivot table summary by Broadcaster, Spot Position and Top Programme Ranking.

This also includes a distinct day play count summary for creative licensing reporting.

RN.Q3.22.Spot.Analysis.tab