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.
accAttributedFeaturedOrders14daysMetric
Total orders attributed to featured ad placements across all channels within a 14-day attribution window.
accAttributedFeaturedSales14daysMetric
Total sales revenue attributed to featured ad placements across all channels within a 14-day attribution window.
accAttributedFeaturedUnits14daysMetric
Total units sold attributed to featured ad placements across all channels within a 14-day attribution window.
accAttributedHaloOrders14daysMetric
Total orders attributed to halo (incremental) sales generated by ads across all channels within a 14-day attribution window.
accAttributedHaloSales14daysMetric
Total sales revenue attributed to halo (incremental) sales generated by ads across all channels within a 14-day attribution window.
accAttributedHaloUnits14daysMetric
Total units sold attributed to halo (incremental) sales generated by ads across all channels within a 14-day attribution window.
accAttributedSales14daysMetric
Total sales attributed to ads across all channels within a 14-day attribution window. This metric reflects the overall sales impact of advertising efforts.
accAttributedUnits14daysMetric
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.
adGroupIdDimension
The unique identifier for an ad group.
adGroupNameDimension
The name of the ad group.
adSpendMetric
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.
advertisedItemIdMetric
The unique identifier of the specific item being advertised.
advertisedSkuSales14daysMetric
Sales generated specifically from the advertised SKU within a 14-day attribution window.
advertisedSkuSales30daysMetric
Sales generated specifically from the advertised SKU within a 30-day attribution window.
advertisedSkuSales3daysMetric
Sales generated specifically from the advertised SKU within a 3-day attribution window.
advertisedSkuUnits14daysMetric
Units sold generated specifically from the advertised SKU within a 14-day attribution window.
advertisedSkuUnits30daysMetric
Units sold generated specifically from the advertised SKU within a 30-day attribution window.
advertisedSkuUnits3daysMetric
Units sold generated specifically from the advertised SKU within a 3-day attribution window.
advertiserIdDimension
Unique numeric identifier for the advertiser, also known as the advertising account ID.
attributedAtc14daysMetric
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.
attributedFeaturedOrders14daysMetric
Number of orders for products featured in an ad campaign, attributed to the campaign within a 14-day attribution window.
attributedFeaturedSales14daysMetric
Sales revenue for products featured in an ad campaign, attributed to the campaign within a 14-day attribution window.
attributedFeaturedUnits14daysMetric
Total number of units sold within 14 days of a customer's last click or view on a featured ad.
attributedHaloOrders14daysMetric
Orders for products not directly advertised but purchased due to the influence of an ad, attributed within a 14-day window.
attributedHaloSales14daysMetric
Sales for products not directly advertised but purchased due to the influence of an ad, attributed within a 14-day window.
attributedHaloUnits14daysMetric
Units sold for products not directly advertised but purchased due to the influence of an ad, attributed within a 14-day window.
attributedOrders14daysMetric
Number of orders attributed to the advertising campaign within a 14-day attribution window.
attributedOrders30daysMetric
The number of orders attributed to an ad within a 30-day attribution window.
attributedOrders3daysMetric
The number of orders attributed to an ad within a 3-day attribution window.
attributedPdp14daysMetric
Represents sales or units attributed to user interactions on a Product Detail Page (PDP) within a 14-day attribution window. This metric is used to measure the effectiveness of advertising campaigns in driving purchases after a user views a product's detail page. It aligns with attribution window concepts found in Walmart Connect API's Snapshot Reports.
attributedPdp30daysMetric
This field represents the number of attributed Product Detail Page (PDP) events, such as sales or units, within a 30-day attribution window. These events are attributed to the associated campaign or ad activity.
attributedSales14daysMetric
Sales revenue attributed to the advertising campaign within a 14-day attribution window.
attributedSales30daysMetric
The sales attributed to an ad within a 30-day attribution window.
attributedSales3daysMetric
The sales attributed to an ad within a 3-day attribution window.
attributedUnits14daysMetric
The number of units sold attributed to an ad within a 14-day attribution window.
attributedUnits30daysMetric
The number of units sold attributed to an ad within a 30-day attribution window.
attributedUnits3daysMetric
The number of units sold attributed to an ad within a 3-day attribution window.
attributionModelDimension
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.
attributionTypeDimension
The model used to attribute conversions to advertising interactions (e.g., last click, view-through).
biddedKeywordDimension
The specific keyword that an advertiser has chosen to bid on.
biddingStrategyDimension
The automated or manual strategy used to bid on ad placements.
brandDimension
The brand associated with the product or ad.
brandClickRevenue30daysMetric
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.
brandClickRevenue3daysMetric
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.
brandViewRevenue30daysMetric
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.
brandViewRevenue3daysMetric
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.
budgetTypeDimension
The type of budget set for a campaign or ad group (e.g., daily, lifetime).
campaignExtIdMetric
External identifier for the campaign.
campaignGroupIdMetric
An identifier for a logical grouping of advertising campaigns. This field is used to organize and track the performance of multiple campaigns that share a common objective or theme, allowing for aggregated reporting and management.
campaignGroupNameDimension
The name assigned to a logical grouping of advertising campaigns. This name provides a human-readable label to easily identify and manage related campaigns within the Walmart Connect advertising platform.
campaignIdDimension
The unique identifier for an advertising campaign.
campaignNameDimension
Name of the advertising campaign.
campaignOptionsDimension
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.
campaignTypeDimension
The type of advertising campaign (e.g., Sponsored Products, Display, Video).
categoryMetric
The product category associated with the item or ad.
channelDimension
The advertising channel where the ad was run (e.g., Search, Display).
clickRevenue30daysMetric
Revenue generated from clicks on ads within a 30-day attribution window.
clickRevenue3daysMetric
Revenue generated from clicks on ads within a 3-day attribution window.
creativeIdDimension
The unique identifier for an ad creative.
creativeNameDimension
The name of the ad creative.
dailyBudgetMetric
The maximum amount allocated to be spent on a campaign or ad group per day.
dateDimension
Specific day for which the report data is available, in 'yyyy-MM-dd' format.
deliveryAttributedFeaturedOrders14daysMetric
The number of orders attributed to featured ad placements within a 14-day attribution window, specifically for delivery channels.
deliveryAttributedFeaturedSales14daysMetric
The sales revenue attributed to featured ad placements within a 14-day attribution window, specifically for delivery channels.
deliveryAttributedFeaturedUnits14daysMetric
The total units sold attributed to featured ad placements for delivery channels within a 14-day attribution window.
deliveryAttributedHaloOrders14daysMetric
The number of orders attributed to halo (incremental) sales generated by ads within a 14-day attribution window, specifically for delivery channels.
deliveryAttributedHaloSales14daysMetric
The sales revenue attributed to halo (incremental) sales generated by ads within a 14-day attribution window, specifically for delivery channels.
deliveryAttributedHaloUnits14daysMetric
The total units sold attributed to halo (incremental) sales generated by ads for delivery channels within a 14-day attribution window.
deliveryAttributedOrders14daysMetric
The total number of orders attributed to ads within a 14-day attribution window, specifically for delivery channels.
deliveryAttributedSales14daysMetric
The total sales revenue attributed to ads within a 14-day attribution window, specifically for delivery channels.
deliveryAttributedUnits14daysMetric
The total units sold attributed to ads within a 14-day attribution window, specifically for delivery channels.
endDateDimension
The last day to be considered for the performance report snapshot, in 'yyyy-MM-dd' format.
itemIdMetric
The unique identifier for an item.
itemKeyworddsDimension
Keywords associated with an item, used for targeting or reporting.
itemNameDimension
The name of the item.
keywordIdMetric
The unique identifier for a keyword.
lineItemExtIdMetric
External identifier for the line item within a campaign.
lineItemNameDimension
Name of the line item within a campaign.
matchTypeDimension
The keyword match type (e.g., exact, phrase, broad) used for targeting.
nameDimension
The name of the campaign, ad group, or other entity.
ntbOrders14daysMetric
Orders placed by new-to-brand customers within a 14-day attribution window.
ntbOrders30daysMetric
Orders placed by new-to-brand customers within a 30-day attribution window.
ntbOrders3daysMetric
Orders placed by new-to-brand customers within a 3-day attribution window.
ntbRevenue14daysMetric
Revenue generated from new-to-brand customers within a 14-day attribution window.
ntbRevenue30daysMetric
Revenue generated from new-to-brand customers within a 30-day attribution window.
ntbRevenue3daysMetric
Revenue generated from new-to-brand customers within a 3-day attribution window.
ntbUnits14daysMetric
Units sold to new-to-brand customers within a 14-day attribution window.
ntbUnits30daysMetric
Units sold to new-to-brand customers within a 30-day attribution window.
ntbUnits3daysMetric
Units sold to new-to-brand customers within a 3-day attribution window.
numAdsClicksMetric
Total number of clicks on the ads.
numAdsShownMetric
Total number of times the ads were shown (impressions).
orderFrequencyDimension
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).
otherSkuSales14daysMetric
Sales of SKUs other than the advertised one, but influenced by the ad, within a 14-day attribution window.
otherSkuSales30daysMetric
Sales of SKUs other than the advertised one, but influenced by the ad, within a 30-day attribution window.
otherSkuSales3daysMetric
Sales of SKUs other than the advertised one, but influenced by the ad, within a 3-day attribution window.
otherSkuUnits14daysMetric
Units sold of SKUs other than the advertised one, but influenced by the ad, within a 14-day attribution window.
otherSkuUnits30daysMetric
Units sold of SKUs other than the advertised one, but influenced by the ad, within a 30-day attribution window.
otherSkuUnits3daysMetric
Units sold of SKUs other than the advertised one, but influenced by the ad, within a 3-day attribution window.
pickupAttributedFeaturedOrders14daysMetric
The number of orders attributed to featured ad placements within a 14-day attribution window, specifically for pickup channels.
pickupAttributedFeaturedSales14daysMetric
The sales revenue attributed to featured ad placements within a 14-day attribution window, specifically for pickup channels.
pickupAttributedFeaturedUnits14daysMetric
The total units sold attributed to featured ad placements for pickup channels within a 14-day attribution window.
pickupAttributedHaloOrders14daysMetric
The number of orders attributed to halo (incremental) sales generated by ads within a 14-day attribution window, specifically for pickup channels.
pickupAttributedHaloSales14daysMetric
The sales revenue attributed to halo (incremental) sales generated by ads within a 14-day attribution window, specifically for pickup channels.
pickupAttributedHaloUnits14daysMetric
The total units sold attributed to halo (incremental) sales generated by ads for pickup channels within a 14-day attribution window.
pickupAttributedOrders14daysMetric
The total number of orders attributed to ads within a 14-day attribution window, specifically for pickup channels.
pickupAttributedSales14daysMetric
The total sales revenue attributed to ads within a 14-day attribution window, specifically for pickup channels.
pickupAttributedUnits14daysMetric
The total units sold attributed to ads within a 14-day attribution window, specifically for pickup channels.
platformDimension
The advertising platform where the ad was displayed (e.g., Walmart.com, Walmart app).
pointOfSaleDimension
Represents the digital platform or channel where a sale or advertising interaction takes place, such as desktop, mobile, or the Walmart app.
purchasedItemIdMetric
The unique identifier of an item that was purchased as a result of an ad interaction.
purchasedItemNameDimension
The name of the item that was purchased as a result of an ad interaction.
relatedClickRevenue30daysMetric
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.
relatedClickRevenue3daysMetric
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.
rolloverDimension
Indicates whether the campaign budget can rollover. For example, 'true' means the budget can rollover, while 'false' means it cannot.
searchedKeywordDimension
The actual keyword or search query entered by the user.
startDateDimension
The first day to be considered for the performance report snapshot, in 'yyyy-MM-dd' format.
statusDimension
The current operational status of a campaign, ad group, or ad (e.g., active, paused).
storeAttributedFeaturedOrders14daysMetric
The number of orders attributed to featured ad placements within a 14-day attribution window, specifically for in-store purchases.
storeAttributedFeaturedSales14daysMetric
The sales revenue attributed to featured ad placements within a 14-day attribution window, specifically for in-store purchases.
storeAttributedFeaturedUnits14daysMetric
The total units sold attributed to featured ad placements for in-store purchases within a 14-day attribution window.
storeAttributedHaloOrders14daysMetric
The number of orders attributed to halo (incremental) sales generated by ads within a 14-day attribution window, specifically for in-store purchases.
storeAttributedHaloSales14daysMetric
The sales revenue attributed to halo (incremental) sales generated by ads within a 14-day attribution window, specifically for in-store purchases.
storeAttributedHaloUnits14daysMetric
The total units sold attributed to halo (incremental) sales generated by ads for in-store purchases within a 14-day attribution window.
storeAttributedOrders14daysMetric
The total number of orders attributed to ads within a 14-day attribution window, specifically for in-store purchases.
storeAttributedSales14daysMetric
The total sales revenue attributed to ads within a 14-day attribution window, specifically for in-store purchases.
storeAttributedUnits14daysMetric
The total units sold attributed to ads within a 14-day attribution window, specifically for in-store purchases.
targetingTypeDimension
The method used to target the audience for an ad (e.g., automatic, manual).
totalBudgetDimension
The total budget allocated for an advertising campaign.
totalBuyers14DaysMetric
The total count of unique buyers who made a purchase attributed to advertising efforts within a 14-day period on Walmart's owned properties.
totalSales14daysMetric
The total sales generated over a 14-day period.
totalSales30daysMetric
This metric represents the total sales value attributed to advertising efforts within a 30-day look-back window.
totalSales3daysMetric
This metric represents the total sales value attributed to advertising efforts within a 3-day look-back window.
totalUnits14daysMetric
The total number of units sold over a 14-day period.
totalUnits30daysMetric
This metric represents the total number of units sold that are attributed to advertising within a 30-day look-back window.
totalUnits3daysMetric
This metric represents the total number of units sold that are attributed to advertising within a 3-day look-back window.
unitSold30daysMetric
The total number of units sold over a 30-day period.
unitSold3daysMetric
The total number of units sold over a 3-day period.
viewRevenue30daysMetric
Revenue generated from views of ads within a 30-day attribution window.
viewRevenue3daysMetric
Revenue generated from views of ads within a 3-day attribution window.
weekOfDimension
The starting date of the reporting week for the data.