Ad spend
Total for selected period$17,300
reporting_amazon.advertising_kpi
Amazon intelligence
Campaign performance, spend efficiency, and ROAS analysis.
Primary source family
Advertising performance
Campaign, search-term, efficiency-rollup, and freshness data for operational review.
Trust posture
Internal-ready with labels
Every block keeps its source/view label visible so claims remain auditable.
Operator focus
Non-brand efficiency
The key watch item is acquisition spend quality, not a broad account failure.
Ad spend
Total for selected period$17,300
reporting_amazon.advertising_kpi
Ad-attributed sales
Total for selected period$36,404
reporting_amazon.advertising_kpi
ROAS
Attributed sales / spend2.10
reporting_amazon.advertising_kpi
ACOS
Spend / attributed sales47.5%
reporting_amazon.advertising_kpi
Campaign view
Core internal operating table for campaign-level spend, attributed-sales, efficiency, and conversion review.
| Campaign | Channel | Objective | Spend | Attributed sales | ROAS | TACOS impact | CVR | Status |
|---|---|---|---|---|---|---|---|---|
| SP | CAP | ASIN Exact | SP | Acquisition | $1,819 | $4,143 | 2.28 | 5.0% | — | Watch |
| SP | DWC | RoS | Exact ABB | SP | Acquisition | $1,249 | $2,020 | 1.62 | 3.4% | — | Watch |
| SP | CAP | ASIN Defense | SP | Acquisition | $791 | $2,011 | 2.54 | 2.2% | — | Watch |
| SP | WMC | ToS | Exact ABB | SP | Acquisition | $942 | $2,009 | 2.13 | 2.6% | — | Watch |
| SP | WMC | RoS | Exact ABB | SP | Acquisition | $1,212 | $1,903 | 1.57 | 3.3% | — | Watch |
| SBI | MULTI-ASIN | WMC+DWC+GDC | HSA | SB | Acquisition | $648 | $1,825 | 2.82 | 1.8% | — | Watch |
| SP | WMC | ASIN Exact ABB | SP | Acquisition | $895 | $1,663 | 1.86 | 2.5% | — | Watch |
| SP | WMC | Broad | SP | Acquisition | $784 | $1,659 | 2.12 | 2.2% | — | Watch |
| SP | CAP | Broad | SP | Acquisition | $524 | $1,159 | 2.21 | 1.4% | — | Watch |
| SP | MULTI-ASIN | WMC+DWC Bundles Broad KW | SP | Acquisition | $245 | $1,058 | 4.32 | 0.7% | — | Stable |
ops_amazon.amzn_ads_sp_campaigns_v3_view
Efficiency posture
Review weaker campaigns, tighten targeting, and cut low-efficiency spend before increasing budgets.
ROAS posture
2.10xEfficiency is weak and needs tighter targeting or bidding.
ACOS posture
47.5%Cost of sale is high enough that efficiency remediation should come before scale.
Top campaign concentration
SP | CAP | ASIN ExactThe top campaign is driving the most attributed sales in the selected period.
Budget pressure
Review targetingUse campaign and search-term detail to decide where to tighten bids or targeting.
ops_amazon.raw_ads_union
Source health
Sponsored Products / Brands / Display
2026-03-24 – 2026-04-07
Advertising tables returned rows for the selected period.
ops_amazon.raw_ads_union
Channel mix
| Channel | Spend share | Sales share | ACOS | Role |
|---|---|---|---|---|
| SP | 48.9% | 48.4% | 48.0% | Primary conversion engine |
| SB | 3.7% | 5.0% | 35.5% | Brand demand capture |
ops_amazon.raw_ads_union
Search-term layer
| Query | Campaign bias | Spend | Sales | ACOS | Quality read |
|---|---|---|---|---|---|
| SP | CAP | ASIN Exact | SP | $1,819 | $4,143 | 5.0% | Tighten targeting |
| SP | DWC | RoS | Exact ABB | SP | $1,249 | $2,020 | 3.4% | Tighten targeting |
| SP | CAP | ASIN Defense | SP | $791 | $2,011 | 2.2% | Tighten targeting |
| SP | WMC | ToS | Exact ABB | SP | $942 | $2,009 | 2.6% | Tighten targeting |
| SP | WMC | RoS | Exact ABB | SP | $1,212 | $1,903 | 3.3% | Tighten targeting |
ops_amazon.amzn_ads_sp_campaigns_v3_view
Risk flags
Efficiency review
StableEfficiency is mixed and should be reviewed before scaling budget.
Action bias
Reduce waste
ops_amazon.raw_ads_union
Coverage and freshness
StableAdvertising data is present across the selected date range.
Action bias
Maintain monitoring cadence
ops_amazon.raw_ads_union
Data sources
Each section is backed by a named reporting view. Source labels are visible per block for auditability.
kpis
reporting_amazon.advertising_kpi
chartData
reporting_amazon.advertising_daily
snapshot
reporting_amazon.advertising_snapshot