Retail Reports

PRISM 3.0 Navigation

PRISM 3.0 Retail Reporting

All the Titles are clickable to the reports

Business Overview

Purpose

Metrics Covered in This Report

The Business Overview report provides a high-level snapshot of overall business and advertising performance for the selected Amazon account. It is designed to help stakeholders quickly understand revenue health, unit trends, advertising contribution, and efficiency, along with Year-over-Year (YoY) and Period-over-Period (PoP) performance comparisons.

This report is typically used for:

Executive updates

Monthly / weekly performance reviews

Identifying topline growth or decline drivers

Assessing advertising efficiency at a glance

Key Visuals Explained

TACoS Goal Achievement Table: Shows whether each account is meeting its TACoS goal for the selected date range by comparing actual TACoS vs the target TACoS goal, and assigns a clear status flag.

Account Name: The selected Amazon account.

TACoS Goal: The target TACoS benchmark set for the account.

TACoS: Actual TACoS achieved in the selected time period.

Flag: Status label indicating goal performance (e.g., Within Goal, Slightly Over, Over Goal, or No Goal/Sales Data when applicable).

Variance: How far above/below the goal the account is (relative gap vs the goal).

Business Performance

Total Revenue

Total Units Sold

Advertising Contribution

Ad Attributed Sales % – Percentage of total revenue driven by advertising

Total Ad Spend (Sponsored Ads + DSP)

Total Ad Revenue (Sponsored Ads + DSP)

Efficiency Metrics TACoS (Total Advertising Cost of Sales)

ROAS (Return on Ad Spend)

Each metric includes:

Current value

YoY % change

PoP % change

Directional indicators (increase / decrease)

VC Sourcing and Manufacturing Business Overview

Purpose

Provides a clear view of overall business performance by comparing shipped revenue, units, COGS, and ROAS across sourcing and manufacturing distribution channels over time. It highlights both year-over-year and period-over-period changes, as well as month-to-date (MTD) performance versus the previous MTD, so you can quickly assess growth, profitability, and channel health at a glance.

How to Use This Report

Business Health Overview: Use the top sourcing and manufacturing cards to quickly understand current shipped revenue, units, COGS, and ROAS, along with their year-over-year and period-over-period trends.

Trend and Delta Interpretation Scan the red and green percentage deltas to see which KPIs are improving or declining on a YoY and PoP basis. Focus deeper analysis on metrics with the largest negative movements, such as units falling faster than revenue.

ROAS and Profitability Focus: Track Total ROAS in both sourcing and manufacturing views to gauge how efficiently spend is converting into shipped revenue. If ROAS and revenue move in opposite directions, review COGS, pricing, and mix to understand profitability impacts.

Channel and Distribution Diagnostics: Compare sourcing and manufacturing blocks to see whether performance issues are isolated to a specific stream or affecting the whole business.

Retail Sales Breakdown

Purpose

Provides a clear view of how total sales are split between Organic, Sponsored Ads (SA), and how advertising spend aligns with sales mix across time and days of the week.

How to Use This Report

Sales Mix Analysis: Use this report to understand the contribution of Organic, Sponsored Ads (SA) to total sales.

Ad Dependency Assessment: Review Ad Attributed Sales % and the sales funnel to evaluate how reliant total revenue is on advertising.

Spend Efficiency Monitoring: Analyze SA spend trends alongside revenue to assess efficiency and scaling opportunities. Supports drill-down to daily performance and drill-up to monthly totals, enabling analysis of sales mix and advertising spend trends at different time granularities.

Day-of-Week Optimization: Use the Day-of-Week Sales Mix to identify high-performing days and optimize budget allocation accordingly.

Key Metrics Explained

Total Organic Sales: Revenue generated without ad attribution.

SA Revenue / Spend: Sales and spend from Sponsored Ads campaigns.

Ad Attributed Sales %: Percentage of total sales attributed to advertising.

Retail Sales Breakdown Including DSP

Purpose

Provides a detailed view of total retail sales split across Organic, Sponsored Ads (SA), and DSP, highlighting how ad spend and ad revenue are distributed by strategy and how sales mix trends over time and by day of week.

How to Use This Report

Sales Channel Contribution: Use this report to understand how Organic, SA, and DSP each contribute to total sales.

Ad Strategy Comparison: Compare SA and DSP revenue and spend to evaluate which advertising strategy is driving stronger returns.

Ad Dependency Analysis: Review Ad Attributed Sales % and the sales funnel to assess reliance on paid media.

Spend Allocation Insights: Analyze ad spend share versus ad revenue share to identify over- or under-investment by strategy.

Temporal Optimization: Use time-based charts to identify trends by month, day, or day of week for better budget planning.

Key Visuals Explained

Retail Sales Breakdown: Displays total sales split between Organic and Ad-attributed sales.

Ad Spend by Ad Strategy: Shows how total advertising spend is allocated between SA and DSP.

Ad Revenue by Ad Strategy: Shows how ad-attributed revenue is distributed between SA and DSP.

Sales Mix (Organic, SA, DSP) with Ad Spend Trend: Allows drill-down to daily performance and drill-up to monthly totals to analyze sales mix and ad spend trends over time.

Day-of-Week Sales Mix (Organic, SA, DSP) with Ad Spend Trend: Highlights how sales mix and ad spend vary by day of the week to support day-level budget optimization.

Retail Traffic Analysis

Purpose

Provides insight into retail traffic trends and seasonality by analyzing page sessions and page views across weekly and monthly timeframes, with monthly comparisons against the previous year.

