Sponsored Ads Reports

PRISM 3.0 Navigation

PRISM 3.0 Sponsored Ads Reporting

All the Titles are clickable to the reports

Sponsored Ads Overview

Purpose

Provides a consolidated view of Sponsored Ads performance across spend, revenue, traffic, and efficiency metrics, with YoY, PoP, and MTD comparisons to assess advertising health, momentum, and efficiency at a glance.

How to Use This Report

Key Metrics Explained

Overall Ads Health Check: Use this report to quickly understand how Sponsored Ads are performing across spend, revenue, traffic, and efficiency metrics.

Efficiency Monitoring: Review ROAS, ACOS, CPC, CTR, and CVR together to evaluate whether ad investment is driving efficient outcomes.

Trend Analysis (Drillable): Use the performance trend charts to drill down to daily data for granular analysis or drill up to monthly views for high-level trend assessment across spend, revenue, and clicks.

Pacing & Momentum: Compare MTD vs Previous MTD to assess whether performance is accelerating or slowing within the current month.

Strategic Filtering: Leverage Campaign Type and Brand Targeting Type filters to isolate performance by ad strategy or branded vs non-branded targeting.

Key Visuals Explained

Ad Performance Trend (Spend, Revenue, Clicks): Displays daily trends for ad spend, ad revenue, and clicks to identify short-term performance shifts and volatility.

MTD Ad Performance Trend (Spend, Revenue, Clicks): Shows cumulative month-to-date trends to evaluate pacing and momentum compared to the prior month.

Ad Spend: Total advertising investment during the selected period

Ad Revenue: Total sales attributed to Sponsored Ads

Clicks: Total ad clicks generated

Impressions: Total times ads were shown

CTR %: Click-through rate (Clicks ÷ Impressions)

Avg. CPC: Average cost per click

CVR %: Conversion rate (Orders ÷ Clicks)

AOV: Average order value from ad-attributed sales

ROAS: Return on ad spend (Ad Revenue ÷ Ad Spend)

ACOS: Advertising cost of sales (Ad Spend ÷ Ad Revenue)

Each KPI tile includes:

Current value

YoY % change

PoP % change

Directional indicators (increase / decrease)

Sponsored Ads CPC and ROAS Trend

Purpose

Provides detailed insight into cost efficiency and return on ad spend by analyzing CPC and ROAS trends across time, day of week, and month, helping assess pricing pressure, efficiency shifts, and long-term performance patterns.

How to Use This Report

Key Metrics Explained

Efficiency Trend Monitoring: Use this report to understand how CPC and ROAS are trending over time and identify periods of rising costs or improving efficiency.

Short-Term Performance Analysis: Review daily trend charts to spot recent shifts in CPC and ROAS and compare against the prior 14-day baseline.

Day-of-Week Optimization: Use day-of-week views to identify consistent patterns in cost and efficiency by day.

Long-Term Trend Assessment: Leverage monthly comparisons to evaluate how CPC and ROAS are tracking versus the previous year.

Focused Drill Analysis: Drill into Avg. CPC Trend and ROAS Trend charts to move between monthly and daily views for deeper trend exploration.

Avg. CPC Over Time (Drillable): Displays CPC trends over time and allows users to drill down to daily data or drill up to monthly views for detailed or high-level analysis.

ROAS Trend (Drillable): Shows ROAS trends over time with the ability to drill down to dates or drill up to months to assess efficiency shifts at different granularities.

Day-of-Week Avg. CPC Trend: Highlights average CPC performance by day of the week to identify higher-cost or more efficient days.

Day-of-Week ROAS Trend: Shows ROAS by day of the week to support day-level optimization decisions.

Monthly CPC Trend: Compares average CPC for the current year versus the previous year and highlights percentage change.

Monthly ROAS Trend: Compares ROAS performance year-over-year and surfaces month-level efficiency shifts.

Ad Tactics Analysis

Purpose

Provides a tactical view of Sponsored Ads performance by ad tactic, helping evaluate how different targeting approaches contribute to spend, revenue, and efficiency, and where optimization opportunities exist across tactics.

How to Use This Report

Key Metrics Explained

Tactic-Level Performance Review: Use this report to understand how each Sponsored Ads tactic contributes to overall spend and revenue.

Spend Allocation Assessment: Compare spend distribution across tactics to identify over- or under-investment.

Revenue Contribution Analysis: Evaluate which tactics are driving the majority of ad-attributed revenue.

