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 |