Lazada Commerce metrics and dimensions

  • Updated on Apr 24, 2026
  • Published on Aug 5, 2025
Prev Next

Supermetrics brings all your Lazada Commerce data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

25 metrics111 dimensions

BILLING

billing_name
Field label Billing name
Description Billing name
Field type dimension
Data type string.text.value
billing_city
Field label Billing city
Description Billing city
Field type dimension
Data type string.geo.city
billing_post_code
Field label Billing post code
Description Post code
Field type dimension
Data type string.geo.zip
billing_country
Field label Billing country
Description Country
Field type dimension
Data type string.geo.country

DATASOURCE

dataSourceName
Field label Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

LINE ITEM

item_name
Field label Item name
Description Name of the item
Field type dimension
Data type string.text.value
item_variation
Field label Item variation
Description Variations of the item
Field type dimension
Data type string.text.value
item_status
Field label Item status
Description Status of the line item
Field type dimension
Data type string.text.value
seller_sku
Field label Seller SKU
Description Seller SKU of the item
Field type dimension
Data type string.text.value
voucher_code
Field label Voucher code
Description Voucher code
Field type dimension
Data type string.text.value
voucher_code_seller
Field label Voucher code (seller)
Description Voucher code from seller
Field type dimension
Data type string.text.value
voucher_code_platform
Field label Voucher code (platform)
Description Voucher code from platform
Field type dimension
Data type string.text.value
item_retail_price
Field label Item retail price
Description Retail price of the item
Field type metric
Data type float.currency.value
item_paid_amount
Field label Item paid amount
Description Paid price of the item, excluding shipping fee
Field type metric
Data type float.currency.value
item_shipping_fee
Field label Item shipping fee
Description Shipping fee of the item
Field type metric
Data type float.currency.value
item_quantity
Field label Item quantity
Description Number of items (Per item SKU)
Field type metric
Data type int.number.value
voucher_seller
Field label Voucher (seller)
Description The voucher that is issued by the seller
Field type metric
Data type float.currency.value
voucher_platform
Field label Voucher (platform)
Description The voucher that is issued by Lazada
Field type metric
Data type float.currency.value
voucher_seller_lpi
Field label Voucher seller LPI
Description The Lazada Bonus that is sponsored by the seller
Field type metric
Data type float.currency.value
voucher_platform_lpi
Field label Voucher platform LPI
Description The Lazada Bonus that is sponsored by Lazada
Field type metric
Data type float.currency.value
voucher_amount
Field label Voucher amount
Description Voucher amount
Field type metric
Data type float.currency.value

ORDER

order_number
Field label Order number
Description Represents the order number
Field type dimension
Data type string.text.value
order_id
Field label Order ID
Description Represents the order ID
Field type dimension
Data type string.text.value
statuses
Field label Status
Description An array of unique status of the items in the order
Field type dimension
Data type string.text.value
discount_code
Field label Discount code
Description The returned value is voucher ID
Field type dimension
Data type string.text.value
warehouse_code
Field label Warehouse code
Description Warehouse Code of multi-wh sellers
Field type dimension
Data type string.text.value
payment_method
Field label Payment method
Description The method of the payment
Field type dimension
Data type string.text.value
buyer_note
Field label Buyer note
Description Buyer note
Field type dimension
Data type string.text.value
delivery_info
Field label Delivery info
Description Delivery information
Field type dimension
Data type string.text.value
extra_attributes
Field label Extra attributes
Description Extra attributes which were passed to the Seller Center
Field type dimension
Data type string.text.value
remarks
Field label Remarks
Description Remarks
Field type dimension
Data type string.text.value
gift_message
Field label Gift message
Description Gift message as specified by the customer
Field type dimension
Data type string.text.value
promised_shipping_time
Field label Promised shipping time
Description Target shipping time for the soonest order item if they are available
Field type dimension
Data type string.text.value
created_at
Field label Order created date
Description Order created date
Field type dimension
Data type string.time.date
created_at_datetime
Field label Order created time and date
Description Order created time and date
Field type dimension
Data type string.time.datetime
updated_at_date
Field label Order updated date
Description Date of the last change to the order
Field type dimension
Data type string.time.date
updated_at_datetime
Field label Order updated time and date
Description Date and time of the last change to the order
Field type dimension
Data type string.time.datetime
orders
Field label Orders
Description Number of orders
Field type metric
Data type int.number.value
order_item_quantity
Field label Order item quantity
Description Number of items in order
Field type metric
Data type int.number.value
order_sub_total
Field label Order subtotal
Description Original subtotal for the order
Field type metric
Data type float.currency.value
order_shipping_fee
Field label Order shipping fee
Description Total shipping fee for this order
Field type metric
Data type float.currency.value
order_shipping_fee_original
Field label Order shipping fee original
Description The original shipping fee which are supposed to be charged to the customer, before any type of shipping fee promotion
Field type metric
Data type float.currency.value
order_shipping_fee_discount_platform
Field label Order shipping fee discount (Lazada)
Description Shipping fee discount from Lazada
Field type metric
Data type float.currency.value
order_shipping_fee_discount_seller
Field label Order shipping fee discount (seller)
Description Shipping fee discount from seller
Field type metric
Data type float.currency.value
order_discount
Field label Order discount
Description Total discount for this order
Field type metric
Data type float.currency.value
order_discount_platform
Field label Order discount (Lazada)
Description The discount that is issued by Lazada
Field type metric
Data type float.currency.value
order_discount_seller
Field label Order discount (seller)
Description The discount that is issued by the seller
Field type metric
Data type float.currency.value
order_grand_total
Field label Order grand total
Description Grand total unadjusted price for the order (order subtotal - discounts + shipping fees)
Field type metric
Data type float.currency.value

