Lazada Ads fields

  • Updated on Sep 30, 2025
  • Published on Aug 5, 2025
Prev Next

Supermetrics brings all your Lazada Ads data into Google Sheets, Looker Studio, Power BI, Excel

15 metrics44 dimensions

CAMPAIGN

campaign_name
Field label Campaign name
Description Campaign name
Field type dimension
Data type string.text.value
campaign_id
Field label Campaign ID
Description Campaign ID
Field type dimension
Data type string.text.value
campaign_type
Field label Campaign type
Description Campaign type (1 Manual, 2 Automated)
Field type dimension
Data type string.text.value
product_type
Field label Product type
Description Type of product (N: Sponsored Search, J: Sponsored Product, ALL: Spopnsored Search + Sponsored Product)
Field type dimension
Data type string.text.value
placement
Field label Placement
Description The platforms used in the campaign (3:Search Result Page, 4:Just For You Page)
Field type dimension
Data type string.text.value
budget
Field label Budget
Description Budget indicates the maximum amount you’re willing to pay each day
Field type dimension
Data type string.text.value
budget_used_amount
Field label Budget used amount
Description Today used amount of the daily money allocated for a campaign or project
Field type dimension
Data type string.text.value
online_status
Field label Online status
Description The online status of the campaign (1:Online, 0:Offline, 9:Deleted)
Field type dimension
Data type string.text.value
switch_status
Field label Switch status
Description The switch status of the campaign (1:ON, 0:OFF)
Field type dimension
Data type string.text.value
max_bid
Field label Max bid
Description The maximum amount you are willing to pay for a specific action, such as a click or impression
Field type dimension
Data type string.text.value
start_date
Field label Start date
Description Campaign start date
Field type dimension
Data type string.time.date
end_date
Field label End date
Description Campaign end date
Field type dimension
Data type string.time.date

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

PERFORMANCE

impressions
Field label Impressions
Description An impression is counted each time your promoted product is shown. Impressions help you understand how often your product is being seen
Field type metric
Data type int.number.value
clicks
Field label Clicks
Description A click is counted each time someone clicks on your promoted product
Field type metric
Data type int.number.value
ctr
Field label CTR
Description Clickthrough rate (CTR) is the ratio showing how often people who see your promoted product end up clicking on it. It’s calculated as Clicks divided by Impressions
Field type metric
Data type float.number.ratio
spend
Field label Spend
Description Spend is the total amount spent
Field type metric
Data type float.currency.value
cpm
Field label CPM
Description Cost per mille ((Spend / Impressions) * 1000)
Field type metric
Data type float.currency.value
cpc
Field label CPC
Description The cost-per-click (CPC) is the average amount you pay each time someone clicks your promoted product. It’s calculated as Spend divided by Clicks
Field type metric
Data type float.currency.value

PROMOTED PRODUCT

promoted_product_name
Field label Promoted product name
Description Name of the product name
Field type dimension
Data type string.text.value
promoted_product_id
Field label Promoted product ID
Description The unique identified of the promoted product
Field type dimension
Data type string.text.value
product_id
Field label Product ID
Description The unique identifier of the product
Field type dimension
Data type string.text.value
product_max_bid
Field label Product max bid
Description Max bid determines the highest amount that you're willing to pay for a click on your promoted product
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

REVENUE

revenue
Field label Revenue
Description Total store revenue is generated from the units sold in your store after buyer(s) click your promoted product(s). It is the total amount paid by the buyer plus all discounts applied, store credit, shipping fees, and surcharges
Field type metric
Data type float.currency.value
roas
Field label ROAS
Description ROAS shows how efficient your Sponsored Discovery's spend is in driving revenue for your store. It is calculated as Revenue divided by Spend
Field type metric
Data type float.currency.value
units_sold
Field label Units sold
Description The total number of units sold after the shoppers click on your promoted product during the selected date range
Field type metric
Data type int.number.value
orders
Field label Orders
Description The total number of orders from your store during the selected time period, after someone clicks on your promoted product
Field type metric
Data type int.number.value
add_to_cart_units
Field label Add to cart units
Description The total number of units from your store added to cart after someone clicks your promoted product
Field type metric
Data type int.number.value
direct_add_to_cart_units
Field label Direct add to cart units
Description The total number of promoted product units added to cart after someone clicks on it
Field type metric
Data type int.number.value
direct_orders
Field label Direct orders
Description The total number of direct orders from your store during the selected time period, after someone clicks on your promoted product
Field type metric
Data type int.number.value
direct_units_sold
Field label Direct units sold
Description The number of promoted product units sold after shoppers click on them and purchase them
Field type metric
Data type int.number.value
direct_revenue
Field label Direct revenue
Description Revenue generated from your promoted product after someone clicks on it and purchases it. It is the total buyer paid amount inclusive of all discounts applied, store credit, shipping fees and surcharges
Field type metric
Data type float.currency.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.geo.country

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