Data options
Data options control how a query writes results to your spreadsheet, and how it calculates metrics. Open the Data Options section at the bottom of a query in the Two Minute Reports sidebar.
Merge new data with old
By default, running a query overwrites the data in your sheet. Append new data adds rows at the end, but re-running the same query repeatedly creates duplicates.
Merge new data with old fixes this. It updates the rows that are already in the sheet with the latest values, and adds only the new records. Your sheet has no duplicate rows.
How it works
Turn on Merge new data with old in the Data Options section, then run your query.
On each subsequent run:
- Rows that match records already in the sheet are updated with the latest values
- Records that didn't exist before are added at the end
- No duplicate rows are created
Example: You query "Last 7 days" on Monday and get 7 rows:
On Tuesday, you run the same query again. The add-on updates the 6 days that overlap with the latest values, and adds Tuesday as a new row. You get 8 days of data with no duplicates:
Currency conversion
Currency conversion changes money metrics, such as amount spent, from the account's currency into a currency that you choose.
How the conversion works
The add-on multiplies each day's spend by the exchange rate of that day. Your data shows the changes in the rate across the date range. Do not convert a total with one rate. Let the add-on apply the daily rate to each row.
Example: $100 USD/day converted to EUR over a week:
| Day | Exchange rate | EUR |
|---|---|---|
| Day 1 | 0.85 | €85 |
| Day 2 | 0.84 | €84 |
| Day 3 | 0.87 | €87 |
| Day 4 | 0.85 | €85 |
| Day 5 | 0.88 | €88 |
| Day 6 | 0.86 | €86 |
| Day 7 | 0.87 | €87 |
Total: $700 USD → €602 EUR (not $700 × a single exchange rate)
How to use it
- In the Two Minute Reports sidebar, open Data Queries. Create or edit a query for a connector that supports currency conversion.
- Select your metrics and dimensions.
- Open the Data Options section at the bottom of the query.
- In Convert currency to, select the currency.
- Select Run query.
The results show money metrics in the currency that you selected:
To change the currency, select a different currency and run the query again:
Do not force aggregate
What are non-aggregatable metrics?
You can't add up or average some metrics across accounts and get a correct result. For example, the sessions of three GA4 properties do not add up to a reliable total, because sessions are unique to each property. These are non-aggregatable metrics.
By default, the add-on aggregates (adds up or averages) all metrics across all the selected accounts. This is correct for metrics that add up, such as Conversions. It gives wrong results for non-aggregatable metrics.
For example, a GA4 query across 3 properties with Sessions and Conversions:
When to use this setting
Turn on Do not force Aggregate when:
- You query more than one account or property at the same time
- One or more selected metrics are non-aggregatable (unique counts, ratio-based, or calculated metrics)
- You want per-account or per-property rows rather than a blended total
How it works
| Setting | Result |
|---|---|
| Force aggregate (default) | Metric values are summed or averaged across all accounts into one row per date |
| Do not force Aggregate | Each account or property gets its own rows; non-aggregatable metrics show their actual individual values |
With force aggregate on (the default), all values are combined into one row for each date. Sessions shows the total of all 3 properties:
With Do not force Aggregate on, each property gets its own rows, and non-aggregatable metrics show UNKNOWN:
UNKNOWN means that the add-on cannot reliably combine that metric across the accounts that you selected.
How to enable it
In the Data Options section of your query, turn on Do not force Aggregate, then run the query.