UA Ledger · Measurement Lab · draft for review

Convert revenue once before adding currencies

Synthetic teaching inputs. No real campaign results or industry defaults. Change the values to inspect the model. Calculations run locally; this page sends no data and does not retain inputs after closing.

Choose a reporting currency and specify the number of reporting-currency units received for one source-currency unit. Apply that rate to the source amount before adding revenue already expressed in the reporting currency. Preserve whether the rate represents transaction-time conversion, a settlement rate or an accounting convention. A rate without its direction is an easy source of silent reciprocal errors.

Calculated outputs

Assumption sensitivity

Only fx varies; all other inputs are held constant. This is not a probability range.

Equations

• Converted source revenue: foreign*fx
• Combined reporting revenue: foreign*fx+domestic

Additional constraints: true. The field minimums also apply.

Limits

Use an approved rate source and consistent timing for a real reconciliation. Platform-reported converted revenue may already include conversion; applying the worksheet to it again would double-convert the value.

Google Analytics BigQuery Export schema · primary documentation checked 19 September 2026.