Lazada: Most-used fields

The table below gives information about most-used fields that you can import from Lazada. 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
address_billing.address1	address_billing.address1	Line 1 of the billing address for the order.	dimension
address_billing.address2	address_billing.address2	Line 2 of the billing address for the order.	dimension
address_billing.address3	address_billing.address3	Line 3 of the billing address for the order.	dimension
address_billing.address4	address_billing.address4	Line 4 of the billing address for the order.	dimension
address_billing.address5	address_billing.address5	Line 5 of the billing address for the order.	dimension
address_billing.addressDistrict	address_billing.addressDistrict	The district component of the billing address for the order.	dimension
address_billing.city	address_billing.city	The city component of the billing address for the order.	dimension
address_billing.country	address_billing.country	The country component of the billing address for the order.	dimension
address_billing.first_name	address_billing.first_name	The first name of the recipient for the billing address.	dimension
address_billing.last_name	address_billing.last_name	The last name of the recipient for the billing address.	dimension
address_billing.phone	address_billing.phone	The primary phone number for the billing address.	dimension
address_billing.phone2	address_billing.phone2	The secondary phone number for the billing address.	dimension
address_billing.post_code	address_billing.post_code	The postal code for the billing address.	metric
address_shipping.address1	address_shipping.address1	Line 1 of the shipping address for the order.	dimension
address_shipping.address2	address_shipping.address2	Line 2 of the shipping address for the order.	dimension
address_shipping.address3	address_shipping.address3	Line 3 of the shipping address for the order.	dimension
address_shipping.address4	address_shipping.address4	Line 4 of the shipping address for the order.	dimension
address_shipping.address5	address_shipping.address5	Line 5 of the shipping address for the order.	dimension
address_shipping.addressDistrict	address_shipping.addressDistrict	The district component of the shipping address for the order.	dimension
address_shipping.city	address_shipping.city	The city component of the shipping address for the order.	dimension
address_shipping.country	address_shipping.country	The country component of the shipping address for the order.	dimension
address_shipping.first_name	address_shipping.first_name	The first name of the recipient for the shipping address.	dimension
address_shipping.last_name	address_shipping.last_name	The last name of the recipient for the shipping address.	dimension
address_shipping.phone	address_shipping.phone	The primary phone number for the shipping address.	dimension
address_shipping.phone2	address_shipping.phone2	The secondary phone number for the shipping address.	dimension
address_shipping.post_code	address_shipping.post_code	The postal code for the shipping address.	metric
adgroupId	adgroupId	The unique identifier for an ad group within a sponsored advertising campaign. Used for performance reporting.	metric
adgroupName	adgroupName	The name of the ad group in a sponsored advertising campaign. Used for performance reporting.	dimension
attributes.{PLACEHOLDER}	attributes.{PLACEHOLDER}	Customizable product attributes, where {PLACEHOLDER} represents the specific attribute name.	dimension
buyer_id	buyer_id	The unique identifier for the buyer who placed the order.	dimension
buyer_note	buyer_note	Any special notes or instructions provided by the buyer for the order.	dimension
campaignId	campaignId	The unique identifier for a sponsored advertising campaign. Used for performance reporting.	metric
campaignName	campaignName	The name of the sponsored advertising campaign. Used for performance reporting.	dimension
cancel_return_initiator	cancel_return_initiator	Indicates who initiated the cancellation or return of an order, such as ‘cancellation-customer’ or ‘return-customer’.	dimension
clicks	clicks	The total number of clicks received on a sponsored ad. This is a performance metric.	metric
cpc	cpc	The average cost-per-click for a sponsored ad campaign. This is a performance metric.	metric
created_at	created_at	The date and time when the order was created or placed.	dimension
created_time	created_time	The timestamp indicating when a product listing was created.	dimension
ctr	ctr	The click-through rate for a sponsored ad, calculated as clicks divided by impressions. This is a performance metric.	metric
currency	currency	The currency in which the order total and prices are denominated.	dimension
customer_first_name	customer_first_name	The first name of the customer who placed the order.	dimension
customer_last_name	customer_last_name	The last name of the customer who placed the order.	dimension
dateRange	dateRange	The specified date range for which the report data is generated.	dimension
delivery_info	delivery_info	Information related to the delivery of the order, such as delivery method or estimated delivery time.	dimension
delivery_option_sof	delivery_option_sof	Indicates if the delivery option is ‘Seller Own Fleet’ (SOF), with values 1 for SOF and 0 otherwise.	metric
digital_delivery_info	digital_delivery_info	Information specific to the delivery of digital products or services.	dimension
endDate	endDate	The end date for the reporting period of sponsored ads performance metrics, in ISO 8601 date format.	dimension
extra_attributes	extra_attributes	Additional attributes or custom information associated with the order.	dimension
fulfillment_sla	fulfillment_sla	The Service Level Agreement (SLA) for order fulfillment, indicating the target time for processing and shipping.	dimension
gift_message	gift_message	The gift message provided by the customer for the order.	dimension
gift_option	gift_option	Indicates if the order includes a gift option, such as gift wrapping.	dimension
gift_wrapping	gift_wrapping	Indicates if gift wrapping was requested for the order, with values 1 for gift wrapping and 0 if not.	dimension
images.{NUM}	images.{NUM}	A list of URLs for product images, where {NUM} represents the index of the image.	dimension
impressions	impressions	The total number of times a sponsored ad was displayed. This is a performance metric.	metric
invoice_number	invoice_number	The invoice number generated for the order.	dimension
is_digital	is_digital	Indicates if the ordered item is a digital product.	metric
is_fbl	is_fbl	Indicates if the order is fulfilled by Lazada (FBL), with values 1 for FBL and 0 otherwise.	metric
is_reroute	is_reroute	Indicates if the order delivery has been rerouted.	metric
itemId	itemId	The unique identifier for a product item. In sponsored ads, this refers to the advertised product.	metric
item_id	item_id	The unique identifier for a product item.	dimension
item_price	item_price	The price of an individual item within an order.	metric
items_count	items_count	The total number of unique items included in the order.	metric
keyword	keyword	The specific keyword targeted in a sponsored ad campaign. Used for performance reporting at the keyword level.	dimension
keywordId	keywordId	The unique identifier for a specific keyword in a sponsored advertising campaign. Used for performance reporting.	metric
marketImages.{NUM}	marketImages.{NUM}	A list of URLs for market-specific product images, where {NUM} represents the index of the image.	dimension
maxBid	maxBid	The maximum bid set for a keyword or ad group in a sponsored advertising campaign.	metric
name	name	The name of the ordered product or the customer’s name.	dimension
national_registration_number	national_registration_number	The national registration number provided by the customer, required in some countries for orders.	dimension
order_flag	order_flag	Indicates the status or a specific characteristic of an order. For example, a flag could indicate if an item is a gift (1 for gift, 0 if not).	dimension
order_id	order_id	The unique identifier for the order.	dimension
order_item_id	order_item_id	The unique identifier for a specific item within an order.	dimension
order_number	order_number	The order tracking number or reference number.	metric
order_type	order_type	The type of order, such as ‘NORMAL’, ‘GUARANTEE’, or ‘GLOBAL_COLLECTION’, which may influence SLA requirements.	dimension
package_id	package_id	The unique identifier for the shipping package associated with the order.	dimension
paid_price	paid_price	The actual price paid by the customer for an item after any discounts or promotions.	metric
payment_method	payment_method	The method of payment used for the order.	dimension
payment_time	payment_time	The timestamp when the payment for the order was successfully processed.	metric
price	price	The total price of the order or a specific item.	metric
primary_category	primary_category	The main category to which a product belongs.	metric
priority_fulfillment_tag	priority_fulfillment_tag	A tag indicating whether an order item is fulfilled by Lazada (FBL) or a secondary sale. The specific values are 1 for FBL and 0 for secondary sale.	dimension
productCvr	productCvr		metric
productImageUrl	productImageUrl	The URL of the main image for the product associated with the sponsored ad.	dimension
productOrders	productOrders		metric
productRevenue	productRevenue		metric
productUnitSold	productUnitSold		metric
product_detail_url	product_detail_url	The URL linking to the detailed product page of an ordered item.	dimension
product_main_image	product_main_image	The URL of the main image for an ordered product.	dimension
promised_shipping_time	promised_shipping_time	The promised shipping time for the soonest order item, if available.	dimension
promised_shipping_times	promised_shipping_times	A list of promised shipping times for items within the order.	dimension
purchase_order_id	purchase_order_id	The unique identifier for the purchase order.	dimension
purchase_order_number	purchase_order_number	The reference number for the purchase order.	dimension
reason	reason	The reason for an order cancellation, return, or refund.	dimension
reason_detail	reason_detail	Detailed explanation of the reason for an order cancellation, return, or refund.	dimension
remarks	remarks	Additional remarks or comments related to the order.	dimension
report_date	report_date	The date for which the report data is generated.	dimension
return_status	return_status	The current status of a return request for the order.	dimension
shipment_provider	shipment_provider	The name of the logistics or shipment provider handling the order delivery.	dimension
shipping_amount	shipping_amount	The total amount charged for shipping the order.	metric
shipping_fee	shipping_fee	The shipping fee applied to the order.	metric
shipping_fee_discount_platform	shipping_fee_discount_platform	The discount amount on shipping fees provided by the platform.	metric
shipping_fee_discount_seller	shipping_fee_discount_seller	The discount amount on shipping fees provided by the seller.	metric
shipping_fee_original	shipping_fee_original	The original shipping fee before any discounts were applied.	metric
shipping_provider_type	shipping_provider_type	The type of shipping provider (e.g., standard, express).	dimension
shipping_service_cost	shipping_service_cost	The cost of the shipping service for the order.	metric
shipping_type	shipping_type	The type of shipping used for the order.	dimension
shop_id	shop_id	The unique identifier for the seller’s shop.	dimension
shop_sku	shop_sku	The Stock Keeping Unit (SKU) as defined by the shop for a product.	dimension
sku	sku	The Stock Keeping Unit (SKU) identifier for a product.	dimension
sku_id	sku_id	The unique identifier for a Stock Keeping Unit (SKU).	dimension
skus.{NUM}.Available	skus.{NUM}.Available	Indicates the availability status of a specific SKU (Stock Keeping Unit), where {NUM} is the SKU index.	metric
skus.{NUM}.Color	skus.{NUM}.Color	The color attribute of a specific SKU, where {NUM} is the SKU index.	dimension
skus.{NUM}.Images.{NUM}	skus.{NUM}.Images.{NUM}	A list of URLs for images associated with a specific SKU, where the first {NUM} is the SKU index and the second {NUM} is the image index.	dimension
skus.{NUM}.SellerSku	skus.{NUM}.SellerSku	The unique SKU identifier assigned by the seller for a specific product variation, where {NUM} is the SKU index.	dimension
skus.{NUM}.ShopSku	skus.{NUM}.ShopSku	The unique SKU identifier assigned by the shop for a specific product variation, where {NUM} is the SKU index.	dimension
skus.{NUM}.SkuId	skus.{NUM}.SkuId	The unique identifier for a Stock Keeping Unit (SKU) within the Lazada system, where {NUM} is the SKU index.	metric
skus.{NUM}.Status	skus.{NUM}.Status	The current status of a specific SKU (e.g., active, inactive), where {NUM} is the SKU index.	dimension
skus.{NUM}.Url	skus.{NUM}.Url	The URL for the product page of a specific SKU, where {NUM} is the SKU index.	dimension
skus.{NUM}.Variation	skus.{NUM}.Variation	The variation attribute of a specific SKU, where {NUM} is the SKU index.	dimension
skus.{NUM}.Volume	skus.{NUM}.Volume	The physical volume of a specific SKU, where {NUM} is the SKU index.	metric
skus.{NUM}.channelInventories.{NUM}.channelName	skus.{NUM}.channelInventories.{NUM}.channelName	The name of the sales channel for the inventory of a specific SKU, where the first {NUM} is the SKU index and the second {NUM} is the channel inventory index.	dimension
skus.{NUM}.channelInventories.{NUM}.endTime	skus.{NUM}.channelInventories.{NUM}.endTime	The end time for the inventory availability on a specific channel for an SKU, where the first {NUM} is the SKU index and the second {NUM} is the channel inventory index.	dimension
skus.{NUM}.channelInventories.{NUM}.sellableQuantity	skus.{NUM}.channelInventories.{NUM}.sellableQuantity	The quantity of a specific SKU available for sale on a particular channel, where the first {NUM} is the SKU index and the second {NUM} is the channel inventory index.	metric
skus.{NUM}.channelInventories.{NUM}.startTime	skus.{NUM}.channelInventories.{NUM}.startTime	The start time for the inventory availability on a specific channel for an SKU, where the first {NUM} is the SKU index and the second {NUM} is the channel inventory index.	dimension
skus.{NUM}.color_family	skus.{NUM}.color_family	The color family of a specific SKU, where {NUM} is the SKU index.	dimension
skus.{NUM}.color_text	skus.{NUM}.color_text	The textual description of the color for a specific SKU, where {NUM} is the SKU index.	dimension
skus.{NUM}.fblWarehouseInventories.{NUM}.occupyQuantity	skus.{NUM}.fblWarehouseInventories.{NUM}.occupyQuantity	The quantity of a specific SKU currently reserved or occupied in a Fulfilled By Lazada (FBL) warehouse, where the first {NUM} is the SKU index and the second {NUM} is the warehouse inventory index.	metric
skus.{NUM}.fblWarehouseInventories.{NUM}.quantity	skus.{NUM}.fblWarehouseInventories.{NUM}.quantity	The total quantity of a specific SKU in a Fulfilled By Lazada (FBL) warehouse, where the first {NUM} is the SKU index and the second {NUM} is the warehouse inventory index.	metric
skus.{NUM}.fblWarehouseInventories.{NUM}.sellableQuantity	skus.{NUM}.fblWarehouseInventories.{NUM}.sellableQuantity	The quantity of a specific SKU available for sale in a Fulfilled By Lazada (FBL) warehouse, where the first {NUM} is the SKU index and the second {NUM} is the warehouse inventory index.	metric
skus.{NUM}.fblWarehouseInventories.{NUM}.totalQuantity	skus.{NUM}.fblWarehouseInventories.{NUM}.totalQuantity	The total physical quantity of a specific SKU in a Fulfilled By Lazada (FBL) warehouse, where the first {NUM} is the SKU index and the second {NUM} is the warehouse inventory index.	metric
skus.{NUM}.fblWarehouseInventories.{NUM}.warehouseCode	skus.{NUM}.fblWarehouseInventories.{NUM}.warehouseCode	The code of the Fulfilled By Lazada (FBL) warehouse storing a specific SKU, where the first {NUM} is the SKU index and the second {NUM} is the warehouse inventory index.	dimension
skus.{NUM}.fblWarehouseInventories.{NUM}.withholdQuantity	skus.{NUM}.fblWarehouseInventories.{NUM}.withholdQuantity	The quantity of a specific SKU withheld from sale in a Fulfilled By Lazada (FBL) warehouse, where the first {NUM} is the SKU index and the second {NUM} is the warehouse inventory index.	metric
skus.{NUM}.flavor	skus.{NUM}.flavor	The flavor variant of a specific SKU, where {NUM} is the SKU index.	dimension
skus.{NUM}.fragrance_family	skus.{NUM}.fragrance_family	The fragrance family of a specific SKU, where {NUM} is the SKU index.	dimension
skus.{NUM}.multiWarehouseInventories.{NUM}.bizCode	skus.{NUM}.multiWarehouseInventories.{NUM}.bizCode	The business code associated with the multi-warehouse inventory for a specific SKU, where the first {NUM} is the SKU index and the second {NUM} is the warehouse inventory index.	dimension
skus.{NUM}.multiWarehouseInventories.{NUM}.bizType	skus.{NUM}.multiWarehouseInventories.{NUM}.bizType	The business type associated with the multi-warehouse inventory for a specific SKU, where the first {NUM} is the SKU index and the second {NUM} is the warehouse inventory index.	metric
skus.{NUM}.multiWarehouseInventories.{NUM}.occupyQuantity	skus.{NUM}.multiWarehouseInventories.{NUM}.occupyQuantity	The quantity of a specific SKU currently reserved or occupied across multiple warehouses, where the first {NUM} is the SKU index and the second {NUM} is the warehouse inventory index.	metric
skus.{NUM}.multiWarehouseInventories.{NUM}.quantity	skus.{NUM}.multiWarehouseInventories.{NUM}.quantity	The total quantity of a specific SKU across multiple warehouses, where the first {NUM} is the SKU index and the second {NUM} is the warehouse inventory index.	metric
skus.{NUM}.multiWarehouseInventories.{NUM}.sellableQuantity	skus.{NUM}.multiWarehouseInventories.{NUM}.sellableQuantity	The quantity of a specific SKU available for sale across multiple warehouses, where the first {NUM} is the SKU index and the second {NUM} is the warehouse inventory index.	metric
skus.{NUM}.multiWarehouseInventories.{NUM}.totalQuantity	skus.{NUM}.multiWarehouseInventories.{NUM}.totalQuantity	The total physical quantity of a specific SKU across multiple warehouses, where the first {NUM} is the SKU index and the second {NUM} is the warehouse inventory index.	metric
skus.{NUM}.multiWarehouseInventories.{NUM}.warehouseCode	skus.{NUM}.multiWarehouseInventories.{NUM}.warehouseCode	The code of the warehouse storing a specific SKU, where the first {NUM} is the SKU index and the second {NUM} is the warehouse inventory index.	dimension
skus.{NUM}.multiWarehouseInventories.{NUM}.warehouseType	skus.{NUM}.multiWarehouseInventories.{NUM}.warehouseType	The type of warehouse in the multi-warehouse inventory for a specific SKU, where the first {NUM} is the SKU index and the second {NUM} is the warehouse inventory index.	dimension
skus.{NUM}.multiWarehouseInventories.{NUM}.withholdQuantity	skus.{NUM}.multiWarehouseInventories.{NUM}.withholdQuantity	The quantity of a specific SKU withheld from sale across multiple warehouses, where the first {NUM} is the SKU index and the second {NUM} is the warehouse inventory index.	metric
skus.{NUM}.package_content	skus.{NUM}.package_content	The contents of the package for a specific SKU, where {NUM} is the SKU index.	dimension
skus.{NUM}.package_height	skus.{NUM}.package_height	The height of the package for a specific SKU, where {NUM} is the SKU index.	metric
skus.{NUM}.package_length	skus.{NUM}.package_length	The length of the package for a specific SKU, where {NUM} is the SKU index.	metric
skus.{NUM}.package_weight	skus.{NUM}.package_weight	The weight of the package for a specific SKU, where {NUM} is the SKU index.	metric
skus.{NUM}.package_width	skus.{NUM}.package_width	The width of the package for a specific SKU, where {NUM} is the SKU index.	metric
skus.{NUM}.price	skus.{NUM}.price	The regular selling price of a specific SKU, where {NUM} is the SKU index.	metric
skus.{NUM}.quantity	skus.{NUM}.quantity	The total available quantity for a specific SKU, where {NUM} is the SKU index.	metric
skus.{NUM}.saleProp.Color	skus.{NUM}.saleProp.Color	The color property for a specific SKU as a sales attribute, where {NUM} is the SKU index.	dimension
skus.{NUM}.saleProp.Variation	skus.{NUM}.saleProp.Variation	The variation property for a specific SKU as a sales attribute, where {NUM} is the SKU index.	dimension
skus.{NUM}.saleProp.Volume	skus.{NUM}.saleProp.Volume	The volume of a specific SKU, possibly related to its sale properties, where {NUM} is the SKU index.	metric
skus.{NUM}.saleProp.color_family	skus.{NUM}.saleProp.color_family	The color family of a specific SKU as a sales property, where {NUM} is the SKU index.	dimension
skus.{NUM}.saleProp.color_text	skus.{NUM}.saleProp.color_text	The textual description of the color for a specific SKU as a sales property, where {NUM} is the SKU index.	dimension
skus.{NUM}.saleProp.flavor	skus.{NUM}.saleProp.flavor	The flavor variant of a specific SKU as a sales property, where {NUM} is the SKU index.	dimension
skus.{NUM}.saleProp.fragrance_family	skus.{NUM}.saleProp.fragrance_family	The fragrance family of a specific SKU as a sales property, where {NUM} is the SKU index.	dimension
skus.{NUM}.special_from_date	skus.{NUM}.special_from_date	The start date for a special price or promotion of a specific SKU, where {NUM} is the SKU index.	dimension
skus.{NUM}.special_from_time	skus.{NUM}.special_from_time	The start time for a special price or promotion of a specific SKU, where {NUM} is the SKU index.	dimension
skus.{NUM}.special_price	skus.{NUM}.special_price	The special promotional price of a specific SKU, where {NUM} is the SKU index.	metric
skus.{NUM}.special_time_format	skus.{NUM}.special_time_format	The time format used for special price durations for a specific SKU, where {NUM} is the SKU index.	dimension
skus.{NUM}.special_to_date	skus.{NUM}.special_to_date	The end date for a special price or promotion of a specific SKU, where {NUM} is the SKU index.	dimension
skus.{NUM}.special_to_time	skus.{NUM}.special_to_time	The end time for a special price or promotion of a specific SKU, where {NUM} is the SKU index.	dimension
skus.{NUM}.tax_class	skus.{NUM}.tax_class	The tax class applicable to a specific SKU, where {NUM} is the SKU index.	dimension
sla_time_stamp	sla_time_stamp	The timestamp indicating the Service Level Agreement (SLA) deadline.	dimension
spend	spend	The total amount spent on a sponsored advertising campaign or ad group. This is a performance metric.	metric
stage_pay_status	stage_pay_status		dimension
startDate	startDate	The start date for the reporting period of sponsored ads performance metrics, in ISO 8601 date format.	dimension
status	status	The current status of a product listing.	dimension
statuses.{NUM}	statuses.{NUM}	A list of statuses associated with the order or order item, where {NUM} is the index of the status.	dimension
storeCvr	storeCvr		metric
storeOrders	storeOrders		metric
storeRevenue	storeRevenue		metric
storeRoi	storeRoi		metric
storeUnitSold	storeUnitSold		metric
supply_price	supply_price	The cost or supply price of the product.	metric
supply_price_currency	supply_price_currency	The currency of the product’s supply price.	dimension
tax_amount	tax_amount	The total tax amount applied to the order.	metric
tax_code	tax_code	(For Thailand and Vietnam only) The customer’s VAT tax code, provided during order placement. (For Thailand only) The tax branch code for corporate customers.	dimension
tracking_code	tracking_code	The tracking code or number for the order shipment.	dimension
tracking_code_pre	tracking_code_pre	The preliminary tracking code for the order shipment.	dimension
updated_at	updated_at	The date and time when the order was last updated.	dimension
updated_time	updated_time	The timestamp indicating when a product listing was last updated.	dimension
variation	variation	Details about the product variation for an order item.	dimension
variation.Variation1.hasImage	variation.Variation1.hasImage	Indicates if the first variation option has an associated image.	dimension
variation.Variation1.label	variation.Variation1.label	The label for the first variation option.	dimension
variation.Variation1.name	variation.Variation1.name	The name of the first variation option.	dimension
variation.Variation1.options.{NUM}	variation.Variation1.options.{NUM}	A list of options available for the first product variation, where {NUM} is the option index.	dimension
voucher	voucher	Indicates if a voucher was applied to the order.	metric
voucher_amount	voucher_amount	The total amount of the voucher applied to the order.	metric
voucher_code	voucher_code	The code of the voucher applied to the order.	dimension
voucher_code_platform	voucher_code_platform	The code of the platform-provided voucher applied to the order.	dimension
voucher_code_seller	voucher_code_seller	The code of the seller-provided voucher applied to the order.	metric
voucher_platform	voucher_platform	Indicates if a platform-provided voucher was applied to the order.	metric
voucher_seller	voucher_seller	Indicates if a seller-provided voucher was applied to the order.	metric
wallet_credits	wallet_credits	The amount of wallet credits used for the order.	metric
warehouse_code	warehouse_code	The code of the warehouse from which the order items are shipped.	dimension