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.

API name	Adverity UI name	Description	Use in Adverity
ad_id	ad_id	Unique identifier for an advertisement or creative used in a campaign. It is used to filter clicks or transactions related to a specific ad.	dimension
advertiser_id	advertiser_id	Unique identifier for the advertiser associated with a program or transaction.	dimension
advertiser_name	advertiser_name	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.	dimension
affiliatemarketing_id	affiliatemarketing_id	Unique identifier for the affiliate marketing campaign.	dimension
click_interval	click_interval	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.	metric
click_lead	click_lead	The number of clicks that have resulted in a lead. This metric helps in evaluating the effectiveness of campaigns in generating potential customer interest.	metric
click_raw	click_raw	The total number of raw clicks recorded for a given period or campaign, prior to any processing or filtering for duplicates or invalid clicks. This metric provides a foundational count of all click events.	metric
clickout_amount	clickout_amount	The total monetary amount generated from click-out events.	metric
clickout_raw	clickout_raw	The raw, unfiltered count of all click-out events.	metric
clickout_unique	clickout_unique	The count of unique click-out events, representing individual users who clicked out.	metric
cpc_amount	cpc_amount	The total monetary amount generated from Cost Per Click (CPC) events.	metric
cpc_raw	cpc_raw	The raw, unfiltered count of all Cost Per Click (CPC) events.	metric
cpc_unique	cpc_unique	The count of unique Cost Per Click (CPC) events, representing individual users.	metric
currency_code	currency_code	The ISO 4217 currency code used for monetary amounts (e.g., EUR, USD).	dimension
date	date	The date of an event, such as a click, transaction, or news item.	dimension
date_click	date_click	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.	dimension
date_transaction	date_transaction	The date when a transaction occurred.	dimension
device_browser	device_browser	The web browser used by the device associated with the transaction.	dimension
device_model	device_model	The model of the device used for the transaction.	dimension
device_platform	device_platform	The operating system or platform of the device used for the transaction.	dimension
device_type	device_type	The type of device used for the transaction (e.g., desktop, mobile, tablet).	dimension
ecpc	ecpc	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.	metric
end_date	end_date	The end date for a reporting period or the validity end date for an item.	dimension
ip	ip	The IP address associated with a click or transaction, often anonymized or hashed for privacy.	dimension
ip_country_name	ip_country_name	The country name derived from the IP address associated with a click or transaction.	dimension
media_id	media_id	Unique identifier for the media (e.g., website, app) where the ad was displayed or the click originated.	dimension
media_name	media_name	The name of the media channel or property.	dimension
modified_date	modified_date	The date and time when the record was last modified.	dimension
program_commission	program_commission	The commission earned from a program for a specific transaction.	metric
program_description	program_description	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.	dimension
program_id	program_id	Unique identifier for the affiliate program.	dimension
program_name	program_name	The name of the affiliate program.	dimension
publisher_commission	publisher_commission	The commission earned by the publisher for a specific transaction.	metric
publisher_description	publisher_description	A descriptive text providing details about the publisher.	dimension
publisher_name	publisher_name	The name of the publisher.	dimension
referer_click	referer_click	The referring URL from which a click originated.	dimension
revenue	revenue	The total revenue generated from a transaction or group of transactions.	metric
start_date	start_date	The start date for a reporting period or the validity start date for an item.	dimension
status	status	The current status of a transaction, media, or other record (e.g., approved, disapproved, open, active).	dimension
transaction_amount	transaction_amount	The total monetary value of a transaction, encompassing all parts.	metric
transaction_approved	transaction_approved	The count of transactions that have been approved.	metric
transaction_approved_amount	transaction_approved_amount	The total monetary amount of approved transactions.	metric
transaction_approved_parts	transaction_approved_parts	The number of approved parts within a transaction. Transactions can be composed of multiple parts (e.g., individual products in an order).	metric
transaction_disapproved	transaction_disapproved	The count of transactions that have been disapproved.	metric
transaction_disapproved_amount	transaction_disapproved_amount	The total monetary amount of disapproved transactions.	metric
transaction_disapproved_parts	transaction_disapproved_parts	The number of disapproved parts within a transaction.	metric
transaction_id	transaction_id	A unique identifier for a specific transaction. This ID is used to track individual sales or conversions generated through affiliate marketing efforts.	dimension
transaction_open_parts	transaction_open_parts	The number of open parts within a transaction, awaiting approval or disapproval.	metric
transaction_parts	transaction_parts	The total number of parts associated with a transaction. (Not directly found, but inferred from other ‘transaction_parts’ fields).	metric
transaction_revenue	transaction_revenue	The total revenue generated specifically from transactions.	metric
used_compensationcode	used_compensationcode	The compensation or promotion code used in a transaction.	dimension