Empty results

An empty result is a situation where the report runs successfully (status Completed or Partial), but the source returns no data. For example, there's no statistics for the selected period, or the filters excluded every row.

Behavior by write mode

Mode	Behavior on an empty result
replace	The sheet is cleared (headers usually remain)
append + any policy	The sheet is unchanged
append_dedup	The sheet is unchanged

Special attention: Replace + empty result

Replace is the only mode that clears the sheet on an empty result. This can be a problem:

Scenario: an hourly report with today and Replace mode. At 3:00 AM, today's data hasn't been generated yet. The result is empty > the sheet is cleared > the previous hour's data is lost.

Solution:

• Use yesterday instead of today for daily reports
• For Replace, make sure data is guaranteed to exist (the date range covers periods with data)
• Consider Append or SoftRefresh if an empty result shouldn't clear the sheet

Causes of an empty result

1. No data for the period — the source has no statistics for the selected dates (holidays, weekends, a new account)
2. Filters excluded everything — the filter conditions are too strict, no row passes
3. Data delay — data hasn't yet arrived in the source API (relevant for today in the early morning)
4. Inactive entity — the selected account or campaign has no activity

How to diagnose

• The run status will be Completed (not Failed), but with 0 rows
• The logs will contain an entry: "Query returned 0 rows"
• The reason for the empty result is shown in the run details

How to verify

• Run the report and check the row count in the result (should be 0)
• Check the destination sheet — depending on the mode, it's either cleared or unchanged
• Check the logs — they should show the reason for the missing data

Related articles

• Write modes (overview) — comparing all modes
• Replace — the only mode that clears the sheet
• Filters — a possible cause of empty results
• Date range — choosing a period with data