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 |
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 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 |
Unique numeric identifier for the advertiser, also known as the advertising account ID. |
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 method used to attribute sales or orders to an advertisement (e.g., click-through, view-through). |
dimension |
biddedKeyword |
biddedKeyword |
The actual keyword or category path used for bidding in a campaign. |
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 |
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 |
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 |
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 |
date |
date |
Specific day for which the report data is available, 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 |
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 |
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 |
Total number of clicks on the ads. |
metric |
numAdsShown |
numAdsShown |
Total number of times the ads were shown (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 |
Unique identifier for the item that was purchased. |
metric |
purchasedItemName |
purchasedItemName |
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 |
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 |
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 |
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 |
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 |