Mediamath walkthrough

Pulling data from Mediamath

Choose an aggregated report.
A loading sign indicates the report settings are ready after choosing the aggregated report.

Dimensions are entities or attributes of the report. You must select at least one dimension.
Metrics are calculated fields, such as sums or averages.

These fields are a numeric data type. Leave this input empty to get all metrics or select the necessary fields.

If you cannot switch between predefined and custom time periods, the report only supports predefined time periods.

All the aggregated reports support a predefined time period.

Custom time period: When available, select Custom and configure the time period type. Some reports also support a custom time period. For example, Yesterday or last week.

To select a date range:

Select the start date and end date.
Leave the end date empty to pull data until the river runs.
After each run of the river, the start date updates automatically with the end date, and the end date updates with the empty value. This enables the next run to pull data from the end of the previous run.
Select the time zone offset. It is relevant only if the end date is empty to find the river’s run according to the time zone.
Use Days back to pull data from the days before the start date. :::

To select any other value (not Date range):

Select the timezone offset to send the correct dates that consider that offset. Time Rollups indicates the available grouping options.

For example:

By week: group rows by the week (week starts on Monday).
By month: group rows by the month.
All: produces at most one row of output per combination of dimension fields chosen.

You can use filters under Advanced Options to refine report data.

The filter parameter lets you filter against the dimensions only, and is performed before row grouping. The Having parameter lets you filter against the metrics only. It is performed after row grouping and metric calculation.

Operators supported in filtering expressions	Operators	Operation	Field Data Type
=, !=	equality, non-equality	check	all
>, <, >=, <=	inequality	check	numeric
, =	contains	case sensitive	string
=:	contains	case insensitive	string
!	does not contain	case sensitive	string
!:	does not contain	case insensitive	string

You can combine multiple filtering conditions joined by an "&"—logical and (logical or is not supported).

Encoding special characters

The following predicates require special encoding:

" ! :

The encoding is a simple two-step process.

For example,