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 |
metric |
|
accAttributedFeaturedSales14days |
accAttributedFeaturedSales14days |
metric |
|
accAttributedFeaturedUnits14days |
accAttributedFeaturedUnits14days |
metric |
|
accAttributedHaloOrders14days |
accAttributedHaloOrders14days |
metric |
|
accAttributedHaloSales14days |
accAttributedHaloSales14days |
metric |
|
accAttributedHaloUnits14days |
accAttributedHaloUnits14days |
metric |
|
accAttributedSales14days |
accAttributedSales14days |
metric |
|
accAttributedUnits14days |
accAttributedUnits14days |
metric |
|
adGroupId |
adGroupId |
The unique identifier for an ad group within a campaign. |
metric |
adGroupName |
adGroupName |
The name of the ad group. |
dimension |
adSpend |
adSpend |
The total amount of money spent on advertising. |
metric |
advertisedItemId |
advertisedItemId |
The unique identifier of the specific item that was advertised. |
metric |
advertisedSkuSales14days |
advertisedSkuSales14days |
Sales value of the specific SKU that was advertised, attributed to ad clicks within a 14-day window. |
metric |
advertisedSkuSales30days |
advertisedSkuSales30days |
Sales value of the specific SKU that was advertised, attributed to ad clicks within a 30-day window. |
metric |
advertisedSkuSales3days |
advertisedSkuSales3days |
Sales value of the specific SKU that was advertised, attributed to ad clicks within a 3-day window. |
metric |
advertisedSkuUnits14days |
advertisedSkuUnits14days |
Number of units of the specific SKU that was advertised, attributed to ad clicks within a 14-day window. |
metric |
advertisedSkuUnits30days |
advertisedSkuUnits30days |
Number of units of the specific SKU that was advertised, attributed to ad clicks within a 30-day window. |
metric |
advertisedSkuUnits3days |
advertisedSkuUnits3days |
Number of units of the specific SKU that was advertised, attributed to ad clicks within a 3-day window. |
metric |
advertiserId |
advertiserId |
The unique identifier for the advertiser’s account. |
metric |
attributedFeaturedOrders14days |
attributedFeaturedOrders14days |
metric |
|
attributedFeaturedSales14days |
attributedFeaturedSales14days |
metric |
|
attributedFeaturedUnits14days |
attributedFeaturedUnits14days |
metric |
|
attributedHaloOrders14days |
attributedHaloOrders14days |
Number of orders for related products (different brand, same category) attributed to ad clicks within a 14-day window. |
metric |
attributedHaloSales14days |
attributedHaloSales14days |
Sales value of related products (different brand, same category) attributed to ad clicks within a 14-day window. ‘Halo’ is synonymous with ‘related’. |
metric |
attributedHaloUnits14days |
attributedHaloUnits14days |
metric |
|
attributedOrders14days |
attributedOrders14days |
Total number of orders attributed to ad clicks within a 14-day window. |
metric |
attributedOrders30days |
attributedOrders30days |
Total number of orders attributed to ad clicks within a 30-day window. |
metric |
attributedOrders3days |
attributedOrders3days |
Total number of orders attributed to ad clicks within a 3-day window. |
metric |
attributedSales14days |
attributedSales14days |
Total sales value from all attributed sales (direct, brand, and related) within a 14-day window. |
metric |
attributedSales30days |
attributedSales30days |
Total sales value from all attributed sales (direct, brand, and related) within a 30-day window. |
metric |
attributedSales3days |
attributedSales3days |
Total sales value from all attributed sales (direct, brand, and related) within a 3-day window. |
metric |
attributedUnits14days |
attributedUnits14days |
Total number of units sold attributed to ad clicks within a 14-day window. |
metric |
attributedUnits30days |
attributedUnits30days |
Total number of units sold attributed to ad clicks within a 30-day window. |
metric |
attributedUnits3days |
attributedUnits3days |
Total number of units sold attributed to ad clicks within a 3-day window. |
metric |
attributionType |
attributionType |
The type of attribution (e.g. ‘CLICK’, ‘VIEW’). |
dimension |
biddedKeyword |
biddedKeyword |
The keyword text that was bid on. |
dimension |
brandAttributedSales14days |
brandAttributedSales14days |
Sales value of other products from the same brand as the advertised product, attributed to ad clicks within a 14-day window. |
metric |
brandAttributedSales30days |
brandAttributedSales30days |
Sales value of other products from the same brand as the advertised product, attributed to ad clicks within a 30-day window. |
metric |
brandAttributedSales3days |
brandAttributedSales3days |
Sales value of other products from the same brand as the advertised product, attributed to ad clicks within a 3-day window. |
metric |
brandClickRevenue30days |
brandClickRevenue30days |
Revenue from sales of same-brand products attributed to ad clicks within a 30-day window. |
metric |
brandClickRevenue3days |
brandClickRevenue3days |
Revenue from sales of same-brand products attributed to ad clicks within a 3-day window. |
metric |
brandViewRevenue30days |
brandViewRevenue30days |
Revenue from sales of same-brand products attributed to an ad impression (view) without a click, within a 30-day window. |
metric |
brandViewRevenue3days |
brandViewRevenue3days |
Revenue from sales of same-brand products attributed to an ad impression (view) without a click, within a 3-day window. |
metric |
campaignExtId |
campaignExtId |
External identifier for the campaign. |
metric |
campaignId |
campaignId |
The unique identifier for an advertising campaign. |
metric |
campaignName |
campaignName |
The name of the advertising campaign. |
dimension |
clickRevenue30days |
clickRevenue30days |
Total revenue from all sales attributed to ad clicks within a 30-day window. |
metric |
clickRevenue3days |
clickRevenue3days |
Total revenue from all sales attributed to ad clicks within a 3-day window. |
metric |
creativeId |
creativeId |
dimension |
|
creativeName |
creativeName |
dimension |
|
date |
date |
The date for which the report data is provided, in YYYY-MM-DD format. |
dimension |
deliveryAttributedFeaturedOrders14days |
deliveryAttributedFeaturedOrders14days |
metric |
|
deliveryAttributedFeaturedSales14days |
deliveryAttributedFeaturedSales14days |
metric |
|
deliveryAttributedFeaturedUnits14days |
deliveryAttributedFeaturedUnits14days |
metric |
|
deliveryAttributedHaloOrders14days |
deliveryAttributedHaloOrders14days |
metric |
|
deliveryAttributedHaloSales14days |
deliveryAttributedHaloSales14days |
metric |
|
deliveryAttributedHaloUnits14days |
deliveryAttributedHaloUnits14days |
metric |
|
deliveryAttributedOrders14days |
deliveryAttributedOrders14days |
metric |
|
deliveryAttributedSales14days |
deliveryAttributedSales14days |
metric |
|
deliveryAttributedUnits14days |
deliveryAttributedUnits14days |
metric |
|
directAttributedSales14days |
directAttributedSales14days |
Sales value of the exact advertised product, attributed to ad clicks within a 14-day window. |
metric |
directAttributedSales30days |
directAttributedSales30days |
Sales value of the exact advertised product, attributed to ad clicks within a 30-day window. |
metric |
directAttributedSales3days |
directAttributedSales3days |
Sales value of the exact advertised product, attributed to ad clicks within a 3-day window. |
metric |
endDate |
endDate |
dimension |
|
itemId |
itemId |
The unique identifier for an item. |
metric |
itemKeyword |
ds |
metric |
|
itemName |
itemName |
The name of the item. |
dimension |
keywordId |
keywordId |
The unique identifier for a keyword. |
metric |
lineItemExtId |
lineItemExtId |
metric |
|
lineItemName |
lineItemName |
dimension |
|
matchType |
matchType |
For keyword targeting, the match type (e.g., ‘BROAD’, ‘PHRASE’, ‘EXACT’). |
dimension |
ntbOrders14days |
ntbOrders14days |
metric |
|
ntbOrders30days |
ntbOrders30days |
metric |
|
ntbOrders3days |
ntbOrders3days |
metric |
|
ntbRevenue14days |
ntbRevenue14days |
metric |
|
ntbRevenue30days |
ntbRevenue30days |
metric |
|
ntbRevenue3days |
ntbRevenue3days |
metric |
|
ntbUnits14days |
ntbUnits14days |
metric |
|
ntbUnits30days |
ntbUnits30days |
metric |
|
ntbUnits3days |
ntbUnits3days |
metric |
|
numAdsClicks |
numAdsClicks |
The total number of clicks an ad received. |
metric |
numAdsShown |
numAdsShown |
The total number of times an ad was displayed (impressions). |
metric |
orderFrequency |
orderFrequency |
dimension |
|
otherSkuSales14days |
otherSkuSales14days |
Sales value of other SKUs from the same brand, attributed to ad clicks within a 14-day window. |
metric |
otherSkuSales30days |
otherSkuSales30days |
Sales value of other SKUs from the same brand, attributed to ad clicks within a 30-day window. |
metric |
otherSkuSales3days |
otherSkuSales3days |
Sales value of other SKUs from the same brand, attributed to ad clicks within a 3-day window. |
metric |
otherSkuUnits14days |
otherSkuUnits14days |
Number of units of other SKUs from the same brand sold, attributed to ad clicks within a 14-day window. |
metric |
otherSkuUnits30days |
otherSkuUnits30days |
Number of units of other SKUs from the same brand sold, attributed to ad clicks within a 30-day window. |
metric |
otherSkuUnits3days |
otherSkuUnits3days |
Number of units of other SKUs from the same brand sold, attributed to ad clicks within a 3-day window. |
metric |
pickupAttributedFeaturedOrders14days |
pickupAttributedFeaturedOrders14days |
metric |
|
pickupAttributedFeaturedSales14days |
pickupAttributedFeaturedSales14days |
metric |
|
pickupAttributedFeaturedUnits14days |
pickupAttributedFeaturedUnits14days |
metric |
|
pickupAttributedHaloOrders14days |
pickupAttributedHaloOrders14days |
metric |
|
pickupAttributedHaloSales14days |
pickupAttributedHaloSales14days |
metric |
|
pickupAttributedHaloUnits14days |
pickupAttributedHaloUnits14days |
metric |
|
pickupAttributedOrders14days |
pickupAttributedOrders14days |
metric |
|
pickupAttributedSales14days |
pickupAttributedSales14days |
metric |
|
pickupAttributedUnits14days |
pickupAttributedUnits14days |
metric |
|
pointOfSale |
pointOfSale |
dimension |
|
purchasedItemId |
purchasedItemId |
The unique identifier of the item that was purchased. |
metric |
purchasedItemName |
purchasedItemName |
The name of the item that was purchased. |
dimension |
relatedAttributedSales14days |
relatedAttributedSales14days |
Sales value of related products (different brand, same category) attributed to ad clicks within a 14-day window. |
metric |
relatedAttributedSales30days |
relatedAttributedSales30days |
Sales value of related products (different brand, same category) attributed to ad clicks within a 30-day window. |
metric |
relatedAttributedSales3days |
relatedAttributedSales3days |
Sales value of related products (different brand, same category) attributed to ad clicks within a 3-day window. |
metric |
relatedClickRevenue30days |
relatedClickRevenue30days |
Revenue from sales of related products (different brand, same category) attributed to ad clicks within a 30-day window. |
metric |
relatedClickRevenue3days |
relatedClickRevenue3days |
Revenue from sales of related products (different brand, same category) attributed to ad clicks within a 3-day window. |
metric |
searchedKeyword |
searchedKeyword |
The keyword that was searched for by the user. |
dimension |
startDate |
startDate |
dimension |
|
storeAttributedFeaturedOrders14days |
storeAttributedFeaturedOrders14days |
metric |
|
storeAttributedFeaturedSales14days |
storeAttributedFeaturedSales14days |
metric |
|
storeAttributedFeaturedUnits14days |
storeAttributedFeaturedUnits14days |
metric |
|
storeAttributedHaloOrders14days |
storeAttributedHaloOrders14days |
metric |
|
storeAttributedHaloSales14days |
storeAttributedHaloSales14days |
metric |
|
storeAttributedHaloUnits14days |
storeAttributedHaloUnits14days |
metric |
|
storeAttributedOrders14days |
storeAttributedOrders14days |
metric |
|
storeAttributedSales14days |
storeAttributedSales14days |
metric |
|
storeAttributedUnits14days |
storeAttributedUnits14days |
metric |
|
totalBuyers14Days |
totalBuyers14Days |
metric |
|
totalSales14days |
totalSales14days |
Total sales value from all attributed sales (direct, brand, and related) within a 14-day window. |
metric |
totalUnits14days |
totalUnits14days |
Total number of units from all attributed sales (direct, brand, and related) within a 14-day window. |
metric |
unitSold30days |
unitSold30days |
Total number of units sold attributed to ad clicks within a 30-day window. |
metric |
unitSold3days |
unitSold3days |
Total number of units sold attributed to ad clicks within a 3-day window. |
metric |
viewRevenue30days |
viewRevenue30days |
Revenue attributed to an ad impression (view) without a click, within a 30-day window. |
metric |
viewRevenue3days |
viewRevenue3days |
Revenue attributed to an ad impression (view) without a click, within a 3-day window. |
metric |
walmart_connect_account_id |
walmart_connect_account_id |
dimension |