Ecommerce Ad Report Analyzer

Q: How are ROAS and ACoS calculated?

ROAS is mapped ad-attributed revenue divided by mapped spend. ACoS is mapped spend divided by mapped ad-attributed revenue.

Q: Will total store revenue be used when attributed revenue is missing?

No. The metric remains not calculated because total store revenue is not an equivalent attribution measure.

Q: What happens when a denominator is zero?

The dependent metric is shown as not calculated. The tool never returns Infinity or invents a replacement.

Q: Is the advertising report uploaded?

No. Import, mapping, calculations, persistence, and export happen locally in your browser.

Normalize an advertising report and calculate ROAS, ACoS, CTR, CPC, and conversion rate from confirmed fields. Missing denominators stay visible and currencies are never mixed.

Saved sessions

Drop an ecommerce ad CSV, TSV, or XLSX report here

The report stays in your browser. Legacy .xls files are not supported.

Private ad report analysis

The report, mappings, metrics, saved session, and exports stay in your browser and are excluded from BaseToolbox analytics.

Current limitations

The tool uses the attribution values in your report and does not reconcile attribution windows across ad platforms.
Missing impressions, clicks, orders, spend, or attributed revenue leave dependent metrics uncalculated.
Currencies remain separate; exchange rates, taxes, profit, and unreported advertising fees are not estimated.
Browser storage can be cleared or reclaimed, and private browsing may not retain sessions or files.

How ecommerce ad report analysis works

Map the actual report

Confirm campaign, spend, attributed revenue, traffic, orders, and currency fields.

Calculate declared metrics

The decimal engine groups campaigns and currencies, then applies explicit numerator and denominator definitions.

Review coverage and export

Inspect missing inputs, invalid values, zero denominators, and downloadable campaign results.