Skip to main content

What data can I get from Walmart Connect Sponsored Search?

Know what data you can get from Walmart Connect Sponsored Search using Funnel's connector.

Kelsey Maynard avatar
Written by Kelsey Maynard
Updated today

Note: Funnel fetches these dimensions and metrics directly from Walmart Connect Sponsored Search. For more details about these dimensions and metrics, see the official Walmart Connect API documentation: Introduction to Walmart Connect - Sponsored Search APIs.

Walmart Connect Sponsored Search provides comprehensive advertising performance data for sponsored product campaigns on Walmart’s marketplace. The Walmart Connect Sponsored Search connector in Funnel allows you to analyze campaign performance, keyword effectiveness, and attribution metrics across multiple timeframes to optimize your advertising strategy.

This connector provides data across multiple report types, each with specific dimensions and metrics designed for different analysis needs.

Available report types

  • Ad Group: Campaign and ad group level performance metrics with attribution data

  • Ad Item: Individual product performance within campaigns

  • Attributed Purchases: Purchase attribution data linking ads to customer purchases

  • Brand: Brand-level performance and attribution metrics

  • Category: Category-based performance analysis

  • Item Health: Product listing quality and availability metrics

  • Item Keyword: Keyword performance data at the product level

  • Keyword: Campaign keyword performance and attribution

  • Out Of Budget Recommendations: Budget optimization recommendations

  • Page Type: Performance metrics by page placement type

  • Placement: Advertisement placement performance data

  • Platform: Performance metrics by platform (mobile, desktop)

  • Search Impression: Search impression share and ranking data

  • Video Campaigns: Video advertisement performance metrics

  • Video Keywords: Keyword performance for video campaigns

Ad Group

Dimensions

  • Ad Group ID

  • Ad Group Name

  • Ad Group Status

  • Campaign Bidding Strategy

  • Campaign Bidding Strategy Status

  • Campaign Budget Type

  • Campaign Channel

  • Campaign End Date

  • Campaign ID

  • Campaign Name

  • Campaign Rollover

  • Campaign Start Date

  • Campaign Status

  • Campaign Targeting

  • Campaign TROAS

  • Campaign Type

  • Date

Metrics

  • Ad Spend

  • Advertised SKU Sales (3, 14, 30 days)

  • Advertised SKU Units (3, 14, 30 days)

  • Attributed Orders (3, 14, 30 days)

  • Attributed Sales (3, 14, 30 days)

  • Attributed Units (3, 14, 30 days)

  • Brand Attributed Sales (3, 14, 30 days)

  • Direct Attributed Sales (3, 14, 30 days)

  • New-to-brand Orders (3, 14, 30 days)

  • New-to-brand Revenue (3, 14, 30 days)

  • New-to-brand Units (3, 14, 30 days)

  • Number of Ads Clicks

  • Number of Ads Shown

  • Other SKU Sales (3, 14, 30 days)

  • Other SKU Units (3, 14, 30 days)

  • Related Attributed Sales (3, 14, 30 days)

Ad Item

Dimensions

  • Ad Group ID

  • Ad Group Name

  • Ad Group Status

  • Campaign Bidding Strategy

  • Campaign Bidding Strategy Status

  • Campaign Budget Type

  • Campaign Channel

  • Campaign End Date

  • Campaign ID

  • Campaign Name

  • Campaign Rollover

  • Campaign Start Date

  • Campaign Status

  • Campaign Targeting Type

  • Campaign TROAS

  • Campaign Type

  • Date

  • Item ID

  • Item Image URL

  • Item Name

  • Item Page URL

Metrics

  • Ad Spend

  • Advertised SKU Sales (3, 14, 30 days)

  • Advertised SKU Units (3, 14, 30 days)

  • Attributed Orders (3, 14, 30 days)

  • Attributed Sales (3, 14, 30 days)

  • Attributed Units (3, 14, 30 days)

  • Brand Attributed Sales (3, 14, 30 days)

  • Direct Attributed Sales (3, 14, 30 days)

  • In-Store Advertised Sales (3, 14, 30 days)

  • In-Store Attributed Sales (3, 14, 30 days)

  • In-Store Orders (3, 14, 30 days)

  • In-Store Other Sales (3, 14, 30 days)

  • In-Store Units Sold (3, 14, 30 days)

  • New-to-brand Orders (3, 14, 30 days)

  • New-to-brand Revenue (3, 14, 30 days)

  • New-to-brand Units (3, 14, 30 days)

  • Number of Ads Clicks

  • Number of Ads Shown

  • Other SKU Sales (3, 14, 30 days)

  • Other SKU Units (3, 14, 30 days)

  • Related Attributed Sales (3, 14, 30 days)

