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.
accAttributedFeaturedOrders14days Metric
Total orders attributed to featured ad placements across all channels within a 14-day attribution window.
accAttributedFeaturedSales14days Metric
Total sales revenue attributed to featured ad placements across all channels within a 14-day attribution window.
accAttributedFeaturedUnits14days Metric
Total units sold attributed to featured ad placements across all channels within a 14-day attribution window.
accAttributedHaloOrders14days Metric
Total orders attributed to halo (incremental) sales generated by ads across all channels within a 14-day attribution window.
accAttributedHaloSales14days Metric
Total sales revenue attributed to halo (incremental) sales generated by ads across all channels within a 14-day attribution window.
accAttributedHaloUnits14days Metric
Total units sold attributed to halo (incremental) sales generated by ads across all channels within a 14-day attribution window.
accAttributedSales14days Metric
Total sales attributed to ads across all channels within a 14-day attribution window. This metric reflects the overall sales impact of advertising efforts.
accAttributedUnits14days Metric
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.
adGroupId Dimension
The unique identifier for an ad group.
adGroupName Dimension
The name of the ad group.
adSpend Metric
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.
advertisedItemId Metric
The unique identifier of the specific item being advertised.
advertisedSkuSales14days Metric
Sales generated specifically from the advertised SKU within a 14-day attribution window.
advertisedSkuSales30days Metric
Sales generated specifically from the advertised SKU within a 30-day attribution window.
advertisedSkuSales3days Metric
Sales generated specifically from the advertised SKU within a 3-day attribution window.
advertisedSkuUnits14days Metric
Units sold generated specifically from the advertised SKU within a 14-day attribution window.
advertisedSkuUnits30days Metric
Units sold generated specifically from the advertised SKU within a 30-day attribution window.
advertisedSkuUnits3days Metric
Units sold generated specifically from the advertised SKU within a 3-day attribution window.
advertiserId Dimension
Unique numeric identifier for the advertiser, also known as the advertising account ID.
attributedAtc14days Metric
The number of attributed 'Add to Cart' events or similar conversion actions that occurred within a 14-day attribution window after a user interacted with an ad.
attributedFeaturedOrders14days Metric
Number of orders for products featured in an ad campaign, attributed to the campaign within a 14-day attribution window.
attributedFeaturedSales14days Metric
Sales revenue for products featured in an ad campaign, attributed to the campaign within a 14-day attribution window.
attributedFeaturedUnits14days Metric
Total number of units sold within 14 days of a customer's last click or view on a featured ad.
attributedHaloOrders14days Metric
Orders for products not directly advertised but purchased due to the influence of an ad, attributed within a 14-day window.
attributedHaloSales14days Metric
Sales for products not directly advertised but purchased due to the influence of an ad, attributed within a 14-day window.
attributedHaloUnits14days Metric
Units sold for products not directly advertised but purchased due to the influence of an ad, attributed within a 14-day window.
attributedOrders14days Metric
Number of orders attributed to the advertising campaign within a 14-day attribution window.
attributedOrders30days Metric
The number of orders attributed to an ad within a 30-day attribution window.
attributedOrders3days Metric
The number of orders attributed to an ad within a 3-day attribution window.
attributedSales14days Metric
Sales revenue attributed to the advertising campaign within a 14-day attribution window.
attributedSales30days Metric
The sales attributed to an ad within a 30-day attribution window.
attributedSales3days Metric
The sales attributed to an ad within a 3-day attribution window.
attributedUnits14days Metric
The number of units sold attributed to an ad within a 14-day attribution window.
attributedUnits30days Metric
The number of units sold attributed to an ad within a 30-day attribution window.
attributedUnits3days Metric
The number of units sold attributed to an ad within a 3-day attribution window.
attributionModel Dimension
The methodology used to assign credit to various touchpoints (e.g., onsite, offsite, in-club) in a customer's journey that contribute to a conversion. Walmart Connect utilizes a Multi-Touch Attribution (MTA) model for this purpose.
attributionType Dimension
The model used to attribute conversions to advertising interactions (e.g., last click, view-through).
biddedKeyword Dimension
The specific keyword that an advertiser has chosen to bid on.
biddingStrategy Dimension
The automated or manual strategy used to bid on ad placements.
brand Dimension
The brand associated with the product or ad.
brandClickRevenue30days Metric
Represents the revenue generated from clicks on branded products over a 30-day attribution window. This metric is used to measure the financial performance directly attributable to user clicks on advertisements for a specific brand.
brandClickRevenue3days Metric
Represents the revenue generated from clicks on branded products over a 3-day attribution window. This metric is used to measure the recent financial performance directly attributable to user clicks on advertisements for a specific brand.
brandViewRevenue30days Metric
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.
brandViewRevenue3days Metric
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.
budgetType Dimension
The type of budget set for a campaign or ad group (e.g., daily, lifetime).
campaignExtId Metric
External identifier for the campaign.
campaignId Dimension
The unique identifier for an advertising campaign.
campaignName Dimension
Name of the advertising campaign.
campaignOptions Dimension
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.
campaignType Dimension
The type of advertising campaign (e.g., Sponsored Products, Display, Video).
category Dimension
The product category associated with the item or ad.
channel Dimension
The advertising channel where the ad was run (e.g., Search, Display).
clickRevenue30days Metric
Revenue generated from clicks on ads within a 30-day attribution window.
clickRevenue3days Metric
Revenue generated from clicks on ads within a 3-day attribution window.
creativeId Dimension
The unique identifier for an ad creative.
creativeName Dimension
The name of the ad creative.
dailyBudget Metric
The maximum amount allocated to be spent on a campaign or ad group per day.
date Dimension
Specific day for which the report data is available, in 'yyyy-MM-dd' format.
deliveryAttributedFeaturedOrders14days Metric
The number of orders attributed to featured ad placements within a 14-day attribution window, specifically for delivery channels.
deliveryAttributedFeaturedSales14days Metric
The sales revenue attributed to featured ad placements within a 14-day attribution window, specifically for delivery channels.
deliveryAttributedFeaturedUnits14days Metric
The total units sold attributed to featured ad placements for delivery channels within a 14-day attribution window.
deliveryAttributedHaloOrders14days Metric
The number of orders attributed to halo (incremental) sales generated by ads within a 14-day attribution window, specifically for delivery channels.
deliveryAttributedHaloSales14days Metric
The sales revenue attributed to halo (incremental) sales generated by ads within a 14-day attribution window, specifically for delivery channels.
deliveryAttributedHaloUnits14days Metric
The total units sold attributed to halo (incremental) sales generated by ads for delivery channels within a 14-day attribution window.
deliveryAttributedOrders14days Metric
The total number of orders attributed to ads within a 14-day attribution window, specifically for delivery channels.
deliveryAttributedSales14days Metric
The total sales revenue attributed to ads within a 14-day attribution window, specifically for delivery channels.
deliveryAttributedUnits14days Metric
The total units sold attributed to ads within a 14-day attribution window, specifically for delivery channels.
endDate Dimension
The last day to be considered for the performance report snapshot, in 'yyyy-MM-dd' format.
itemId Dimension
The unique identifier for an item.
itemKeyword ds Dimension
Keywords associated with an item, used for targeting or reporting.
itemName Dimension
The name of the item.
keywordId Dimension
The unique identifier for a keyword.
lineItemExtId Metric
External identifier for the line item within a campaign.
lineItemName Dimension
Name of the line item within a campaign.
matchType Dimension
The keyword match type (e.g., exact, phrase, broad) used for targeting.
name Dimension
The name of the campaign, ad group, or other entity.
ntbOrders14days Metric
Orders placed by new-to-brand customers within a 14-day attribution window.
ntbOrders30days Metric
Orders placed by new-to-brand customers within a 30-day attribution window.
ntbOrders3days Metric
Orders placed by new-to-brand customers within a 3-day attribution window.
ntbRevenue14days Metric
Revenue generated from new-to-brand customers within a 14-day attribution window.
ntbRevenue30days Metric
Revenue generated from new-to-brand customers within a 30-day attribution window.
ntbRevenue3days Metric
Revenue generated from new-to-brand customers within a 3-day attribution window.
ntbUnits14days Metric
Units sold to new-to-brand customers within a 14-day attribution window.
ntbUnits30days Metric
Units sold to new-to-brand customers within a 30-day attribution window.
ntbUnits3days Metric
Units sold to new-to-brand customers within a 3-day attribution window.
numAdsClicks Metric
Total number of clicks on the ads.
numAdsShown Metric
Total number of times the ads were shown (impressions).
orderFrequency Dimension
Indicates the frequency at which orders are attributed to advertising campaigns. This can be derived from metrics such as attributed orders within specific look-back windows (e.g., 3, 14, or 30 days).
otherSkuSales14days Metric
Sales of SKUs other than the advertised one, but influenced by the ad, within a 14-day attribution window.
otherSkuSales30days Metric
Sales of SKUs other than the advertised one, but influenced by the ad, within a 30-day attribution window.
otherSkuSales3days Metric
Sales of SKUs other than the advertised one, but influenced by the ad, within a 3-day attribution window.
otherSkuUnits14days Metric
Units sold of SKUs other than the advertised one, but influenced by the ad, within a 14-day attribution window.
otherSkuUnits30days Metric
Units sold of SKUs other than the advertised one, but influenced by the ad, within a 30-day attribution window.
otherSkuUnits3days Metric
Units sold of SKUs other than the advertised one, but influenced by the ad, within a 3-day attribution window.
pickupAttributedFeaturedOrders14days Metric
The number of orders attributed to featured ad placements within a 14-day attribution window, specifically for pickup channels.
pickupAttributedFeaturedSales14days Metric
The sales revenue attributed to featured ad placements within a 14-day attribution window, specifically for pickup channels.
pickupAttributedFeaturedUnits14days Metric
The total units sold attributed to featured ad placements for pickup channels within a 14-day attribution window.
pickupAttributedHaloOrders14days Metric
The number of orders attributed to halo (incremental) sales generated by ads within a 14-day attribution window, specifically for pickup channels.
pickupAttributedHaloSales14days Metric
The sales revenue attributed to halo (incremental) sales generated by ads within a 14-day attribution window, specifically for pickup channels.
pickupAttributedHaloUnits14days Metric
The total units sold attributed to halo (incremental) sales generated by ads for pickup channels within a 14-day attribution window.
pickupAttributedOrders14days Metric
The total number of orders attributed to ads within a 14-day attribution window, specifically for pickup channels.
pickupAttributedSales14days Metric
The total sales revenue attributed to ads within a 14-day attribution window, specifically for pickup channels.
pickupAttributedUnits14days Metric
The total units sold attributed to ads within a 14-day attribution window, specifically for pickup channels.
platform Dimension
The advertising platform where the ad was displayed (e.g., Walmart.com, Walmart app).
pointOfSale Dimension
Represents the digital platform or channel where a sale or advertising interaction takes place, such as desktop, mobile, or the Walmart app.
purchasedItemId Metric
The unique identifier of an item that was purchased as a result of an ad interaction.
purchasedItemName Dimension
The name of the item that was purchased as a result of an ad interaction.
relatedClickRevenue30days Metric
Represents the revenue generated from clicks on products related to the advertised items over a 30-day attribution window. This metric helps understand the indirect sales impact of ads on products within the same category or frequently purchased together.
relatedClickRevenue3days Metric
Represents the revenue generated from clicks on products related to the advertised items over a 3-day attribution window. This metric helps understand the recent indirect sales impact of ads on products within the same category or frequently purchased together.
rollover Dimension
Indicates whether the campaign budget can rollover. For example, 'true' means the budget can rollover, while 'false' means it cannot.
searchedKeyword Dimension
The actual keyword or search query entered by the user.
startDate Dimension
The first day to be considered for the performance report snapshot, in 'yyyy-MM-dd' format.
status Dimension
The current operational status of a campaign, ad group, or ad (e.g., active, paused).
storeAttributedFeaturedOrders14days Metric
The number of orders attributed to featured ad placements within a 14-day attribution window, specifically for in-store purchases.
storeAttributedFeaturedSales14days Metric
The sales revenue attributed to featured ad placements within a 14-day attribution window, specifically for in-store purchases.
storeAttributedFeaturedUnits14days Metric
The total units sold attributed to featured ad placements for in-store purchases within a 14-day attribution window.
storeAttributedHaloOrders14days Metric
The number of orders attributed to halo (incremental) sales generated by ads within a 14-day attribution window, specifically for in-store purchases.
storeAttributedHaloSales14days Metric
The sales revenue attributed to halo (incremental) sales generated by ads within a 14-day attribution window, specifically for in-store purchases.
storeAttributedHaloUnits14days Metric
The total units sold attributed to halo (incremental) sales generated by ads for in-store purchases within a 14-day attribution window.
storeAttributedOrders14days Metric
The total number of orders attributed to ads within a 14-day attribution window, specifically for in-store purchases.
storeAttributedSales14days Metric
The total sales revenue attributed to ads within a 14-day attribution window, specifically for in-store purchases.
storeAttributedUnits14days Metric
The total units sold attributed to ads within a 14-day attribution window, specifically for in-store purchases.
targetingType Dimension
The method used to target the audience for an ad (e.g., automatic, manual).
totalBudget Dimension
The total budget allocated for an advertising campaign.
totalBuyers14Days Metric
The total count of unique buyers who made a purchase attributed to advertising efforts within a 14-day period on Walmart's owned properties.
totalSales14days Metric
The total sales generated over a 14-day period.
totalSales30days Metric
This metric represents the total sales value attributed to advertising efforts within a 30-day look-back window.
totalSales3days Metric
This metric represents the total sales value attributed to advertising efforts within a 3-day look-back window.
totalUnits14days Metric
The total number of units sold over a 14-day period.
totalUnits30days Metric
This metric represents the total number of units sold that are attributed to advertising within a 30-day look-back window.
totalUnits3days Metric
This metric represents the total number of units sold that are attributed to advertising within a 3-day look-back window.
unitSold30days Metric
The total number of units sold over a 30-day period.
unitSold3days Metric
The total number of units sold over a 3-day period.
viewRevenue30days Metric
Revenue generated from views of ads within a 30-day attribution window.
viewRevenue3days Metric
Revenue generated from views of ads within a 3-day attribution window.
weekOf Dimension
The starting date of the reporting week for the data.