<aside>

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.

</aside>

Prerequisites

Before you begin, ensure you have the following:

• A Client ID and Client Secret from your Walmart Developer account
• Power My Analytics added in Walmart as a Solution Provider with View Only permission for the following:
  • Inventory
  • Orders
  • Returns
  • Shipping
  • Reports
  • Account Profile
  • Growth

For information on adding Power My Analytics as a solution provider and obtaining your Client ID and Client Secret, please see How to Connect to Walmart.

Adding Walmart as a Data Source

1. Log in to your Power My Analytics hub.
2. Navigate to the Sources section in the menu.
3. Click on + Add new source.
4. Select Walmart from the gallery of available sources
5. Enter your Walmart Client ID and Client Secret.
6. Provide a name for this account connection.
7. Click Connect to finalize.

Creating a Looker Studio Report

Follow these steps to create a Looker Studio report using your Walmart data:

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:
   • Step 1:
     • Name your data source (e.g., "Walmart - Your Organization")
     • Select your Power My Analytics hub from the dropdown
     • Optional: Leave "Use report template for new reports" checked if you want to use the PMA demo template
     • Click Next
   • Step 2:
     • User Account: Choose your Walmart account (for real data) or "Sample Account" (for sample data)
     • Click Next
   • Step 3:
     • Optional: Select "Optional - Order Status Filter" for your reports
     • Optional: Allow "Optional - Order Status Filter" modification in reports
     • Click Connect in the top right to complete the data source configuration
   • Step 4:
     • Click Create Report in the top right corner

For a quick start, use our pre-built Walmart demo template.