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	Use in Adverity
Hour	hour	dimension
affiliate_id	affiliate_id	dimension
affiliate_name	affiliate_name	dimension
affiliate_payment_status	affiliate_payment_status	dimension
aov	aov	metric
aov_locale	aov_locale	dimension
average_order_value	average_order_value	metric
average_order_value_locale	average_order_value_locale	dimension
campaign_id	campaign_id	dimension
campaign_name	campaign_name	dimension
click_reference	click_reference	dimension
click_through_rate	click_through_rate	metric
click_through_rate_locale	click_through_rate_locale	metric
clicks	clicks	metric
clicks_locale	clicks_locale	metric
clickthru_time	clickthru_time	dimension
clickthru_time_locale	clickthru_time_locale	dimension
comment	comment	dimension
commission	commission	metric
commission_before_currency_conversion	commission_before_currency_conversion	metric
commission_id	commission_id	dimension
commission_locale	commission_locale	dimension
commission_status	commission_status	dimension
conversion_rate	conversion_rate	metric
conversion_rate_locale	conversion_rate_locale	metric
currency	currency	dimension
currency_conversion_rate	currency_conversion_rate	metric
date	date	dimension
date_locale	date_locale	dimension
device_os	device_os	dimension
ephc	ephc	metric
ephc_locale	ephc_locale	dimension
event_type	event_type	dimension
full_date	full_date	dimension
full_date_detail_level	full_date_detail_level	dimension
full_date_locale	full_date_locale	dimension
id	id	dimension
invoice_id	invoice_id	dimension
is_adjusted	is_adjusted	metric
landing_page	landing_page	dimension
locale	locale	dimension
merchant	merchant	dimension
merchant_payment_status	merchant_payment_status	dimension
month	month	dimension
n_sales	n_sales	metric
n_sales_locale	n_sales_locale	metric
number_commissions	number_commissions	metric
number_commissions_locale	number_commissions_locale	metric
order_reference	order_reference	metric
payment_status	payment_status	dimension
period	period	dimension
platform	platform	dimension
program_country	program_country	dimension
program_id	program_id	dimension
program_name	program_name	dimension
quarter	quarter	dimension
sale	sale	metric
sale_before_currency_conversion	sale_before_currency_conversion	metric
sale_date_time	sale_date_time	dimension
sale_date_time_locale	sale_date_time_locale	dimension
sale_locale	sale_locale	dimension
sales	sales	metric
sales_before_currency_conversion	sales_before_currency_conversion	metric
sales_locale	sales_locale	dimension
sales_referrer	sales_referrer	dimension
start_of_period	start_of_period	dimension
status	status	metric
status_change_date	status_change_date	dimension
status_change_date_locale	status_change_date_locale	dimension
tenancy_ref	tenancy_ref	dimension
totals.average_order_value	totals.average_order_value	metric
totals.click_through_rate	totals.click_through_rate	metric
totals.clicks	totals.clicks	metric
totals.clicks_locale	totals.clicks_locale	metric
totals.commission	totals.commission	metric
totals.commission_locale	totals.commission_locale	dimension
totals.conversion_rate	totals.conversion_rate	metric
totals.ephc	totals.ephc	metric
totals.n_sales	totals.n_sales	metric
totals.n_sales_locale	totals.n_sales_locale	metric
totals.sales	totals.sales	metric
totals.sales_locale	totals.sales_locale	dimension
totals.views	totals.views	metric
totals.views_locale	totals.views_locale	metric
transaction_country	transaction_country	dimension
transaction_id	transaction_id	dimension
transaction_voucher_code	transaction_voucher_code	dimension
views	views	metric
views_locale	views_locale	metric
weekOfYear	weekOfYear	dimension
year	year	metric