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	Description	Use in Adverity
billing_address_2	billing_address_2	This field represents the second line of the customer’s billing address, often used for apartment numbers, suites, or other secondary address details.	dimension
billing_phone	billing_phone	The phone number for the customer’s billing contact.	dimension
coupon_lines_discount	coupon_lines_discount	The total discount amount provided by the coupon line.	dimension
coupon_lines_discount_tax	coupon_lines_discount_tax	The total tax amount on the discount provided by the coupon line.	dimension
coupon_lines_discount_type	coupon_lines_discount_type	The type of discount applied by the coupon (e.g., ‘fixed_cart’, ‘percent’, ‘fixed_product’, ‘recurring_percent’).	dimension
coupon_lines_free_shipping	coupon_lines_free_shipping	Indicates if the coupon provides free shipping for the order.	dimension
coupon_lines_id	coupon_lines_id	The unique identifier for the coupon line item.	dimension
coupon_lines_meta_data	coupon_lines_meta_data	Additional meta data associated with the coupon line.	dimension
date_completed	date_completed	The date and time when the order or subscription was marked as completed, in the site’s timezone.	dimension
date_completed_gmt	date_completed_gmt	The date and time when the subscription was marked as completed, in GMT.	dimension
date_paid	date_paid	The date and time when the order or subscription was marked as paid, in the site’s timezone.	dimension
line_items_price	line_items_price	The price of the product in the line item.	metric
shipping_address_2	shipping_address_2	The second line of the customer’s shipping address.	dimension
shipping_phone	shipping_phone	The phone number associated with the customer’s shipping address.	dimension