PRODUCT

product_id
Field label Product ID
Description Unique product identifier
Field type dimension
Data type string.text.value
status
Field label Status
Description Product status
Field type dimension
Data type string.text.value
category_id
Field label Category ID
Description Category ID
Field type dimension
Data type string.text.value
category_name
Field label Category name
Description Name of primary product category
Field type dimension
Data type string.text.value
created_datetime
Field label Created datetime
Description Product creation timestamp
Field type dimension
Data type string.time.datetime
created_date
Field label Created date
Description Product creation date
Field type dimension
Data type string.time.date
updated_datetime
Field label Updated datetime
Description Product last updated timestamp
Field type dimension
Data type string.time.datetime
updated_date
Field label Updated date
Description Product last updated date
Field type dimension
Data type string.time.date
trial_product
Field label Trial product
Description Whether the product is a trial product
Field type dimension
Data type bool
image_gs
Field label Image
Description First product image URL
Field type dimension
Data type string.text.url
Destinations Google Sheets
image
Field label Image
Description First product image URL
Field type dimension
Data type string.text.url
Destinations
product_name
Field label Product name
Description Product title
Field type dimension
Data type string.text.value
brand
Field label Brand
Description Product brand
Field type dimension
Data type string.text.value
description
Field label Description
Description Product description
Field type dimension
Data type string.text.value
unit
Field label Unit
Description Unit of measurement
Field type dimension
Data type string.text.value
delivery_option_standard
Field label Delivery option standard
Description Standard delivery option availability
Field type dimension
Data type string.text.value
delivery_option_instant
Field label Delivery option instant
Description Instant delivery option availability
Field type dimension
Data type string.text.value
delivery_option_sof
Field label Delivery option SOF
Description SOF (Seller Own Fleet) delivery option availability
Field type dimension
Data type string.text.value
source
Field label Source
Description Product source
Field type dimension
Data type string.text.value

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json
system_metadata.query_excluded_accounts
Field label Excluded invalid accounts
Description A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting
Field type dimension
Data type string.text.json

RETURN

