Shopee Commerce metrics and dimensions

Prev Next

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

7 metrics111 dimensions

BUYER

buyer_cpf_id
buyer_user_id
buyer_username
buyer_cancel_reason
order_item_buyer_cpf_id
order_item_buyer_user_id
order_item_buyer_username
order_item_buyer_cancel_reason

DATASOURCE

dataSourceName
system_metadata.data_source_logins
system_metadata.data_source_login_owners

ITEM

order_item_item_id
order_item_item_name
order_item_item_sku
order_item_order_item_id
order_item_model_id
order_item_model_name
order_item_model_sku
order_item_wholesale
order_item_main_item
order_item_image_url
order_item_add_on_deal
order_item_add_on_deal_id
order_item_promotion_type
order_item_promotion_id
order_item_promotion_group_id
order_item_product_location_id
order_item_is_prescription_item
order_item_is_b2c_owned_item
order_item_model_quantity_purchased
order_item_model_original_price
order_item_model_discounted_price
order_item_weight

ORDER

order_sn
order_status
region
currency
payment_method
cod
advance_package
booking_sn
cancel_by
cancel_reason
dropshipper
fulfillment_flag
days_to_ship
goods_to_declare
message_to_seller
note
actual_shipping_fee_confirmed
shipping_carrier
split_up
order_item_order_status
order_item_region
order_item_currency
order_item_payment_method
order_item_cod
order_item_advance_package
order_item_booking_sn
order_item_cancel_by
order_item_cancel_reason
order_item_dropshipper
order_item_fulfillment_flag
order_item_days_to_ship
order_item_goods_to_declare
order_item_message_to_seller
order_item_note
order_item_actual_shipping_fee_confirmed
order_item_shipping_carrier
order_item_split_up
estimated_shipping_fee
reverse_shipping_fee
total_amount

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

STORE

store_name
store_id

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

TIMESTAMP

create_time
create_datetime
pay_time
pay_datetime
pickup_done_time
pickup_done_datetime
ship_by_date
ship_by_datetime
update_time
updated_datetime
order_item_create_time
order_item_create_datetime
order_item_pay_time
order_item_pay_datetime
order_item_pickup_done_time
order_item_pickup_done_datetime
order_item_ship_by_date
order_item_ship_by_datetime
order_item_update_time
order_item_updated_datetime