Schema Information for Walmart Connect
Schema Information for Walmart Connect
In this article, we will look at the schema information of the supported APIs and tables for Walmart Connect.
Find the links to other articles related to Walmart Connect Below:
- Essential Attributes and Supported Tables for Walmart Connect
- Setup Instructions for Walmart Connect
Tables/APIs Supported
The tables and APIs associated with the Walmart Ads connector are as follows.
Campaigns
Purpose: Retrieves all campaigns for specific advertiser between given dates
Source API Documentation: Campaigns
Replication Type: Key Based Replication
Replication Key: Last Modified Date
Primary Key: campaignId
Schema Detail: Walmart Connect Schema
Adgroup
Purpose: Retrieve all the ad group(s) for specific advertiser between given dates
Source API Documentation: Adgroup
Replication Type: Key Based Replication
Replication Key: Last Modified Date
Primary Key: adGroupId
Schema Detail: Walmart Connect Schema
Aditems
Purpose: Retrieves the list of all the products added to the campaign catalog.
Source API Documentation: AdItems
Replication Type: Key Based Replication
Replication Key: Campaign Id
Primary Key: adItemId
Schema Detail: Walmart Connect Schema
AdgroupSnapshotReport
Purpose: Retrieves performance report data for adgroups
Source API Documentation: AdgroupSnapshotReport
Replication Type: Key Based Replication
Replication Key: Report date
Primary Key: adGroupId
Schema Detail: Walmart Connect Schema
AditemSnapshotReport
Purpose: Retrieves performance report data for adItems
Source API Documentation: AditemSnapshotReport
Replication Type: Key Based Replication
Replication Key: Report date
Primary Key: itemId
Schema Detail: Walmart Connect Schema
KeywordSnapshotReport
Purpose: Retrieves performance report data for different keywords.
Source API Documentation: KeywordSnapshotReport
Replication Type: Key Based Replication
Replication Key: Report date
Schema Detail: Walmart Connect Schema
StatsNearRealTime
Purpose: It provides capability to retrieve near real time metrics and campaign budget cap-out time on the day of request.
Source API Documentation: Stats Near Real time
Replication Type: Full load(current day’s data)
Primary Key: campaignId
Schema Detail: Walmart Connect Schema
SuggestedKeywords
Purpose: Gives a list of suggested keywords based on the item added in the ad group.
Source API Documentation: Suggested Keywords
Replication Type: Full load
Schema Detail: Walmart Connect Schema
SponsoredBrandProfile
Purpose: Retrieve a specific Sponsored Brands profile for a specific campaign by providing campaign ID and ad group ID.
Source API Documentation: SponsoredBrandProfile
Replication Type: Full load
Primary Key: searchAmpName
Schema Detail: Walmart Connect Schema
TopSearchTrends
Purpose: Retrieves top organic search trends across Walmart.com/app and the 3 top selling items (including variant items) associated with each high performing keyword.
Source API Documentation: TopSearchTrends
Replication Type: Full load
Primary Key: reportDate, searchKeyword
Schema Detail: Walmart Connect Schema
