WooCommerce
The table below gives information about all the data fields that you can import from WooCommerce.
To see the fields you can collect from another data source, go back to the Available fields in Adverity overview.
|
Field UI name |
Field API name |
Data Type |
Description |
Use in Adverity |
Docs |
|---|---|---|---|---|---|
|
billing_address_1 |
billing_address_1 |
String |
|
dimension |
|
|
billing_address_2 |
billing_address_2 |
String |
|
dimension |
|
|
billing_city |
billing_city |
String |
|
dimension |
|
|
billing_company |
billing_company |
String |
|
dimension |
|
|
billing_country |
billing_country |
String |
|
dimension |
|
|
billing_email |
billing_email |
String |
|
dimension |
|
|
billing_first_name |
billing_first_name |
String |
|
dimension |
|
|
billing_interval |
billing_interval |
Long |
|
metric |
|
|
billing_last_name |
billing_last_name |
String |
|
dimension |
|
|
billing_period |
billing_period |
String |
|
dimension |
|
|
billing_phone |
billing_phone |
String |
|
dimension |
|
|
billing_postcode |
billing_postcode |
String |
|
dimension |
|
|
billing_state |
billing_state |
String |
|
dimension |
|
|
cart_hash |
cart_hash |
String |
|
dimension |
|
|
cart_tax |
cart_tax |
Float |
|
metric |
|
|
coupon_lines |
coupon_lines |
String |
|
dimension |
|
|
coupon_lines_code |
coupon_lines_code |
String |
|
dimension |
|
|
coupon_lines_discount |
coupon_lines_discount |
Float |
|
metric |
|
|
coupon_lines_discount_tax |
coupon_lines_discount_tax |
Float |
|
metric |
|
|
coupon_lines_id |
coupon_lines_id |
Long |
|
dimension |
|
|
coupon_lines_meta_data |
coupon_lines_meta_data |
JSON |
|
dimension |
|
|
created_via |
created_via |
String |
|
dimension |
|
|
currency |
currency |
String |
|
dimension |
|
|
customer_id |
customer_id |
Long |
|
dimension |
|
|
customer_ip_address |
customer_ip_address |
String |
|
dimension |
|
|
customer_note |
customer_note |
String |
|
dimension |
|
|
customer_user_agent |
customer_user_agent |
String |
|
dimension |
|
|
customers |
customers |
Long |
|
metric |
|
|
date |
date |
Date |
|
dimension |
|
|
date_completed |
date_completed |
DateTime |
|
dimension |
|
|
date_completed_gmt |
date_completed_gmt |
DateTime |
|
dimension |
|
|
date_created |
date_created |
DateTime |
|
dimension |
|
|
date_created_gmt |
date_created_gmt |
DateTime |
|
dimension |
|
|
date_modified |
date_modified |
DateTime |
|
dimension |
|
|
date_modified_gmt |
date_modified_gmt |
DateTime |
|
dimension |
|
|
date_paid |
date_paid |
DateTime |
|
dimension |
|
|
date_paid_gmt |
date_paid_gmt |
DateTime |
|
dimension |
|
|
discount |
discount |
Float |
|
metric |
|
|
discount_tax |
discount_tax |
Float |
|
metric |
|
|
discount_total |
discount_total |
Float |
|
metric |
|
|
domain_name |
domain_name |
String |
|
dimension |
|
|
end_date |
end_date |
DateTime |
|
dimension |
|
|
fee_lines |
fee_lines |
String |
|
dimension |
|
|
id |
id |
Long |
|
dimension |
|
|
items |
items |
Long |
|
metric |
|
|
line_items_id |
line_items_id |
Long |
|
dimension |
|
|
line_items_meta |
line_items_meta |
String |
|
dimension |
|
|
line_items_meta_data |
line_items_meta_data |
JSON |
|
dimension |
|
|
line_items_name |
line_items_name |
String |
|
dimension |
|
|
line_items_parent_name |
line_items_parent_name |
String |
|
dimension |
|
|
line_items_price |
line_items_price |
Float |
|
metric |
|
|
line_items_product_id |
line_items_product_id |
Long |
|
dimension |
|
|
line_items_quantity |
line_items_quantity |
Long |
|
metric |
|
|
line_items_sku |
line_items_sku |
String |
|
dimension |
|
|
line_items_subtotal |
line_items_subtotal |
Float |
|
metric |
|
|
line_items_subtotal_tax |
line_items_subtotal_tax |
Float |
|
metric |
|
|
line_items_tax_class |
line_items_tax_class |
String |
|
dimension |
|
|
line_items_taxes |
line_items_taxes |
JSON |
|
dimension |
|
|
line_items_total |
line_items_total |
Float |
|
metric |
|
|
line_items_total_tax |
line_items_total_tax |
Float |
|
metric |
|
|
line_items_variation_id |
line_items_variation_id |
Long |
|
dimension |
|
|
meta_data |
meta_data |
JSON |
|
dimension |
|
|
next_payment_date |
next_payment_date |
DateTime |
|
dimension |
|
|
number |
number |
Long |
|
metric |
|
|
order_key |
order_key |
String |
|
dimension |
|
|
orders |
orders |
Long |
|
metric |
|
|
parent_id |
parent_id |
Long |
|
dimension |
|
|
payment_method |
payment_method |
String |
|
dimension |
|
|
payment_method_title |
payment_method_title |
String |
|
dimension |
|
|
prices_include_tax |
prices_include_tax |
Boolean |
|
dimension |
|
|
refunds |
refunds |
String |
|
dimension |
|
|
removed_line_items |
removed_line_items |
String |
|
dimension |
|
|
resubscribed_from |
resubscribed_from |
String |
|
dimension |
|
|
resubscribed_subscription |
resubscribed_subscription |
String |
|
dimension |
|
|
sales |
sales |
Float |
|
metric |
|
|
shipping |
shipping |
Float |
|
metric |
|
|
shipping_address_1 |
shipping_address_1 |
String |
|
dimension |
|
|
shipping_address_2 |
shipping_address_2 |
String |
|
dimension |
|
|
shipping_city |
shipping_city |
String |
|
dimension |
|
|
shipping_company |
shipping_company |
String |
|
dimension |
|
|
shipping_country |
shipping_country |
String |
|
dimension |
|
|
shipping_first_name |
shipping_first_name |
String |
|
dimension |
|
|
shipping_last_name |
shipping_last_name |
String |
|
dimension |
|
|
shipping_lines |
shipping_lines |
String |
|
dimension |
|
|
shipping_phone |
shipping_phone |
String |
|
dimension |
|
|
shipping_postcode |
shipping_postcode |
String |
|
dimension |
|
|
shipping_state |
shipping_state |
String |
|
dimension |
|
|
shipping_tax |
shipping_tax |
Float |
|
metric |
|
|
shipping_total |
shipping_total |
Float |
|
metric |
|
|
start_date |
start_date |
DateTime |
|
dimension |
|
|
status |
status |
String |
|
dimension |
|
|
tax |
tax |
Float |
|
metric |
|
|
tax_lines |
tax_lines |
String |
|
dimension |
|
|
total |
total |
Float |
|
metric |
|
|
total_tax |
total_tax |
Float |
|
metric |
|
|
transaction_id |
transaction_id |
String |
|
dimension |
|
|
trial_end_date |
trial_end_date |
String |
|
dimension |
|
|
version |
version |
String |
|
dimension |
|