Schema Information for Walmart Connect

Need help with something?

Talk to data expert

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:

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