Efficiency Comparison: Use CPC, CTR, CVR, ROAS, and ACOS to compare efficiency across different targeting tactics.

Optimization Prioritization: Identify tactics to scale, maintain, optimize, or deprioritize based on performance trends.

Ad Spend by Ad Tactics: Shows the percentage distribution of ad spend across different Sponsored Ads tactics.

Ad Revenue by Ad Tactics: Displays how ad-attributed revenue is distributed across targeting tactics.

Ad Tactics Performance – YoY: Provides tactic-level performance metrics with year-over-year percentage change across spend, revenue, and efficiency.

Default metrics include: SA Spend, SA Revenue, Avg. CPC, CTR %, CVR %, ROAS, and ACOS.

Optional metrics available: SA Impressions, SA Clicks, SA Orders, and SA Conversions, which can be toggled on or off based on analysis needs.

Ad Tactics Performance – PoP: Shows tactic-level performance compared to the previous period to highlight short-term changes.

Default metrics include: SA Spend, SA Revenue, Avg. CPC, CTR %, CVR %, ROAS, and ACOS.

Optional metrics available: SA Impressions, SA Clicks, SA Orders, and SA Conversions, allowing users to customize the table view for deeper traffic or conversion analysis.

Campaign Analysis

Purpose

Provides a campaign-level view of Sponsored Ads performance, enabling detailed analysis of spend allocation, revenue contribution, and efficiency across individual campaigns to support optimization and prioritization decisions.

How to Use This Report

Key Metrics Explained

Campaign-Level Performance Review: Use this report to evaluate how individual Sponsored Ads campaigns are performing across spend, revenue, and efficiency metrics.

Spend Allocation Assessment: Review spend distribution by campaign and portfolio to identify concentration risk or underfunded opportunities.

Revenue Contribution Analysis: Compare campaign-level revenue contribution against spend to understand return by campaign.

Efficiency Optimization: Use CPC, CTR, CVR, ROAS, and ACOS to identify campaigns that should be scaled, optimized, or deprioritized.

Short- vs Long-Term Comparison: Use YoY and PoP tables to understand both long-term trends and recent performance shifts at the campaign level.

Ad Spend by Portfolio: Displays the distribution of ad spend across portfolios to show where investment is concentrated.

Ad Revenue by Portfolio: Shows how ad-attributed revenue is distributed across portfolios, enabling comparison between spend share and revenue share.

Campaign Performance – YoY: Provides campaign-level performance metrics with year-over-year percentage change across spend, revenue, traffic, and efficiency.

Default metrics include: SA Spend, SA Revenue, Avg. CPC, CTR %, CVR %, ROAS, and ACOS.

Optional metrics available: SA Impressions, SA Clicks, SA Orders, and SA Conversions, which can be toggled on or off based on analysis needs.

Campaign Performance – PoP: Shows campaign-level performance compared to the previous period to identify recent performance shifts.

Default metrics include: SA Spend, SA Revenue, Avg. CPC, CTR %, CVR %, ROAS, and ACOS.

Optional metrics available: SA Impressions, SA Clicks, SA Orders, and SA Conversions, allowing users to customize the table view for deeper traffic and conversion analysis.

Keyword Match Type Analysis

Purpose

Provides insight into Sponsored Ads performance by keyword match type (Exact, Phrase, Broad), enabling analysis of spend allocation, revenue contribution, efficiency, and performance trends to support match-type optimization decisions.

How to Use This Report

Key Metrics Explained

Match Type Performance Review: Use this report to understand how Exact, Phrase, and Broad match types contribute to overall spend and revenue.

Spend vs Revenue Alignment: Compare spend and revenue breakdowns to identify match types that are over- or under-performing relative to investment.

Efficiency Optimization: Evaluate CPC, CTR, CVR, ROAS, and ACOS by match type to guide bid and budget adjustments.

Trend Analysis (Drillable): Use trend-over-time charts to drill down to daily performance or drill up to monthly views to understand how match type performance evolves over time.

Short- and Long-Term Comparison: Use YoY and PoP tables to assess both long-term structural changes and recent performance shifts by match type

Keyword Match Type – Spend & Revenue Breakdown: Displays absolute ad spend and ad-attributed revenue by match type.

Keyword Match Type – Spend & Revenue Breakdown (%): Shows the percentage share of spend and revenue by match type to compare contribution mix.

Keyword Match Type – Spend Trend Over Time (Drillable): Visualizes how ad spend by match type changes over time, with the ability to drill down to dates or drill up to months.

