Automatically pull data from ads manager every day (even on days where no ads are running)

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.