The Quick Pivot Report tab allows you to build your custom report to answer your specific business question. Export your report into excel by right clicking anywhere on the report and selecting Export then Export Table.
Report Fields
Make your selections to build your pivot report. To select multiple fields, hold the ctrl button and select the additional field with your mouse.
Use Columns & Rows to view the following:
Rollup Month = Dates group by month
Rollup Week = Dates group by weeks
Rollup Quarter = Dates group by quarter
Client Name = Customize your report, with your company name
Platform = Different platforms include discovery+, HBO Max, Hulu, Paramount+, Peacock, Pluto TV, ViX, The Roku Channel, and Tubi.
Advertiser = Company publishing the advertisement
Category = Data distributed by category
Parent Category = Grouped the Category
Product_Name= a service or an item of a particular brand
Commercial Length = duration of advertisement ; 10s, 10-25s, 25-45s, >45s
UserGender = Gender distribution
Use the Metrics to view the following:
Spend($) = Spend dollars across the pivot
Spend SOV All= Spend Share of Voice across the pivot
Spend SOV Column= Spend Share of Voice across each Column of the pivot
Spend SOV Rows= Spend Share of Voice across each Row of the pivot
SOV All = Share of Voice across the pivot
SOV Column = Share of Voice across each Column of the pivot
SOV Rows = Share of Voice across each Row of the pivot
Filters
Use the scroll bar to select your date range and filter by Advertiser, Platform, and Categories.
