WooCommerce: Most-used fields

The table below gives information about most-used fields that you can import from WooCommerce. 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
average_sales	average_sales	metric
billing_address_1	billing_address_1	dimension
billing_address_2	billing_address_2	dimension
billing_city	billing_city	dimension
billing_company	billing_company	dimension
billing_country	billing_country	dimension
billing_email	billing_email	dimension
billing_first_name	billing_first_name	dimension
billing_last_name	billing_last_name	dimension
billing_phone	billing_phone	metric
billing_postcode	billing_postcode	dimension
billing_state	billing_state	dimension
cart_tax	cart_tax	metric
coupon_lines_code	coupon_lines_code	dimension
coupon_lines_discount	coupon_lines_discount	metric
coupon_lines_discount_tax	coupon_lines_discount_tax	metric
coupon_lines_discount_type	coupon_lines_discount_type	dimension
coupon_lines_free_shipping	coupon_lines_free_shipping	dimension
coupon_lines_id	coupon_lines_id	dimension
coupon_lines_meta_data	coupon_lines_meta_data	dimension
created_via	created_via	dimension
currency	currency	dimension
customer_id	customer_id	dimension
customer_ip_address	customer_ip_address	dimension
customer_note	customer_note	dimension
customer_user_agent	customer_user_agent	dimension
customers	customers	metric
date	date	dimension
date_completed	date_completed	dimension
date_completed_gmt	date_completed_gmt	dimension
date_created	date_created	dimension
date_created_gmt	date_created_gmt	dimension
date_max	date_max	dimension
date_min	date_min	dimension
date_modified	date_modified	dimension
date_modified_gmt	date_modified_gmt	dimension
date_paid	date_paid	dimension
discount	discount	metric
discount_tax	discount_tax	metric
discount_total	discount_total	metric
domain_name	domain_name	dimension
id	id	dimension
items	items	metric
line_items_id	line_items_id	dimension
line_items_image_id	line_items_image_id	dimension
line_items_image_src	line_items_image_src	dimension
line_items_meta_data	line_items_meta_data	dimension
line_items_name	line_items_name	dimension
line_items_price	line_items_price	metric
line_items_product_id	line_items_product_id	dimension
line_items_quantity	line_items_quantity	metric
line_items_sku	line_items_sku	dimension
line_items_subtotal	line_items_subtotal	metric
line_items_subtotal_tax	line_items_subtotal_tax	metric
line_items_tax_class	line_items_tax_class	dimension
line_items_taxes	line_items_taxes	dimension
line_items_total	line_items_total	metric
line_items_total_tax	line_items_total_tax	metric
line_items_variation_id	line_items_variation_id	dimension
meta_data	meta_data	dimension
net_sales	net_sales	metric
number	number	metric
order_key	order_key	dimension
orders	orders	metric
parent_id	parent_id	dimension
payment_method	payment_method	dimension
payment_method_title	payment_method_title	dimension
prices_include_tax	prices_include_tax	dimension
sales	sales	metric
shipping	shipping	metric
shipping_address_1	shipping_address_1	dimension
shipping_address_2	shipping_address_2	dimension
shipping_city	shipping_city	dimension
shipping_company	shipping_company	dimension
shipping_country	shipping_country	dimension
shipping_first_name	shipping_first_name	dimension
shipping_last_name	shipping_last_name	dimension
shipping_phone	shipping_phone	dimension
shipping_postcode	shipping_postcode	dimension
shipping_state	shipping_state	dimension
shipping_tax	shipping_tax	metric
shipping_total	shipping_total	metric
status	status	dimension
tax	tax	metric
total	total	metric
total_customers	total_customers	metric
total_discount	total_discount	metric
total_items	total_items	metric
total_orders	total_orders	metric
total_refunds	total_refunds	metric
total_sales	total_sales	metric
total_shipping	total_shipping	metric
total_tax	total_tax	metric
transaction_id	transaction_id	dimension
version	version	dimension