BigCommerce: Most-used fields

The table below gives information about most-used fields that you can import from BigCommerce. 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
accepts_product_review_abandoned_cart_emails	accepts_product_review_abandoned_cart_emails	dimension
authentication.force_password_reset	authentication.force_password_reset	dimension
base_handling_cost	base_handling_cost	metric
base_shipping_cost	base_shipping_cost	metric
base_wrapping_cost	base_wrapping_cost	metric
billing_address.city	billing_address.city	dimension
billing_address.company	billing_address.company	dimension
billing_address.country	billing_address.country	dimension
billing_address.country_iso2	billing_address.country_iso2	dimension
billing_address.email	billing_address.email	dimension
billing_address.first_name	billing_address.first_name	dimension
billing_address.form_fields	billing_address.form_fields	dimension
billing_address.last_name	billing_address.last_name	dimension
billing_address.phone	billing_address.phone	metric
billing_address.state	billing_address.state	dimension
billing_address.street_1	billing_address.street_1	dimension
billing_address.street_2	billing_address.street_2	dimension
billing_address.zip	billing_address.zip	metric
cart_id	cart_id	dimension
channel_id	channel_id	dimension
channel_ids	channel_ids	dimension
company	company	dimension
coupon_discount	coupon_discount	metric
credit_card_type	credit_card_type	dimension
currency_code	currency_code	dimension
currency_exchange_rate	currency_exchange_rate	metric
currency_id	currency_id	dimension
customer_group_id	customer_group_id	dimension
customer_id	customer_id	dimension
customer_locale	customer_locale	dimension
customer_message	customer_message	dimension
date_created	date_created	dimension
date_modified	date_modified	dimension
date_shipped	date_shipped	dimension
default_currency_code	default_currency_code	dimension
default_currency_id	default_currency_id	dimension
discount_amount	discount_amount	metric
email	email	dimension
external_id	external_id	dimension
external_order_id	external_order_id	dimension
external_source	external_source	dimension
fees	fees	dimension
first_name	first_name	dimension
geoip_country	geoip_country	dimension
geoip_country_iso2	geoip_country_iso2	dimension
gift_certificate_amount	gift_certificate_amount	metric
handling_cost_ex_tax	handling_cost_ex_tax	metric
handling_cost_inc_tax	handling_cost_inc_tax	metric
handling_cost_tax	handling_cost_tax	metric
handling_cost_tax_class_id	handling_cost_tax_class_id	dimension
id	id	dimension
ip_address	ip_address	dimension
ip_address_v6	ip_address_v6	dimension
is_deleted	is_deleted	dimension
is_email_opt_in	is_email_opt_in	dimension
is_tax_inclusive_pricing	is_tax_inclusive_pricing	dimension
items_shipped	items_shipped	metric
items_total	items_total	metric
last_name	last_name	dimension
notes	notes	dimension
order_is_digital	order_is_digital	dimension
order_source	order_source	dimension
origin_channel_id	origin_channel_id	dimension
payment_method	payment_method	dimension
payment_provider_id	payment_provider_id	dimension
payment_status	payment_status	dimension
phone	phone	dimension
refunded_amount	refunded_amount	metric
registration_ip_address	registration_ip_address	dimension
shipping_address_count	shipping_address_count	metric
shipping_cost_ex_tax	shipping_cost_ex_tax	metric
shipping_cost_inc_tax	shipping_cost_inc_tax	metric
shipping_cost_tax	shipping_cost_tax	metric
shipping_cost_tax_class_id	shipping_cost_tax_class_id	dimension
status	status	dimension
status_id	status_id	dimension
store_credit_amount	store_credit_amount	metric
store_default_currency_code	store_default_currency_code	dimension
store_default_to_transactional_exchange_rate	store_default_to_transactional_exchange_rate	metric
subtotal_ex_tax	subtotal_ex_tax	metric
subtotal_inc_tax	subtotal_inc_tax	metric
subtotal_tax	subtotal_tax	metric
tax_exempt_category	tax_exempt_category	dimension
tax_provider_id	tax_provider_id	dimension
total_ex_tax	total_ex_tax	metric
total_inc_tax	total_inc_tax	metric
total_tax	total_tax	metric
wrapping_cost_ex_tax	wrapping_cost_ex_tax	metric
wrapping_cost_inc_tax	wrapping_cost_inc_tax	metric
wrapping_cost_tax	wrapping_cost_tax	metric
wrapping_cost_tax_class_id	wrapping_cost_tax_class_id	dimension