Attributed Purchases

Dimensions

  • Ad Group ID

  • Ad Group Name

  • Ad Group Status

  • Advertised Item ID

  • Attribution Type

  • Campaign Bidding Strategy

  • Campaign Bidding Strategy Status

  • Campaign Budget Type

  • Campaign Channel

  • Campaign End Date

  • Campaign ID

  • Campaign Name

  • Campaign Rollover

  • Campaign Start Date

  • Campaign Status

  • Campaign Targeting Type

  • Campaign TROAS

  • Campaign Type

  • Date

  • Purchased Item ID

  • Purchased Item Name

Metrics

  • Attributed Orders (3, 14, 30 days)

  • New-to-brand Orders (3, 14, 30 days)

  • New-to-brand Revenue (3, 14, 30 days)

  • New-to-brand Units (3, 14, 30 days)

  • Total Sales (3, 14, 30 days)

  • Total Units (3, 14, 30 days)

Brand

Dimensions

  • Ad Group ID

  • Ad Group Name

  • Ad Group Status

  • Brand

  • Campaign Bidding Strategy

  • Campaign Bidding Strategy Status

  • Campaign Budget Type

  • Campaign Channel

  • Campaign End Date

  • Campaign ID

  • Campaign Name

  • Campaign Rollover

  • Campaign Start Date

  • Campaign Status

  • Campaign Targeting Type

  • Campaign TROAS

  • Campaign Type

  • Date

Metrics

  • Ad Spend

  • Advertised SKU Sales (3, 14, 30 days)

  • Advertised SKU Units (3, 14, 30 days)

  • Attributed Orders (3, 14, 30 days)

  • Attributed Sales (3, 14, 30 days)

  • Attributed Units (3, 14, 30 days)

  • Brand Attributed Sales (3, 14, 30 days)

  • Direct Attributed Sales (3, 14, 30 days)

  • New-to-brand Orders (3, 14, 30 days)

  • New-to-brand Revenue (3, 14, 30 days)

  • New-to-brand Units (3, 14, 30 days)

  • Number of Ads Clicks

  • Number of Ads Shown

  • Other SKU Sales (3, 14, 30 days)

  • Other SKU Units (3, 14, 30 days)

  • Related Attributed Sales (3, 14, 30 days)

Category

Dimensions

  • Ad Group ID

  • Ad Group Name

  • Ad Group Status

  • Campaign Bidding Strategy

  • Campaign Bidding Strategy Status

  • Campaign Budget Type

  • Campaign Channel

  • Campaign End Date

  • Campaign ID

  • Campaign Name

  • Campaign Rollover

  • Campaign Start Date

  • Campaign Status

  • Campaign Targeting Type

  • Campaign TROAS

  • Campaign Type

  • Category

  • Date

Metrics

  • Ad Spend

  • Advertised SKU Sales (3, 14, 30 days)

  • Advertised SKU Units (3, 14, 30 days)

  • Attributed Orders (3, 14, 30 days)

  • Attributed Sales (3, 14, 30 days)

  • Attributed Units (3, 14, 30 days)

  • Brand Attributed Sales (3, 14, 30 days)

  • Direct Attributed Sales (3, 14, 30 days)

  • New-to-brand Orders (3, 14, 30 days)

  • New-to-brand Revenue (3, 14, 30 days)

  • New-to-brand Units (3, 14, 30 days)

  • Number of Ads Clicks

  • Number of Ads Shown

  • Other SKU Sales (3, 14, 30 days)

  • Other SKU Units (3, 14, 30 days)

  • Related Attributed Sales (3, 14, 30 days)

Item Health

Dimensions

  • Ad Group ID

  • Ad Group Name

  • Ad Group Status

  • Campaign Bidding Strategy

  • Campaign Bidding Strategy Status

  • Campaign Budget Type

  • Campaign Channel

  • Campaign End Date

  • Campaign ID

  • Campaign Name

  • Campaign Rollover

  • Campaign Start Date

  • Campaign Status

  • Campaign Targeting Type

  • Campaign TROAS

  • Campaign Type

  • Date

  • Item ID

  • Item Image URL

  • Item Name

  • Item Page URL

  • Primary Variant ID

  • Publish Status

