How to use the APPEND_RESULTS setting in Google Sheets queries

The APPEND_RESULTS setting can pull older historical data for Google Sheets queries that can’t use the Date dimension.

If your query can use the Date dimension, use the Combine new results with old setting instead.

Instructions

The APPEND_RESULTS setting will add an additional column to the beginning of your query that indicates the fetch date.

1. In the Supermetrics sidebar, click Create new query and set up the query details.
2. If a Date range setting is available, set it to Today.
3. Navigate to the Options section.
4. In the Advanced settings field, type APPEND_RESULTS.
5. All refreshes after this point will append the data to the bottom of your existing data with a new Fetch date column.
6. Run the query.