Daisycon: Most-used fields#
The table below gives information about most-used fields that you can import from Daisycon. Other fields might also be available in Adverity.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.
ad_id Dimension
Unique identifier for an advertisement or creative used in a campaign. It is used to filter clicks or transactions related to a specific ad.
advertiser_id Dimension
Unique identifier for the advertiser associated with a program or transaction.
advertiser_name Dimension
The name of the advertiser associated with the campaign or program. This identifies the brand or company for whom the affiliate marketing activities are performed.
affiliatemarketing_id Dimension
Unique identifier for the affiliate marketing campaign.
click_interval Dimension
This field represents the time interval over which click data is measured and reported. Data can be aggregated by various time dimensions such as date or hour.
click_lead Metric
The number of clicks that have resulted in a lead. This metric helps in evaluating the effectiveness of campaigns in generating potential customer interest.
clickout_amount Metric
The total monetary amount generated from click-out events.
clickout_raw Metric
The raw, unfiltered count of all click-out events.
clickout_unique Metric
The count of unique click-out events, representing individual users who clicked out.
cpc_amount Metric
The total monetary amount generated from Cost Per Click (CPC) events.
cpc_raw Metric
The raw, unfiltered count of all Cost Per Click (CPC) events.
cpc_unique Metric
The count of unique Cost Per Click (CPC) events, representing individual users.
currency_code Dimension
The ISO 4217 currency code used for monetary amounts (e.g., EUR, USD).
date Dimension
The date of an event, such as a click, transaction, or news item.
date_click Dimension
The date and time when a click occurred, leading to a transaction. This field is used to track the timing of user interactions with affiliate links.
date_transaction Dimension
The date when a transaction occurred.
device_browser Dimension
The web browser used by the device associated with the transaction.
device_model Dimension
The model of the device used for the transaction.
device_platform Dimension
The operating system or platform of the device used for the transaction.
device_type Dimension
The type of device used for the transaction (e.g., desktop, mobile, tablet).
disapproved_reason Dimension
The reason provided by the advertiser for disapproving a transaction. This field indicates why a transaction was rejected during the validation process, providing transparency for both advertisers and publishers.
ecpc Metric
This field represents the effective Cost Per Click (eCPC), which indicates the average cost incurred for each click in advertising campaigns. It is available within statistics reports.
end_date Dimension
The end date for a reporting period or the validity end date for an item.
ip Dimension
The IP address associated with a click or transaction, often anonymized or hashed for privacy.
ip_country_name Dimension
The country name derived from the IP address associated with a click or transaction.
media_id Dimension
Unique identifier for the media (e.g., website, app) where the ad was displayed or the click originated.
media_name Dimension
The name of the media channel or property.
modified_date Dimension
The date and time when the record was last modified.
program_commission Metric
The commission earned from a program for a specific transaction.
program_description Dimension
A detailed description of the affiliate program, providing information about its goals, offerings, and terms for consumers. This field is available through the advertisers API.
program_id Dimension
Unique identifier for the affiliate program.
program_name Dimension
The name of the affiliate program.
publisher_commission Metric
The commission earned by the publisher for a specific transaction.
publisher_description Dimension
A descriptive text providing details about the publisher.
publisher_name Dimension
The name of the publisher.
referer_click Dimension
The referring URL from which a click originated.
revenue Metric
The total revenue generated from a transaction or group of transactions.
start_date Dimension
The start date for a reporting period or the validity start date for an item.
status Dimension
The current status of a transaction, media, or other record (e.g., approved, disapproved, open, active).
transaction_amount Metric
The total monetary value of a transaction, encompassing all parts.
transaction_approved Metric
The count of transactions that have been approved.
transaction_approved_amount Metric
The total monetary amount of approved transactions.
transaction_approved_parts Metric
The number of approved parts within a transaction. Transactions can be composed of multiple parts (e.g., individual products in an order).
transaction_disapproved Metric
The count of transactions that have been disapproved.
transaction_disapproved_amount Metric
The total monetary amount of disapproved transactions.
transaction_disapproved_parts Metric
The number of disapproved parts within a transaction.
transaction_id Dimension
A unique identifier for a specific transaction. This ID is used to track individual sales or conversions generated through affiliate marketing efforts.
transaction_open_parts Metric
The number of open parts within a transaction, awaiting approval or disapproval.
transaction_parts Metric
The total number of parts associated with a transaction. (Not directly found, but inferred from other 'transaction_parts' fields).
transaction_revenue Metric
The total revenue generated specifically from transactions.
used_compensationcode Dimension
The compensation or promotion code used in a transaction.