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 |
Total orders attributed to featured ad placements across all channels within a 14-day attribution window. |
metric |
accAttributedFeaturedSales14days |
accAttributedFeaturedSales14days |
Total sales revenue attributed to featured ad placements across all channels within a 14-day attribution window. |
metric |
accAttributedFeaturedUnits14days |
accAttributedFeaturedUnits14days |
Total units sold attributed to featured ad placements across all channels within a 14-day attribution window. |
metric |
accAttributedHaloOrders14days |
accAttributedHaloOrders14days |
Total orders attributed to halo (incremental) sales generated by ads across all channels within a 14-day attribution window. |
metric |
accAttributedHaloSales14days |
accAttributedHaloSales14days |
Total sales revenue attributed to halo (incremental) sales generated by ads across all channels within a 14-day attribution window. |
metric |
accAttributedHaloUnits14days |
accAttributedHaloUnits14days |
Total units sold attributed to halo (incremental) sales generated by ads across all channels within a 14-day attribution window. |
metric |
accAttributedSales14days |
accAttributedSales14days |
Total sales attributed to ads across all channels within a 14-day attribution window. This metric reflects the overall sales impact of advertising efforts. |
metric |
accAttributedUnits14days |
accAttributedUnits14days |
Total units sold attributed to ads across all channels within a 14-day attribution window. This metric indicates the volume of products sold due to advertising campaigns. |
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 |
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 |
Total number of units sold within 14 days of a customer’s last click or view on a featured ad. |
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 user clicks on the brand’s advertisements within a 30-day attribution window. This is represented by the attributedSales30days metric in the API, which captures sales attributed to ad interactions. |
metric |
brandClickRevenue3days |
brandClickRevenue3days |
Revenue generated from user clicks on the brand’s advertisements within a 3-day attribution window. This is represented by the attributedSales3days metric in the API, which captures sales attributed to ad interactions. |
metric |
brandViewRevenue30days |
brandViewRevenue30days |
Revenue generated from user views of the brand’s advertisements within a 30-day attribution window. This directly corresponds to the completeViewRevenue30days metric in the API, relevant for display or video campaigns. |
metric |
brandViewRevenue3days |
brandViewRevenue3days |
Revenue generated from user views of the brand’s advertisements within a 3-day attribution window. This directly corresponds to the completeViewRevenue3days metric in the API, relevant for display or video campaigns. |
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 |
Options associated with a campaign, such as ‘BRAND_TERM_OPT_OUT’, which determines if a campaign participates in brand term targeting. For new automatic campaigns, brand term targeting is enabled by default. |
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 |
The number of orders attributed to featured ad placements within a 14-day attribution window, specifically for delivery channels. |
metric |
deliveryAttributedFeaturedSales14days |
deliveryAttributedFeaturedSales14days |
The sales revenue attributed to featured ad placements within a 14-day attribution window, specifically for delivery channels. |
metric |
deliveryAttributedFeaturedUnits14days |
deliveryAttributedFeaturedUnits14days |
The total units sold attributed to featured ad placements for delivery channels within a 14-day attribution window. |
metric |
deliveryAttributedHaloOrders14days |
deliveryAttributedHaloOrders14days |
The number of orders attributed to halo (incremental) sales generated by ads within a 14-day attribution window, specifically for delivery channels. |
metric |
deliveryAttributedHaloSales14days |
deliveryAttributedHaloSales14days |
The sales revenue attributed to halo (incremental) sales generated by ads within a 14-day attribution window, specifically for delivery channels. |
metric |
deliveryAttributedHaloUnits14days |
deliveryAttributedHaloUnits14days |
The total units sold attributed to halo (incremental) sales generated by ads for delivery channels within a 14-day attribution window. |
metric |
deliveryAttributedOrders14days |
deliveryAttributedOrders14days |
The total number of orders attributed to ads within a 14-day attribution window, specifically for delivery channels. |
metric |
deliveryAttributedSales14days |
deliveryAttributedSales14days |
The total sales revenue attributed to ads within a 14-day attribution window, specifically for delivery channels. |
metric |
deliveryAttributedUnits14days |
deliveryAttributedUnits14days |
The total units sold attributed to ads within a 14-day attribution window, specifically for delivery channels. |
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 |
The number of orders attributed to featured ad placements within a 14-day attribution window, specifically for pickup channels. |
metric |
pickupAttributedFeaturedSales14days |
pickupAttributedFeaturedSales14days |
The sales revenue attributed to featured ad placements within a 14-day attribution window, specifically for pickup channels. |
metric |
pickupAttributedFeaturedUnits14days |
pickupAttributedFeaturedUnits14days |
The total units sold attributed to featured ad placements for pickup channels within a 14-day attribution window. |
metric |
pickupAttributedHaloOrders14days |
pickupAttributedHaloOrders14days |
The number of orders attributed to halo (incremental) sales generated by ads within a 14-day attribution window, specifically for pickup channels. |
metric |
pickupAttributedHaloSales14days |
pickupAttributedHaloSales14days |
The sales revenue attributed to halo (incremental) sales generated by ads within a 14-day attribution window, specifically for pickup channels. |
metric |
pickupAttributedHaloUnits14days |
pickupAttributedHaloUnits14days |
The total units sold attributed to halo (incremental) sales generated by ads for pickup channels within a 14-day attribution window. |
metric |
pickupAttributedOrders14days |
pickupAttributedOrders14days |
The total number of orders attributed to ads within a 14-day attribution window, specifically for pickup channels. |
metric |
pickupAttributedSales14days |
pickupAttributedSales14days |
The total sales revenue attributed to ads within a 14-day attribution window, specifically for pickup channels. |
metric |
pickupAttributedUnits14days |
pickupAttributedUnits14days |
The total units sold attributed to ads within a 14-day attribution window, specifically for pickup channels. |
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 |
Indicates whether the campaign budget can rollover. For example, ‘true’ means the budget can rollover, while ‘false’ means it cannot. |
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 |
The number of orders attributed to featured ad placements within a 14-day attribution window, specifically for in-store purchases. |
metric |
storeAttributedFeaturedSales14days |
storeAttributedFeaturedSales14days |
The sales revenue attributed to featured ad placements within a 14-day attribution window, specifically for in-store purchases. |
metric |
storeAttributedFeaturedUnits14days |
storeAttributedFeaturedUnits14days |
The total units sold attributed to featured ad placements for in-store purchases within a 14-day attribution window. |
metric |
storeAttributedHaloOrders14days |
storeAttributedHaloOrders14days |
The number of orders attributed to halo (incremental) sales generated by ads within a 14-day attribution window, specifically for in-store purchases. |
metric |
storeAttributedHaloSales14days |
storeAttributedHaloSales14days |
The sales revenue attributed to halo (incremental) sales generated by ads within a 14-day attribution window, specifically for in-store purchases. |
metric |
storeAttributedHaloUnits14days |
storeAttributedHaloUnits14days |
The total units sold attributed to halo (incremental) sales generated by ads for in-store purchases within a 14-day attribution window. |
metric |
storeAttributedOrders14days |
storeAttributedOrders14days |
The total number of orders attributed to ads within a 14-day attribution window, specifically for in-store purchases. |
metric |
storeAttributedSales14days |
storeAttributedSales14days |
The total sales revenue attributed to ads within a 14-day attribution window, specifically for in-store purchases. |
metric |
storeAttributedUnits14days |
storeAttributedUnits14days |
The total units sold attributed to ads within a 14-day attribution window, specifically for in-store purchases. |
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 |
totalSales14days |
totalSales14days |
The total sales generated over a 14-day period. |
metric |
totalUnits14days |
totalUnits14days |
The total number of units sold over a 14-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 |