How to Avoid ACoS Metric Distortion for Multiple Accounts
← Back to How to Aggregate Amazon Ads Data Without Breaking Ratio Metrics
Quick answer
ACoS metric distortion for multiple accounts is avoided by aggregating total advertising spend and total attributed sales across all accounts first, then calculating ACoS as total spend divided by total sales. Averaging individual account ACoS percentages gives small accounts or short date ranges the same influence as larger ones, which can make performance look better or worse than it actually is. This sum-based approach preserves the true ratio and keeps multi-account reporting comparable across marketplaces, campaigns, and time periods.
The most common mistake is not collecting too little data, but combining already-calculated ratios as if they were simple totals. Once you shift to raw spend and sales totals, the ACoS number becomes stable enough to support account-level and portfolio-level decisions.
Why Percentage Averaging Breaks ACoS
ACoS is a ratio: ad spend divided by attributed sales. When you average the ACoS values from several accounts, you treat each account as equally important regardless of how much it spent or sold. A small test account with a 60% ACoS can pull a portfolio average up even if the largest account delivered a healthy 20% ACoS on far more volume.
Using total spend and total sales avoids that imbalance. It weights every click, order, and dollar according to its actual contribution, so the final ACoS reflects the combined account performance rather than a mathematical average of percentages.
- A portfolio appears inefficient because one small account had an unusually high ACoS
- High-volume account performance is underrepresented in the blended number
- Comparisons across months become misleading when account spend concentration shifts
A Simple Multi-Account Calculation Workflow
The calculation works in a consistent order:
- Export or collect total ad spend for every account in the group.
- Export or collect total attributed sales for the same accounts and date range.
- Add all spend values into one total. Add all sales values into one total.
- Divide total spend by total sales and multiply by 100 to get ACoS.
For teams that manage many marketplaces, an Amazon Ads Dashboard by Todoza can consolidate these totals from imported reports, so you are not manually combining spreadsheets each week. The key is to keep the calculation at the raw total level before applying any ratio logic.
When This Matters
This distinction matters most when you are comparing accounts of very different sizes, reviewing portfolio-level ACoS for budget decisions, or reporting to stakeholders. If you need to spot a decline in efficiency, a distorted ACoS can delay action because the real problem is buried inside an averaged percentage.
It also matters for cleanup. Once the unified ACoS is accurate, tools that flag wasted spend by ROAS or ACoS can help you prioritize which accounts and search terms need attention. The goal is not a perfect number for its own sake; it is a reliable baseline for reducing waste without losing the signal from accounts that are already performing well.
Related products
Related guides
Keeping multi-account ACoS accurate is one part of the broader challenge covered in our guide to aggregating Amazon Ads data without breaking ratio metrics. The same principle applies to ROAS, conversion rate, and other ratio-based KPIs: aggregate the underlying totals first, then calculate the ratio once.