DRR is one of the fundamental metrics without which advertising on marketplaces quickly turns into a “black hole.” It answers a simple question: what share of revenue was consumed by advertising. In this article, we will break down the DRR formula, show calculation examples, and most importantly—how to calculate DRR so that the number helps manage rather than mislead.
What is DRR in simple terms
DRR (Advertising Expense Ratio) is the percentage of revenue that you spent on advertising.
If DRR = 15%, it means that out of every $100 in revenue, $15 went to advertising.
DRR Formula
The basic formula:
DRR = (Advertising Expenses / Revenue) × 100%
Where:
- Advertising Expenses — the actual money spent on advertising during the period.
- Revenue — revenue for the same period (important: choose which revenue you consider “baseline,” see below).
Example of DRR Calculation (Basic)
Let's say for one day:
- Advertising: $9,000
- Revenue: $60,000
DRR = (9,000 / 60,000) × 100% = 15%
Which Revenue to Use for DRR: 3 Working Options
On marketplaces, DRR can be calculated in different ways. The main thing is to choose one standard and stick to it.
Option 1. DRR Based on Order Revenue (most practical for managing advertising)
Revenue = total of orders/paid orders for the period.
Pros:
- quickly see the dynamics “today/yesterday”;
- convenient to manage the budget by days.
Cons:
- returns and cancellations may later “catch up” with profit.
Who it suits: for daily advertising control.
Option 2. DRR Based on Sales Revenue (more “honest” to reality)
Revenue = total sales (what was actually purchased/not returned) for the period.
Pros:
- closer to actual money;
- easier to relate to profit.
Cons:
- lags behind in time (the effect of advertising does not manifest immediately);
- harder to “manage by days.”
Who it suits: for weekly/monthly control.
Option 3. DRR Based on Attributed Advertising Revenue (caution)
Revenue = revenue that the platform “attributed” to advertising.
Pros:
- shows the effectiveness of specific advertising campaigns.
Cons:
- attribution on marketplaces is often incomplete/noisy;
- can yield “pretty numbers” that do not reflect reality.
Who it suits: for campaign optimization, but not as the sole basis.
How to Calculate DRR Correctly: The Main Rule
Expenses and revenue must be taken from the same time window.
Classic mistake: expenses for “today” and revenue for “yesterday” or “orders for the week.” Then DRR turns into a random number.
Practical Standard:
- for daily control: day-to-day (daily expenses / daily order revenue)
- for strategic control: week-to-week (weekly expenses / weekly sales revenue)
DRR by Days: Example with Dynamics (Why It “Jumps”)
Day 1:
- Expenses: $10,000
- Revenue: $100,000
- DRR = 10%
Day 2:
- Expenses: $10,000
- Revenue: $50,000
- DRR = 20%
Expenses are the same, but revenue dropped—DRR increased. This is normal: DRR is a metric not only of advertising but of the entire “context” (price, conversion, stock, delivery, seasonality).
DRR at the SKU Level: How to Calculate and Why
Overall DRR for the store is useful, but managing advertising is better at the SKU level.
The formula is the same:
DRR SKU = (Advertising Expenses by SKU / Revenue by SKU) × 100%
Example
- Advertising on SKU A: $3,000
- Revenue SKU A: $15,000
- DRR SKU A = 20%
Why is this needed:
- products with different margins require different target DRRs;
- one “bad” SKU can spoil the DRR of the entire store.
DRR and Margin: Quick Check “Are We in the Black or Not”
DRR cannot be viewed in isolation from margin.
Very roughly:
- if gross margin is 30%, and DRR is 25% — 5% remains for logistics/returns/penalties/profit
- if margin is 20%, and DRR is 25% — you are in the red even before reality
Practical Rule: target DRR should be lower than gross margin (unless you are consciously “ramping up” at launch).
Common Mistakes in DRR Calculation
Mistake 1. Calculating DRR from Different Sources (and Different Periods)
For example:
- expenses — from the advertising account,
- revenue — from the sales report,
- periods do not match.
Solution: fix a single report/window and do not mix.
Mistake 2. Calculating DRR “on average” and not seeing who is ruining it
Average DRR may be normal while one SKU/campaign is burning the budget.
Solution: breakdown at least into:
- top-20 SKUs by expenses
- top-20 campaigns by expenses
Mistake 3. Calculating DRR and Ignoring Conversion
DRR often increases because CR (conversion) is falling—advertising brings traffic that does not buy.
Solution: simultaneously monitor the CR of the listing and price/reviews/delivery.
DRR Calculator: How to Calculate in 10 Seconds (in Excel/Sheets)
In the table:
- A2 = expenses (for example, 9000)
- B2 = revenue (for example, 60000)
Formula:
=A2/B2*100
And format the cell as “percent” (or round to 1 decimal).
FAQ: Questions about DRR
Is DRR and ACOS the Same?
Formally similar, but ACOS is often calculated based on attributed advertising revenue, while DRR is based on total revenue (or orders). Because of this, the numbers may differ.
Why Does DRR “Jump” Every Day?
Because it depends on both advertising and revenue, and revenue changes due to price, conversion, stock, delivery, seasonality.
Can You Compare DRR of Different Products?
You can, but only if you consider margin. A product with a 15% margin and a product with a 40% margin cannot have the same “normal” DRR.
Short Conclusion
DRR is a simple formula but a powerful management tool. For it to work:
- calculate expenses and revenue in the same time window
- choose a revenue standard (orders/sales) and do not mix
- look at DRR by SKU and campaigns, not just overall
- always compare DRR with margin and conversion
Recommended Internal Link
If you want to not only calculate DRR but also manage it (why it grows, what to do, how to set goals), see the guide: DRR and Advertising on Marketplaces: How to Calculate and Manage