Skip to main content
Analyzing Spend by Local Media

Follow the steps laid out below to run a custom report in Explore for local market advertising activity.

Vivvix Support avatar
Written by Vivvix Support
Updated over a week ago

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.

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

MEDIA

Select any or all of the following local market media types:

  • Spot TV

  • Internet Display

  • Online Video

  • Mobile Web

  • Mobile App

  • Mobile Web Video

  • National Spot Radio

  • Local Radio

  • Local Magazines

  • Newspapers

  • Hispanic Newspapers

  • Outdoor

MARKET

Select the market needed for your report.


STEP 4: BRANDS/CATEGORIES TAB

To run a report for ALL Advertisers:

If you would like to run a report for ALL advertisers in the market, you can SKIP over the BRANDS/CATEGORIES tab. Skipping this tab will default the report to ALL Advertisers. You have already told Explore to break the report out by Advertiser by including Advertiser as a sort in the Layout tab.

To run a report for a specific Advertiser/Category:

Click into the search field on the left.

Click the checkbox next to the Brand Level or Category Level boxes to select which level you would like to search.

Search for the Advertiser/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?