Lazada Commerce metrics and dimensions

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
billing_city
billing_post_code
billing_country

DATASOURCE

dataSourceName
system_metadata.data_source_logins
system_metadata.data_source_login_owners

LINE ITEM

item_name
item_variation
item_status
seller_sku
voucher_code
voucher_code_seller
voucher_code_platform
item_retail_price
item_paid_amount
item_shipping_fee
item_quantity
voucher_seller
voucher_platform
voucher_seller_lpi
voucher_platform_lpi
voucher_amount

ORDER

order_number
order_id
statuses
discount_code
warehouse_code
payment_method
buyer_note
delivery_info
extra_attributes
remarks
gift_message
promised_shipping_time
created_at
created_at_datetime
updated_at_date
updated_at_datetime
orders
order_item_quantity
order_sub_total
order_shipping_fee
order_shipping_fee_original
order_shipping_fee_discount_platform
order_shipping_fee_discount_seller
order_discount
order_discount_platform
order_discount_seller
order_grand_total

PRODUCT

product_id
status
category_id
category_name
created_datetime
created_date
updated_datetime
updated_date
trial_product
image_gs
image
product_name
brand
description
unit
delivery_option_standard
delivery_option_instant
delivery_option_sof
source

QUERY

system_metadata.query_date_range_start
system_metadata.query_date_range_end
system_metadata.query_timezone
system_metadata.query_filters
system_metadata.query_date_start
system_metadata.query_date_end
system_metadata.query_duration
system_metadata.query_accounts
system_metadata.query_excluded_accounts

RETURN

return_order_id
return_item_id
return_status
request_type
reason
order_item_id
return_line_created_date
return_line_created_datetime
return_line_modified_date
return_line_modified_datetime
order_created_date
order_created_datetime
platform_sku_id
seller_sku_id
buyer_id
shipping_type
tracking_number
refund_payment_method
is_dispute
is_return_to_merchant
returns
refund_amount
item_unit_price

SHIPPING

shipping_name
shipping_city
shipping_post_code
shipping_country

SKU

sku_id
sku_seller_sku
shop_sku
sku_status
sku_url
sku_image_gs
sku_image
package_width
package_height
package_length
package_weight
sku_price
sku_quantity
sku_available

STORE

store_name
store_location

TIME

today
year
year_of_week
year_of_week_iso
year_month
month
year_week
year_week_iso
week
week_iso
day_of_month
day_of_week_name
day_of_week_name_iso
date
atom