Webgains: Most-used fields

The table below gives information about most-used fields that you can import from Webgains. 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
affiliate_id	affiliate_id	A unique identifier for the affiliate (publisher) involved in the transaction or performance data.	metric
affiliate_name	affiliate_name	The name of the affiliate (publisher) associated with the transaction or performance data.	dimension
affiliate_payment_status	affiliate_payment_status	The current payment status of the commission owed to the affiliate.	dimension
aov	aov	The Average Order Value, calculated as total sales divided by the number of orders.	metric
aov_locale	aov_locale		dimension
campaign_id	campaign_id	A unique identifier for the specific marketing campaign.	metric
campaign_name	campaign_name	The name of the marketing campaign.	dimension
click_reference	click_reference	A unique reference ID for a specific click-through event.	dimension
click_through_rate	click_through_rate	The Click-Through Rate, calculated as clicks divided by views, expressed as a percentage.	metric
click_through_rate_locale	click_through_rate_locale		metric
clicks	clicks	The total number of clicks recorded for the period or grouping.	metric
clicks_locale	clicks_locale	The geographical or language locale associated with a specific click event or a group of clicks, as reported in the Publisher Performance data.	dimension
clickthru_time	clickthru_time	The date and time when the user clicked on an affiliate link.	dimension
clickthru_time_locale	clickthru_time_locale		dimension
comment	comment	Additional comments or notes related to a transaction.	dimension
commission	commission	The amount of commission earned for a transaction.	metric
commission_before_currency_conversion	commission_before_currency_conversion	The commission amount before any currency conversion is applied.	metric
commission_id	commission_id	A unique identifier for a commission entry.	dimension
commission_locale	commission_locale		dimension
commission_status	commission_status	The current status of the commission (e.g., confirmed, delayed, cancelled).	dimension
conversion_rate	conversion_rate	The Conversion Rate, calculated as sales divided by clicks, expressed as a percentage.	metric
conversion_rate_locale	conversion_rate_locale		metric
currency	currency	The currency code used for monetary values in the report, such as ‘EUR’ or ‘USD’.	dimension
currency_conversion_rate	currency_conversion_rate	The exchange rate used for converting currency values.	metric
date	date	The date of the transaction or event.	dimension
date_locale	date_locale		dimension
date_paid	date_paid	The date when the commission or payment was processed.	dimension
device_os	device_os	The operating system of the device used for the click or transaction.	dimension
ephc	ephc	Earnings Per Hundred Clicks (EPHC), a metric indicating the average earnings generated for every 100 clicks.	metric
ephc_locale	ephc_locale		dimension
event_type	event_type	The type of event, such as CPA (Cost Per Action) or CPC (Cost Per Click).	dimension
full_date	full_date	The complete date of the transaction or event.	dimension
full_date_detail_level	full_date_detail_level	The level of detail for the full date (e.g., day, month, hour).	dimension
full_date_locale	full_date_locale		dimension
hour	hour	The hour of the day when an event occurred, used for grouping data in activity reports.	dimension
id	id	A unique identifier, often referring to a transaction ID.	metric
invoice_id	invoice_id	A unique identifier for the invoice generated for affiliate earnings.	dimension
is_adjusted	is_adjusted	Indicates whether the transaction or commission has been adjusted (e.g., updated amounts, confirmed, cancelled).	metric
landing_page	landing_page	The URL of the landing page where the user arrived after clicking an affiliate link.	dimension
link	link	The tracking link associated with the click-through or transaction.	dimension
locale	locale	The geographical and language locale associated with the data.	dimension
merchant	merchant	The name of the merchant (advertiser) for the program.	dimension
merchant_payment_status	merchant_payment_status	The payment status from the merchant’s perspective for the transaction.	dimension
month	month	The month of the year for the transaction or event, used for grouping data.	dimension
n_sales	n_sales	The total number of sales (transactions) recorded.	metric
n_sales_locale	n_sales_locale		metric
order_reference	order_reference	A unique identifier or reference code for the customer’s order.	dimension
payment_status	payment_status	The general payment status of a transaction or commission.	dimension
platform	platform		dimension
program_country	program_country	The country where the affiliate program operates.	dimension
program_id	program_id	A unique identifier for the affiliate program.	dimension
program_name	program_name	The name of the affiliate program.	dimension
quarter	quarter	The quarter of the year for the transaction or event, used for grouping data.	dimension
sale	sale	The monetary value of the sale associated with the transaction.	metric
sale_before_currency_conversion	sale_before_currency_conversion	The value of a single sale before any currency conversion is applied.	metric
sale_date_time	sale_date_time	The date and time when the sale occurred.	dimension
sale_date_time_locale	sale_date_time_locale		dimension
sale_locale	sale_locale		dimension
sales	sales	The total monetary value of all sales for the period or grouping.	metric
sales_before_currency_conversion	sales_before_currency_conversion	The total monetary value of all sales before any currency conversion is applied.	metric
sales_locale	sales_locale		dimension
sales_referrer	sales_referrer	The referring URL or source that led to the sale.	dimension
start_of_period	start_of_period	The start date and time of the reporting period.	dimension
status	status	The general status of the transaction (e.g., confirmed, delayed, cancelled).	dimension
status_change_date	status_change_date	The date when the status of the transaction or commission last changed.	dimension
status_change_date_locale	status_change_date_locale		dimension
totals.average_order_value	totals.average_order_value	The total average order value across all transactions in the report.	metric
totals.click_through_rate	totals.click_through_rate	The total click-through rate across all activities in the report.	metric
totals.clicks	totals.clicks	The total number of clicks across all activities in the report.	metric
totals.clicks_locale	totals.clicks_locale	The aggregated count or value of clicks attributed to a specific geographical or language locale within the Publisher Performance report.	dimension
totals.commission	totals.commission	The total commission earned across all transactions in the report.	metric
totals.commission_locale	totals.commission_locale		dimension
totals.conversion_rate	totals.conversion_rate	The total conversion rate across all activities in the report.	metric
totals.ephc	totals.ephc	The total earnings per hundred clicks across all activities in the report.	metric
totals.n_sales	totals.n_sales	The total number of sales across all transactions in the report.	metric
totals.n_sales_locale	totals.n_sales_locale		metric
totals.sales	totals.sales	The total monetary value of all sales across the report.	metric
totals.sales_locale	totals.sales_locale		dimension
totals.views	totals.views	The total number of views or impressions across all activities in the report.	metric
totals.views_locale	totals.views_locale		metric
transaction_country	transaction_country	The country where the transaction took place.	dimension
transaction_id	transaction_id	A unique identifier for the transaction.	dimension
transaction_voucher_code	transaction_voucher_code	The voucher or coupon code used in the transaction.	dimension
views	views	The number of views or impressions recorded for the period or grouping.	metric
views_locale	views_locale		metric
website	website	The website where the click or transaction originated.	dimension
weekOfYear	weekOfYear	The week number of the year for the transaction or event, used for grouping data.	dimension
year	year	The year of the transaction or event, used for grouping data.	dimension