Report filters

Filters are in the Reports («Отчёты») section, on the Builder («Конструктор») tab, under the Filters («Фильтры») button in the top row. The button shows the number of conditions. How to build the report itself is on the Report builder page.

General rules

• A condition is a field, an operator and a value.
• Conditions and groups are combined with AND: the report includes only what matches all of them at once.
• OR is available only inside a group.
• The report recalculates automatically after each filter change.
• A condition without a selected field is ignored.
• Filters apply to the table, the “Total” («Итого») row and CSV export.
• Filters are part of a saved report.
• The list has no fields that the admin has restricted for your account — see Forbidden report fields.

Limits:

• 64 conditions per report, counting conditions in groups;
• 16 groups;
• 2048 bytes per value — that is 2048 Latin characters or 1024 Cyrillic ones.

Adding a condition

1. Click Filters.
2. Click + Add filter («+ Добавить фильтр»).
3. Select a field in the — field — («— поле —») list.
4. Select an operator.
5. Enter a value.

The report recalculates after each step, so before you choose a value the table may show “No data for the period” («Нет данных за период»). When you change the field in a condition, the value is reset.

While there are no conditions or groups, the panel says “No filters — add a condition.” («Фильтров нет — добавьте условие.»)

The cross to the left of a condition deletes it. The Reset («Сбросить») button deletes all conditions outside groups; the groups themselves remain.

Fields

The field list is divided into four sections. The section determines which operators and values are available.

Data («Данные»)

Click attributes. There is no operator; the value is Yes («Да») or No («Нет»). A new condition has Yes selected. No keeps the other clicks.

Fields («Поля»)

Six fields are chosen from a list with search: Campaign («Кампания»), Campaign group («Группа кампании»), Offer («Оффер»), Landing page («Лендинг»), Source («Источник»), Country («Страна»). The operators are Equals («Равно») and Not equal («Не равно»); a new condition has Equals.

1. Start typing the name in the “start typing…” («начните вводить…») field.
2. Select a row in the list.

A long list is not shown in full: if the row you need is not there, type more letters. You can search for a country by name and by its two-letter code. How a campaign group gets into clicks is described in Group in reports.

The other fields are text fields: Region («Регион»), City («Город»), Device («Устройство»), OS («ОС»), OS version («Версия ОС»), Browser («Браузер»), Browser version («Версия браузера»), Device model («Модель устройства»), Language («Язык»), Connection («Соединение»), ISP / Provider («ISP / Провайдер»), User Agent, Referrer («Реферер»), IP, Subid (click id), External ID, Creative ID, Ad Campaign ID, Keyword («Ключевик»), Adset (name) («Adset (назв.)»), Ad (name) («Ad (назв.)»). All text operators are available for them.

• Device takes the values mobile, tablet, desktop, unknown.
• Connection takes the values hosting, vpn, tor, proxy; for a regular connection the field is empty.
• External ID, Creative ID, Ad Campaign ID, Keyword, Adset (name) and Ad (name) are filled from source tokens.

Metrics («Метрики»)

21 metrics: Clicks («Клики»), Uniq. («Уник.»), Bots («Боты»), LP clicks («LP клики»), LP CTR, Conversions («Конверсии»), Leads («Лиды»), Sales («Продажи»), Rej. («Отклон.»), Approval («Аппрув»), Cost («Расход»), Revenue («Доход»), Revenue (exp.) («Доход (ожид.)»), Profit («Прибыль»), Profit (exp.) («Прибыль (ожид.)»), ROI, ROI (exp.) («ROI (ожид.)»), CR, EPC, CPA, CPL. The value is a number. Custom metrics and conversion type columns are not in the list.

Parameters («Параметры»)

Sub ID 1 … Sub ID 30 — values of the click's sub_id_1 … sub_id_30 slots. These are text fields with the same operators. How values get into the slots is described on the Source tokens and link parameters page.

Text operators

