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