Lineup Explore

The Podcast Metrics Lineups feature is designed for podcast inventory planners, buyers, and agencies. It is not available to all Podcast Metrics users.

For an overview of Podcast Metrics Lineups, see the Knowledge Base article Podcast Metrics Lineups, Explained.

With Lineup Explore you can create a variety of filtered reports for podcasts that have been made available through shared lineups. You can include up to six dimensions in a report, in any order. In Podcast Explore you can filter your query results by lineup, by selecting one or more lineups in the Content Filter. You can also export your reports to an Excel file.

Important! Lineup Explore is accessed from the https://metrics.tritondigital.com domain. Be sure to allow that domain if your web browser uses an ad blocker.

The on-screen report shows a maximum of 500 rows. Exported reports show a maximum of 100,000 rows.

The Lineup Explore user interface is responsive and easy to use. The descriptions in this user guide will help you get started, but the best thing to do is navigate through the application, seeing how the various elements work together to create insightful reports that you create according to your needs and interests.

Overview of the Lineup Explore interface

Query Builder. Select the lineup, choose a date range, add optional additional filters, and set up your dimensions.
Selection management area. What appears here depends on what you have selected in one of the other areas:
- Select a filter or "+Add new" in the Query Builder and the filter selector appears.
- Click the date range and the Date Range manager appears.
Report area. This is where the reports you create appear. Reports are sorted by Downloads. The on-screen report shows a maximum of 500 rows.

Creating Reports with the Query Builder

The basic steps for creating a report in Lineup Explore are:

In the Query Builder, choose one or more lineups.
Select the date range for the report. (You can look back as far as one year, assuming data is available.)
Add any additional filters you want. (See note, below.)
Build out your splits by selecting one or more dimensions (up to six).
Run the report to see it in the report area.
(Optional) Export the report to an Excel (.xlsx) file.

Example report showing podcast statistics for three dimensions (sorted by Downloads)

Selecting Lineups

Click the Lineup filter
…the Lineup Selection filter panel appears in the selection management area.
Select the lineups you want to explore. (Use the Search field to narrow your choices.)
Click "Apply" or "Apply and Run."
(Optional) Click "Add new" to add additional filters.

Available Optional Query Filters

Click to view the list of available optional query filters

Dimension	Description
Country	The country of the listener.
DMA	The listener's DMA (Designated Market Area), by name. Only applicable in the U.S.
DMA Code	The listener's DMA (Designated Market Area) code number. Only applicable in the U.S.
Device Family	The listener's device family, such as "Mobile Device" or "Smart Speaker." (See note, below.*)
MSA	The listener's MSA (Triton Metro Streaming Area). Only applicable in the U.S. (See MSA Usage Notes, below.)
MSA Code	The listener's MSA (Triton Metro Streaming Area) code number. Only applicable in the U.S. (See MSA Usage Notes, below.)
Region	The geographical region of the listener (such as the state or province). Not all countries have defined regions.
iTunes Subcategory	The subcategory label, as read from the RSS feed itunes:subcategory. If you have applied more than one subcategory to your podcast, Podcast Explore uses the first one you applied. For example, if you applied the subcategories Soccer, Football, and Baseball, in that order (within the Sports category), Podcast Explore uses Soccer. Note 1: If your program contains multiple RSS feeds using different subcategories, your metrics for that program will be split according to that number of subcategories. To avoid this, use the same subcategory for all RSS feeds from the same program. Note 2: If you are using Omny Studio, be sure to use the same subcategories at the Program level and the Playlist (podcast) level, to avoid splitting your metrics.
iTunes Category	The category label, as read from the RSS feed using itunes:category. If you have applied more than one category to your podcast, Podcast Explore uses the first one you applied. For example, if you applied the categories Fiction, Comedy, and Art, in that order, Podcast Explore uses Fiction. Note 1: If your program contains multiple RSS feeds using different categories, your metrics for that program will be split according to that number of categories. To avoid this, use the same category for all RSS feeds from the same program. Note 2: If you are using Omny Studio, be sure to use the same categories at the Program level and the Playlist (podcast) level, to avoid splitting your metrics.

Dimensions that originate from the listener's user agent might include some variability because user agents do not always return an exact match (i.e., a particular device or player might go by two or more different names).

Choosing a Date Range

Lineup Explore requires a date range. When you click the date range indicator the Date Range panel appears, where you can choose a range such as "Last 7 Days" or "Last Week," or specify a custom range. Click Apply or Apply and Run to apply the date range.

The date range and time dimension settings in Tap, Webcast Metrics, and Streaming Metrics are based on station timezone. Those settings in Tap Explore, Tap Affidavits, Podcast Explore, Lineup Explore, and ACPM Explore are based on UTC.

Click the Date Range indicator...
...the Date Range panel appears.
Select a date range preset or a custom range (minimum 1 week).
Click "Apply" or "Apply and Run."

Date range definitions

Preset	Definition
Last week	The previous week, from Monday to Sunday.
Last Month	The previous calendar month.
Last 4 weeks	The previous four calendar weeks (Monday to Sunday).

