Loading Power BI...
Amazon Ads Reports
Drag & drop a CSV or Excel file, or click Browse
Brand & Competitor Keywords
Active
▼
Create a copy-ready AI prompt for brand variations and competitors.
Brand Keywords
Competitor Keywords
Performance Filters
Active
▼
ROAS Target
Min
—
Max
Conv. Rate Target
Min %
—
Max %
Cross-Channel Overview
Brand vs. Non-Brand vs. Competitor
Platform Share
Loaded Ad Channels
| Channel | Ad Sales | Spend | Sales Share | Spend Share | ROAS | Clicks | Impressions | Conversions | CTR | CVR |
|---|
Saved Audits
Open prospect ad audits saved from the Ad Audit workspace.
Account KPIs
Brand vs. Non-Brand vs. Competitor
Spend vs. Ad Sales — by Campaign
Spend
Ad Sales
Spend by Match Type
Keyword Concentration
Campaign Performance
| Campaign |
Allocation
|
% Spend
|
% Sales
|
ROAS
Ad Sales / Spend
|
CPC
Spend / Clicks
|
Conv. Rate
Conversions / Clicks
|
CTR
Clicks / Impressions
|
|---|
Search Terms
| Search Term | Keyword | Type | Match | Campaign |
ROAS
Ad Sales / Spend
|
CPC
Spend / Clicks
|
Conv. Rate
Conversions / Clicks
|
CTR
Clicks / Impressions
|
|---|
AI-Derived Insights
Account Insights
Phrase Analysis
Top 2-3 Word Phrases
Automatic phrase extraction from customer search terms using cleaned contiguous 2-word and 3-word phrases.
| Phrase | Query Count | Spend | Clicks | Ad Sales | Conversions | ROAS | CVR |
|---|
Leadership Scorecard
Channel
Overall Performance
Choose a brand and date range to load the comparison.
Campaign Performance
Choose a brand and date range to load the comparison.
Monday Insights
Weekly pre-generated client insights appear here once a Monday run is available.
Loading Monday Insights...
Included Brands
Loading brands...
Monthly Client Reporting Bundles
Ready bundles appear here once the monthly reporting job uploads them.
Loading monthly reports...
Quarterly Client Reporting Bundles
Ready bundles appear here once the quarterly reporting job uploads them.
Loading quarterly reports...
Untitled
Hey there! Chat with Max to ask questions about our MRC Partners. Happy querying!
File Upload
Upload partner data files directly into MRC's data warehouse. Supported file types are `.csv` and `.xlsx`.
Partner Source Files
Drag & drop CSV or Excel files, or click Browse
Partner Data
Edit the partner reference tables that feed MRC's data warehouse and reporting models.
Promo Events
Save event dates for use in Promo Forecast.
Forecast Baseline
Monthly Assumptions
Current Ad Spend
Current Target ROAS
Monthly sales target
Organic share %
Target ROAS
One-time fill: Apply replaces the monthly Sales Target values using historical monthly sales. You can edit individual months afterward.
Sales targets are allocated to SKUs using their prior-year sales mix. Ad spend is derived from the paid share divided by target ROAS. SKU adjustments and manual sales overrides are available only in Custom Build.
Forecast Output by SKU
Adjust SKU lift percentages or override any projected sales cell directly in the table.
Choose a brand and baseline months, then run the forecast.
Promo Setup
Set the event dates and assumptions. Historical lift compares the selected comparison promo with the surrounding baseline window.
Defaults to the same dates one year earlier. Choosing a saved comparison locks its dates; clear the selection to edit them.
Promo Forecast by SKU
| SKU | Baseline Units | Forecast Units | Base ASP | Promo ASP | Baseline Sales | Forecast Sales | COGS | Est. Gross Margin |
|---|
Review a Past Promo
Choose a brand and completed event to see its performance against the surrounding baseline.
Compare Offer Performance
Compare unit and sales lift across the 10 most recent completed promos for this brand with saved offer details.
Average lift by recorded offer
| Offer / discount | Events | Average unit lift | Average sales lift |
|---|
Event details
| Event | Dates | Partner | Offer details | Discount | Unit lift | Sales lift |
|---|
Promo performance
Post-promo carryover
Compares the selected post-event window with the pre-event daily average scaled to the same number of days. This is descriptive, not a causal estimate.
Daily Unit Performance
Daily Context
| Date | Period | Baseline sales/day | Actual sales | Units | Traffic / sessions | Ad spend | Estimated organic sales share |
|---|
SKU Performance
| SKU / deal | List price | Deal price | Discount | Offer terms | Baseline Units | Promo Units | Unit Lift | Baseline Sales | Promo Sales | Sales Lift | Promo Traffic | Promo Gross Margin |
|---|
Saved Forecasts
Show