Webgains: Most-used fields

A unique identifier for the affiliate (publisher) involved in the transaction or performance data.

The name of the affiliate (publisher) associated with the transaction or performance data.

The current payment status of the commission for the affiliate, reflecting the stage of the payment process for a transaction.

A unique identifier for the specific marketing campaign.

The name of the marketing campaign.

A unique identifier or reference associated with a click that led to a transaction.

The date and time when the user clicked through the affiliate link, provided as a UNIX timestamp (click_through_date).

The date and time when a user clicked through an affiliate link, presented in a localized format. This corresponds to the event of a click on an advertisement or promotional material.

Additional notes or remarks associated with a specific transaction. This field provides supplementary information at the individual transaction level.

The amount of commission earned for a transaction.

A unique identifier for a specific commission generated.

The amount of commission generated from a transaction, presented in a format specific to a given locale.

The current status of the commission (e.g., confirmed, delayed, cancelled).

The currency code used for monetary values in the report, such as 'EUR' or 'USD'.

A unique identifier for the customer associated with the transaction, if available. For example, 'CUSTOMER123'.

The date when a transaction or event occurred. For incremental logic, this refers to the transaction date.

The date of a specific event or transaction, formatted according to a given locale.

The date when the commission for the transaction was paid out, as implied by the transaction payment status.

The operating system of the device used for the transaction. This field is collected as part of additional custom tracking data.

The type of event, such as CPA (Cost Per Action) or CPC (Cost Per Click).

The complete date of the event or transaction.

A unique identifier, often referring to a transaction ID.

A unique identifier for the invoice generated for affiliate earnings.

Indicates whether the transaction or commission has been adjusted (e.g., updated amounts, confirmed, cancelled).

The URL of the landing page where the user arrived after clicking the affiliate link (click_target).

The geographical and language locale associated with the data.

The advertiser or merchant associated with the affiliate program or transaction.

The current status of the payment from the merchant for a given transaction, such as 'confirmed', 'delayed', or 'cancelled'.

A unique reference number provided by the merchant for the specific order or transaction.

The overall payment status of the transaction.

The platform or device type (e.g., desktop, mobile) from which the click or transaction originated (device_type).

The country where the affiliate program is based or primarily targeted.

A unique identifier for the affiliate program.

The name of the affiliate program.

The type of reward or commission generated by a transaction or event, such as Cost Per Action (CPA) or Cost Per Click (CPC).

The monetary value of the sale associated with the transaction.

The date and time when the sale occurred (date).

The exact date and time a sale was recorded, formatted according to a specific locale.

The monetary value of the sale, presented in a format specific to a given locale.

The source or referrer that drove the sale, such as a specific website or ad campaign (click_source).

The general status of the transaction (e.g., confirmed, delayed, cancelled).

The date when the status of the transaction last changed (status_changed_date).

The date when the status of a transaction (e.g., confirmed, delayed, cancelled) was last updated, formatted according to a specific locale.

The country where the transaction occurred.

A unique identifier for the transaction.

Any voucher or coupon code applied during the transaction.