Filters

Filters narrow down the data shown in tables, reports, and logs. PalDock has two of them.

  • Large filter: a full filter with a field, an operator, and a value. Use it for anything beyond a single column.
  • Small filter: a quick filter applied straight to one column, shown inline in the table.

Large filter

Click the filter button and a submenu opens with the first empty row ready to fill in.

Each row has three parts:

  • Field: what you are filtering. Fields are grouped into categories, because the list is long.
  • Operator: contains, equals, and so on. Which operators are offered depends on the field type.
  • Value: one value or several, again depending on the field type.

Every row you add narrows the result further. Rows can be removed one by one, or cleared all at once.

Small filter

The small filter belongs to a single column and sits in the table itself. It is meant for quick lookups rather than analysis.

Some tables offer only this one. In Offers, List for example, filtering is done through the small filter on selected columns.

You do not have to show a column to filter by it

Tables can be filtered by:

  • Displayed columns
  • Hidden columns
  • Metrics that are not available as columns at all

This matters most in reports, where you often want to restrict the data without adding another column to an already wide table. Filtering by country, tag, or transaction type works the same whether that column is on screen or not.

What you can filter by

Beyond the columns of the report itself, the same set of filters is available across reports, logs, and the transactions report:

  • Advertiser, offer, affiliate
  • Transaction type: prospect, sale, or a custom type
  • Origin type: click or lead
  • Source type: link, iframe, or API
  • Category
  • Tags: on affiliates, offers, and advertisers
  • Offer country and affiliate country
  • affs1 to affs10 and adv1 to adv10, the custom values passed with the click or the lead

The custom values are most useful in the logs and in the Transactions report, where you are looking at individual rows. In aggregated reports they can produce a very long list of values, since anything the partner sends ends up there.

Filters built into each report

Every report also carries the filters that make sense for what it groups by:

  • Performance report: advertiser
  • Affiliate report: offer
  • Advertiser report: affiliate, offer
  • Offer report: affiliate, advertiser
  • Pingtree report: no additional filter

What partners can filter

Affiliates and advertisers use the same reports as you, with two limits.

  • They see only their own data. A filter never widens that.
  • Affiliates cannot filter by channel. Which channel bought a lead is not something a partner is shown, so that filter is not available to them.

Not the same as offer filters

Report filters only change what you see. The filters on an offer decide whether a lead is processed at all. The two look similar and do entirely different things.

Insights that
helps you grow

  • Release notes 2026/08/14
    This was a big one. We went through roughly 200 pages of our knowledge base and rewrote the whole thing. Clearer structure, consistent terminology, and…
  • Release notes 2026/07/31
    What’s new in PalDock? A lot of this month went into things you won’t see directly – query optimisation, indexing, and general tuning under the…
  • Free Affiliate tracking software
    Many companies (inlcuding YOU) search for free affiliate tracking software because they want to launch an affiliate program without committing to expensive monthly fees. The…