Walmart Connect

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.