Are you looking to streamline your Walmart marketplace data analysis and reporting? This guide will walk you through the process of connecting your Walmart seller account to Power My Analytics, enabling you to automate data collection, centralize your metrics, and create powerful reports. By following these steps, you'll be able to save time and gain valuable insights into your Walmart sales performance.

Adding Walmart as a Data Source

To connect your Walmart Seller Center account, follow these steps:

1. Log in to your Power My Analytics hub.
2. Navigate to the Sources section in the menu.
3. Click on + Add new source and select the Walmart (US) connector. You'll be forwarded to the Walmart Seller Center platform.
4. Enter your Walmart Seller Center email or user ID and password, then click the Log In button.
5. Review the requested permissions, then click the Authorize button to grant PMA access to your Walmart Seller Center information.
6. Your Walmart account is now connected, and you'll be sent back to your PMA hub.
   

For a detailed walkthrough of the connection process, see How to Connect to Walmart.

Geographic Limitation: PMA only supports the United States Walmart API. Mexico and Canada use different APIs and are not currently supported.

Creating a Looker Studio Report

1. In your PMA hub, go to Reports > Looker Studio
2. Click on Walmart under the Create Looker Studio Report section (this will open the official Looker Studio application in a new window)
3. Google Looker Studio Configuration:
   
1. Step 1:
1. Name your data source (e.g., "Walmart - Your Organization")
2. Select your Power My Analytics hub from the dropdown
3. Optional: Leave "Use report template for new reports" checked if you want to use the PMA demo template
4. Click Next
2. Step 2:
1. User Account: Choose your Walmart account (for real data) or "Sample Account" (for sample data)
2. Click Next
3. Step 3:
1. Optional: Select "Optional - Order Status Filter" for your reports
2. Optional: Allow "Optional - Order Status Filter" modification in reports
3. Click Connect in the top right to complete the data source configuration
4. Step 4:
1. Click Create Report in the top right corner

Key Reports and Fields

Limitations and Important Considerations

1. Cached Data Requests with Unique Metrics and Date Dimension: When a unique metric is paired with the date dimension, this will result in a request for cached data instead of a request for live data. For this reason, only cached data will appear in a report or chart that pairs a unique field with the date dimension.
2. Backfilling: Most metrics can be backfilled for up to 180 days.
   
1. Returns data can be backfilled for up to 2 years.
   
2. Inventory is a live metric and cannot be backfilled.
   
3. API key changes: If you create new API keys for your Walmart account after connecting to PMA, you'll need to create a new Walmart data source in your hub and update your existing reports to use the new data source.
   
4. Reconciliation data: This is not available daily and will populate 2 to 3 times per month.
5. Inventory reporting: Include the current date in your date range to get the most recent inventory values.
6. Geographic limitation: PMA only supports the United States Walmart API. Mexico and Canada use different APIs and are not supported.

Unavailable Data

1. Realtime data
   
2. Custom fields

Account Behavior When Reconnecting with New API Keys

1. When you connect to your Walmart account in PMA using your new API keys, this will create a new Walmart data source in your hub corresponding to the new keys.
   
2. This will not reconnect the previously connected Walmart data source corresponding to the earlier API keys.
   
3. Your existing reports using your previous Walmart data source will need to be changed to use the newly connected Walmart data source.

Troubleshooting