return_order_id
Field label Return order ID
Description Unique identifier of the return order
Field type dimension
Data type string.text.value
return_item_id
Field label Return item ID
Description Unique identifier of the return order line
Field type dimension
Data type string.text.value
return_status
Field label Return status
Description Current status of the return, e.g. REFUND_SUCCESS
Field type dimension
Data type string.text.value
request_type
Field label Request type
Description Type of the reverse order, e.g. RETURN or CANCEL
Field type dimension
Data type string.text.value
reason
Field label Reason
Description Human-readable reason for the return as provided by the buyer
Field type dimension
Data type string.text.value
order_item_id
Field label Order item ID
Description Identifier of the original order line associated with the return
Field type dimension
Data type string.text.value
return_line_created_date
Field label Return line created date
Description Date the return line was created
Field type dimension
Data type string.time.date
return_line_created_datetime
Field label Return line created datetime
Description Date and time the return line was created
Field type dimension
Data type string.time.datetime
return_line_modified_date
Field label Return line modified date
Description Date the return line was last modified
Field type dimension
Data type string.time.date
return_line_modified_datetime
Field label Return line modified datetime
Description Date and time the return line was last modified
Field type dimension
Data type string.time.datetime
order_created_date
Field label Order created date
Description Date the original order was created
Field type dimension
Data type string.time.date
order_created_datetime
Field label Order created datetime
Description Date and time the original order was created
Field type dimension
Data type string.time.datetime
platform_sku_id
Field label Platform SKU ID
Description Platform-assigned SKU identifier, format: {item_id}_SGAMZ-{sku_id}
Field type dimension
Data type string.text.value
seller_sku_id
Field label Seller SKU ID
Description Seller-defined SKU code for the returned item
Field type dimension
Data type string.text.value
buyer_id
Field label Buyer ID
Description Unique identifier of the buyer
Field type dimension
Data type string.text.value
shipping_type
Field label Shipping type
Description Method of return shipping, e.g. DROP_OFF or PICK_UP
Field type dimension
Data type string.text.value
tracking_number
Field label Tracking number
Description Tracking number for the return shipment
Field type dimension
Data type string.text.value
refund_payment_method
Field label Refund payment method
Description Payment method used for the refund, e.g. PAYMENT_ACCOUNT or STORECREDIT_VOUCHER
Field type dimension
Data type string.text.value
is_dispute
Field label Is dispute
Description Whether the return is disputed
Field type dimension
Data type bool
is_return_to_merchant
Field label Is return to merchant
Description Whether the item is returned to the merchant
Field type dimension
Data type bool
returns
Field label Returns
Description Number of return order lines
Field type metric
Data type int.number.value
refund_amount
Field label Refund amount
Description Amount refunded to the buyer, currency in cent except VN (for example for SG, 100 equals SGD $1; for VN, 10000 equals VND 10000)
Field type metric
Data type float.currency.value
item_unit_price
Field label Item unit price
Description Original listed price of the returned item, currency in cent except VN (for example for SG, 100 equals SGD $1; for VN, 10000 equals VND 10000)
Field type metric
Data type float.currency.value
Aggregation Non-aggregatable metric

SHIPPING

shipping_name
Field label Shipping name
Description Shipping name
Field type dimension
Data type string.text.value
shipping_city
Field label Shipping city
Description City name
Field type dimension
Data type string.geo.city
shipping_post_code
Field label Shipping post code
Description Post code
Field type dimension
Data type string.geo.zip
shipping_country
Field label Shipping country
Description Country
Field type dimension
Data type string.geo.country

SKU

sku_id
Field label SKU ID
Description Unique SKU identifier
Field type dimension
Data type string.text.value
sku_seller_sku
Field label Seller SKU
Description Seller-defined SKU code
Field type dimension
Data type string.text.value
shop_sku
Field label Shop SKU
Description Platform-assigned shop SKU
Field type dimension
Data type string.text.value
sku_status
Field label SKU status
Description Status of the SKU
Field type dimension
Data type string.text.value
sku_url
Field label SKU URL
Description URL to the SKU product page
Field type dimension
Data type string.text.url
sku_image_gs
Field label SKU image
Description First SKU image URL
Field type dimension
Data type string.text.url
Destinations Google Sheets
sku_image
Field label SKU image
Description First SKU image URL
Field type dimension
Data type string.text.url
Destinations
package_width
Field label Package width
Description Package width (cm)
Field type dimension
Data type string.text.value
package_height
Field label Package height
Description Package height (cm)
Field type dimension
Data type string.text.value
package_length
Field label Package length
Description Package length (cm)
Field type dimension
Data type string.text.value
package_weight
Field label Package weight
Description Package weight (kg)
Field type dimension
Data type string.text.value
sku_price
Field label SKU price
Description Listed price of the SKU
Field type dimension
Data type string.text.value
sku_quantity
Field label SKU quantity
Description Total stock quantity of the SKU
Field type metric
Data type int.number.value
sku_available
Field label SKU available
Description Available stock quantity of the SKU
Field type metric
Data type int.number.value

STORE

store_name
Field label Store
Field type dimension
Data type string.text.value
store_location
Field label Store location
Description Location of the store
Field type dimension
Data type string.text.value

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
year
Field label Year
Field type dimension
Data type string.time.year
year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
month
Field label Month
Field type dimension
Data type string.time.month
year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
date
Field label Date
Field type dimension
Data type string.time.date
atom
Field label Datetime
Field type dimension
Data type string.time.datetime

© Supermetrics 2025