Skip to content
Book a demo

Connect documentation

All documentation
Documentation

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.

FieldAdverity UI nameType
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.