With Podcast Metrics > Lineup Explore you can create a variety of filtered reports for podcasts that have been made available through shared lineups. In Podcast Explore you can filter your query results by lineup, by selecting one or more lineups in the Content Filter.
Also see:
Lineup Explore is for podcast inventory planners, buyers, and agencies. It is not available to all Podcast Metrics users.
The on-screen report shows a maximum of 500 rows. Exported reports show a maximum of 100,000 rows.
The Lineup Explore Interface
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.
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 Query and the filter selector appears.
Click the date range and Date Range appears.
Report area: This is where the reports you create appear. The on-screen report shows a maximum of 500 rows.
Create Reports with the Query Builder
Go to Podcast Metrics > Lineups Explore then 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 Lineup Explore Report
This example shows podcast statistics for three dimensions, sorted by Downloads.
Select Lineups
Select 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.
Select Apply or Apply and Run.
Optional: Select Add new to add more filters.
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." User agents do not always return an exact match. For example, a particular device or player might go by two or more different names. |
MSA | The listener's Metro Streaming Area. Only applicable in the U.S. See MSA Usage Notes, below. |
MSA Code | The listener's 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. 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. 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. 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. 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. |
Choose a Date Range
Lineup Explore requires a date range. When you select 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. Select Apply or Apply and Run to apply the date range.
Improve report accuracy
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 smaller time dimension to your query to break the results down into smaller chunks in order to get a more accurate Listener metric.
Date ranges and timezones
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.
Select the date range.
The Date Range panel appears.
Select a date range preset or a custom range, minimum 1 week.
Select 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). |
Add and Select 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.
By default, data is sorted by Downloads. 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.
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.
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." User agents do not always return an exact match. For example, a particular device or player might go by two or more different names. |
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. 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. 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. 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. 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. |
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. |
MSA Usage Notes
Metro Streaming Area (MSA) 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.