Walmart Connect#
The table below gives information about all the data fields that you can import from Walmart Connect.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs. As a result, the fields shown here may not be the same as the fields available in Adverity. If you notice a difference between this documentation and the fields you see in Adverity, please contact your Adverity account manager for more information.
To see the fields you can collect from another data source, go back to the Available fields in Adverity overview.
Field UI name below refers to how the name displayed in Adverity.
Field API name |
Description |
---|---|
Error |
Contains error details if the API request fails. |
GTIN |
The Global Trade Item Number of the item. |
UPC |
The Universal Product Code of the item. |
adGroupId |
The unique identifier for an ad group within a campaign. |
adGroupName |
The name of the ad group. |
adSpend |
The total amount of money spent on advertising. |
advertisedItemId |
The unique identifier of the specific item that was advertised. |
advertisedSkuSales14days |
Sales value of the specific SKU that was advertised, attributed to ad clicks within a 14-day window. |
advertisedSkuSales30days |
Sales value of the specific SKU that was advertised, attributed to ad clicks within a 30-day window. |
advertisedSkuSales3days |
Sales value of the specific SKU that was advertised, attributed to ad clicks within a 3-day window. |
advertisedSkuUnits14days |
Number of units of the specific SKU that was advertised, attributed to ad clicks within a 14-day window. |
advertisedSkuUnits30days |
Number of units of the specific SKU that was advertised, attributed to ad clicks within a 30-day window. |
advertisedSkuUnits3days |
Number of units of the specific SKU that was advertised, attributed to ad clicks within a 3-day window. |
advertiserId |
The unique identifier for the advertiser’s account. |
attributedFeaturedOrders14days |
|
attributedFeaturedOrders30days |
|
attributedFeaturedSales14days |
|
attributedFeaturedSales30days |
|
attributedHaloOrders14days |
Number of orders for related products (different brand, same category) attributed to ad clicks within a 14-day window. |
attributedHaloOrders30days |
Number of orders for related products (different brand, same category) attributed to ad clicks within a 30-day window. |
attributedHaloSales14days |
Sales value of related products (different brand, same category) attributed to ad clicks within a 14-day window. ‘Halo’ is synonymous with ‘related’. |
attributedHaloSales30days |
Sales value of related products (different brand, same category) attributed to ad clicks within a 30-day window. ‘Halo’ is synonymous with ‘related’. |
attributedOrders14days |
Total number of orders attributed to ad clicks within a 14-day window. |
attributedOrders30days |
Total number of orders attributed to ad clicks within a 30-day window. |
attributedOrders3days |
Total number of orders attributed to ad clicks within a 3-day window. |
attributedOrdersPct |
|
attributedSales14days |
Total sales value from all attributed sales (direct, brand, and related) within a 14-day window. |
attributedSales30days |
Total sales value from all attributed sales (direct, brand, and related) within a 30-day window. |
attributedSales3days |
Total sales value from all attributed sales (direct, brand, and related) within a 3-day window. |
attributedSalesPct |
|
attributedUnits14days |
Total number of units sold attributed to ad clicks within a 14-day window. |
attributedUnits30days |
Total number of units sold attributed to ad clicks within a 30-day window. |
attributedUnits3days |
Total number of units sold attributed to ad clicks within a 3-day window. |
attributionType |
The type of attribution (e.g. ‘CLICK’, ‘VIEW’). |
attributionWindow |
The number of days after an ad event (click or view) during which a conversion can be recorded. |
availabilityStatus |
The stock status of the item (e.g., ‘In Stock’, ‘Out of Stock’). |
averageRating |
The average customer rating for the item. |
avgCapOutTime |
|
baseItemId |
|
baseVariantIdentifier |
|
biddedKeyword |
The keyword text that was bid on. |
biddingStrategy |
The bidding strategy used for the ad group (e.g., ‘CPC’). |
brand |
The brand name of the item. |
brandAttributedSales14days |
Sales value of other products from the same brand as the advertised product, attributed to ad clicks within a 14-day window. |
brandAttributedSales30days |
Sales value of other products from the same brand as the advertised product, attributed to ad clicks within a 30-day window. |
brandAttributedSales3days |
Sales value of other products from the same brand as the advertised product, attributed to ad clicks within a 3-day window. |
brandClickRevenue30days |
Revenue from sales of same-brand products attributed to ad clicks within a 30-day window. |
brandClickRevenue3days |
Revenue from sales of same-brand products attributed to ad clicks within a 3-day window. |
brandName |
The brand name of the item. |
brandViewRevenue30days |
Revenue from sales of same-brand products attributed to an ad impression (view) without a click, within a 30-day window. |
brandViewRevenue3days |
Revenue from sales of same-brand products attributed to an ad impression (view) without a click, within a 3-day window. |
budgetType |
The type of budget, which can be ‘daily’ or ‘total’ (lifetime). |
buyboxWinnerPrice |
The price of the item that is currently winning the Buy Box. |
campaignExtId |
External identifier for the campaign. |
campaignId |
The unique identifier for an advertising campaign. |
campaignName |
The name of the advertising campaign. |
campaignOptions |
|
campaignType |
The type of campaign (e.g., ‘Sponsored Products’, ‘Display’). |
catalogItemId |
The unique identifier for an item in the Walmart catalog. |
catalogItemName |
The name of the item as it appears in the Walmart catalog. |
category |
The product category of the item. |
channel |
The sales channel where the purchase occurred (e.g., ‘Marketplace’, ‘Walmart’). |
clickRevenue30days |
Total revenue from all sales attributed to ad clicks within a 30-day window. |
clickRevenue3days |
Total revenue from all sales attributed to ad clicks within a 3-day window. |
completeViewRevenue14days |
|
completeViewRevenue30days |
|
completeViewRevenue3days |
|
dailyBudget |
The maximum amount to be spent per day for a campaign. |
date |
The date for which the report data is provided, in YYYY-MM-DD format. |
deliveryAttributedFeaturedOrders14days |
|
deliveryAttributedFeaturedOrders30days |
|
deliveryAttributedFeaturedSales14days |
|
deliveryAttributedFeaturedSales30days |
|
deliveryAttributedHaloOrders14days |
|
deliveryAttributedHaloOrders30days |
|
deliveryAttributedHaloSales14days |
|
deliveryAttributedHaloSales30days |
|
deliveryAttributedOrders14days |
|
deliveryAttributedOrders30days |
|
deliveryAttributedSales14days |
|
deliveryAttributedSales30days |
|
directAttributedSales14days |
Sales value of the exact advertised product, attributed to ad clicks within a 14-day window. |
directAttributedSales30days |
Sales value of the exact advertised product, attributed to ad clicks within a 30-day window. |
directAttributedSales3days |
Sales value of the exact advertised product, attributed to ad clicks within a 3-day window. |
ds |
Date partition column, typically in YYYY-MM-DD format. |
endDate |
|
inventoryCount |
The number of items currently in stock. |
itemCreationDate |
The date the item was created in the Walmart catalog. |
itemId |
The unique identifier for an item. |
itemImage |
A URL for the item’s image. |
itemImageUrl |
A URL for the item’s image. |
itemLastUpdatedDate |
The date the item’s information was last updated. |
itemName |
The name of the item. |
itemPageUrl |
The URL of the item’s product detail page on Walmart.com. |
item_brand_1 |
|
item_brand_2 |
|
item_brand_3 |
|
item_id_1 |
|
item_id_2 |
|
item_id_3 |
|
item_name_1 |
|
item_name_2 |
|
item_name_3 |
|
keywordId |
The unique identifier for a keyword. |
keyword_rank |
|
lineItemExtId |
|
lineItemName |
|
matchType |
For keyword targeting, the match type (e.g., ‘BROAD’, ‘PHRASE’, ‘EXACT’). |
missedClicksLower |
|
missedClicksUpper |
|
missedImpressionsLower |
|
missedImpressionsUpper |
|
monthOf |
The starting date of the month for which the report data is aggregated. |
name |
A generic name field, context depends on the report (e.g., campaign name, ad group name). |
ntbOrders14days |
|
ntbOrders30days |
|
ntbOrders3days |
|
ntbRevenue14days |
|
ntbRevenue30days |
|
ntbRevenue3days |
|
ntbUnits14days |
|
ntbUnits30days |
|
ntbUnits3days |
|
numAdsClicks |
The total number of clicks an ad received. |
numAdsShown |
The total number of times an ad was displayed (impressions). |
orderFrequency |
|
otherSkuSales14days |
Sales value of other SKUs from the same brand, attributed to ad clicks within a 14-day window. |
otherSkuSales30days |
Sales value of other SKUs from the same brand, attributed to ad clicks within a 30-day window. |
otherSkuSales3days |
Sales value of other SKUs from the same brand, attributed to ad clicks within a 3-day window. |
otherSkuUnits14days |
Number of units of other SKUs from the same brand sold, attributed to ad clicks within a 14-day window. |
otherSkuUnits30days |
Number of units of other SKUs from the same brand sold, attributed to ad clicks within a 30-day window. |
otherSkuUnits3days |
Number of units of other SKUs from the same brand sold, attributed to ad clicks within a 3-day window. |
pageType |
The type of page where the ad was displayed (e.g., ‘SEARCH’, ‘ITEM’, ‘CATEGORY’). |
pageViewBasedAvailabilityRate |
|
pageViewBasedBuyboxWinRate |
|
pct_click_share_item_1 |
|
pct_click_share_item_2 |
|
pct_click_share_item_3 |
|
pct_conv_share_item_1 |
|
pct_conv_share_item_2 |
|
pct_conv_share_item_3 |
|
pickupAttributedFeaturedOrders14days |
|
pickupAttributedFeaturedOrders30days |
|
pickupAttributedFeaturedSales14days |
|
pickupAttributedFeaturedSales30days |
|
pickupAttributedHaloOrders14days |
|
pickupAttributedHaloOrders30days |
|
pickupAttributedHaloSales14days |
|
pickupAttributedHaloSales30days |
|
pickupAttributedOrders14days |
|
pickupAttributedOrders30days |
|
pickupAttributedSales14days |
|
pickupAttributedSales30days |
|
placement |
The specific location where an ad is displayed (e.g., ‘Search In-grid’, ‘Buy Box’). |
platform |
The platform where the ad was shown (e.g., ‘Desktop’, ‘Mobile Web’, ‘Mobile App’). |
pointOfSale |
|
price |
The price of the item. |
publishedStatus |
The publication status of the entity (e.g. ‘PUBLISHED’, ‘UNPUBLISHED’). |
purchasedItemId |
The unique identifier of the item that was purchased. |
purchasedItemName |
The name of the item that was purchased. |
relatedAttributedSales14days |
Sales value of related products (different brand, same category) attributed to ad clicks within a 14-day window. |
relatedAttributedSales30days |
Sales value of related products (different brand, same category) attributed to ad clicks within a 30-day window. |
relatedAttributedSales3days |
Sales value of related products (different brand, same category) attributed to ad clicks within a 3-day window. |
relatedClickRevenue30days |
Revenue from sales of related products (different brand, same category) attributed to ad clicks within a 30-day window. |
relatedClickRevenue3days |
Revenue from sales of related products (different brand, same category) attributed to ad clicks within a 3-day window. |
replenishmentStatus |
|
reportDate |
The date for which the report data is provided, in YYYY-MM-DD format. |
report_date |
The date for which the report data is provided, in YYYY-MM-DD format. |
reviewCount |
The total number of customer reviews for the item. |
rollover |
|
salesChannel |
|
search_keyword |
The keyword that was searched for by the user. |
searchedKeyword |
The keyword that was searched for by the user. |
searchedKeywordImpressionRank |
|
searchedKeywordImpressionShare |
|
startDate |
|
status |
The current status of the entity (e.g., campaign, ad group) such as ‘ENABLED’, ‘PAUSED’, or ‘ENDED’. |
storeAttributedFeaturedOrders14days |
|
storeAttributedFeaturedOrders30days |
|
storeAttributedFeaturedSales14days |
|
storeAttributedFeaturedSales30days |
|
storeAttributedHaloOrders14days |
|
storeAttributedHaloOrders30days |
|
storeAttributedHaloSales14days |
|
storeAttributedHaloSales30days |
|
storeAttributedOrders14days |
|
storeAttributedOrders30days |
|
storeAttributedSales14days |
|
storeAttributedSales30days |
|
suggestedLatestDailyBudget |
|
suggestedLatestTotalBudget |
|
tactic |
The advertising tactic being used (e.g., ‘prospecting’, ‘retargeting’). |
targetingType |
The type of targeting used for the ad group, such as ‘KEYWORD’ or ‘PRODUCT’. |
tosSearchedKeywordImpressionRank |
|
tosSearchedKeywordImpressionShare |
|
totalBudget |
The total lifetime budget for a campaign. |
totalBuyers14Days |
|
totalBuyers30Days |
|
totalCompleteViewOrders14days |
|
totalCompleteViewOrders30days |
|
totalCompleteViewOrders3days |
|
totalCompleteViewUnits14days |
|
totalCompleteViewUnits30days |
|
totalCompleteViewUnits3days |
|
totalSales14days |
Total sales value from all attributed sales (direct, brand, and related) within a 14-day window. |
totalSales30days |
Total sales value from all attributed sales (direct, brand, and related) within a 30-day window. |
totalSales3days |
Total sales value from all attributed sales (direct, brand, and related) within a 3-day window. |
totalUnits14days |
Total number of units from all attributed sales (direct, brand, and related) within a 14-day window. |
totalUnits30days |
Total number of units from all attributed sales (direct, brand, and related) within a 30-day window. |
totalUnits3days |
Total number of units from all attributed sales (direct, brand, and related) within a 3-day window. |
unitSold30days |
Total number of units sold attributed to ad clicks within a 30-day window. |
unitSold3days |
Total number of units sold attributed to ad clicks within a 3-day window. |
validBids |
|
videoCompleteViews |
|
videoFirstQuartileViews |
|
videoImpressions |
|
videoMidpointViews |
|
videoThirdQuartileViews |
|
videoUnmutes |
|
viewRevenue30days |
Revenue attributed to an ad impression (view) without a click, within a 30-day window. |
viewRevenue3days |
Revenue attributed to an ad impression (view) without a click, within a 3-day window. |
viewThroughOrders14days |
Number of orders attributed to an ad impression (view) without a click, within a 14-day window. |
viewThroughOrders30days |
Number of orders attributed to an ad impression (view) without a click, within a 30-day window. |
viewThroughOrders3days |
Number of orders attributed to an ad impression (view) without a click, within a 3-day window. |
viewThroughSales14days |
Sales value attributed to an ad impression (view) without a click, within a 14-day window. |
viewThroughSales30days |
Sales value attributed to an ad impression (view) without a click, within a 30-day window. |
viewThroughSales3days |
Sales value attributed to an ad impression (view) without a click, within a 3-day window. |
viewThroughUnitsSold14days |
Number of units sold attributed to an ad impression (view) without a click, within a 14-day window. |
viewThroughUnitsSold30days |
Number of units sold attributed to an ad impression (view) without a click, within a 30-day window. |
viewThroughUnitsSold3days |
Number of units sold attributed to an ad impression (view) without a click, within a 3-day window. |
walmartItemNumber |
The Walmart-specific item number (WM#). |
walmartProductId |
The Product ID is a unique identifier assigned by Walmart to a group of variants. |
weekOf |
The starting date of the week for which the report data is aggregated. |