Kaufland: Most-used fields

Kaufland: Most-used fields#

The table below gives information about most-used fields that you can import from Kaufland. 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.city

billing.city

The city of the billing address for the order.

dimension

billing.company_name

billing.company_name

The company name associated with the billing address.

dimension

billing.country

billing.country

The country of the billing address for the order.

dimension

billing.first_name

billing.first_name

The first name of the recipient at the billing address.

dimension

billing.gender

billing.gender

The gender of the customer associated with a billing record or order.

dimension

billing.house_number

billing.house_number

The house number of the billing address.

metric

billing.last_name

billing.last_name

The last name of the recipient at the billing address.

dimension

billing.phone

billing.phone

The phone number associated with the billing address.

dimension

billing.postcode

billing.postcode

The postal code of the billing address.

metric

billing.street

billing.street

The street name of the billing address.

dimension

buyer.email

buyer.email

The email address of the buyer.

dimension

buyer.id_buyer

buyer.id_buyer

The unique identifier for the buyer.

metric

date

date

The date when the order was created.

dimension

delivery_time_expires

delivery_time_expires

The date and time when the delivery timeframe for the order expires.

dimension

delivery_time_max

delivery_time_max

The maximum estimated date and time for the delivery of the order.

metric

delivery_time_min

delivery_time_min

The minimum estimated date and time for the delivery of the order.

metric

id_sales_order

id_sales_order

The unique identifier for a sales order.

metric

item.EANs

item.EANs

European Article Number (EAN) or International Article Number (IAN) associated with a product item.

metric

item.id_item

item.id_item

A unique identifier for an item or product sold on the Kaufland marketplace.

metric

offer_id

offer_id

Unique identifier for a specific offer or unit listed by a seller.

dimension

order_number

order_number

The unique order number or identifier for a sales order.

dimension

payment_method

payment_method

The method used by the customer to pay for the order, such as credit card, PayPal, or invoice. This field is typically found within order or sales reports.

dimension

price

price

The selling price of the individual product item or unit.

metric

revenue_gross

revenue_gross

The total gross revenue generated from the sale, including taxes and other charges.

metric

revenue_net

revenue_net

The net revenue generated from sales or bookings, excluding taxes, discounts, or returns.

metric

shipping.city

shipping.city

The city of the shipping address for the order.

dimension

shipping.company_name

shipping.company_name

The company name associated with the shipping address.

dimension

shipping.country

shipping.country

The country of the shipping address for the order.

dimension

shipping.first_name

shipping.first_name

The first name of the recipient at the shipping address.

dimension

shipping.house_number

shipping.house_number

The house number of the shipping address.

metric

shipping.last_name

shipping.last_name

The last name of the recipient at the shipping address.

dimension

shipping.phone

shipping.phone

The phone number associated with the shipping address.

dimension

shipping.postcode

shipping.postcode

The postal code of the shipping address.

metric

shipping.street

shipping.street

The street name of the shipping address.

dimension

shipping_charges

shipping_charges

The cost charged to the customer for shipping the order. This field is generally part of order details or sales reports, related to ‘Orders’, ‘Order Units’, or ‘Shipments’ endpoints.

metric

unit_condition

unit_condition

The condition of the product unit, such as new or used.

dimension

unit_status

unit_status

The current status of the product unit, indicating its availability or state on the marketplace.

dimension