The Day-to-Day report was built by customer request. The idea is straightforward: instead of jumping between different dashboards to piece together what's happening, you get all the essential metrics in one table, side by side, tracked over time. This makes it possible to see not just that profit is up or down, but why.
What It's For
When you look at profit in isolation, you can see the number but not the cause. The Day-to-Day report shows the metrics that influence your bottom line all at once, so you can trace the chain: did units go up because you increased PPC spend? Because conversion rate improved? Because of a pricing change? Or just seasonality? The same logic works in reverse when something is going wrong.
Use it on a weekly basis for trend analysis and on a daily basis when you need to spot something quickly.
Recommended Views
Two views tend to be most useful:
Last 14 days by day: Good for a quick daily check on direction. You can see whether sales, profit, and spend are trending up or down without needing to dig deeper.
Last 6 weeks by week: Click the Week button to switch from daily rows to weekly rows. This gives you a clean week-over-week comparison with heat map coloring applied across all metrics. Green is your best-performing value in the range, red is your worst, and orange is in the middle. This is the most useful view for understanding performance trends and presenting results.
There are also two special filters worth knowing about:
New to brand: Switches the table to show only new-to-brand performance. The key metric here is profit per new customer — useful for understanding your cost of acquisition and whether it's improving or worsening over time.
Repeat: Filters to repeat order performance only.
Metrics in the Table
The table covers four groups of metrics:
Sales Metrics
Total sales, units sold, orders, organic percentage, and average price. The average price here accounts for all discounts including Prime Exclusive, Best Deals, and everything else — so it reflects what customers actually paid. Subscribe and Save orders are shown alongside their percentage of total orders. New-to-brand orders and their ratio to total orders are also included, though these are available on the CPG package only.
Marketing Metrics
TACoS (PPC spend divided by total sales), Total Marketing, and Total CPA.
Total Marketing is different from TACoS because it includes both PPC spend and discounts divided by total sales. This matters because a heavy coupon or S&S discount drives sales similarly to ad spend but shows up differently in your cost structure. Seeing both TACoS and Total Marketing together lets you understand the full cost of driving a sale, regardless of whether it came through ads or promotions. Total CPA is your spend divided by total orders.
Profit Metrics
Profit from sales, profit margin, profit per unit, and ROI. Profit from sales excludes reimbursements, disposal fees, storage fees, and inbound placement fees — it shows only what you're making from actual product sales. ROI is profit divided by cost of goods sold, which tells you what percentage return you're generating on the inventory you invested in. If ROI is consistently low, it typically points to an average price problem rather than an advertising one.
Pending orders are also shown here. If you're a CPG brand, the pending orders video in the CPG section explains why this number matters for how you interpret the rest of the table.
PPC and Conversion Metrics
PPC sales, spend, CPC, CTR, ACoS, CPA (spend divided by PPC orders), and PPC conversion rate. Discounts (Subscribe and Save, coupons, etc.) are shown separately. Sessions come from your Business Reports and the account-level conversion rate rounds out the picture.
Filters and Product-Level View
You can filter the entire table by product using the filters at the top of the page. Scrolling down shows a simplified product-level breakdown by parent ASIN. Clicking any parent in that table filters the main table above to just that product.
If you have custom categories set up, you can filter by those as well.
Driver Analysis Page
Driver Analysis is a companion page within the Day-to-Day report. It uses the same metrics but applies color coding to every cell, making it easier to see at a glance which weeks had strong performance across the board and which had mixed or negative signals. A week where sales were green but profit and margin were red tells a specific story — usually that growth came at a cost that didn't pay off. A week where everything is green points to a combination of factors working together (like raising prices while cutting inefficient ad spend).
One additional metric appears here called Spread, which is the difference between your average price and your CPA. It's a quick way to see whether raising your price is making customer acquisition more or less expensive in relative terms.
BSR
Best Seller Rank is available at the product level in the table. It won't appear on demo accounts, but on your live account you'll see BSR for each individual product alongside the other metrics.
Chart View
Below the main table there's a chart where you can add any metric from the table for a visual representation over time. Useful for presentations or when you want to see the relationship between two metrics plotted together.
Exporting
To export the table, hover over the top right corner of the table until the three dots icon appears, click it, and select Export Data. The export is structured as a flat table suitable for pivot tables or further analysis in Excel.