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 |