Lazada: Most-used fields

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

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

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

clicks

clicks

The total number of clicks received on a sponsored ad. This is a performance metric.

metric

country

country

The two-letter country code (e.g., SG for Singapore, MY for Malaysia) representing the Lazada marketplace where the seller operates or the country associated with an address.

dimension

cpc

cpc

The average cost-per-click for a sponsored ad campaign. This is a performance metric.

metric

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

dateRange

dateRange

The specified date range for which the report data is generated.

dimension

endDate

endDate

The end date for the reporting period of sponsored ads performance metrics, in ISO 8601 date format.

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

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

marketImages.{NUM}

marketImages.{NUM}

A collection of image URLs for the product, used for main product images and SKU-specific images.

dimension

maxBid

maxBid

The maximum bid set for a keyword or ad group in a sponsored advertising campaign.

metric

primary_category

primary_category

The main category to which a product belongs.

metric

productCvr

productCvr

The conversion rate for a product, representing the percentage of product views that result in an order.

metric

productImageUrl

productImageUrl

The URL of the main image for the product associated with the sponsored ad.

dimension

productOrders

productOrders

The total number of orders placed for a specific product.

metric

productRevenue

productRevenue

The total revenue generated by a specific product.

metric

productUnitSold

productUnitSold

The total number of units sold for a specific product.

metric

report_date

report_date

The date for which the report data is generated.

dimension

seller_id

seller_id

The unique identifier for the seller’s shop on Lazada.

dimension

seller_location

seller_location

The primary country of operation or registration for the seller.

dimension

seller_name

seller_name

The display name or registered account name of the seller on the Lazada platform.

dimension

seller_status

seller_status

The current operational status of the seller’s account on the Lazada marketplace, indicating whether the seller is active or not.

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.

metric

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}.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}.fblWarehouseInventories.{NUM}.bizCode

skus.{NUM}.fblWarehouseInventories.{NUM}.bizCode

The business code associated with the inventory of a specific SKU within a Fulfilled By Lazada (FBL) warehouse.

dimension

skus.{NUM}.fblWarehouseInventories.{NUM}.bizType

skus.{NUM}.fblWarehouseInventories.{NUM}.bizType

The business type associated with the inventory of a specific SKU within a Fulfilled By Lazada (FBL) warehouse.

metric

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}.warehouseType

skus.{NUM}.fblWarehouseInventories.{NUM}.warehouseType

The type of Fulfilled By Lazada (FBL) warehouse holding the inventory for a specific SKU.

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}.multiWarehouseInventories.{NUM}.bizCode

skus.{NUM}.multiWarehouseInventories.{NUM}.bizCode

The business code associated with the inventory in a specific warehouse for a Stock Keeping Unit (SKU).

dimension

skus.{NUM}.multiWarehouseInventories.{NUM}.bizType

skus.{NUM}.multiWarehouseInventories.{NUM}.bizType

The business type associated with the inventory in a specific warehouse for a Stock Keeping Unit (SKU).

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 holding the inventory for a specific Stock Keeping Unit (SKU).

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}.preorder

skus.{NUM}.preorder

Indicates whether the product SKU is available for preorder. This field typically shows ‘Yes’ for products that can be ordered in advance before their official release.

dimension

skus.{NUM}.preorder_days

skus.{NUM}.preorder_days

The number of days specified for the preorder period for the product SKU. This indicates the estimated lead time or duration during which a product can be preordered.

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.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.volume

skus.{NUM}.saleProp.volume

This field represents a custom sales attribute related to the volume for a specific SKU variation. It defines a characteristic of the product that influences its sale, such as a bundle size or a sales-specific volumetric measurement.

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 Stock Keeping Unit (SKU).

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}.volume

skus.{NUM}.volume

This field represents the physical volume of a product SKU. It can be calculated using the package dimensions (length, width, height) provided for the SKU.

dimension

spend

spend

The total amount spent on a sponsored advertising campaign or ad group. This is a performance metric.

metric

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

storeCvr

storeCvr

The overall conversion rate for the store, indicating the percentage of store visitors who make a purchase.

metric

storeOrders

storeOrders

The total number of orders received by the store.

metric

storeRevenue

storeRevenue

The total revenue generated by the store.

metric

storeRoi

storeRoi

The Return on Investment (ROI) for the store, indicating the profitability of marketing efforts.

metric

storeUnitSold

storeUnitSold

The total number of product units sold by the store.

metric

updated_time

updated_time

The timestamp indicating when a product listing was last updated.

dimension