This guide contains all permissions and requirements for connecting your Walmar Connect (Search) data to Supermetrics.
You can connect to data sources from the Data sources page on the Supermetrics Hub. On the Hub, you can also share an authentication link to connect to a data source you don't have direct access to.
After you connect to the data source on the Hub, you can use the data source connection in all available destinations.
Required permissions
Before using the Walmart Connect (Search) connector, you need to grant Supermetrics read access to your Search Ads data. Follow the steps below.
- Open the Manager profile and account page in Walmart Connect.
- Ensure the correct organization is selected on the left side menu.
- Click Access and select the Partner tab.
- Click +Add Partner.
- In the API Partner name drop-down menu, select Supermetrics (Read access).
- Select the correct Ad account and set access levels for selected ad accounts.
- Click Add Partner.
After sufficient access to Supermetrics has been granted to read your data, you need an Advertiser ID for an account you want to fetch data for.
Additionally, you need:
- Campaign ID that belongs to the advertiser you’re connecting with.
- Ad Group ID that belongs to the campaign you connected with.
Note that once the connection is established, you will be able to fetch data from all campaigns and ad groups under the specified advertiser, not just the ones you provided during setup.
Query types
Query types define what sort of metrics and dimensions are available. You need to select one of the following query types when pulling data:
- Ad group
- Ad item
- Attributed purchases
- Brand
- Category
- Keyword
- Out of budget recommendations
- Page type
- Placement
- Platform
- Search impression
- Video campaign
- Video keyword
Connection instructions
Before you begin, please make sure you've granted Supermetrics API access in the Walmart Connect platform as described in the Required permissions section.
When connecting to Walmart Connect, you need to insert your credentials to Walmart Connect.
- Select the Walmart Connect (Search) data source on the Supermetrics Hub or in the data destination.
- Insert your Advertiser ID, and a pair of Campaign ID and Ad group ID.
- If prompted, choose to make this connection shared or private.
- Click Start.
- In your data destination, select the query type to use, if prompted.
See detailed instructions on how to connect to a data source from the Supermetrics Hub.
You can also connect to Walmart Connect (Search) from these destinations:
- Google Sheets: How to log in to a Supermetrics data source in Google Sheets
- Looker Studio: How to connect data sources to Looker Studio
- Excel: How to connect data sources to Excel with Supermetrics
- Power BI: How to create your first Supermetrics query for Power BI
- The Supermetrics API: How to use the Query Manager
- Data warehouse and cloud storage (Hub): How to create a transfer
- BigQuery (marketplace): How to create a BigQuery (marketplace) transfer