Crear informes

Puede buscar hasta 13 meses de datos (hasta ayer). Use the Query builder to set a date range, and select one or more Filters, such as station or advertiser. You also determine the layout and breakdown of the report by choosing one or more Dimensions (to a maximum of six).

Create a Report

1. Seleccione un tipo de informe.

2. In Filters, choose at least one filter and the date range.
   If you manage more than one publisher, use the first filter to select the publisher you want. Si administra solo uno, ese publisher queda seleccionado de manera predeterminada y no puede cambiarlo.

3. Seleccione una o más dimensiones (hasta un máximo de seis). Si seleccionó Impresiones o Spots - CPS como tipo de informe, también puede seleccionar Métricas.
   Elija las dimensiones en la lista desplegable. Las dimensiones se van agregando en el orden en que las selecciona.

4. Haga clic en Ejecutar.

5. View the report in the Report area. The on-screen report area is a quick view of your report, with a limit of 500 lines.

6. Optional: Save your query and set it to run on a schedule.

7. Optional: Export the report as an Excel (.xlsx) or .csv file to see the full results, up to 100,000 lines.

Choose a Date Range

The date range and time dimension settings in TAP, Webcast Metrics, Streaming Metrics, and Royalty Reports are based on station timezone. Those settings in TAP Explore, TAP Affidavits, Podcast Explore, Lineup Explore, and TAP Segment PoP Report are based on UTC.

TAP Explore retains data for up to 13 months. Use the custom date range settings to retrieve this data. You must enter a start date and an end date, and the custom date range cannot exceed six months. In other words, you can select a range of up to six months from any time within the previous 13 months. Exception: TAP Explore retains only seven days' data for the dimension Date Hour.

If you want a report from beyond the previous 13 months, contact Triton Digital Customer Support. (Es posible que se aplique un cargo adicional).

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. Haga clic en Aplicar o en Aplicar y ejecutar para aplicar el intervalo de fechas.

Notas de uso de MSA

MSA (Metro Streaming Area) es una región definida por Triton Digital para medir la demografía en los Estados Unidos. Se utiliza principalmente para áreas urbanas densamente pobladas; no todas las direcciones en los Estados Unidos caen dentro de un MSA Triton, y algunas direcciones se superponen en dos MSA de Triton (como algunas direcciones en el estado de Nueva York que caen bajo el MSA de Nueva York y el MSA de Nassau-Suffolk (Long Island)).

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). Además, no debe agregar los resultados de MSA, ya que podría estar contando a algunos oyentes dos veces debido a los límites del mercado que se superponen.

Uso de Run, Apply y Apply and Run

TAP Explore Query-building Notes

• Si cambia de una selección de tipo de informe a otra, se restablecen todos los filtros y dimensiones.

• Puede restablecer manualmente la configuración haciendo clic en Restablecer. Be careful, there is no undo.

  

• When you add a filter, the filter's selection defaults to the selection you used the last time you used that filter. For example, if you add a City filter for Boston, the next time you choose the City filter, Boston will be automatically selected. It is very easy to change the selection.

• To edit a filter, click it and make your changes in the Filter panel, which appears on the right side of the screen. Click Apply to save the changes.

• To remove a filter or dimension, click the X on the item's button. If you have only one filter or dimension selected, there is no X because there must always be at least one filter/dimension. To remove that item, click it and change it to a different item in Filter or Dimensions.

Consejos y mejores prácticas

TAP Explore provides a variety of dimensions and metrics combinations. Para obtener los mejores resultados, intente limitar el alcance de sus informes a una cobertura razonable; de lo contrario, el rendimiento podría verse afectado. Los siguientes consejos y mejores prácticas deberían ayudarle a evitar problemas de rendimiento.

• To run a RON (run of network) report, select the publisher but do not filter by any stations.

• Use filters to reduce the amount of data to be queried. For example, run your report for a single campaign or a selected group of campaigns instead of all campaigns; this will make the report run faster if you have many campaigns booked in TAP.

• Use shorter date ranges when possible. Una selección amplia de un intervalo de fechas podría afectar al rendimiento del informe.

• A 24 hour delay applies: you can only query data that is at 24 hours old.

• A maximum of 500 rows are displayed in the on-screen report results section. If you need more than 500 rows of results, export the report to see the full range of data, up to 100,000 lines.

• Reports with high row counts that include large numbers of dimensions and/or metrics may fail to export successfully. Si esto ocurre, reduzca la complejidad del informe incluyendo menos dimensiones y/o métricas, o acortando el rango de fechas, y luego intente exportar nuevamente.

• You can add a maximum of six dimensions to a query.

• Keep your report as simple as possible to achieve the results you're looking for. A medida que agrega más dimensiones y métricas a sus consultas, aumenta la complejidad del informe, lo que aumenta la probabilidad de latencia o error.

• Avoid double-counting report totals. Tenga en cuenta que algunas dimensiones pueden representar el mismo evento más de una vez. Por ejemplo, una impresión individual puede estar asociada tanto con TTag como con un segmento de audiencia (DMP). Si crea un informe usando ambas dimensiones, la impresión individual será contada dos veces. Por esta razón, y para evitar la duplicación, tenga cuidado con las dimensiones que elige y no sume las columnas métricas. This is why there is no Totals row for reports that include dimensions where this is possible.

• Example: Flight number 1234 targets three DMP segments; Female 18-24 AND Car enthusiast AND Avid gamer. The flight received 250 impressions. If you create a report that includes the DMP segment dimension, the result will be like the table below. This represents only 250 impressions, but if you sum the Total Impressions column it will appear to be 750 impressions.

  Vuelo	Segmento DMP	Impresiones totales
  1234	Mujer 18-24	250
  1234	Amante de los autos	250
  1234	Jugador ávido	250

• Las dimensiones de desglose de hora se muestran en los husos horarios de las estaciones. The report shows the sum of all impressions delivered per-station in their time zone for the selected time breakdown such as month.

• TAP Explore cannot create a useful report for every possible combination of report type and dimensions. A later release will include validations to prevent you from creating badly formed reports, but for now it is up to you to use caution. If a report takes an unusually long time to generate, or if the results are missing or seem inaccurate, please reduce the scope of your query and try again.