Metrics

  • Availability Percentage

  • Availability Percentage Last Week

  • Buy Box Percentage

  • Buy Box Percentage Last Week

  • Content Score

  • Listing Quality Score

  • Offer Score

  • Page View Last Week

  • Page Views

  • Rating Score

Item Keyword

Dimensions

  • Ad Group ID

  • Ad Group Name

  • Ad Group Status

  • Bidded Keyword

  • Campaign Bidding Strategy

  • Campaign Bidding Strategy Status

  • Campaign Budget Type

  • Campaign Channel

  • Campaign End Date

  • Campaign ID

  • Campaign Name

  • Campaign Rollover

  • Campaign Start Date

  • Campaign Status

  • Campaign Targeting Type

  • Campaign TROAS

  • Campaign Type

  • Date

  • Item ID

  • Item Image URL

  • Item Name

  • Item Page URL

  • Keyword ID

  • Match Type

  • Searched Keyword

Metrics

  • Ad Spend

  • Advertised SKU Sales (3, 14, 30 days)

  • Advertised SKU Units (3, 14, 30 days)

  • Attributed Orders (3, 14, 30 days)

  • Number of Ads Clicks

  • Number of Ads Shown

  • Other SKU Sales (3, 14, 30 days)

  • Other SKU Units (3, 14, 30 days)

Keyword

Dimensions

  • Ad Group ID

  • Ad Group Name

  • Ad Group Status

  • Bidded Keyword

  • Campaign Bidding Strategy

  • Campaign Bidding Strategy Status

  • Campaign Budget Type

  • Campaign Channel

  • Campaign End Date

  • Campaign ID

  • Campaign Name

  • Campaign Rollover

  • Campaign Start Date

  • Campaign Status

  • Campaign Targeting Type

  • Campaign TROAS

  • Campaign Type

  • Date

  • Keyword ID

  • Match Type

  • Searched Keyword

Metrics

  • Ad Spend

  • Advertised SKU Sales (3, 14, 30 days)

  • Advertised SKU Units (3, 14, 30 days)

  • Attributed Orders (3, 14, 30 days)

  • Attributed Sales (3, 14, 30 days)

  • Attributed Units (3, 14, 30 days)

  • Brand Attributed Sales (3, 14, 30 days)

  • Direct Attributed Sales (3, 14, 30 days)

  • In-Store Advertised Sales (3, 14, 30 days)

  • In-Store Attributed Sales (3, 14, 30 days)

  • In-Store Orders (3, 14, 30 days)

  • In-Store Other Sales (3, 14, 30 days)

  • In-Store Units Sold (3, 14, 30 days)

  • New-to-brand Orders (3, 14, 30 days)

  • New-to-brand Revenue (3, 14, 30 days)

  • New-to-brand Units (3, 14, 30 days)

  • Number of Ads Clicks

  • Number of Ads Shown

  • Other SKU Sales (3, 14, 30 days)

  • Other SKU Units (3, 14, 30 days)

  • Related Attributed Sales (3, 14, 30 days)

Out Of Budget Recommendations

Dimensions

  • Campaign Bidding Strategy

  • Campaign Bidding Strategy Status

  • Campaign Budget Type

  • Campaign Channel

  • Campaign End Date

  • Campaign ID

  • Campaign Name

  • Campaign Rollover

  • Campaign Start Date

  • Campaign Status

  • Campaign Targeting Type

  • Campaign TROAS

  • Campaign Type

  • Start Date

Metrics

  • Average Cap Out Time

  • Missed Clicks Lower

  • Missed Clicks Upper

  • Missed Impressions Lower

  • Missed Impressions Upper

  • Suggested Latest Daily Budget

  • Suggested Latest Total Budget

Page Type

Dimensions

  • Ad Group ID

  • Ad Group Name

  • Ad Group Status

  • Campaign Bidding Strategy

  • Campaign Bidding Strategy Status

  • Campaign Budget Type

  • Campaign Channel

  • Campaign End Date

  • Campaign ID

  • Campaign Name

  • Campaign Rollover

  • Campaign Start Date

  • Campaign Status

  • Campaign Targeting Type

  • Campaign TROAS

  • Campaign Type

  • Date

  • Page Type

