Hi Karl,

To accomplish that, you can use the "Append Data" feature. Just follow these steps:

1. Open a new sheet.
2. Import the data with "Append data" selected and ensure that "All date values" is checked. (This setting will include the metrics as 0 on the days where the spend is 0)
3. Save this query and schedule it.

For a more detailed setup, you can refer to the link provided here.

It is not working when I try manually. Please see 2 attached screenshots
- Set date to 2025-12-08. Click export. Get's data
- Set date to 2025-12-09. Click export. Get's data. Appends row
- Set date to 2025-12-10. Click export. Error: No data for the specified date range

https://imgur.com/a/bBY7eiT

Sorry for not being specific. It should be "Append Data (Date-wise:DoD, WoW, MoM)" as shown here.

I can't get it to work when using 'Append data (Date-wise)'

Please see attached 6 screenshots ( https://imgur.com/a/udGNkGM)
- Set date to 2025-12-08. Click export. Gets data correctly
- Set date to 2025-12-09. Click export. Over-writes previous row
- Set date to 2025-12-10. Click export. Error: No data for the specified date range

Conclusions
- I think 'append data (date-wise)' only works when exporting multiple dates at the same time
- I don't think this works when exporting one date at a time

Yes. You are right, it only works when exporting multiple date ranges.

But as per your requirement of having a table with date-wise data,

1.) You can first try to import the last X days data in a new sheet, save that query with Append row (date-wise) checked while importing it for the first time. (here & here)

2.) Now, next time if you want to run the same report, run the query manually, from the 2nd tab as shown here. (don't run it from the 1st tab by selecting a single date range). Then only the new data with yesterday's date will get appended.