Advanced columns

Every table opens with a core set of columns. Advanced columns are everything else the table can show, from financial detail to the values a partner sent with the lead.

Open the picker with the column icon in the table header, then switch individual columns on and off. Your selection stays with you, so a table you have set up once opens the same way next time.

Column groups

Fields are grouped, because the full list is long. The groups always appear in the same order, in the picker and in the table, so a column sits in the same place in every report.

• Performance: clicks, leads, transactions, revenues, costs, and the metrics derived from them.
• Finance: payouts, margins, invoice data, and payment statuses.
• Categorization: tags, categories, countries, languages, and other classification fields.
• Entities: identifiers and names for affiliates, advertisers, offers, and everything related to them.
• Processing: the technical side. Source type (link, iframe, API), statuses, processing times, error codes, and similar.
• Data: the custom fields collected by your forms.

Performance metrics

The performance columns are laid out in four blocks, separated visually so you can tell at a glance which unit a number is in.

Totals

The plain counts and amounts for the selected period.

• Clicks, Leads, Transactions
• Costs: what you pay your partners
• Revenues: what the advertisers pay you
• Profit: revenues minus costs

Per lead

• CR: conversion rate from lead to transaction
• CPL: cost per lead
• EPL: earned per lead
• PPL: profit per lead

Per click

• CR: conversion rate from click to transaction
• CPC: cost per click
• EPC: earned per click
• PPC: profit per click

Per transaction

• ACV, average conversion value: revenue divided by the number of transactions. How much one conversion is worth.
• APV, average payout value: payout divided by the number of transactions. How much one conversion costs you.

Per lead and per click answer how well traffic converts. Per transaction answers how valuable a single conversion is, which is a different question and often moves in the opposite direction.

Columns in logs and the transactions report

Row level tables carry columns that make no sense in an aggregated report:

• affs1 to affs10 and adv1 to adv10, the custom values passed with the click or the lead
• Device, user agent, and referrer
• Value and coupon
• Commission ID, the commission that created the transaction
• Product

See Transactions report and Logs.

Hidden columns still work

A column does not have to be visible to be useful.

• You can filter by a column that is switched off. See Filters.
• You can export every available column, whether or not it is on screen. See Export.

This is how you keep a table readable while still working with the full dataset. Filter by country without adding a country column, then export everything when you need the detail.

For how each metric is calculated, see Columns explained.