Custom Field

Partner Vertical

Program

Publisher

Publisher Code

Publisher Group

Publisher Name

Average amount of order

CA – Chiffre d'affaires (turnover), derived as Revenue + Revenue Refused.

Clicks

Commission

Cost fees

Cost transactions

Displays

Fees – Publisher-specific fixed fees or bonuses as single values.

Leads

Leads Post Click

Leads Post Click Refused

Leads Post View

Leads Post View Refused

Leads Refused

Revenue

Revenue Post Click

Revenue Post View

Revenue Refused

Royalties – Royalties monetary amount, computed per row as royalty rate x commission (cost_transactions + cost_fee, confirmed by Effinity). Materialised in the transform so it sums correctly at any grain.

Royalty Rate – Non-aggregatable.
Royalty rate applied to the program/advertiser (e.g. 0.2 = 20%), not a monetary amount. Varies per advertiser. Multiply by turnover to get the Royalties value.

Sales

Sales Post Click

Sales Post Click Refused

Sales Post View

Sales Post View Refused

Sales Refused

Unique Clicks

Unique Displays