Lazada Connector Reference

14 metrics47 dimensions

Fields

The Lazada connector exposes 61 fields (14 metrics, 47 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Lazada Fields

Lazada AdCampaigns fields

The AdCampaigns report of the Lazada connector includes 11 fields.

ID	Type	Name	Description
campaign_end_date	DATE	Campaign End Date	The end date of the campaign.
campaign_id	TEXT	Campaign ID	The unique identifier of the Sponsored Discovery campaign.
campaign_name	TEXT	Campaign Name	The name of the Sponsored Discovery campaign.
campaign_start_date	DATE	Campaign Start Date	The start date of the campaign.
campaign_status	TEXT	Campaign Status	The online status of the campaign (online, offline, deleted).
clicks	NUMERIC	Clicks	The number of ad clicks.
cpc	NUMERIC	CPC	Cost per click, spend divided by clicks.
ctr	PERCENT	CTR	Click-through rate, clicks divided by impressions.
daily_budget	NUMERIC	Daily Budget	The daily budget of the campaign.
impressions	NUMERIC	Impressions	The number of ad impressions.
spend	NUMERIC	Spend	The Sponsored Discovery ad spend.

Lazada AdProducts fields

The AdProducts report of the Lazada connector includes 9 fields.

ID	Type	Name	Description
ad_group_id	TEXT	Ad Group ID	The unique identifier of the ad group.
ad_group_name	TEXT	Ad Group Name	The name of the ad group.
ad_image_url	IMAGE_URL	Ad Product Image	The image URL of the advertised product.
ad_product_id	TEXT	Ad Product ID	The item ID of the advertised product.
ad_status	TEXT	Ad Status	The online status of the ad group (online, offline, deleted).
bid_price	NUMERIC	Bid Price	The bid price set for the ad group.
revenue	NUMERIC	Revenue	The revenue attributed to the ads.
roas	PERCENT	ROAS	Return on ad spend, revenue divided by spend.
units_sold	NUMERIC	Units Sold	The number of units sold attributed to the ads.

Lazada Categories fields

The Categories report of the Lazada connector includes 5 fields.

ID	Type	Name	Description
category_id	TEXT	Category ID	The unique identifier of the category.
category_leaf	BOOLEAN	Category Leaf	Whether the category is a leaf category.
category_name	TEXT	Category Name	The name of the category.
category_path	TEXT	Category Path	The full path of the category in the tree.
parent_category_id	TEXT	Parent Category ID	The identifier of the parent category.

Lazada General fields

The General report of the Lazada connector includes 3 fields.

ID	Type	Name	Description
account_id	TEXT	Account ID	The seller ID of the connected Lazada account.
account_name	TEXT	Account Name	The name of the connected Lazada account.
date	DATE	Date	The date of the record.

Lazada Products fields

The Products report of the Lazada connector includes 15 fields.

ID	Type	Name	Description
brand	TEXT	Brand	The brand of the product.
created_time	TIMESTAMP	Product Created Time	The date and time the product was created.
primary_category	TEXT	Primary Category	The primary category ID of the product.
product_available	NUMERIC	Product Available	The available quantity of the SKU.
product_id	TEXT	Product ID	The unique identifier of the product.
product_name	TEXT	Product Name	The name of the product.
product_price	NUMERIC	Product Price	The price of the SKU.
product_quantity	NUMERIC	Product Quantity	The stock quantity of the SKU.
product_special_price	NUMERIC	Product Special Price	The special (discounted) price of the SKU.
product_status	TEXT	Product Status	The status of the product.
seller_sku	TEXT	Seller SKU	The seller-defined SKU code.
shop_sku	TEXT	Shop SKU	The Lazada shop SKU code.
sku_id	TEXT	SKU ID	The unique identifier of the SKU.
sku_status	TEXT	SKU Status	The status of the SKU.
updated_time	TIMESTAMP	Product Updated Time	The date and time the product was last updated.

Lazada other fields

The Lazada connector has 18 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
week	TEXT	Week	Week (Sun-Sat).
week_day	TEXT	Day of week and day number	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso	TEXT	Day of week and day number, ISO	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso	TEXT	Week ISO	Week, ISO format (Mon-Sun).
year	TEXT	Year	Year
year_month	TEXT	Yearmonth	Year and month, e.g. 2024\|3
year_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
year_of_week	TEXT	Year of week	The year that contains first day of the week (Sun-Sat).
year_of_week_iso	TEXT	Year of week, ISO	The year that contains first day of the ISO week (Mon-Sun).
year_week	TEXT	Year week	Year and week for US weeks (Sun-Sat), e.g. 2024\|15
year_week_iso	TEXT	Year week ISO	Year and week for ISO weeks (Mon-Sun), e.g. 2024\|20

API Connectors