How to Use This Report

Traffic Trend Monitoring: Use this report to understand overall traffic movement and identify increases or declines in shopper engagement.

Short-Term Trend Analysis: Review weekly and day-of-week charts to assess recent traffic behavior and performance patterns.

Day-of-Week Insights: Identify which days consistently drive higher or lower traffic to support campaign timing and merchandising decisions.

Seasonality & YoY Comparison: Use the monthly view to compare current-year traffic against the same months from the previous year.

Top-of-Funnel Evaluation: Leverage this report to evaluate awareness and discovery trends before conversion occurs.

Key Visuals Explained

Weekly Retail Traffic Trend: Shows total page sessions over time, compared against the prior period to highlight weekly momentum.

Day-of-Week Retail Traffic Trend: Displays average page sessions by day of the week to identify consistent traffic patterns.

Traffic Analysis by Month: Compares monthly page views for the selected year versus the previous year and highlights the percentage change.

Retail Sales Analysis

Purpose

Provides insight into retail sales performance and advertising investment trends by analyzing total sales and ad spend across weekly and monthly views, with monthly comparisons versus the previous year.

How to Use This Report

Sales & Spend Trend Analysis: Use this report to evaluate how total retail sales trend alongside advertising spend over time.

Short-Term Performance Monitoring: Review weekly and day-of-week views to understand recent sales momentum and spend behavior.

Day-of-Week Optimization: Identify which days drive stronger sales and how ad spend aligns with daily performance.

YoY Performance Evaluation: Use the monthly comparison to assess how current-year sales and ad spend compare to the same months last year.

Efficiency Context: Analyze whether changes in ad spend are translating into proportional changes in total sales.

Key Visuals Explained

Weekly Sales Mix with Ad Spend Trend: Shows total retail sales and ad spend by week, compared against the prior period to highlight Weekly performance shifts.

Day-of-Week Sales Mix with Ad Spend Trend: Displays average sales and ad spend by day of the week to identify consistent daily patterns.

Sales and Spend Analysis by Month: Compares monthly total revenue and ad spend for the selected year versus the previous year and highlights percentage change.

ASIN Level Analysis

Purpose

Provides a product-level (ASIN-level) view of sales, traffic, and advertising performance to identify top-performing and underperforming ASINs, assess spend efficiency, and understand contribution to total business results.

How to Use This Report

Top ASIN Identification: Use this report to identify which ASINs drive the majority of sales, units, and ad spend.

Sales & Spend Distribution: Review the top distribution chart to understand how sales, units, and ad spend are concentrated across leading products.

Performance Comparison: Use YoY and PoP tables to compare ASIN performance across different time periods.

Efficiency Evaluation: Analyze conversion rates and ad-attributed sales to understand whether ad spend is translating into meaningful performance.

Prioritization & Optimization: Identify ASINs to scale, defend, optimize, or deprioritize based on sales, traffic, and efficiency metrics.

Key Visuals Explained

Top 15 Product Sales and Spend Distribution: Visualizes how the top 15 ASINs contribute to Total Sales, Total Units Sold, SA Revenue, and SA Spend, highlighting product concentration and hero ASINs.

ASIN Level Performance – YoY: Displays ASIN-level performance metrics with percentage change compared to the same period last year.

Metrics available include: SA Spend, Total Sales, % of Total Sales, Total Units Sold, Total Sessions, Retail CVR %, SA CVR %, Ad Attributed Sales %, with optional metrics such as SA Impressions, SA Orders, SA Clicks, and SA Revenue.

ASIN Level Performance – PoP: Displays ASIN-level performance metrics with percentage change compared to the previous period.

Metrics available include: SA Spend, Total Sales, % of Total Sales, Total Units Sold, Total Sessions, Retail CVR %, SA CVR %, Ad Attributed Sales %, with optional metrics such as SA Impressions, SA Orders, SA Clicks, and SA Revenue.

TACoS Achievement Report

Purpose

The TACoS Achievement Report is designed to evaluate how effectively each Amazon account is performing against its defined TACoS (Total Advertising Cost of Sales) goal. This report provides a clear, goal-oriented view of advertising efficiency by comparing actual TACoS against target benchmarks across accounts.

It enables stakeholders to quickly identify which accounts are operating efficiently, which are slightly misaligned, and which require immediate optimization to control advertising costs.

How to Use This Report

Goal Compliance Review: Use the table to determine whether each account is meeting, exceeding, or lacking sufficient data to evaluate against its TACoS goal.

Account Prioritization: Quickly identify accounts marked as Over Goal to prioritize optimization efforts.

Efficiency Benchmarking: Compare actual TACoS levels across accounts relative to their individual goals.

Portfolio Management: Assess overall advertising efficiency trends across multiple accounts within a country or region.

Exception Handling: Identify accounts with missing goals or insufficient sales data that may require setup or data validation.

Key Visuals Explained

TACoS Goal Achievement Table: Displays account-level performance against defined TACoS goals for the selected date range.

Account Name: Amazon account included in the analysis.

TACoS Goal: Target TACoS benchmark set for the account.

TACoS: Actual TACoS achieved during the selected period.

Flag: Visual status indicator showing performance vs goal:

Within Goal: Actual TACoS is at or below the target.

Over Goal: Actual TACoS exceeds the target.

No Goal or Sales Data: Missing goal configuration or insufficient sales data.

Variance: Relative difference between actual TACoS and the goal, indicating how far above or below target the account is.