Walmart Connect: Most-used fields

The table below gives information about most-used fields that you can import from Walmart Connect. Other fields might also be available in Adverity.

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.

API name	Adverity UI name	Description	Use in Adverity
adGroupId	adGroupId	The unique identifier for an ad group, which is a collection of ads and keywords within a campaign.	dimension
adGroupName	adGroupName	The name of the ad group.	dimension
adSpend	adSpend	The total amount of budget spent on advertising in dollars. This can be calculated as Cost Per Click (CPC) multiplied by the number of clicks.	metric
advertisedSkuSales14days	advertisedSkuSales14days	The total sales generated by the advertised SKU within a 14-day attribution window.	metric
advertiserId	advertiserId	Unique numeric identifier for the advertiser, also known as the advertising account ID.	metric
attributedFeaturedOrders14days	attributedFeaturedOrders14days	Number of orders for products featured in an ad campaign, attributed to the campaign within a 14-day attribution window.	metric
attributedFeaturedSales14days	attributedFeaturedSales14days	Sales revenue for products featured in an ad campaign, attributed to the campaign within a 14-day attribution window.	metric
attributedOrders14days	attributedOrders14days	Number of orders attributed to the advertising campaign within a 14-day attribution window.	metric
attributedSales14days	attributedSales14days	Sales revenue attributed to the advertising campaign within a 14-day attribution window.	metric
campaignExtId	campaignExtId	External identifier for the campaign.	metric
campaignId	campaignId	The unique identifier for a specific advertising campaign.	dimension
campaignName	campaignName	Name of the advertising campaign.	dimension
date	date	Specific day for which the report data is available, in ‘yyyy-MM-dd’ format.	dimension
endDate	endDate	The last day to be considered for the performance report snapshot, in ‘yyyy-MM-dd’ format.	dimension
itemId	itemId	The unique identifier for an item on Walmart.com.	dimension
itemName	itemName	The name of the item on Walmart.com.	dimension
keywordId	keywordId	The unique identifier for a specific keyword used in a campaign.	dimension
lineItemExtId	lineItemExtId	External identifier for the line item within a campaign.	metric
lineItemName	lineItemName	Name of the line item within a campaign.	dimension
ntbOrders14days	ntbOrders14days	The number of orders from new-to-brand customers within a 14-day attribution window.	metric
ntbRevenue14days	ntbRevenue14days	The revenue generated from new-to-brand customers within a 14-day attribution window.	metric
numAdsClicks	numAdsClicks	Total number of clicks on the ads.	metric
numAdsShown	numAdsShown	Total number of times the ads were shown (impressions).	metric
orderFrequency	orderFrequency	Represents the frequency of orders attributed to advertising campaigns within a specified attribution window. This metric can be derived from the available ‘attributedOrders’ or ‘viewThroughOrders’ data over different timeframes (e.g., 3, 14, or 30 days).	dimension
pointOfSale	pointOfSale	The channel or location where a sale was made, such as online (Walmart.com), delivery, pickup, or in-store. This helps categorize where attributed sales occurred.	dimension
startDate	startDate	The first day to be considered for the performance report snapshot, in ‘yyyy-MM-dd’ format.	dimension
totalBuyers14Days	totalBuyers14Days	The total number of unique buyers who made a purchase within a 14-day attribution window after viewing or clicking an ad.	metric