The Walmart Tacos Report provides an in-depth analysis of sales and advertising performance for products sold by Walmart Sellers. This report is essential for stakeholders who wish to understand the effectiveness of their marketing strategies and overall sales performance.
I. Summary Sheet
The Summary sheet offers a snapshot comparison of key performance indicators (KPIs) between two consecutive periods. This comparison helps stakeholders quickly assess changes in advertising efficiency and sales performance. The primary metrics include:
- TACOS (Total Advertising Cost of Sales): Measures advertising spend as a percentage of total sales.
- ROAS (Return on Advertising Spend): Indicates the revenue generated for every dollar spent on advertising.
- Ad Spend: The total amount spent on advertising.
- Ad Sales: The total sales generated from advertising.
- Ad SKU Sales: The total sales of specific stock-keeping units (SKUs) generated from advertising.
II. Color Coding in the Report
The report uses a color-coding system to help readers quickly identify the data type represented in each column. The colors and their meanings are as follows:
- White: General data, such as names, identifiers, and basic metrics.
- Blue: Total data, including total sales, return sales, canceled sales, and units sold.
- Yellow: Advertising-related data, including ad spend, ad sales, and ad units sold.
- Green: Organic data, such as organic sales, and organic units sold.
III. By Product Type Sheet
The By Product Type sheet breaks down sales and advertising data by different product categories. Key columns include:
- Product Type: The specific classification of the category.
- Total Net Sales: The total sales revenue for each product type.
- Share of Sales: The proportion of total sales attributed to each product type, calculated as (Sales of each Type/Total Sales).
- Return Sales: The revenue from returned products for each product type.
- Cancelled Sales: The revenue from canceled sales for each product type.
- Total Net Unit Sold: The total number of units sold for each product type.
- Ad Spend: The total amount spent on advertising for each product type.
- Share of Ad Spend: The proportion of total ad spend attributed to each product type, calculated as (Ad spend on each Type/Total Ad spend).
- TACOS: Total Advertising Cost of Sales for each product type, calculated as (Ad Spend/Total Sales).
- Previous TACOS: TACOS value from the previous period for comparison.
- Ad Sales: The total sales revenue generated from advertising for each product type.
- Share of Ad Sales: The proportion of total ad sales attributed to each product type, calculated as (Ad Sales/Total Sales).
- ROAS: Return on Advertising Spend for each product type, calculated as (Ad Sales/Ad Spend).
- Previous ROAS: ROAS value from the previous period for comparison.
- Ad Units Sold: The total number of units sold through advertising for each product type.
- Ad Conversion: The conversion rate of ads for each product type, calculated as (Ad Units Sold/Total Ad Clicks).
- Walmart Item Page Views: The number of page views for Walmart item pages for each product type.
- EBC Page Views: The number of page views for Enhanced Brand Content for each product type.
- Organic Views: Estimated number of organic page views, calculated based on the difference between total page views and ad clicks.
- Organic Sales: The total sales revenue generated from organic (non-advertised) views for each product type.
- Organic Units Sold: The total number of units sold through organic views for each product type.
- Organic Conversion: The conversion rate for organic views, calculated as (Organic Units Sold/Organic Views).
- Share of Organic: The proportion of total sales attributed to organic views for each product type, calculated as (Organic Sales/Total Sales).
- Days of Inventory: The available inventory is divided by the average daily units sold in the last 30 days, indicating the number of days of inventory is available for each product type.
IV. By Item IDs Sheet
The By Item IDs sheet provides data at the individual item level, offering insights into the performance of specific products. Key columns include:
- Item ID: The unique identifier for each product.
- Total Net Sales: The total sales revenue for each item.
- Share of Sales: The proportion of total sales attributed to each item, calculated as (Sales of each Item/Total Sales).
- Return Sales: The revenue from returned products for each item.
- Cancelled Sales: The revenue from canceled sales for each item.
- Total Net Unit Sold: The total number of units sold for each item.
- Ad Spend: The total amount spent on advertising for each item.
- Share of Ad Spend: The proportion of total ad spend attributed to each item, calculated as (Adspend on each Item/Total Adspend).
- TACOS: Total Advertising Cost of Sales for each item, calculated as (Ad Spend/Total Sales).
- Previous TACOS: TACOS value from the previous period for comparison.
- Ad Sales: The total sales revenue generated from advertising for each item.
- Share of Ad Sales: The proportion of total ad sales attributed to each item, calculated as (Ad Sales/Total Sales).
- ROAS: Return on Advertising Spend for each item, calculated as (Ad Sales/Ad Spend).
- Previous ROAS: ROAS value from the previous period for comparison.
- Ad Units Sold: The total number of units sold through advertising for each item.
- Ad Conversion: The conversion rate of ads for each item, calculated as (Ad Units Sold/Total Ad Clicks).
- Walmart Item Page Views: The number of page views for Walmart item pages for each item.
- EBC Page Views: The number of page views for Enhanced Brand Content for each item.
- Organic Views: Estimated number of organic page views, calculated based on the difference between total page views and ad clicks.
- Organic Sales: The total sales revenue generated from organic (non-advertised) views for each item.
- Organic Units Sold: The total number of units sold through organic views for each item.
- Organic Conversion: The conversion rate for organic views, calculated as (Organic Units Sold/Organic Views).
- Share of Organic: The proportion of total sales attributed to organic views for each item, calculated as (Organic Sales/Total Sales).
- Days of Inventory: The available inventory is divided by the average daily units sold in the last 30 days, indicating how many days of inventory are available for each item.
V. By Category Sheet
The By Category sheet groups data by product categories, offering a broader view of performance across different segments. Key columns include:
- Category: The product category.
- Total Net Sales: The total sales revenue for each category.
- Share of Sales: The proportion of total sales attributed to each category.
- Return Sales: The revenue from returned products for each category.
- Cancelled Sales: The revenue from canceled sales for each category.
- Total Net Unit Sold: The total number of units sold for each category.
- Ad Spend: The total amount spent on advertising for each category.
- Share of Ad Spend: The proportion of total ad spend attributed to each category.
- TACOS: Total Advertising Cost of Sales for each category.
- Previous TACOS: TACOS value from the previous period for comparison.
- Ad Sales: The total sales revenue generated from advertising for each category.
- Share of Ad Sales: The proportion of total ad sales attributed to each category.
- ROAS: Return on Advertising Spend for each category.
- Previous ROAS: ROAS value from the previous period for comparison.
- Ad Units Sold: The total number of units sold through advertising for each category.
- Ad Conversion: The conversion rate of ads for each category.
- Walmart Item Page Views: The number of page views for Walmart item pages for each category.
- EBC Page Views: The number of page views for Enhanced Brand Content for each category.
- Organic Views: Estimated number of organic page views, calculated based on the difference between total page views and ad clicks.
- Organic Sales: The total sales revenue generated from organic (non-advertised) views for each category.
- Organic Units Sold: The total number of units sold through organic views for each category.
- Organic Conversion: The conversion rate for organic views.
- Share of Organic: The proportion of total sales attributed to organic views for each category.
- Days of Inventory: The available inventory is divided by the average daily units sold in the last 30 days,indicating the number of days of inventory is available for each category.
VI. By Brands Sheet
The By Brands sheet offers insights into the performance of different brands within the product portfolio. Key columns include:
- Brand: The product brand.
- Total Net Sales: The total sales revenue for each brand.
- Share of Sales: The proportion of total sales attributed to each brand.
- Return Sales: The revenue from returned products for each brand.
- Canceled Sales: The revenue from canceled sales for each brand.
- Total Net Unit Sold: The total number of units sold for each brand.
- Ad Spend: The total amount spent on advertising for each brand.
- Share of Ad Spend: The proportion of total ad spend attributed to each brand.
- TACOS: Total Advertising Cost of Sales for each brand.
- Previous TACOS: TACOS value from the previous period for comparison.
- Ad Sales: The total sales revenue generated from advertising for each brand.
- Share of Ad Sales: The proportion of total ad sales attributed to each brand.
- ROAS: Return on Advertising Spend for each brand.
- Previous ROAS: ROAS value from the previous period for comparison.
- Ad Units Sold: The total number of units sold through advertising for each brand.
- Ad Conversion: The conversion rate of ads for each brand.
- Walmart Item Page Views: The number of page views for Walmart item pages for each brand.
- EBC Page Views: The number of page views for Enhanced Brand Content for each brand.
- Organic Views: Estimated number of organic page views, calculated based on the difference between total page views and ad clicks.
- Organic Sales: The total sales revenue generated from organic (non-advertised) views for each brand.
- Organic Units Sold: The total number of units sold through organic views for each brand.
- Organic Conversion: The conversion rate for organic views.
- Share of Organic: The proportion of total sales attributed to organic views for each brand.
- Days of Inventory: The available inventory is divided by the average daily units sold in the last 30 days, indicating the number of days of inventory is available for each brand.
VII. By Keywords Sheet
The By Keywords sheet analyzes the effectiveness of different keywords used in advertising campaigns. Key columns include:
- Keyword: The keyword used in advertising campaigns.
- Total Net Sales: The total sales revenue generated using each keyword.
- Share of Sales: The proportion of total sales attributed to each keyword.
- Return Sales: The revenue from returned products associated with each keyword.
- Canceled Sales: The revenue from canceled sales associated with each keyword.
- Total Net Unit Sold: The total number of units sold associated with each keyword.
- Ad Spend: The total amount spent on advertising for each keyword.
- Share of Ad Spend: The proportion of total ad spend attributed to each keyword.
- TACOS: Total Advertising Cost of Sales for each keyword.
- Previous TACOS: TACOS value from the previous period for comparison.
- Ad Sales: The total sales revenue generated from advertising for each keyword.
- Share of Ad Sales: The proportion of total ad sales attributed to each keyword.
- ROAS: Return on Advertising Spend for each keyword.
- Previous ROAS: ROAS value from the previous period for comparison.
- Ad Units Sold: The total number of units sold through advertising for each keyword.
- Ad Conversion: The conversion rate of ads for each keyword.
- Walmart Item Page Views: The number of page views for Walmart item pages associated with each keyword.
- EBC Page Views: The number of page views for Enhanced Brand Content associated with each keyword.
- Organic Views: The estimated number of organic page views is calculated based on the difference between total page views and ad clicks.
- Organic Sales: The total sales revenue generated from organic (non-advertised) views associated with each keyword.
- Organic Units Sold: The total number of units sold through organic views associated with each keyword.
- Organic Conversion: The conversion rate for organic views.
- Share of Organic: The proportion of total sales attributed to organic views associated with each keyword.
- Days of Inventory: The available inventory is divided by the average daily units sold in the last 30 days, indicating the number of days of inventory is available for each keyword.
VIII. By Variants Sheet
The By Variants sheet provides data on different product variants, offering detailed insights into the performance of each variant. Key columns include:
- Variant: The specific variant of the product.
- Total Net Sales: The total sales revenue for each variant.
- Share of Sales: The proportion of total sales attributed to each variant.
- Return Sales: The revenue from returned products for each variant.
- Cancelled Sales: The revenue from canceled sales for each variant.
- Total Net Unit Sold: The total number of units sold for each variant.
- Ad Spend: The total amount spent on advertising for each variant.
- Share of Ad Spend: The proportion of total ad spend attributed to each variant.
- TACOS: Total Advertising Cost of Sales for each variant.
- Previous TACOS: TACOS value from the previous period for comparison.
- Ad Sales: The total sales revenue generated from advertising for each variant.
- Share of Ad Sales: The proportion of total ad sales attributed to each variant.
- ROAS: Return on Advertising Spend for each variant.
- Previous ROAS: ROAS value from the previous period for comparison.
- Ad Units Sold: The total number of units sold through advertising for each variant.
- Ad Conversion: The conversion rate of ads for each variant.
- Walmart Item Page Views: The number of page views for Walmart item pages for each variant.
- EBC Page Views: The number of page views for Enhanced Brand Content for each variant.
- Organic Views: Estimated number of organic page views, calculated based on the difference between total page views and ad clicks.
- Organic Sales: The total sales revenue generated from organic (non-advertised) views for each variant.
- Organic Units Sold: The total number of units sold through organic views for each variant.
- Organic Conversion: The conversion rate for organic views.
- Share of Organic: The proportion of total sales attributed to organic views for each variant.
- Days of Inventory: The available inventory is divided by the average daily units sold in the last 30 days, indicating the number of days of inventory is available for each variant.
The Walmart Tacos Report provides valuable insights into the sales and advertising performance of Walmart sellers' products. By analyzing key metrics such as TACOS, ROAS, and the share of sales and ad spend, stakeholders can make informed decisions to optimize their marketing strategies and improve overall sales performance.
The detailed breakdown across different sheets - By Item IDs, By Category, By Brands, By Keywords, and By Variants - allows for a comprehensive analysis of performance at various levels, from individual items to broader categories. This granular data helps stakeholders identify strengths, uncover opportunities for improvement, and strategically allocate resources to drive growth and profitability.
By leveraging this report, stakeholders can gain a deeper understanding of their product performance and advertising effectiveness, enabling them to make data-driven decisions that drive growth and profitability.