Keyword Match Type – Revenue Trend Over Time (Drillable): Shows revenue trends by match type over time, supporting daily or monthly analysis through drill interactions.

Keyword Match Type Performance – YoY: Provides match-type-level performance metrics with year-over-year percentage change.

Default metrics include: SA Spend, SA Revenue, Avg. CPC, CTR %, CVR %, ROAS, and ACOS.

Optional metrics available: SA Impressions, SA Clicks, SA Orders, and SA Conversions, which can be toggled on or off based on analysis needs.

Keyword Match Type Performance – PoP: Shows match-type performance compared to the previous period to identify short-term changes.

Default metrics include: SA Spend, SA Revenue, Avg. CPC, CTR %, CVR %, ROAS, and ACOS.

Optional metrics available: SA Impressions, SA Clicks, SA Orders, and SA Conversions for deeper traffic and conversion analysis.

Keyword Brand Targeting Analysis

Purpose

Provides insight into Sponsored Ads performance by keyword brand targeting (Branded vs Non-Branded), enabling analysis of spend allocation, revenue contribution, efficiency, and performance trends to support brand defense and prospecting decisions.

How to Use This Report

Key Metrics Explained

Brand Targeting Performance Review: Use this report to understand how Branded and Non-Branded keywords contribute to overall spend and revenue.

Spend vs Revenue Alignment: Compare spend and revenue breakdowns to identify whether brand or non-brand targeting is over- or under-invested.

Efficiency Optimization: Evaluate CPC, CTR, CVR, ROAS, and ACOS across Branded and Non-Branded keywords to guide bid and budget decisions.

Trend Analysis (Drillable): Use trend-over-time charts to drill down to daily performance or drill up to monthly views to understand how brand targeting performance evolves over time.

Short- and Long-Term Comparison: Use YoY and PoP tables to assess both longer-term structural shifts and recent performance changes by brand targeting type.

Keyword Brand Targeting – Spend & Revenue Breakdown: Displays absolute ad spend and ad-attributed revenue split between Branded and Non-Branded keywords.

Keyword Brand Targeting – Spend & Revenue Breakdown (%): Shows the percentage share of spend and revenue for Branded vs Non-Branded targeting to compare contribution mix.

Keyword Brand Targeting – Spend Trend Over Time (Drillable): Visualizes how ad spend trends for Branded and Non-Branded keywords over time, with the ability to drill down to dates or drill up to months.

Keyword Brand Targeting – Revenue Trend Over Time (Drillable): Shows revenue trends for Branded and Non-Branded keywords over time, supporting daily or monthly analysis through drill interactions.

Keyword Brand Targeting Performance – YoY: Provides brand-targeting-level performance metrics with year-over-year percentage change.

Default metrics include: SA Spend, SA Revenue, Avg. CPC, CTR %, CVR %, ROAS, and ACOS.

Optional metrics available: SA Impressions, SA Clicks, SA Orders, and SA Conversions, which can be toggled on or off based on analysis needs.

Keyword Brand Targeting Performance – PoP: Shows performance by brand targeting compared to the previous period to identify short-term changes.

Default metrics include: SA Spend, SA Revenue, Avg. CPC, CTR %, CVR %, ROAS, and ACOS.

Optional metrics available: SA Impressions, SA Clicks, SA Orders, and SA Conversions for deeper traffic and conversion analysis.

Keywords Analysis

Purpose

Provides a keyword-level view of Sponsored Ads performance, enabling identification of top-contributing keywords, spend and revenue concentration, and efficiency differences across individual keywords to support bid, budget, and keyword optimization decisions.

How to Use This Report

Key Metrics Explained

Top Keyword Identification: Use this report to identify the keywords driving the highest share of ad spend and ad-attributed revenue.

Spend vs Revenue Alignment: Compare spend and revenue distribution to surface keywords that may be over- or under-funded.

Efficiency Optimization: Evaluate CPC, CTR, CVR, ROAS, and ACOS at the keyword level to guide bid adjustments and keyword expansion or pruning.

Keyword Prioritization: Use YoY and PoP performance tables to determine which keywords should be scaled, optimized, or deprioritized based on performance trends.

Strategic Filtering: Apply campaign type, brand targeting, and match type filters to isolate keyword performance by strategy.

Top Keywords – Spend & Revenue Breakdown: Displays the distribution of ad spend and ad-attributed revenue across the top-performing keywords to highlight concentration and contribution.

Keywords Performance – YoY: Provides keyword-level performance metrics with year-over-year percentage change across spend, revenue, traffic, and efficiency.

