Skip to main content
All CollectionsPlaybooks (step-by-step guides)
Analyzing Year-Over-Year Spend by Advertiser/Media
Analyzing Year-Over-Year Spend by Advertiser/Media

Follow the steps laid out below to run a custom report in Explore by Category, broken out by Advertiser and Media.

Vivvix Support avatar
Written by Vivvix Support
Updated this week

Click the Explore button located on the left-side menu and choose Create New Report.


STEP 1: PROFILE TAB

To run a report for advertisers you’ve added to your profile via the My Profiles section, select a Profile in the drop-down menu:

Then choose either Link (Brands/Categories linked to selected profile) or Populate (All selections originally copied from profile).

To run a report with no profile selections included, choose None from the drop-down menu.


STEP 2: LAYOUT TAB

SORTS

Under the Product sorts grouping, choose Advertiser.

Under the Media/Time sorts grouping, choose Media.

MEASURES

Choose Dollars.

SELECTED SORTS & MEASURES

Click into the Column Type drop-down and choose Media.

Click the 3-dot action menu to the right of the Column Type drop-down and choose to Include Total Column, if needed.

Under the selected Measures, click the 3-dot action menu to the right and choose the option to show Dols/Imp in Thousands, if needed.

Click the list icon within the chosen Dollars measure and choose All to rank your advertisers top spender at the top based on the total.


STEP 3: MEDIA/MARKETS TAB

Skip this tab to default to All Media/Markets, or you can click the check boxes at the top of the media and markets section to choose All.


STEP 4: BRANDS/CATEGORIES TAB

Click into the search field on the left.

Click the checkbox next to the Category Level box and choose Major or Category.

Search for the Major/Category you would like to pull into your report.

QUICK TIP: If you don’t know the name of the Category you are looking for, search the Advertiser level for an advertiser you know will be in the category you are looking for, then use the Drill To feature to drill up to the Category.

Click the checkbox to the left of the entity to select.

Then click the ADD button at the bottom.

Click Close if you are done adding items. If you need to add more, click into the search field on the left and continue adding.


STEP 5: TIME PERIODS TAB

Choose regular Calendar or Broadcast Calendar time period type.

Under the Frequency column on the left, choose the Time Period needed:

  • Single One lump time period (i.e. Nov 2022 – Oct 2023)

  • Day Break the info out daily, where available by media type

  • Week Break the info out weekly, where available by media type

  • Month Break the info out monthly

  • Quarter Break the info out quarterly

  • Year Break the info out by year

Choose the time period by clicking the up or down arrows on the left of the calendar to advance to the year needed.

Once in the correct year, choose the month, then the date for your Start Date.

Repeat this process for your End Date.

Click the + icon to add that time period to your report.


Go to the top-left of the report, clear out Untitled Report, and give your report a title.

Click the Run arrow over towards the right to run your report.


If you have any additional questions, you can reach out to your local Vivvix Client Success Manager. Our support team is also available for assistance via email at support@vivvix.com.

Did this answer your question?