Magento
The table below gives information about all the data fields that you can import from Magento.
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 |
|---|---|---|---|---|---|
|
|
base_currency_code |
string |
|
dimension |
|
|
|
base_discount_amount |
float |
|
metric |
|
|
|
base_grand_total |
float |
|
metric |
|
|
|
base_price |
float |
|
metric |
|
|
|
base_shipping_amount |
float |
|
metric |
|
|
|
base_subtotal |
float |
|
metric |
|
|
|
base_tax_amount |
float |
|
metric |
|
|
|
base_total_offline_refunded |
string |
|
dimension |
|
|
|
base_total_online_refunded |
string |
|
dimension |
|
|
|
base_total_refunded |
string |
|
dimension |
|
|
|
billing_address_id |
long |
|
metric |
|
|
|
converted_at |
string |
|
dimension |
|
|
|
coupon_code |
string |
|
dimension |
|
|
|
created_at |
string |
|
dimension |
|
|
|
created_at |
datetime |
|
dimension |
|
|
|
customer_email |
string |
|
dimension |
|
|
|
customer_id |
string |
|
dimension |
|
|
|
customer_id |
long |
|
metric |
|
|
|
date |
string |
|
dimension |
|
|
|
date |
date |
|
dimension |
|
|
|
|
string |
|
dimension |
|
|
|
entity_id |
string |
|
dimension |
|
|
|
entity_id |
long |
|
metric |
|
|
|
is_active |
string |
|
dimension |
|
|
|
item_id |
long |
|
metric |
|
|
|
items_count |
string |
|
dimension |
|
|
|
items_qty |
string |
|
dimension |
|
|
|
name |
string |
|
dimension |
|
|
|
order_id |
long |
|
metric |
|
|
|
orig_order_id |
string |
|
dimension |
|
|
|
product_id |
long |
|
metric |
|
|
|
qty_ordered |
float |
|
metric |
|
|
|
shipping_address_id |
long |
|
metric |
|
|
|
shipping_method |
string |
|
dimension |
|
|
|
sku |
string |
|
dimension |
|
|
|
status |
string |
|
dimension |
|
|
|
store_id |
string |
|
dimension |
|
|
|
store_id |
long |
|
metric |
|
|
|
store_name |
string |
|
dimension |
|
|
|
wishlist_id |
long |
|
metric |
|