Metrics

  • Ad Spend

  • Advertised SKU Sales (3, 14, 30 days)

  • Advertised SKU Units (3, 14, 30 days)

  • Attributed Orders (3, 14, 30 days)

  • Attributed Sales (3, 14, 30 days)

  • Attributed Units (3, 14, 30 days)

  • Brand Attributed Sales (3, 14, 30 days)

  • Direct Attributed Sales (3, 14, 30 days)

  • In-Store Advertised Sales (3, 14, 30 days)

  • In-Store Attributed Sales (3, 14, 30 days)

  • In-Store Orders (3, 14, 30 days)

  • In-Store Other Sales (3, 14, 30 days)

  • In-Store Units Sold (3, 14, 30 days)

  • New-to-brand Orders (3, 14, 30 days)

  • New-to-brand Revenue (3, 14, 30 days)

  • New-to-brand Units (3, 14, 30 days)

  • Number of Ads Clicks

  • Number of Ads Shown

  • Other SKU Sales (3, 14, 30 days)

  • Other SKU Units (3, 14, 30 days)

  • Related Attributed Sales (3, 14, 30 days)

Placement

Dimensions

  • Ad Group ID

  • Ad Group Name

  • Ad Group Status

  • Campaign Bidding Strategy

  • Campaign Bidding Strategy Status

  • Campaign Budget Type

  • Campaign Channel

  • Campaign End Date

  • Campaign ID

  • Campaign Name

  • Campaign Rollover

  • Campaign Start Date

  • Campaign Status

  • Campaign Targeting Type

  • Campaign TROAS

  • Campaign Type

  • Date

  • Placement

Metrics

  • Ad Spend

  • Advertised SKU Sales (3, 14, 30 days)

  • Advertised SKU Units (3, 14, 30 days)

  • Attributed Orders (3, 14, 30 days)

  • Attributed Sales (3, 14, 30 days)

  • Attributed Units (3, 14, 30 days)

  • Brand Attributed Sales (3, 14, 30 days)

  • Direct Attributed Sales (3, 14, 30 days)

  • In-Store Advertised Sales (3, 14, 30 days)

  • In-Store Attributed Sales (3, 14, 30 days)

  • In-Store Orders (3, 14, 30 days)

  • In-Store Other Sales (3, 14, 30 days)

  • In-Store Units Sold (3, 14, 30 days)

  • New-to-brand Orders (3, 14, 30 days)

  • New-to-brand Revenue (3, 14, 30 days)

  • New-to-brand Units (3, 14, 30 days)

  • Number of Ads Clicks

  • Number of Ads Shown

  • Other SKU Sales (3, 14, 30 days)

  • Other SKU Units (3, 14, 30 days)

  • Related Attributed Sales (3, 14, 30 days)

Platform

Dimensions

  • Ad Group ID

  • Ad Group Name

  • Ad Group Status

  • Campaign Bidding Strategy

  • Campaign Bidding Strategy Status

  • Campaign Budget Type

  • Campaign Channel

  • Campaign End Date

  • Campaign ID

  • Campaign Name

  • Campaign Rollover

  • Campaign Start Date

  • Campaign Status

  • Campaign Targeting Type

  • Campaign TROAS

  • Campaign Type

  • Date

  • Platform

Metrics

  • Ad Spend

  • Advertised SKU Sales (3, 14, 30 days)

  • Advertised SKU Units (3, 14, 30 days)

  • Attributed Orders (3, 14, 30 days)

  • Attributed Sales (3, 14, 30 days)

  • Attributed Units (3, 14, 30 days)

  • Brand Attributed Sales (3, 14, 30 days)

  • Direct Attributed Sales (3, 14, 30 days)

  • In-Store Advertised Sales (3, 14, 30 days)

  • In-Store Attributed Sales (3, 14, 30 days)

  • In-Store Orders (3, 14, 30 days)

  • In-Store Other Sales (3, 14, 30 days)

  • In-Store Units Sold (3, 14, 30 days)

  • New-to-brand Orders (3, 14, 30 days)

  • New-to-brand Revenue (3, 14, 30 days)

  • New-to-brand Units (3, 14, 30 days)

  • Number of Ads Clicks

  • Number of Ads Shown

  • Other SKU Sales (3, 14, 30 days)

  • Other SKU Units (3, 14, 30 days)

  • Related Attributed Sales (3, 14, 30 days)

Search Impression

