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 |
|---|---|---|---|
accAttributedFeaturedOrders14days |
accAttributedFeaturedOrders14days |
The number of orders attributed to an ad for the featured product (the advertised item) within a 14-day attribution window, aggregated across all channels (acceleration). |
metric |
accAttributedFeaturedSales14days |
accAttributedFeaturedSales14days |
The sales amount attributed to an ad for the featured product (the advertised item) within a 14-day attribution window, aggregated across all channels (acceleration). |
metric |
accAttributedFeaturedUnits14days |
accAttributedFeaturedUnits14days |
The number of units sold attributed to an ad for the featured product (the advertised item) within a 14-day attribution window, aggregated across all channels (acceleration). |
metric |
accAttributedHaloOrders14days |
accAttributedHaloOrders14days |
The number of orders attributed to an ad for halo products (products other than the advertised item but purchased by the same customer) within a 14-day attribution window, aggregated across all channels (acceleration). |
metric |
accAttributedHaloSales14days |
accAttributedHaloSales14days |
The sales amount attributed to an ad for halo products (products other than the advertised item but purchased by the same customer) within a 14-day attribution window, aggregated across all channels (acceleration). |
metric |
accAttributedHaloUnits14days |
accAttributedHaloUnits14days |
The number of units sold attributed to an ad for halo products (products other than the advertised item but purchased by the same customer) within a 14-day attribution window, aggregated across all channels (acceleration). |
metric |
accAttributedSales14days |
accAttributedSales14days |
The total sales amount attributed to an ad (including both featured and halo products) within a 14-day attribution window, aggregated across all channels (acceleration). |
metric |
accAttributedUnits14days |
accAttributedUnits14days |
The total number of units sold attributed to an ad (including both featured and halo products) within a 14-day attribution window, aggregated across all channels (acceleration). |
metric |
adGroupId |
adGroupId |
Unique identifier for the ad group. |
metric |
adGroupName |
adGroupName |
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 |
advertisedItemId |
advertisedItemId |
Unique identifier for the item that was advertised. |
metric |
advertisedSkuSales14days |
advertisedSkuSales14days |
Sales revenue generated specifically by advertised SKUs within a 14-day attribution window. |
metric |
advertisedSkuSales30days |
advertisedSkuSales30days |
Sales revenue generated specifically by advertised SKUs within a 30-day attribution window. |
metric |
advertisedSkuSales3days |
advertisedSkuSales3days |
Sales revenue generated specifically by advertised SKUs within a 3-day attribution window. |
metric |
advertisedSkuUnits14days |
advertisedSkuUnits14days |
Number of units sold specifically for advertised SKUs within a 14-day attribution window. |
metric |
advertisedSkuUnits30days |
advertisedSkuUnits30days |
Number of units sold specifically for advertised SKUs within a 30-day attribution window. |
metric |
advertisedSkuUnits3days |
advertisedSkuUnits3days |
Number of units sold specifically for advertised SKUs within a 3-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 |
attributedFeaturedUnits14days |
attributedFeaturedUnits14days |
Number of units sold for products featured in an ad campaign, attributed to the campaign within a 14-day attribution window. |
metric |
attributedHaloOrders14days |
attributedHaloOrders14days |
Number of orders for non-advertised products from the same brand (halo products), attributed to the advertising campaign within a 14-day attribution window. |
metric |
attributedHaloSales14days |
attributedHaloSales14days |
Sales revenue for non-advertised products from the same brand (halo products), attributed to the advertising campaign within a 14-day attribution window. |
metric |
attributedHaloUnits14days |
attributedHaloUnits14days |
Number of units sold for non-advertised products from the same brand (halo products), attributed to the advertising 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 |
attributedOrders30days |
attributedOrders30days |
Number of orders attributed to the advertising campaign within a 30-day attribution window. |
metric |
attributedOrders3days |
attributedOrders3days |
Number of orders attributed to the advertising campaign within a 3-day attribution window. |
metric |
attributedSales14days |
attributedSales14days |
Sales revenue attributed to the advertising campaign within a 14-day attribution window. |
metric |
attributedSales30days |
attributedSales30days |
Sales revenue attributed to the advertising campaign within a 30-day attribution window. |
metric |
attributedSales3days |
attributedSales3days |
Sales revenue attributed to the advertising campaign within a 3-day attribution window. |
metric |
attributedUnits14days |
attributedUnits14days |
Number of units sold attributed to the advertising campaign within a 14-day attribution window. |
metric |
attributedUnits30days |
attributedUnits30days |
Number of units sold attributed to the advertising campaign within a 30-day attribution window. |
metric |
attributedUnits3days |
attributedUnits3days |
Number of units sold attributed to the advertising campaign within a 3-day attribution window. |
metric |
attributionType |
attributionType |
The method used to attribute a sale or order to an ad interaction (e.g., last click, view-through, featured product, halo product). This field specifies the attribution model applied. |
dimension |
biddedKeyword |
biddedKeyword |
The actual keyword or category path used for bidding in a campaign. |
dimension |
biddingStrategy |
biddingStrategy |
The bidding strategy for the campaign, which can be DYNAMIC, FIXED, or TROAS. |
dimension |
brandAttributedSales14days |
brandAttributedSales14days |
Sales attributed to brand advertisements within a 14-day attribution window. |
metric |
brandAttributedSales30days |
brandAttributedSales30days |
Sales attributed to brand advertisements within a 30-day attribution window. |
metric |
brandAttributedSales3days |
brandAttributedSales3days |
Sales attributed to brand advertisements within a 3-day attribution window. |
metric |
brandClickRevenue30days |
brandClickRevenue30days |
Attributed sales revenue in dollars based on a direct click of the same brand as the advertised item, over a 30-day click attribution window. |
metric |
brandClickRevenue3days |
brandClickRevenue3days |
Attributed sales revenue in dollars based on a direct click of the same brand as the advertised item, over a 3-day click attribution window. |
metric |
brandViewRevenue30days |
brandViewRevenue30days |
Attributed sales revenue in dollars based on a view of the same brand as the advertised item, over a 30-day view attribution window. |
metric |
brandViewRevenue3days |
brandViewRevenue3days |
Attributed sales revenue in dollars based on a view of the same brand as the advertised item, over a 3-day view attribution window. |
metric |
budgetType |
budgetType |
The type of budget for the campaign, e.g., “daily” or “total”, or “both”. |
dimension |
campaignExtId |
campaignExtId |
External identifier for the campaign. |
metric |
campaignId |
campaignId |
Unique identifier for the advertising campaign. |
metric |
campaignName |
campaignName |
Name of the advertising campaign. |
dimension |
campaignOptions |
campaignOptions |
Campaign-specific options, such as opting out of brand term targeting. New automatic campaigns are opted in to Brand Term Targeting by default. |
dimension |
campaignType |
campaignType |
The type of advertising campaign, such as Sponsored Products, Sponsored Brands (SBA), or Video. |
dimension |
channel |
channel |
The sales channel where the ad was displayed, such as Walmart.com. |
dimension |
clickRevenue30days |
clickRevenue30days |
Attributed sales revenue in dollars based on a direct click of the advertised item, over a 30-day click attribution window. |
metric |
clickRevenue3days |
clickRevenue3days |
Attributed sales revenue in dollars based on a direct click of the advertised item, over a 3-day click attribution window. |
metric |
creativeId |
creativeId |
Unique identifier for an ad creative. |
dimension |
creativeName |
creativeName |
Name of the ad creative. |
dimension |
dailyBudget |
dailyBudget |
The maximum amount allocated for the campaign’s daily spending. |
dimension |
date |
date |
Specific day for which the report data is available, in ‘yyyy-MM-dd’ format. |
dimension |
deliveryAttributedFeaturedOrders14days |
deliveryAttributedFeaturedOrders14days |
The number of delivery orders attributed to an ad for the featured product (the advertised item) within a 14-day attribution window. |
metric |
deliveryAttributedFeaturedSales14days |
deliveryAttributedFeaturedSales14days |
The sales amount from delivery orders attributed to an ad for the featured product (the advertised item) within a 14-day attribution window. |
metric |
deliveryAttributedFeaturedUnits14days |
deliveryAttributedFeaturedUnits14days |
The number of units sold via delivery attributed to an ad for the featured product (the advertised item) within a 14-day attribution window. |
metric |
deliveryAttributedHaloOrders14days |
deliveryAttributedHaloOrders14days |
The number of delivery orders attributed to an ad for halo products (products other than the advertised item) within a 14-day attribution window. |
metric |
deliveryAttributedHaloSales14days |
deliveryAttributedHaloSales14days |
The sales amount from delivery orders attributed to an ad for halo products (products other than the advertised item) within a 14-day attribution window. |
metric |
deliveryAttributedHaloUnits14days |
deliveryAttributedHaloUnits14days |
The number of units sold via delivery attributed to an ad for halo products (products other than the advertised item) within a 14-day attribution window. |
metric |
deliveryAttributedOrders14days |
deliveryAttributedOrders14days |
The total number of delivery orders attributed to an ad (including both featured and halo products) within a 14-day attribution window. |
metric |
deliveryAttributedSales14days |
deliveryAttributedSales14days |
The total sales amount from delivery orders attributed to an ad (including both featured and halo products) within a 14-day attribution window. |
metric |
deliveryAttributedUnits14days |
deliveryAttributedUnits14days |
The total number of units sold via delivery attributed to an ad (including both featured and halo products) within a 14-day attribution window. |
metric |
directAttributedSales14days |
directAttributedSales14days |
Sales directly attributed to ads where the customer purchased the advertised product, within a 14-day attribution window. |
metric |
directAttributedSales30days |
directAttributedSales30days |
Sales directly attributed to ads where the customer purchased the advertised product, within a 30-day attribution window. |
metric |
directAttributedSales3days |
directAttributedSales3days |
Sales directly attributed to ads where the customer purchased the advertised product, within a 3-day attribution window. |
metric |
endDate |
endDate |
The last day to be considered for the performance report snapshot, in ‘yyyy-MM-dd’ format. |
dimension |
itemId |
itemId |
Unique identifier for the item (product) in the catalog. |
metric |
itemKeyword |
ds |
Specific day and time for which the item keyword report is pulled, in Date-Time format. |
metric |
itemName |
itemName |
Name of the item. |
dimension |
keywordId |
keywordId |
Unique identifier for the keyword, primarily for manual campaigns. |
metric |
lineItemExtId |
lineItemExtId |
External identifier for the line item within a campaign. |
metric |
lineItemName |
lineItemName |
Name of the line item within a campaign. |
dimension |
matchType |
matchType |
The matching criteria for keywords. Possible values include: exact, phrase, broad, or category. |
dimension |
name |
name |
The name of the advertising entity, such as a campaign, ad group, or media asset. |
dimension |
ntbOrders14days |
ntbOrders14days |
Number of orders placed by customers identified as new-to-brand, attributed to the advertising campaign within a 14-day window. |
metric |
ntbOrders30days |
ntbOrders30days |
Number of orders placed by customers identified as new-to-brand, attributed to the advertising campaign within a 30-day window. |
metric |
ntbOrders3days |
ntbOrders3days |
Number of orders placed by customers identified as new-to-brand, attributed to the advertising campaign within a 3-day window. |
metric |
ntbRevenue14days |
ntbRevenue14days |
Revenue generated from new-to-brand customers, attributed to the advertising campaign within a 14-day window. |
metric |
ntbRevenue30days |
ntbRevenue30days |
Revenue generated from new-to-brand customers, attributed to the advertising campaign within a 30-day window. |
metric |
ntbRevenue3days |
ntbRevenue3days |
Revenue generated from new-to-brand customers, attributed to the advertising campaign within a 3-day window. |
metric |
ntbUnits14days |
ntbUnits14days |
Number of units sold to customers identified as new-to-brand, attributed to the advertising campaign within a 14-day window. |
metric |
ntbUnits30days |
ntbUnits30days |
Number of units sold to customers identified as new-to-brand, attributed to the advertising campaign within a 30-day window. |
metric |
ntbUnits3days |
ntbUnits3days |
Number of units sold to customers identified as new-to-brand, attributed to the advertising campaign within a 3-day 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 |
This field represents the frequency of orders, typically measured over various attribution windows (e.g., 3, 14, or 30 days) and categorized by different attribution models (e.g., attributed, view-through, or total complete view orders). It indicates how often customers place orders after interacting with an advertisement. |
dimension |
otherSkuSales14days |
otherSkuSales14days |
Sales revenue generated by other (non-advertised) SKUs from the same seller, attributed to the advertising campaign within a 14-day window. |
metric |
otherSkuSales30days |
otherSkuSales30days |
Sales revenue generated by other (non-advertised) SKUs from the same seller, attributed to the advertising campaign within a 30-day window. |
metric |
otherSkuSales3days |
otherSkuSales3days |
Sales revenue generated by other (non-advertised) SKUs from the same seller, attributed to the advertising campaign within a 3-day window. |
metric |
otherSkuUnits14days |
otherSkuUnits14days |
Number of units sold for other (non-advertised) SKUs from the same seller, attributed to the advertising campaign within a 14-day window. |
metric |
otherSkuUnits30days |
otherSkuUnits30days |
Number of units sold for other (non-advertised) SKUs from the same seller, attributed to the advertising campaign within a 30-day window. |
metric |
otherSkuUnits3days |
otherSkuUnits3days |
Number of units sold for other (non-advertised) SKUs from the same seller, attributed to the advertising campaign within a 3-day window. |
metric |
pickupAttributedFeaturedOrders14days |
pickupAttributedFeaturedOrders14days |
The number of pickup orders attributed to an ad for the featured product (the advertised item) within a 14-day attribution window. |
metric |
pickupAttributedFeaturedSales14days |
pickupAttributedFeaturedSales14days |
The sales amount from pickup orders attributed to an ad for the featured product (the advertised item) within a 14-day attribution window. |
metric |
pickupAttributedFeaturedUnits14days |
pickupAttributedFeaturedUnits14days |
The number of units sold via pickup attributed to an ad for the featured product (the advertised item) within a 14-day attribution window. |
metric |
pickupAttributedHaloOrders14days |
pickupAttributedHaloOrders14days |
The number of pickup orders attributed to an ad for halo products (products other than the advertised item) within a 14-day attribution window. |
metric |
pickupAttributedHaloSales14days |
pickupAttributedHaloSales14days |
The sales amount from pickup orders attributed to an ad for halo products (products other than the advertised item) within a 14-day attribution window. |
metric |
pickupAttributedHaloUnits14days |
pickupAttributedHaloUnits14days |
The number of units sold via pickup attributed to an ad for halo products (products other than the advertised item) within a 14-day attribution window. |
metric |
pickupAttributedOrders14days |
pickupAttributedOrders14days |
The total number of pickup orders attributed to an ad (including both featured and halo products) within a 14-day attribution window. |
metric |
pickupAttributedSales14days |
pickupAttributedSales14days |
The total sales amount from pickup orders attributed to an ad (including both featured and halo products) within a 14-day attribution window. |
metric |
pickupAttributedUnits14days |
pickupAttributedUnits14days |
The total number of units sold via pickup attributed to an ad (including both featured and halo products) within a 14-day attribution window. |
metric |
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 |
purchasedItemId |
purchasedItemId |
Unique identifier for the item that was purchased. |
metric |
purchasedItemName |
purchasedItemName |
Name of the item that was purchased. |
dimension |
relatedAttributedSales14days |
relatedAttributedSales14days |
Sales attributed to ads where the customer purchased a product related to the advertised product, within a 14-day attribution window. |
metric |
relatedAttributedSales30days |
relatedAttributedSales30days |
Sales attributed to ads where the customer purchased a product related to the advertised product, within a 30-day attribution window. |
metric |
relatedAttributedSales3days |
relatedAttributedSales3days |
Sales attributed to ads where the customer purchased a product related to the advertised product, within a 3-day attribution window. |
metric |
relatedClickRevenue30days |
relatedClickRevenue30days |
Attributed sales revenue in dollars from related items based on a direct click of an advertised item, over a 30-day click attribution window. |
metric |
relatedClickRevenue3days |
relatedClickRevenue3days |
Attributed sales revenue in dollars from related items based on a direct click of an advertised item, over a 3-day click attribution window. |
metric |
rollover |
rollover |
Indicates whether any unspent daily budget can be rolled over to future days within the campaign period. |
dimension |
searchedKeyword |
searchedKeyword |
The search query entered by the site visitor when an ad is delivered, or the Item ID for ads delivered on item page placements. Maximum length is 60 characters. |
dimension |
startDate |
startDate |
The first day to be considered for the performance report snapshot, in ‘yyyy-MM-dd’ format. |
dimension |
status |
status |
The current status of the campaign or ad group, such as enabled, disabled, or deleted. |
dimension |
storeAttributedFeaturedOrders14days |
storeAttributedFeaturedOrders14days |
The number of in-store orders attributed to an ad for the featured product (the advertised item) within a 14-day attribution window. |
metric |
storeAttributedFeaturedSales14days |
storeAttributedFeaturedSales14days |
The sales amount from in-store orders attributed to an ad for the featured product (the advertised item) within a 14-day attribution window. |
metric |
storeAttributedFeaturedUnits14days |
storeAttributedFeaturedUnits14days |
The number of units sold in-store attributed to an ad for the featured product (the advertised item) within a 14-day attribution window. |
metric |
storeAttributedHaloOrders14days |
storeAttributedHaloOrders14days |
The number of in-store orders attributed to an ad for halo products (products other than the advertised item) within a 14-day attribution window. |
metric |
storeAttributedHaloSales14days |
storeAttributedHaloSales14days |
The sales amount from in-store orders attributed to an ad for halo products (products other than the advertised item) within a 14-day attribution window. |
metric |
storeAttributedHaloUnits14days |
storeAttributedHaloUnits14days |
The number of units sold in-store attributed to an ad for halo products (products other than the advertised item) within a 14-day attribution window. |
metric |
storeAttributedOrders14days |
storeAttributedOrders14days |
The total number of in-store orders attributed to an ad (including both featured and halo products) within a 14-day attribution window. |
metric |
storeAttributedSales14days |
storeAttributedSales14days |
The total sales amount from in-store orders attributed to an ad (including both featured and halo products) within a 14-day attribution window. |
metric |
storeAttributedUnits14days |
storeAttributedUnits14days |
The total number of units sold in-store attributed to an ad (including both featured and halo products) within a 14-day attribution window. |
metric |
targetingType |
targetingType |
The method used for targeting ads, such as manual or automatic targeting. |
dimension |
totalBudget |
totalBudget |
The total maximum amount allocated for the entire duration of the campaign. |
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 |
totalSales14days |
totalSales14days |
Total sales attributed to advertising within a 14-day attribution window. |
metric |
totalUnits14days |
totalUnits14days |
Total units sold attributed to advertising within a 14-day attribution window. |
metric |
unitSold30days |
unitSold30days |
Number of items sold based on a direct click, for a 30-day window. |
metric |
unitSold3days |
unitSold3days |
Number of items sold based on a direct click, for a 3-day window. |
metric |
viewRevenue30days |
viewRevenue30days |
Attributed sales revenue in dollars based on a view of the advertised item, over a 30-day view attribution window. Note: This metric is no longer supported after 3-1-2021 and its value will be 0. |
metric |
viewRevenue3days |
viewRevenue3days |
Attributed sales revenue in dollars based on a view of the advertised item, over a 3-day view attribution window. Note: This metric is no longer supported after 3-1-2021 and its value will be 0. |
metric |
walmart_connect_account_id |
walmart_connect_account_id |
The unique identifier for the Walmart Connect advertising account. |
dimension |