Tip: The Listener metric loses relevance and accuracy when compiled into a long report duration. If you choose a duration of more than 4 weeks, add a time dimension (week/month) to your query to break the results down into smaller chunks in order to get a more accurate Listener metric.

Adding/Selecting Dimensions

You can split your podcast metrics by up to six dimensions. Dimensions are selected in the Dimensions drop-down menu, similar to choosing dimensions in Podcast Explore.

If you list more than one dimension and the first in your list is time-based, the resulting data is sorted by that time dimension. Otherwise, data is sorted by downloads.

Available Dimensions

Click to view the list of available dimensions

Dimension	Description
Company Name	The sales representation name from the Lineup description.
Company Website	The sales representation website from the Lineup description.
Contact Email	The sales contact email address from the Lineup description.
Contact Name	The sales contact name from the Lineup description.
Country	The country of the listener.
DMA	The listener's DMA (Designated Market Area), by name. Only applicable in the U.S.
DMA Code	The listener's DMA (Designated Market Area) code number. Only applicable in the U.S.
Device Family	The listener's device family, such as "Mobile Device" or "Smart Speaker." (See note, below.*)
Lineup	Split metrics by selected lineups.
MSA	The listener's MSA (Triton Metro Streaming Area). Only applicable in the U.S. (See MSA Usage Notes, below.)
MSA Code	The listener's MSA (Triton Metro Streaming Area) code number. Only applicable in the U.S. (See MSA Usage Notes, below.)
Month	Split the metrics by the calendar month.
Owner	Owner of the lineup.
Program	The program. This is the top level of your podcast programming.
Region	The geographical region of the listener (such as the state or province). Not all countries have defined regions.
Week	Split the metrics by week (Monday to Sunday).
iTunes Category	The category label, as read from the RSS feed using itunes:category. If you have applied more than one category to your podcast, Podcast Explore uses the first one you applied. For example, if you applied the categories Fiction, Comedy, and Art, in that order, Podcast Explore uses Fiction. Note 1: If your program contains multiple RSS feeds using different categories, your metrics for that program will be split according to that number of categories. To avoid this, use the same category for all RSS feeds from the same program. Note 2: If you are using Omny Studio, be sure to use the same categories at the Program level and the Playlist (podcast) level, to avoid splitting your metrics.
iTunes Subcategory	The subcategory label, as read from the RSS feed itunes:subcategory. If you have applied more than one subcategory to your podcast, Podcast Explore uses the first one you applied. For example, if you applied the subcategories Soccer, Football, and Baseball, in that order (within the Sports category), Podcast Explore uses Soccer. Note 1: If your program contains multiple RSS feeds using different subcategories, your metrics for that program will be split according to that number of subcategories. To avoid this, use the same subcategory for all RSS feeds from the same program. Note 2: If you are using Omny Studio, be sure to use the same subcategories at the Program level and the Playlist (podcast) level, to avoid splitting your metrics.

Note:

Lineups can include "country" filters in which only data from selected countries appears in the lineup report. This is at the discretion of the publisher who creates and shares the lineup. Different buyers and agencies might see different data in the same lineup because of the way country filters are applied for each share. However, when a publisher views their own lineup in Lineup Explore, they see the data from all countries.

Using Run, Apply, and Apply and Run

There are several ways to apply changes in the query builder and to run the report. The option you choose depends on your context.

Item	Description
Run	The Run button appears in the Query Builder. Use it to submit changes and re-run a report after you change a filter or dimension. You can also use this button to run a report if you have closed the Selection Management Area without having clicked Apply and Run.
Apply	Click the Apply button in the Selection Management Area to apply your selection (filter or dimension) without running the report. Use this when you plan on adding several filters or dimensions. It saves you time because you don't have to wait for the report to generate before you select the next item.
Apply and Run	Use Apply and Run when you have selected the last item from the Selection Management Area and you are ready to run the report.

Saving and Scheduling Lineup Queries

Saved Podcast Explore queries.
Saved Lineup Explore queries.

Query ID and Metrics API

You can save and retrieve queries in Triton Streaming Explore, Podcast Explore, Lineup Explore, Tap Explore, and Tap Affidavit. Every saved query has a query ID that you can use to send the resulting data to your business intelligence (BI) applications via the Triton Metrics API.

Important! The Triton Metrics API can only access queries that were saved by the same user who created the queries. Be sure to log in with your Triton Metrics API access username before saving queries, and when you want to retrieve query IDs and use the API. For more information, see Using the Query ID and Metrics API.

MSA Usage Notes

MSA (Metro Streaming Area) is a Triton Digital-defined region for measuring demographics in the United States. It is used primarily for densely populated urban areas; not every address in the United States falls into a Triton MSA, and some addresses overlap into two Triton MSAs (such as some addresses in New York state which fall under both the New York MSA and the Nassau-Suffolk (Long Island) MSA).

To avoid duplicate data when using MSA in a report, you should either filter by MSA or split by MSA dimension, but not both (there is no deduplication process). Also, you should not aggregate MSA results, as you could be counting some listeners twice due to market boundaries that overlap.