Dimensions

  • Campaign Bidding Strategy

  • Campaign Bidding Strategy Status

  • Campaign Budget Type

  • Campaign Channel

  • Campaign End Date

  • Campaign ID

  • Campaign Name

  • Campaign Rollover

  • Campaign Start Date

  • Campaign Status

  • Campaign Targeting Type

  • Campaign TROAS

  • Campaign Type

  • Date

  • End Date

  • Month Of

  • Searched Keyword

  • Start Date

  • Week Of

Metrics

  • Ad Spend

  • Advertised SKU Sales (3, 14, 30 days)

  • Advertised SKU Units (3, 14, 30 days)

  • Attributed Orders (3, 14, 30 days)

  • Number of Ads Clicks

  • Number of Ads Shown

  • Other SKU Sales (3, 14, 30 days)

  • Other SKU Units (3, 14, 30 days)

  • Searched Keyword Impression Rank

  • Searched Keyword Impression Share

  • TOS Searched Keyword Impression Rank

  • TOS Searched Keyword Impression Share

Video Campaigns

Dimensions

  • Ad Group ID

  • Ad Group Name

  • Ad Group Status

  • Campaign Bidding Strategy

  • Campaign Bidding Strategy Status

  • Campaign Budget Type

  • Campaign Channel

  • Campaign End Date

  • Campaign ID

  • Campaign Name

  • Campaign Rollover

  • Campaign Start Date

  • Campaign Status

  • Campaign Targeting Type

  • Campaign TROAS

  • Campaign Type

  • Date

Metrics

  • Ad Spend

  • Advertised SKU Sales (3, 14, 30 days)

  • Advertised SKU Units (3, 14, 30 days)

  • Attributed Orders (3, 14, 30 days)

  • Attributed Sales (3, 14, 30 days)

  • Attributed Units (3, 14, 30 days)

  • Brand Attributed Sales (3, 14, 30 days)

  • Complete View Revenue (3, 14, 30 days)

  • Direct Attributed Sales (3, 14, 30 days)

  • Halo Complete View Revenue (3, 14, 30 days)

  • New-to-brand Orders (3, 14, 30 days)

  • New-to-brand Revenue (3, 14, 30 days)

  • New-to-brand Units (3, 14, 30 days)

  • Number of Ads Clicks

  • Number of Ads Shown

  • Other SKU Sales (3, 14, 30 days)

  • Other SKU Units (3, 14, 30 days)

  • Related Attributed Sales (3, 14, 30 days)

  • Total Complete View Orders (3, 14, 30 days)

  • Total Complete View Units (3, 14, 30 days)

Video Keywords

Dimensions

  • Ad Group ID

  • Ad Group Name

  • Ad Group Status

  • Bidded Keyword

  • Campaign Bidding Strategy

  • Campaign Bidding Strategy Status

  • Campaign Budget Type

  • Campaign Channel

  • Campaign End Date

  • Campaign ID

  • Campaign Name

  • Campaign Rollover

  • Campaign Start Date

  • Campaign Status

  • Campaign Targeting Type

  • Campaign TROAS

  • Campaign Type

  • Date

  • Keyword ID

  • Match Type

Metrics

  • Ad Spend

  • Advertised SKU Sales (3, 14, 30 days)

  • Advertised SKU Units (3, 14, 30 days)

  • Attributed Orders (3, 14, 30 days)

  • Attributed Sales (3, 14, 30 days)

  • Attributed Units (3, 14, 30 days)

  • Brand Attributed Sales (3, 14, 30 days)

  • Complete View Revenue (3, 14, 30 days)

  • Direct Attributed Sales (3, 14, 30 days)

  • Halo Complete View Revenue (3, 14, 30 days)

  • New-to-brand Orders (3, 14, 30 days)

  • New-to-brand Revenue (3, 14, 30 days)

  • New-to-brand Units (3, 14, 30 days)

  • Number of Ads Clicks

  • Number of Ads Shown

  • Other SKU Sales (3, 14, 30 days)

  • Other SKU Units (3, 14, 30 days)

  • Related Attributed Sales (3, 14, 30 days)

  • Total Complete View Orders (3, 14, 30 days)

  • Total Complete View Units (3, 14, 30 days)

  • Video 5 Second Views

  • Video Complete Views

  • Video First Quartile Views

  • Video Impressions

  • Video Midpoint Views

  • Video Third Quartile Views

  • Video Unmutes

  • Viewable Impressions

  • View Through Orders (3, 14, 30 days)

  • View Through Sales (3, 14, 30 days)

  • View Through Units Sold (3, 14, 30 days)

Related resources

Did this answer your question?