Who is this for?: Individuals who are responsible for creating and analyzing Walmart sales reports.
Objective: To analyze and summarize the company's sales performance over a given period. The report would provide valuable insights into the company's revenue, profit, customer trends, and other key metrics that would help evaluate the effectiveness of the company's sales strategies and identify areas for improvement.
Data needed are:
Revenue (GMV)
Commission
GMV after Commission
Ad Spend
Ad Revenue
Ad ACOS
True ACOS
Sample of Report
Instructions:
1. Log in to Walmart seller central account. Go to https://seller.walmart.com/
2. Go to Performance under the Analytics tab on the left side navigation menu and click Item Sales.
3. Results can be refined by choosing the preferred Date, Account, Departments, and Brands. We usually obtain sales reports every week. Refine by
Date: choose “Custom” and select the preferred week
Account: Account
Departments: All Department
Brands: All Brands
4. Get the GMV or Gross Merchandise Value and GMV - Commision by copying the result after setting the Date, Account, Department, and Brands.
If GMV and GMV - Commision results are not showing, make sure to customize the settings and check the GMV and GMV - Commision from the table.
5. Once GMV and GMV - Commission are collected. Get the Commission by subtracting the GMV - Commission from the GMV value.
Revenue (GMV): $513.40
GMV after Commission: $465.68
Commission: $47.72
6. Next, get the Ad Spend and Ad Revenue. Go to Ad Center or visit https://advertising.walmart.com/view/home.
You will be redirected to Sponsored Search Dashboard. Again customize the date from the preferred week.
Get the Ad Spend and Ad Revenue by copying the result after setting the Date.
7. Once Ad Spend and Ad Revenue are collected. Get the Ad ACOS percentage using the Ad Spend / Ad Revenue * 100 formula.
Ad Spend: $166.91
Ad Revenue: $196.35
Ad ACOS: 85.01%
8. Last is to get the True ACOS percentage using the Ad Spend / GMV * 100 formula.
Ad Spend: $166.91
Revenue (GMV): $513.40
True ACOS: 32.51%
