Soft refresh
soft_refresh is an output_options.append_policy used with write_mode=append, not a separate write_mode. In the wizard it's labeled "Refresh 1 previous day."
Behavior
- Finds the last date on the sheet (
append_date_field) - API range:
last_sheet_date − 1 … today - Refreshes the tail rows by date, then appends newer dates
This is not an upsert by Campaign ID or entity key.
When to use it
For daily / hourly schedules where you need to pull in yesterday's tail (late-arriving stats) and add today, without a full rewrite of the sheet.