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 |
Orders for featured products attributed to an ad, aggregated by an unspecified accumulation method, within a 14-day attribution window. |
metric |
accAttributedFeaturedSales14days |
accAttributedFeaturedSales14days |
Sales for featured products attributed to an ad, aggregated by an unspecified accumulation method, within a 14-day attribution window. |
metric |
accAttributedFeaturedUnits14days |
accAttributedFeaturedUnits14days |
Units sold for featured products attributed to an ad, aggregated by an unspecified accumulation method, within a 14-day attribution window. |
metric |
accAttributedHaloOrders14days |
accAttributedHaloOrders14days |
Halo orders attributed to an ad, aggregated by an unspecified accumulation method, within a 14-day attribution window. |
metric |
accAttributedHaloSales14days |
accAttributedHaloSales14days |
Halo sales attributed to an ad, aggregated by an unspecified accumulation method, within a 14-day attribution window. |
metric |
accAttributedHaloUnits14days |
accAttributedHaloUnits14days |
Halo units sold attributed to an ad, aggregated by an unspecified accumulation method, within a 14-day attribution window. |
metric |
accAttributedSales14days |
accAttributedSales14days |
Sales attributed to an ad, aggregated by an unspecified accumulation method, within a 14-day attribution window. |
metric |
accAttributedUnits14days |
accAttributedUnits14days |
Units sold attributed to an ad, aggregated by an unspecified accumulation method, within a 14-day attribution window. |
metric |
adGroupId |
adGroupId |
The unique identifier for an ad group. |
dimension |
adGroupName |
adGroupName |
The 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 |
The unique identifier of the specific item being advertised. |
metric |
advertisedSkuSales14days |
advertisedSkuSales14days |
Sales generated specifically from the advertised SKU within a 14-day attribution window. |
metric |
advertisedSkuSales30days |
advertisedSkuSales30days |
Sales generated specifically from the advertised SKU within a 30-day attribution window. |
metric |
advertisedSkuSales3days |
advertisedSkuSales3days |
Sales generated specifically from the advertised SKU within a 3-day attribution window. |
metric |
advertisedSkuUnits14days |
advertisedSkuUnits14days |
Units sold generated specifically from the advertised SKU within a 14-day attribution window. |
metric |
advertisedSkuUnits30days |
advertisedSkuUnits30days |
Units sold generated specifically from the advertised SKU within a 30-day attribution window. |
metric |
advertisedSkuUnits3days |
advertisedSkuUnits3days |
Units sold generated specifically from the advertised SKU within a 3-day attribution window. |
metric |
advertiserId |
advertiserId |
Unique numeric identifier for the advertiser, also known as the advertising account ID. |
dimension |
attributedAtc14days |
attributedAtc14days |
The number of add-to-carts attributed to an ad within a 14-day attribution window. |
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 |
Units sold for featured products attributed to an ad within a 14-day attribution window. |
metric |
attributedHaloOrders14days |
attributedHaloOrders14days |
Orders for products not directly advertised but purchased due to the influence of an ad, attributed within a 14-day window. |
metric |
attributedHaloSales14days |
attributedHaloSales14days |
Sales for products not directly advertised but purchased due to the influence of an ad, attributed within a 14-day window. |
metric |
attributedHaloUnits14days |
attributedHaloUnits14days |
Units sold for products not directly advertised but purchased due to the influence of an ad, attributed within a 14-day window. |
metric |
attributedOrders14days |
attributedOrders14days |
Number of orders attributed to the advertising campaign within a 14-day attribution window. |
metric |
attributedOrders30days |
attributedOrders30days |
The number of orders attributed to an ad within a 30-day attribution window. |
metric |
attributedOrders3days |
attributedOrders3days |
The number of orders attributed to an ad 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 |
The sales attributed to an ad within a 30-day attribution window. |
metric |
attributedSales3days |
attributedSales3days |
The sales attributed to an ad within a 3-day attribution window. |
metric |
attributedUnits14days |
attributedUnits14days |
The number of units sold attributed to an ad within a 14-day attribution window. |
metric |
attributedUnits30days |
attributedUnits30days |
The number of units sold attributed to an ad within a 30-day attribution window. |
metric |
attributedUnits3days |
attributedUnits3days |
The number of units sold attributed to an ad within a 3-day attribution window. |
metric |
attributionType |
attributionType |
The model used to attribute conversions to advertising interactions (e.g., last click, view-through). |
dimension |
biddedKeyword |
biddedKeyword |
The specific keyword that an advertiser has chosen to bid on. |
dimension |
biddingStrategy |
biddingStrategy |
The automated or manual strategy used to bid on ad placements. |
dimension |
brand |
brand |
The brand associated with the product or ad. |
metric |
brandAttributedSales14days |
brandAttributedSales14days |
Sales attributed to a specific brand within a 14-day attribution window. |
metric |
brandAttributedSales30days |
brandAttributedSales30days |
Sales attributed to a specific brand within a 30-day attribution window. |
metric |
brandAttributedSales3days |
brandAttributedSales3days |
Sales attributed to a specific brand within a 3-day attribution window. |
metric |
brandClickRevenue30days |
brandClickRevenue30days |
Revenue generated from clicks on brand-specific ads within a 30-day attribution window. |
metric |
brandClickRevenue3days |
brandClickRevenue3days |
Revenue generated from clicks on brand-specific ads within a 3-day attribution window. |
metric |
brandViewRevenue30days |
brandViewRevenue30days |
Revenue generated from views of brand-specific ads within a 30-day attribution window. |
metric |
brandViewRevenue3days |
brandViewRevenue3days |
Revenue generated from views of brand-specific ads within a 3-day attribution window. |
metric |
budgetType |
budgetType |
The type of budget set for a campaign or ad group (e.g., daily, lifetime). |
dimension |
campaignExtId |
campaignExtId |
External identifier for the campaign. |
dimension |
campaignId |
campaignId |
The unique identifier for an advertising campaign. |
dimension |
campaignName |
campaignName |
Name of the advertising campaign. |
dimension |
campaignOptions |
campaignOptions |
Various configurable options and settings for the advertising campaign. |
dimension |
campaignType |
campaignType |
The type of advertising campaign (e.g., Sponsored Products, Display, Video). |
dimension |
category |
category |
The product category associated with the item or ad. |
metric |
channel |
channel |
The advertising channel where the ad was run (e.g., Search, Display). |
dimension |
clickRevenue30days |
clickRevenue30days |
Revenue generated from clicks on ads within a 30-day attribution window. |
metric |
clickRevenue3days |
clickRevenue3days |
Revenue generated from clicks on ads within a 3-day attribution window. |
metric |
creativeId |
creativeId |
The unique identifier for an ad creative. |
dimension |
creativeName |
creativeName |
The name of the ad creative. |
dimension |
dailyBudget |
dailyBudget |
The maximum amount allocated to be spent on a campaign or ad group per day. |
metric |
date |
date |
Specific day for which the report data is available, in ‘yyyy-MM-dd’ format. |
dimension |
deliveryAttributedFeaturedOrders14days |
deliveryAttributedFeaturedOrders14days |
Orders for featured products attributed to an ad for delivery, within a 14-day attribution window. |
metric |
deliveryAttributedFeaturedSales14days |
deliveryAttributedFeaturedSales14days |
Sales for featured products attributed to an ad for delivery, within a 14-day attribution window. |
metric |
deliveryAttributedFeaturedUnits14days |
deliveryAttributedFeaturedUnits14days |
Units sold for featured products attributed to an ad for delivery, within a 14-day attribution window. |
metric |
deliveryAttributedHaloOrders14days |
deliveryAttributedHaloOrders14days |
Halo orders for delivery-fulfilled products attributed to an ad within a 14-day attribution window. |
metric |
deliveryAttributedHaloSales14days |
deliveryAttributedHaloSales14days |
Halo sales for delivery-fulfilled products attributed to an ad within a 14-day attribution window. |
metric |
deliveryAttributedHaloUnits14days |
deliveryAttributedHaloUnits14days |
Halo units sold for delivery-fulfilled products attributed to an ad within a 14-day attribution window. |
metric |
deliveryAttributedOrders14days |
deliveryAttributedOrders14days |
Orders attributed to an ad for delivery, within a 14-day attribution window. |
metric |
deliveryAttributedSales14days |
deliveryAttributedSales14days |
Sales attributed to an ad for delivery, within a 14-day attribution window. |
metric |
deliveryAttributedUnits14days |
deliveryAttributedUnits14days |
Units sold attributed to an ad for delivery, within a 14-day attribution window. |
metric |
directAttributedSales14days |
directAttributedSales14days |
Sales directly attributed to a specific ad interaction within a 14-day attribution window. |
metric |
directAttributedSales30days |
directAttributedSales30days |
Sales directly attributed to a specific ad interaction within a 30-day attribution window. |
metric |
directAttributedSales3days |
directAttributedSales3days |
Sales directly attributed to a specific ad interaction 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 |
The unique identifier for an item. |
dimension |
itemKeyword |
ds |
Keywords associated with an item, used for targeting or reporting. |
dimension |
itemName |
itemName |
The name of the item. |
dimension |
keywordId |
keywordId |
The unique identifier for a keyword. |
dimension |
lineItemExtId |
lineItemExtId |
External identifier for the line item within a campaign. |
dimension |
lineItemName |
lineItemName |
Name of the line item within a campaign. |
dimension |
matchType |
matchType |
The keyword match type (e.g., exact, phrase, broad) used for targeting. |
dimension |
name |
name |
The name of the campaign, ad group, or other entity. |
dimension |
ntbOrders14days |
ntbOrders14days |
Orders placed by new-to-brand customers within a 14-day attribution window. |
metric |
ntbOrders30days |
ntbOrders30days |
Orders placed by new-to-brand customers within a 30-day attribution window. |
metric |
ntbOrders3days |
ntbOrders3days |
Orders placed by new-to-brand customers within a 3-day attribution window. |
metric |
ntbRevenue14days |
ntbRevenue14days |
Revenue generated from new-to-brand customers within a 14-day attribution window. |
metric |
ntbRevenue30days |
ntbRevenue30days |
Revenue generated from new-to-brand customers within a 30-day attribution window. |
metric |
ntbRevenue3days |
ntbRevenue3days |
Revenue generated from new-to-brand customers within a 3-day attribution window. |
metric |
ntbUnits14days |
ntbUnits14days |
Units sold to new-to-brand customers within a 14-day attribution window. |
metric |
ntbUnits30days |
ntbUnits30days |
Units sold to new-to-brand customers within a 30-day attribution window. |
metric |
ntbUnits3days |
ntbUnits3days |
Units sold to new-to-brand customers within a 3-day attribution 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 |
Represents the frequency of orders attributed to advertising campaigns within a specified attribution window. This metric can be derived from the available ‘attributedOrders’ or ‘viewThroughOrders’ data over different timeframes (e.g., 3, 14, or 30 days). |
dimension |
otherSkuSales14days |
otherSkuSales14days |
Sales of SKUs other than the advertised one, but influenced by the ad, within a 14-day attribution window. |
metric |
otherSkuSales30days |
otherSkuSales30days |
Sales of SKUs other than the advertised one, but influenced by the ad, within a 30-day attribution window. |
metric |
otherSkuSales3days |
otherSkuSales3days |
Sales of SKUs other than the advertised one, but influenced by the ad, within a 3-day attribution window. |
metric |
otherSkuUnits14days |
otherSkuUnits14days |
Units sold of SKUs other than the advertised one, but influenced by the ad, within a 14-day attribution window. |
metric |
otherSkuUnits30days |
otherSkuUnits30days |
Units sold of SKUs other than the advertised one, but influenced by the ad, within a 30-day attribution window. |
metric |
otherSkuUnits3days |
otherSkuUnits3days |
Units sold of SKUs other than the advertised one, but influenced by the ad, within a 3-day attribution window. |
metric |
pickupAttributedFeaturedOrders14days |
pickupAttributedFeaturedOrders14days |
Orders for featured products attributed to an ad for store pickup, within a 14-day attribution window. |
metric |
pickupAttributedFeaturedSales14days |
pickupAttributedFeaturedSales14days |
Sales for featured products attributed to an ad for store pickup, within a 14-day attribution window. |
metric |
pickupAttributedFeaturedUnits14days |
pickupAttributedFeaturedUnits14days |
Units sold for featured products attributed to an ad for store pickup, within a 14-day attribution window. |
metric |
pickupAttributedHaloOrders14days |
pickupAttributedHaloOrders14days |
Halo orders for pickup-fulfilled products attributed to an ad within a 14-day attribution window. |
metric |
pickupAttributedHaloSales14days |
pickupAttributedHaloSales14days |
Halo sales for pickup-fulfilled products attributed to an ad within a 14-day attribution window. |
metric |
pickupAttributedHaloUnits14days |
pickupAttributedHaloUnits14days |
Halo units sold for pickup-fulfilled products attributed to an ad within a 14-day attribution window. |
metric |
pickupAttributedOrders14days |
pickupAttributedOrders14days |
Orders attributed to an ad for store pickup, within a 14-day attribution window. |
metric |
pickupAttributedSales14days |
pickupAttributedSales14days |
Sales attributed to an ad for store pickup, within a 14-day attribution window. |
metric |
pickupAttributedUnits14days |
pickupAttributedUnits14days |
Units sold attributed to an ad for store pickup, within a 14-day attribution window. |
metric |
platform |
platform |
The advertising platform where the ad was displayed (e.g., Walmart.com, Walmart app). |
dimension |
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 |
The unique identifier of an item that was purchased as a result of an ad interaction. |
metric |
purchasedItemName |
purchasedItemName |
The name of the item that was purchased as a result of an ad interaction. |
dimension |
relatedAttributedSales14days |
relatedAttributedSales14days |
Sales of related products attributed to an ad within a 14-day attribution window. |
metric |
relatedAttributedSales30days |
relatedAttributedSales30days |
Sales of related products attributed to an ad within a 30-day attribution window. |
metric |
relatedAttributedSales3days |
relatedAttributedSales3days |
Sales of related products attributed to an ad within a 3-day attribution window. |
metric |
relatedClickRevenue30days |
relatedClickRevenue30days |
Revenue generated from clicks on ads that led to sales of related products within a 30-day attribution window. |
metric |
relatedClickRevenue3days |
relatedClickRevenue3days |
Revenue generated from clicks on ads that led to sales of related products within a 3-day attribution window. |
metric |
rollover |
rollover |
dimension |
|
searchedKeyword |
searchedKeyword |
The actual keyword or search query entered by the user. |
dimension |
startDate |
startDate |
The first day to be considered for the performance report snapshot, in ‘yyyy-MM-dd’ format. |
dimension |
status |
status |
The current operational status of a campaign, ad group, or ad (e.g., active, paused). |
dimension |
storeAttributedFeaturedOrders14days |
storeAttributedFeaturedOrders14days |
Orders for featured products attributed to an ad for in-store purchases, within a 14-day attribution window. |
metric |
storeAttributedFeaturedSales14days |
storeAttributedFeaturedSales14days |
Sales for featured products attributed to an ad for in-store purchases, within a 14-day attribution window. |
metric |
storeAttributedFeaturedUnits14days |
storeAttributedFeaturedUnits14days |
Units sold for featured products attributed to an ad for in-store purchases, within a 14-day attribution window. |
metric |
storeAttributedHaloOrders14days |
storeAttributedHaloOrders14days |
Halo orders for in-store fulfilled products attributed to an ad within a 14-day attribution window. |
metric |
storeAttributedHaloSales14days |
storeAttributedHaloSales14days |
Halo sales for in-store fulfilled products attributed to an ad within a 14-day attribution window. |
metric |
storeAttributedHaloUnits14days |
storeAttributedHaloUnits14days |
Halo units sold for in-store fulfilled products attributed to an ad within a 14-day attribution window. |
metric |
storeAttributedOrders14days |
storeAttributedOrders14days |
Orders attributed to an ad for in-store purchases, within a 14-day attribution window. |
metric |
storeAttributedSales14days |
storeAttributedSales14days |
Sales attributed to an ad for in-store purchases, within a 14-day attribution window. |
metric |
storeAttributedUnits14days |
storeAttributedUnits14days |
Units sold attributed to an ad for in-store purchases, within a 14-day attribution window. |
metric |
targetingType |
targetingType |
The method used to target the audience for an ad (e.g., automatic, manual). |
dimension |
totalBudget |
totalBudget |
The total budget allocated for an advertising 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 |
totalBuyers30Days |
totalBuyers30Days |
metric |
|
totalSales14days |
totalSales14days |
The total sales generated over a 14-day period. |
metric |
totalSales30days |
totalSales30days |
The total sales generated over a 30-day period. |
metric |
totalSales3days |
totalSales3days |
The total sales generated over a 3-day period. |
metric |
totalUnits14days |
totalUnits14days |
The total number of units sold over a 14-day period. |
metric |
totalUnits30days |
totalUnits30days |
The total number of units sold over a 30-day period. |
metric |
totalUnits3days |
totalUnits3days |
The total number of units sold over a 3-day period. |
metric |
unitSold30days |
unitSold30days |
The total number of units sold over a 30-day period. |
metric |
unitSold3days |
unitSold3days |
The total number of units sold over a 3-day period. |
metric |
viewRevenue30days |
viewRevenue30days |
Revenue generated from views of ads within a 30-day attribution window. |
metric |
viewRevenue3days |
viewRevenue3days |
Revenue generated from views of ads within a 3-day attribution window. |
metric |
weekOf |
weekOf |
The starting date of the reporting week for the data. |
dimension |