Default metrics include: SA Spend, SA Revenue, Avg. CPC, CTR %, CVR %, ROAS, and ACOS.

Optional metrics available: SA Impressions, SA Clicks, SA Orders, and SA Conversions, which can be toggled on or off based on analysis needs.

Keywords Performance – PoP: Shows keyword-level performance compared to the previous period to identify short-term changes in efficiency and conversion behavior.

Default metrics include: SA Spend, SA Revenue, Avg. CPC, CTR %, CVR %, ROAS, and ACOS.

Optional metrics available: SA Impressions, SA Clicks, SA Orders, and SA Conversions for deeper traffic and conversion analysis.

Advertised Products Analysis

Purpose

Provides an ASIN-level view of Sponsored Ads performance for advertised products, enabling evaluation of spend allocation, revenue contribution, and efficiency across individual products to support product-level optimization and prioritization decisions.

How to Use This Report

Key Metrics Explained

Advertised Product Performance Review: Use this report to assess how individual advertised ASINs perform in terms of spend, revenue, and efficiency.

Spend Allocation Assessment: Review spend distribution across advertised products to identify concentration risk or underfunded high-performing ASINs.

Revenue Contribution Analysis: Compare ad-attributed revenue by product to understand which ASINs are driving the majority of Sponsored Ads sales.

Efficiency Optimization: Use CPC, CTR, CVR, ROAS, and ACOS to identify products that should be scaled, optimized, or deprioritized.

Short- vs Long-Term Comparison: Use YoY and PoP tables to evaluate both longer-term performance trends and recent changes at the product level.

Ad Tactics – Spend Breakdown: Displays the distribution of ad spend across Sponsored Ads tactics for advertised products.

Ad Tactics – Revenue Breakdown: Shows how ad-attributed revenue is distributed across Sponsored Ads tactics for advertised products.

Advertised Products Performance – YoY: Provides ASIN-level performance metrics with year-over-year percentage change across spend, revenue, traffic, and efficiency.

Default metrics include: SA Spend, SA Revenue, Avg. CPC, CTR %, CVR %, ROAS, and ACOS.

Optional metrics available: SA Impressions, SA Clicks, SA Orders, and SA Conversions, which can be toggled on or off based on analysis needs.

Advertised Products Performance – PoP: Shows ASIN-level performance compared to the previous period to identify short-term changes.

Default metrics include: SA Spend, SA Revenue, Avg. CPC, CTR %, CVR %, ROAS, and ACOS.

Optional metrics available: SA Impressions, SA Clicks, SA Orders, and SA Conversions for deeper traffic and conversion analysis.

Competitive Products Analysis

Purpose

Provides insight into Sponsored Ads performance on competitor ASINs and competitive search terms, enabling evaluation of spend allocation, revenue impact, and efficiency when advertising against competing products.

How to Use This Report

Key Metrics Explained

Competitive Spend Analysis: Understand how Sponsored Ads budget is allocated toward competitive product targeting tactics.

Revenue Impact Assessment: Evaluate how much ad-attributed revenue is generated from competitive product campaigns.

Efficiency Benchmarking: Compare CPC, CTR, CVR, ROAS, and ACOS for competitive targets to assess profitability and scalability.

Target Optimization: Identify competitive products or search terms that should be scaled, optimized, or paused based on performance.

Trend Validation: Use YoY and PoP tables to validate whether competitive strategies are improving or deteriorating over time.

Ad Tactics – Spend Breakdown: Displays the distribution of ad spend across Sponsored Ads tactics used for competitive product targeting.

Ad Tactics – Revenue Breakdown: Shows how ad-attributed revenue is distributed across Sponsored Ads tactics for competitive product campaigns.

Competitive Products Performance – YoY: Provides competitive search term–level performance with year-over-year percentage change across spend, revenue, traffic, and efficiency.

Default metrics include: SA Spend, SA Revenue, Avg. CPC, CTR %, CVR %, ROAS, and ACOS.

Optional metrics available: SA Impressions, SA Clicks, SA Orders, and SA Conversions, which can be enabled for deeper competitive funnel analysis.

Competitive Products Performance – PoP: Shows competitive search term–level performance compared to the previous period to identify short-term shifts in competitiveness.

Default metrics include: SA Spend, SA Revenue, Avg. CPC, CTR %, CVR %, ROAS, and ACOS.

Optional metrics available: SA Impressions, SA Clicks, SA Orders, and SA Conversions.