Replace

Replace is the write mode that fully rewrites the destination sheet. On every report run, all old data is removed and replaced with new data. The simplest and most predictable write mode.

How it works

1. Before writing new data, the sheet is cleared (except for headers, if enabled)
2. New data is written starting from the first available row
3. Only the data from the latest run remains on the sheet

Before/after

Before the run:

| Campaign   | Impressions | Clicks |
|------------|-------------|--------|
| Campaign A | 1000        | 50     |
| Campaign B | 2000        | 100    |
| Campaign C | 1500        | 75     |

After the run (new data: D, E):

| Campaign   | Impressions | Clicks |
|------------|-------------|--------|
| Campaign D | 3000        | 150    |
| Campaign E | 2500        | 120    |

All old rows (A, B, C) are removed. Only the new data remains.

Specifics

• Manual columns: removed when the sheet is cleared. Don't use Replace if there are comment, formula, or tag columns to the right of the data
• Empty result: the sheet is cleared. Only headers remain (if enabled). Be careful with hourly reports run overnight — if there's no data, the sheet will end up empty
• Scheduling: fully compatible
• Performance: the fastest write mode, since it doesn't require searching for or matching rows

When to use it

• Daily reports with a full picture for the day/week/month
• Dashboards that always need only the current data
• Reports with no manual columns
• When you need maximum write speed

When NOT to use it

• There are manual columns with comments or formulas — use SoftRefresh
• You need a history of changes — use Append or AppendDedup
• You need to preserve part of the data between runs — use RewriteFromLast

Related articles

• Write modes (overview) — comparing all modes
• Append — an alternative with accumulation
• SoftRefresh — an alternative that preserves manual columns
• Empty results — behavior when there's no data