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.
Important to note when using the APPEND_RESULTS setting
- This setting will remove the column and row headers. You need to manually add headers if needed and start the query under the headers. For example, if you add headers to row 1, start the query from row 2.
- The first column will be the fetch date.
- Every time you refresh the query, the results are added with today's date. This means if you refresh the query twice within the same day, the result rows will double
- If you add the APPEND_RESULTS setting to an existing query, there will be an extra empty row. Because of this, we recommend adding this setting to new queries only. If needed, test the query before creating the final query and adding the setting.
Instructions
The APPEND_RESULTS setting will add an additional column to the beginning of your query that indicates the fetch date.
- In the Supermetrics sidebar, click Create new query and set up the query details.
- If a Date range setting is available, set it to Today.
- Navigate to the Options section.
- In the Advanced settings field, type APPEND_RESULTS.
- All refreshes after this point will append the data to the bottom of your existing data with a new Fetch date column.
- Run the query.