A new condition has the Contains operator. You type the text in the “value” («значение») field.

Contains and Does not contain ignore the case of Latin letters: fb finds FB-1. The other operators are case-sensitive.

For Has value and No value, you do not enter a value. The condition Sub ID 3 No value keeps clicks where this parameter is empty.

A regular expression is matched anywhere in the value. To compare the whole value, put ^ at the start and $ at the end:

^(android|ios)-\d+$

Metric filters

A metric condition compares the calculated value in a report row with a number. Operators: >, ≥, <, ≤, =, ≠. A new condition has >.

• Enter a number in the “number” («число») field.
• Percentages are entered as a number without the % sign: ROI > 50 keeps rows with ROI above 50%.
• Money is in US dollars, as in the report columns.

A metric filter selects rows at the current groupings. When grouping by campaigns, the condition Clicks ≥ 100 keeps campaigns with at least 100 clicks for the period. Add a grouping by country, and the condition is checked for each “campaign and country” pair.

The “Total” row is calculated over all rows that passed the filter. Metric formulas are on the Report metrics and formulas page.

AND and OR groups

A group combines several conditions and sets how they are joined together: All conditions (AND) («Все условия (И)») or Any condition (OR) («Любое условие (ИЛИ)»). A group is joined with the other conditions and other groups through AND.

1. Add the conditions that should go into the group.
2. Click Combine conditions into an OR group («Собрать условия в группу ИЛИ»).

The button appears when at least one condition has a field selected. All conditions outside groups move to a new group with the Any condition (OR) logic. The group is shown as a frame with a number — “Group 1” («Группа 1») — and a list of conditions. Yes/No conditions are written in the group as Equals 1 (yes) or Equals 0 (no). Conditions added after that stay outside the group.

Group actions:

• The logic list switches the group between All conditions (AND) and Any condition (OR).
• Edit conditions («Редактировать условия») returns the group's conditions to the regular list and removes the group. Change them and click Combine conditions into an OR group again: the new group is created with the Any condition (OR) logic. The button is unavailable while there are other conditions outside groups.
• Delete group («Удалить группу») deletes the group together with its conditions.

Example: traffic from Germany or Austria, mobile devices only.

1. Add the condition Country Equals “Germany (DE)” («Германия (DE)»).
2. Add the condition Country Equals “Austria (AT)” («Австрия (AT)»).
3. Click Combine conditions into an OR group.
4. Add the condition Device Equals mobile.

Error messages

An error is shown in red under the report settings. Until it is fixed, the table is not shown.

Enter a finite number and choose a numeric operator in the metric filter («Введите конечное число и выберите числовой оператор в фильтре по метрике»)

The metric condition has no number. The message appears right after you select a metric and disappears once a number is entered. Enter a value or delete the condition.

filter "clicks" requires a finite number

A metric condition without a number was put into a group. The metric key is in quotes.

1. Click Edit conditions on the group.
2. Enter a number.
3. Click Combine conditions into an OR group.

OR cannot mix click fields and aggregate metrics; use separate groups

The OR group has both click fields and metrics. Split the conditions into two groups or switch the group to All conditions (AND).

invalid regular expression for "referer"

The regular expression could not be parsed. The quotes contain the key of the field whose condition has the error. Check matching brackets and the escaping of special characters. Lookahead and lookbehind — (?=…), (?!…), (?<=…) — and backreferences like \1 are not supported.

maximum 64 filters

The report has more than 64 conditions, counting conditions in groups. Delete the extra ones. The + Add filter button is unavailable when there are 64 conditions outside groups.

maximum 16 filter groups

The report has more than 16 groups. Delete an extra group.

filter value is too long

A condition value is longer than 2048 bytes. Shorten it.

The cost field or its source metrics are restricted by the admin («Поле cost или его исходные показатели ограничены администратором»)

The condition uses a field that the admin has restricted for your account. Instead of cost, the message contains the field key. Delete the condition with this field — see Restriction messages.